| Author |
Message
|
| ucbus1 |
 Posted: Tue Oct 26, 2004 6:25 am Post subject: slow response |
 |
|
Knight
Joined: 30 Jan 2002
Posts: 560
|
I have around 4200 work instances and 8400 work items. I have on my out of box client two views of to show the work items ( max. 1500)
I have noticed the response is slow during some days.
1.It can not be network speed. since I have another application working fine
2.FMCD1 is fine. I do not see dead locks/errors. We just ran some runstats/rebind.
3. I asked DBAs to check the SQL and they found a weird SQL getting executed over and over.
"SELECT WI.OWNER, WI.OWNER, WI.OWNER FROM FMC.WORK_ITEM WI, FMC.WORK_ITEM_VIEW WIV"
It is not holding up but getting executed over and over. As a programmer I do not know what is the purpose of FMC.WORK_ITEM_VIEW WIV. This is Workflow generate SQL. Is something wrong with the set up.
Is something wrong?
4. Does running another execution server helps?
I see from the logs that there is one execution server running..
Execution server for system FMCSYS1 started.
Execution server instance started.
If running execution server instance helps, can I run any time when the response is slow or if there is a criteria? Please let me know how can I start another instance?
Thanks |
|
| Back to top |
|
 |
| paoloz |
| Posted: Tue Feb 01, 2005 6:26 am Post subject: web client slow response |
|
|
Novice
Joined: 31 Dec 2004
Posts: 12
|
We have exactly the same problem.
Please let me know if and how you solved it.
We run a three-tier configuration with MQ Workflow running on z/OS system.
As far as I'm concerned, isolating the query and modifying it (rebuilt the join condition with the table PER_AUTH_FOR_WITM) in a well-defined environment, put the getpages down.
Many thanks to everybody sending a reply  |
|
| Back to top |
|
|
| jmac |
| Posted: Tue Feb 01, 2005 6:46 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
If your DBA examines the SQL and finds that an index would improve things, I would recommend that you contact IBM with that information, and hopefully, they will tell you to define that index.
If you define indexes that are not defined by MQWF during configuration, it is best to run them by IBM to ensure that they are not going to cause you more harm than good. The other issue is that anytime you apply service you may have to redefine your index.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| scar |
| Posted: Thu Feb 03, 2005 3:31 am Post subject: |
|
|
Centurion
Joined: 23 Jun 2004
Posts: 145
|
As the number of workitems/ active istances increase workflow slows down.
to decrease the response time you can increase the execution server instances but only 2 instances per processor.
if you do more than 2 instances per processor it will do more harm than good. |
|
| Back to top |
|
|
| nathanw |
| Posted: Thu Feb 03, 2005 5:12 am Post subject: |
|
|
Knight
Joined: 14 Jul 2004
Posts: 550
|
had a similar problem to this and founf that part of the problem was the I/O to db2
solution was to ensure that db2 was running across all processors and not just one by changing the license |
|
| Back to top |
|
|
| paoloz |
| Posted: Fri Feb 25, 2005 4:17 am Post subject: |
|
|
Novice
Joined: 31 Dec 2004
Posts: 12
|
For ucbus1
We solved the problem simply using the following filter parameter:
OWNER=CURRENT USER
This should avoid the generation of a complex query command by the FMCDDSQL (Dynamic query generator) which otherwise would take into consideration the authorization table.
regards |
|
| Back to top |
|
|
| ucbus1 |
| Posted: Fri Feb 25, 2005 8:50 am Post subject: |
|
|
Knight
Joined: 30 Jan 2002
Posts: 560
|
| Quote: |
We solved the problem simply using the following filter parameter:
OWNER=CURRENT USER
This should avoid the generation of a complex query command by the FMCDDSQL (Dynamic query generator) which otherwise would take into consideration the authorization table.
|
Thanks Paloz,
Could you please let me know where you have added this filter. If possible, please let me know. |
|
| Back to top |
|
|
| jmac |
| Posted: Fri Feb 25, 2005 8:58 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Not sure where Paloz has this, but I assume it's on a queryWorkitems (if 3.5 I guess it could be a queryActivityInstances).
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| paoloz |
| Posted: Tue Apr 12, 2005 5:22 am Post subject: |
|
|
Novice
Joined: 31 Dec 2004
Posts: 12
|
|
| Back to top |
|
|
|
|
