| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Execution group not Responding |
« View previous topic :: View next topic » |
| Author |
Message
|
| ANILK |
 Posted: Thu Nov 05, 2015 8:27 pm Post subject: Execution group not Responding |
 |
|
Acolyte
Joined: 01 May 2014
Posts: 61
|
Hi Friends,
we are using WMB 8.0.0.4 , and we are running multiple execution groups to handle the heavy traffic load. we have deployed a message flow with a database update qry in one of the EG , frequently this EG is getting hanged and messages are not getting processed . normally we kill the EG process and restart to fix this issue .
i don't see any error log for this issue .but when we consulted our DBA he confirmed that there was a DB row lock issue on a same time and that could be the root cause for this issue.
do we need to apply any fix in EG level or in code level to fix this issue ?,
or this issue is only related to Oracle DB table ?
kindly share your suggestions .
Thanks
|
|
| Back to top |
|
 |
| mpong |
| Posted: Thu Nov 05, 2015 10:56 pm Post subject: |
|
|
Disciple
Joined: 22 Jan 2010
Posts: 164
|
| Need more information on database update, are you trying to update multiple tables at the same time or multiple rows? |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Fri Nov 06, 2015 12:05 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
Also look at any selects in the Update query. If you are using a select for reference and not changing it then it could improve performance if that select was done without initiating any locking.
Also look at doing the update inside a Stored Procedure. This may well be more efficient than executing a complex update statement every time.
This way you can test the SP outside of broker to make sure there are no locking issues.
 (as an ex Oracle DBA)
_________________
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 |
|
|
| ANILK |
| Posted: Fri Nov 06, 2015 2:07 am Post subject: |
|
|
Acolyte
Joined: 01 May 2014
Posts: 61
|
| mpong wrote: |
| Need more information on database update, are you trying to update multiple tables at the same time or multiple rows? |
we are not updating multiple tables . only updating multiple rows on a single table , |
|
| Back to top |
|
|
| ANILK |
| Posted: Fri Nov 06, 2015 2:21 am Post subject: |
|
|
Acolyte
Joined: 01 May 2014
Posts: 61
|
| smdavies99 wrote: |
Also look at any selects in the Update query. If you are using a select for reference and not changing it then it could improve performance if that select was done without initiating any locking.
Also look at doing the update inside a Stored Procedure. This may well be more efficient than executing a complex update statement every time.
This way you can test the SP outside of broker to make sure there are no locking issues.
(as an ex Oracle DBA) |
Yes, we are using a select reference column in the update qry, and same select reference column will be updated also.
Update query
----------------
UPDATE TABLEB SET CLOUMN1 ='Y' , CLOLUMN2 ='E' ,COLUMN3 ='T' WHERE COLUMN4 ='O' AND COLUMN5= '9' AND COLUMN6 ='W' AND COLUMN1 ='P' ;
Thanks |
|
| 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
|
|
|
|
