MQSeries.net :: View topic - WBI Database Connection error

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 » WBI Database Connection error

WBI Database Connection error

« View previous topic :: View next topic »

Author

Message

wbiuid

Posted: Fri Aug 05, 2005 2:11 am Post subject: WBI Database Connection error

Apprentice

Joined: 14 Jun 2005
Posts: 34

This morning we received the following connection error in the log while deploying

Aug 5 08:38:33 rthuas55 MQSIv500[40828]: (WBI_TSMQBKQ1_BROKER.exec7)[5141]BIP23
22E: Database error: SQL State '57030'; Native Error Code '-1040'; Error Text '[
IBM][CLI Driver] SQL1040N The maximum number of applications is already connect
ed to the database. SQLSTATE=57030 '. : WBI_TSMQBKQ1_BROKER.c07a8c85-0501-0000-
0080-84544dbeb6ca: /build/S500_P/src/DataFlowEngine/ImbOdbc.cpp: 329: ImbOdbcHan
dle::checkRcInner: :

It says that the maximum number of applications is already connected, any ideas? How do I check the connections? Is there a limit or somewhere that I can extend this?

Thanks

elvis_gn

Posted: Fri Aug 05, 2005 2:52 am Post subject:

Padawan

Joined: 08 Oct 2004
Posts: 1905
Location: Dubai

Hi,

Maybe this will help

http://publib.boulder.ibm.com/infocenter/wbihelp/index.jsp?topic=/com.ibm.etools.mft.eb.doc/au16620_.htm

But I think you should find why the maximum number of connections has been met, this would mean that connections once made are not being released, even if you increase the number, you will eventually meet it sometime...

wbiuid

Posted: Fri Aug 05, 2005 3:11 am Post subject:

Apprentice

Joined: 14 Jun 2005
Posts: 34

Thanks for the link.

Why do connections not get released after being made? Are there general reasons for this happening.

fschofer

Posted: Fri Aug 05, 2005 3:32 am Post subject:

Knight

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

Hi,

db2 list active databases => currently used connections

db2 get db cfg for <DB NAME> => parameter MAXAPPLS

db2 get dbm cfg => parameter MAXAGENTS (total number)

Greetings
Frank

wbiuid

Posted: Fri Aug 05, 2005 4:05 am Post subject:

Apprentice

Joined: 14 Jun 2005
Posts: 34

Is the non releasing of connectins a WBI problem or a setting with DB2?

Is there a WBI or DB2 expiry setting that may release if it is not used for a certain period?

fschofer

Posted: Fri Aug 05, 2005 4:37 am Post subject:

Knight

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

No,

but you simple have to increase the number of connections if the Broker needs more.

for more information look here
http://www.mqseries.net/phpBB2/viewtopic.php?t=16430&highlight=calculate+db2+number+connection

Greetings
Frank

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » WBI Database Connection error

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