| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Lock wait time in the Workflow database |
« View previous topic :: View next topic » |
| Author |
Message
|
| emiranda |
 Posted: Fri May 27, 2005 6:01 am Post subject: Lock wait time in the Workflow database |
 |
|
Disciple
Joined: 21 Nov 2002
Posts: 196
Location: Dublin, Ireland
|
Hi all,
We are running some load tests with a simple flow (1 block, 3 processes, 6 activities, standard containers) and one thing stands out as a concern is the amount of lock wait time in the Workflow database.
Some statements run in less than 0.01 of a second 99% of the time but sometimes take over 2 seconds. The maximum execution time of an SQL statement in the Workflow database during the testing was 2.29 seconds.
Is this a known problem, or even an expected condition, with DB2 Workflow databases?
_________________
Warm Regards,
EM |
|
| Back to top |
|
 |
| emiranda |
| Posted: Mon May 30, 2005 12:42 am Post subject: |
|
|
Disciple
Joined: 21 Nov 2002
Posts: 196
Location: Dublin, Ireland
|
Come on guys... any ideas? Is there none having the same behavior in their database? 
_________________
Warm Regards,
EM |
|
| Back to top |
|
|
| hos |
| Posted: Mon May 30, 2005 5:55 am Post subject: |
|
|
Chevalier
Joined: 03 Feb 2002
Posts: 470
|
Hi,
what do you expect? If your load test basically does the same sequence of
API calls, all execution servers will call the same DB calls in parallel and lock the same tables / rows. So it cannot be avoided that wait times occur in the DB. This is basic DB behaviour and not specific to MQWF.
Tuning the DB ( e.g. multiple disks for the tables ) helps to minimize the DB response time. |
|
| Back to top |
|
|
| emiranda |
| Posted: Mon May 30, 2005 6:13 am Post subject: |
|
|
Disciple
Joined: 21 Nov 2002
Posts: 196
Location: Dublin, Ireland
|
|
| 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
|
|
|
|
