Author |
Message |
Topic: Different Aplications Running in the same instance of MQWF |
mzg
Replies: 7 Views: 5614
|
Forum: Workflow Engines - IBM MQ Workflow & Business Process Choreographer Posted: Thu Sep 28, 2006 5:49 am Subject: Different Aplications Running in the same instance of MQWF |
Creating an index on the description will definitively help, but not in the case where you do a filter with
description like '*text*'
Here you'll have a nonindexable predicate which will result in ... |
Topic: Deadloack occured while accessing the NOTIFICATION_ITEM tabl |
mzg
Replies: 2 Views: 4067
|
Forum: Workflow Engines - IBM MQ Workflow & Business Process Choreographer Posted: Thu Sep 28, 2006 5:33 am Subject: Deadloack occured while accessing the NOTIFICATION_ITEM tabl |
Hi,
you may want to run some database optimizations (runstats/rebind), which can be invoked through "fmczutil".
If that doesn't help to remove the deadlocks you might want to try to in ... |
Topic: MQSeries Workflow Performance Analysis and Tunning |
mzg
Replies: 11 Views: 6240
|
Forum: Workflow Engines - IBM MQ Workflow & Business Process Choreographer Posted: Tue Mar 09, 2004 4:02 am Subject: MQSeries Workflow Performance Analysis and Tunning |
Did you ever do runstats/rebind on the database? This usually helps in getting timeout / deadlock relief.
I did a small capacity consideration for your process (12 activities, 1 block) . It requir ... |
Topic: [Solved] Deleting records from audit trail for finished proc |
mzg
Replies: 1 Views: 1992
|
Forum: Workflow Engines - IBM MQ Workflow & Business Process Choreographer Posted: Tue Mar 09, 2004 3:40 am Subject: [Solved] Deleting records from audit trail for finished proc |
There are usually multiple entries with the same top level process id (e.g. for each activity in the process), so the index cannot be unique.
Ascending or Descending might not make a lot of sense e ... |
Topic: MQSeries Workflow Performance Analysis and Tunning |
mzg
Replies: 11 Views: 6240
|
Forum: Workflow Engines - IBM MQ Workflow & Business Process Choreographer Posted: Mon Mar 08, 2004 7:07 am Subject: MQSeries Workflow Performance Analysis and Tunning |
Hi Fagundes,
do I understand you right? Your program runs in an infinite loop (calling CreateStartProcessinstance() ) for 25 seconds and then those processes run for 40 minutes?
Sorry, but I do ... |
Topic: WOrkflow Load Testing |
mzg
Replies: 4 Views: 2637
|
Forum: Workflow Engines - IBM MQ Workflow & Business Process Choreographer Posted: Thu Feb 19, 2004 1:10 am Subject: load test basics |
for any kind of load test the first thing you need is an automated scenario , a measurement method, and some means to run this scenario in various volumes - either through simple scripts of through e ... |
Topic: Timeout in query workitems |
mzg
Replies: 6 Views: 7223
|
Forum: Workflow Engines - IBM MQ Workflow & Business Process Choreographer Posted: Thu Feb 19, 2004 12:59 am Subject: Check some DB2 settings |
it might be that you're running low on page cleaners or something else in that area.
Try to lower the ?chngpgs_thresh parameter, and/or increase the number of pagecleaners and/or increase the siz ... |
Topic: performance and tunning parameters |
mzg
Replies: 3 Views: 2556
|
Forum: Workflow Engines - IBM MQ Workflow & Business Process Choreographer Posted: Fri Dec 12, 2003 3:34 am Subject: There is a rule of thumb |
If only MQWF servers (and the queuemanager and the database) is running on your box, then you can use number-of-execution-servers = 3 * number-of-physical-CPUs a a number to start with.
If you hav ... |