| Author |
Message
|
| j.f.sorge |
 Posted: Tue Oct 20, 2009 3:52 am Post subject: WTX in WMB - Connection Pooling? |
 |
|
Master
Joined: 27 Feb 2008
Posts: 218
|
Hello!
We are using WTX 8.1 with DTXPlugInNode in WMB 6.0 and have problems with maps which open connections to DB2.
The broker gets restarted every weekend for backup-reason and the wtx map (which causes the problem) runs after broker is up again. Later DB2 gets down for maintance. After DB2 is up again the wtx map does not run for two days.
The first call of wtx map fails with two errors. Oone disconnect error which has a timestamp of the first call before DB2 got down and one open connection error with a timestamp of the call I wanted to do.
| Code: |
<28815-035>: Error in SQLExecDirect
Message: [IBM][CLI Driver] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "127.0.0.1". Communication function detecting the error: "send". Protocol specific error code(s): "32","*", "0". SQLSTATE=08001
SQL State: 40003
<28815-035>: Error in SQLAllocStmt
Message: [IBM][CLI Driver] CLI0106E Connection is closed. SQLSTATE=08003
SQL State: 08003 |
My question is: does WTX use a connection pooling and how to you configure it?
Thanks in advance!
_________________
IBM Certified Solution Designer - WebSphere MQ V6.0
IBM Certified Solution Developer - WebSphere Message Broker V6.0
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
 |
| Gaya3 |
| Posted: Tue Oct 20, 2009 5:46 am Post subject: Re: WTX in WMB - Connection Pooling? |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
| j.f.sorge wrote: |
My question is: does WTX use a connection pooling and how to you configure it?
|
Yes, WTX Uses connection pooling
what kind adapter that you have used in Data base integrator to create the .mdq file
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| mvsivaiah |
| Posted: Tue Oct 20, 2009 8:15 am Post subject: |
|
|
Apprentice
Joined: 30 May 2008
Posts: 25
|
usually db2 connection failure happens for the first time after the broker restart (i've experienced it in z/os). if i go for the re-run it connects to db2.
Can you expalin what do you mean by connection pooling?
_________________
Venkat. |
|
| Back to top |
|
|
| j.f.sorge |
| Posted: Tue Oct 20, 2009 10:53 pm Post subject: Re: WTX in WMB - Connection Pooling? |
|
|
Master
Joined: 27 Feb 2008
Posts: 218
|
| Gaya3 wrote: |
| j.f.sorge wrote: |
My question is: does WTX use a connection pooling and how to you configure it?
|
Yes, WTX Uses connection pooling
what kind adapter that you have used in Data base integrator to create the .mdq file |
The .mdq is configured as followed
Adapter Type: ODBC
Adapter Platform: Microsoft Windows
Can you configure connection pooling in the dstx.ini?
_________________
IBM Certified Solution Designer - WebSphere MQ V6.0
IBM Certified Solution Developer - WebSphere Message Broker V6.0
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Wed Oct 21, 2009 12:29 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
|
| Back to top |
|
|
| j.f.sorge |
| Posted: Thu Oct 22, 2009 1:31 am Post subject: |
|
|
Master
Joined: 27 Feb 2008
Posts: 218
|
As I wrote in my first posting we are using WTX 8.1.0.2(38)
We found some configuration options in dstx.ini
| Code: |
;IdleDB=0
;SLimDB=0
;HLimDB=0
;KeepDB=0
;MinDB=0 |
and will try to change the value of KeepDB.
Hope that helps!
_________________
IBM Certified Solution Designer - WebSphere MQ V6.0
IBM Certified Solution Developer - WebSphere Message Broker V6.0
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
|
|
