| Author |
Message
|
| er_pankajgupta84 |
 Posted: Wed Feb 15, 2012 10:25 am Post subject: Esql/Compute db threads question |
 |
|
Master
Joined: 14 Nov 2008
Posts: 203
Location: charlotte,NC, USA
|
According to the documentation -
When you start a broker, and while it is running, it opens connections to WebSphere® MQ queues and to databases. The broker makes the connections when it needs to use them, and they remain open until one of the following events occurs:
1. The message flow has been idle for one minute (time configurable)
2. The message flow is stopped
3. The broker is stopped
Where we can configure the 1st property thru maxConnectionAge property.
This should hold good if I am doing db operation using eqsl in compute node.
Has anyone observed a deviation from this understanding ?
We ran a load test and found there are 100 DB threads remains active even after 24 hours of the load completion.
Can anybody comment on this?
It's a old production system and it also had db access thru java-jdbc and it could be possible that some clients (using java) might not have closed the connection after doing db operation.
But I would like to make sure that those are not any internal broker managed threads before looking into the java piece. |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Wed Feb 15, 2012 11:08 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
The behavior changes between versions. V6 behaves differently than V7. V8 has pre-emptive database connections.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| deepnair |
| Posted: Wed Feb 15, 2012 11:10 am Post subject: |
|
|
Apprentice
Joined: 07 Feb 2012
Posts: 35
|
| Quote: |
| V8 has pre-emptive database connections |
lancelotlinc - did u mean "connection pooling" in V8 ?
Thanks,
Deep Nair |
|
| Back to top |
|
|
| er_pankajgupta84 |
| Posted: Wed Feb 15, 2012 11:12 am Post subject: |
|
|
Master
Joined: 14 Nov 2008
Posts: 203
Location: charlotte,NC, USA
|
My Bad - I didn't specify the version
I am on WMB 6.1 with FP 3 on Z/os. |
|
| Back to top |
|
|
| er_pankajgupta84 |
| Posted: Wed Feb 15, 2012 11:31 am Post subject: |
|
|
Master
Joined: 14 Nov 2008
Posts: 203
Location: charlotte,NC, USA
|
Further notes (for WMB 6.1) -
Each broker needs the following connections:
1. Five for internal broker threads. 2.One for each Publish/Subscribe neighbor, if you are using retained publications and the topology has been deployed.
3. One for each message flow thread that contains a Publication node, if you are using retained publications.
4. One for each message flow thread that parses MRM messages.
5. A further number if you are using SCADA nodes with WebSphere® MQ Everyplace®. The exact number to add depends on whether thread pooling is being used (determined by the Use Thread Pooling property of the SCADAInput node):
If you are using the same database for several brokers, include all brokers in your calculations.
When you start a broker, it opens all connections that it needs to the broker database for its own operation. When you stop the broker, it releases all current database connection handles.
The broker also opens connections to WebSphere MQ queues and to user databases when it needs to use them, and these connections remain open until:
The connection has been idle for one minute
The broker is stopped
Still its written that these connections are closed if idle for 1 min |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Feb 15, 2012 11:52 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
You should review the list of APARS in 6.1 between FP3 and FPLatest (which I think is FP10).
You might find APARs in this area that you can apply or use to justify applying the entire FP.
But odds are good that it's the JDBC code leaving things open, rather than the ODBC code in broker... |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Wed Feb 15, 2012 12:21 pm Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| er_pankajgupta84 wrote: |
My Bad - I didn't specify the version
I am on WMB 6.1 with FP 3 on Z/os. |
z/OS is spelled with a lower case z and upper case OS. Yes, it matters.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| er_pankajgupta84 |
| Posted: Wed Feb 15, 2012 12:30 pm Post subject: |
|
|
Master
Joined: 14 Nov 2008
Posts: 203
Location: charlotte,NC, USA
|
|
| Back to top |
|
|
| er_pankajgupta84 |
| Posted: Fri Feb 24, 2012 8:24 am Post subject: |
|
|
Master
Joined: 14 Nov 2008
Posts: 203
Location: charlotte,NC, USA
|
Further discovery showed that the 100 connections I was refereing to were only ODBC connections.
All the java related connections are JDBC type 4. These were couple of leaks in that and we fixed it. Still these 100 ODBC connections are active on database even we stop load testing.
We don't use any database node just esql.
Can someone provide some pointer  |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Fri Feb 24, 2012 9:39 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
|
| Back to top |
|
|
| smdavies99 |
| Posted: Fri Feb 24, 2012 9:53 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
Ok, I give in. since when did the WM663 course get into Broker on z/OS Performance?
Suggesting that someone who is clearly beyond a beginner attend basic training is not very constructive (IMHO)
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Fri Feb 24, 2012 10:14 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| smdavies99 wrote: |
Ok, I give in. since when did the WM663 course get into Broker on z/OS Performance?
Suggesting that someone who is clearly beyond a beginner attend basic training is not very constructive (IMHO) |
I'm not in agreement with your assessment of skill level.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Feb 24, 2012 10:42 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| lancelotlinc wrote: |
| I'm not in agreement with your assessment of skill level. |
Based on?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| er_pankajgupta84 |
| Posted: Fri Feb 24, 2012 10:43 am Post subject: |
|
|
Master
Joined: 14 Nov 2008
Posts: 203
Location: charlotte,NC, USA
|
@lancelotlinc - spelling z/OS correctly doesn't define your skill set. Even it does then this forum is for helping other and not for funny replies.
People will appreciate you when you reply sensibly. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Fri Feb 24, 2012 10:44 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
|
| Back to top |
|
|
|
|
