| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| SQL Select failing in WMQI Custom Node - Urgent !!! |
« View previous topic :: View next topic » |
| Author |
Message
|
| subhadra |
 Posted: Tue Jun 11, 2002 1:59 am Post subject: SQL Select failing in WMQI Custom Node - Urgent !!! |
 |
|
Newbie
Joined: 06 May 2002
Posts: 8
|
Hi All,
We have written a custom node in C, in which we select a row from a DB2 table. It works fine for a few messages, and then the Select statement(cniSqlSelect) abruptly fails, with a rethrowable exception.
When I print the trace file of the Exception_st (or use a trace node), the trace text says "Implementation Error". 
Is there any way, we can trap the DB2 SQL Error code ? And why should a Select stmt which was working perfectly fine, fail all of a sudden? The same Select stmt works fine from the DB2 prompt or from a Database node.
Thanx in advance
Subhadra |
|
| Back to top |
|
 |
| kirani |
| Posted: Tue Jun 11, 2002 10:04 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Is your data (input message) same for all tests?
Can you check maxappls and avg_appls parameters for your DB2 application database? Try changing these to higher values.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
