MQSeries.net :: View topic - max no. of app db connections that broker handles?

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » max no. of app db connections that broker handles?

max no. of app db connections that broker handles?

« View previous topic :: View next topic »

Author

Message

yuj

Posted: Mon Mar 19, 2007 6:27 am Post subject: max no. of app db connections that broker handles?

Novice

Joined: 19 Mar 2007
Posts: 10

Does anybody know what is the maximum number of app database connections that the message broker can handle?
I couldn't find any clue from IBM's docs. Does it mean there's no limitation at all? My problem is that one of my msgflow hit the max allowed dbconnect number and generate "db2 package not found" err. Our DBA increased the allowed connection number from 5 to 10. What if it fails again?

fschofer

Posted: Mon Mar 19, 2007 7:10 am Post subject:

Knight

Joined: 02 Jul 2001
Posts: 524
Location: Mainz, Germany

look here

http://publib.boulder.ibm.com/infocenter/wmbhelp/v6r0m0/topic/com.ibm.etools.mft.doc/ac00406_.htm

Greetings
Frank

yuj

Posted: Mon Mar 19, 2007 8:47 am Post subject: How the instances work with db2 bind package?

Novice

Joined: 19 Mar 2007
Posts: 10

Thanks Frank, very good information.
This probably goes too far...we have this message flow configed with "Additional Instances=10" in the BAR file and our DBA has increased the CLIPKG value to 10 after we bumped to the problem at first time. But after a little while, we encountered the same problem again. do you know how the broker's instances (threads) work with the db2 client bind package? Why it ran out of bind package so quickly even though we already made these 2 number in snyc?

Here is the error log...
(0x03000000):Text = '[IBM][CLI Driver][DB2] SQL0805N Package "DB0
3.NULLID.SYSLH20A.5359534C564C3031" was not found. SQLSTATE=51002 '

Edde

Posted: Mon Mar 19, 2007 10:22 am Post subject: Re: How the instances work with db2 bind package?

Acolyte

Joined: 01 Oct 2006
Posts: 67
Location: Moscow, Russia

I don't really know how broker works with the db2 client bind package.

But "Additional Instances=10" means that broker runs 11 instances of flow if needed, so you can have 11 DB connections.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » max no. of app db connections that broker handles?

Jump to:

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

Protected by Anti-Spam ACP