| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| WMB 6.1 flow gets hung when db2 Stored Proc is locked |
« View previous topic :: View next topic » |
| Author |
Message
|
| bprasana |
 Posted: Wed May 04, 2011 1:20 pm Post subject: WMB 6.1 flow gets hung when db2 Stored Proc is locked |
 |
|
Disciple
Joined: 18 Apr 2005
Posts: 179
|
we are using db2 9.5. We have a set of stored procs that we call from WMB 6.1.0.7 broker.
Our WMB flow wait indefinitely for the SP to return.
Ultimately we had to reload the EG or kill the EG(sometimes).
Did anyone encounter a similar problem?
Can we mention a time out for stored procs in WMB or in ODBC profile? |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Wed May 04, 2011 4:11 pm Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Maybe you should just fix the stored procedures so that they don't loop forever?
And apply 6.1.0.9. I believe there are fixes in this area. |
|
| Back to top |
|
|
| bprasana |
| Posted: Wed May 04, 2011 4:28 pm Post subject: |
|
|
Disciple
Joined: 18 Apr 2005
Posts: 179
|
thanks mqjeff,
Yes fixing the SP is priority 1.
I was just wondering how to mitigate the impact on end user.
maybe, adding a new instance would help or any other suggestions you all might provide.
Also,
Are you referring to any specific issues that got fixed in .9?
I checked http://www-01.ibm.com/support/docview.wss?&uid=swg27015978
this link and did not find anything explicitly mentioned. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu May 05, 2011 1:31 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Huh. I thought I had remembered seeing a fix related to ODBC timeouts. But in looking again, even at v7, I don't see one.
Sorry.
Regardless, the DBA should be able to kill the connection from the DB2 side and this should cause the EG to start functioning again. |
|
| 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
|
|
|
|
