| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Custom database node and connection pooling |
« View previous topic :: View next topic » |
| Author |
Message
|
| autorun |
 Posted: Thu Aug 15, 2002 7:43 am Post subject: Custom database node and connection pooling |
 |
|
Apprentice
Joined: 02 Feb 2002
Posts: 29
|
Hi all,
Question again. Since we need to call some Mainframe DB2 stored procedures which have OUT parameter under our AIX MQSI 2.0.2 environment, we have a custom DB2 node to achieve this, MQSI 2.0.2 doesn't support stored procedure which have OUT parameter. Everything is running fine except a concern on performance or DB2 connection pooling.
My questions are,
1. If I have 100 different concurrent message flows which use the same custom DB2 node to access different stored procedures, does MQSI use 1 instance of that custom node (shared object) or 100 custom node?
2. After completing a job, will the message flow destory the custom node instance or it will keep the instance for the next use?
3. How can I make sure that connection pooling are being used by our custom node? Assumed that the connection pooling option from our side to Mainframe side are turned ON by DBA.
Best regards,
autorun |
|
| Back to top |
|
 |
| dhaksr |
| Posted: Thu Aug 15, 2002 3:47 pm Post subject: |
|
|
Apprentice
Joined: 20 Feb 2002
Posts: 37
|
Interesting questions 
If you migrate to WMQI 2.1, you can use the PASSTHRU statement
which provides mechanism for you to recieve results for Stored
procedures.
Since you are using 2.0.2 cant comment much.
But as far as WMQI 2.1 is concerned, I can answer the following questions:
2. A node instance will be reused till further re-deploy.
3. A DB connection once acquired will be released only if a re-deploy
happens or the broker is brought down.
Also ensure that you are in the latest CSD levels (CSD03 for 2.0.2) |
|
| 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
|
|
|
|
