| Author |
Message
|
| newfella |
 Posted: Mon Mar 22, 2004 9:01 am Post subject: Cleanup servers |
 |
|
Newbie
Joined: 17 Mar 2004
Posts: 2
Location: USA
|
Hi
Can anybody tell me where can I find some good recommendations for maintaining Cleanup servers.
Currently, our cleanup server is scheduled to run everday at 12 in the night when the volume of the transactions is not high. But we are experiencing deadlocks when the server starts cleaning up the processes. Is it because of the cleanup servers ?
We have this configuration on our machine:
Cleanup server settings
- Check interval PT5M
- Start mode Immediate
- Cleanup time P1W
- Cleanup delay time PT1H
Would appreciate any suggestions.
Thanx |
|
| Back to top |
|
 |
| jmac |
| Posted: Mon Mar 22, 2004 10:13 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
|
| Back to top |
|
|
| hos |
| Posted: Mon Mar 22, 2004 2:27 pm Post subject: |
|
|
Chevalier
Joined: 03 Feb 2002
Posts: 470
|
| Hi, please make sure that you applied the latest service level on your MQWF server. There are couple of deadlock fixes in the servicepacks. Check the readme file of the servicepack. |
|
| Back to top |
|
|
| Dio |
| Posted: Fri May 12, 2006 11:33 am Post subject: |
|
|
Novice
Joined: 18 Jan 2006
Posts: 11
Location: Moscow, Russia
|
We have the same error.
Cleanup server runs automaticaly 00:00 - 06:00 but all this time every second DB2 throws errors about deadlock escalation. No other errors in any logs. Cleanup server stops normaly.
We've got about 25.000-30.000 new proc. instances every day and most of then finishes same day (except 20-30 inst. waites next day).
2 weeks ago cleanup worked fine but now database grow very fast and now it's about 7Gb.
What about service packs that hos spoke about?
Our WF version is 3.5 SP4 |
|
| Back to top |
|
|
| Dio |
| Posted: Sat May 13, 2006 12:26 am Post subject: |
|
|
Novice
Joined: 18 Jan 2006
Posts: 11
Location: Moscow, Russia
|
Here I've this:
"FMCCLEAN should only run when ALL Workflow configurations are down. "
Is it really necessary? So in our case exec. servers are running but it could be 1-2 new process instances for all night. Can it prevent cleanup server to work? |
|
| Back to top |
|
|
| jmac |
| Posted: Sat May 13, 2006 3:38 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
fmcemain must be running in order for fmccmain to do its cleanup. When was the last time you ran a runstats rebind?
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| Dio |
| Posted: Sat May 13, 2006 9:25 am Post subject: |
|
|
Novice
Joined: 18 Jan 2006
Posts: 11
Location: Moscow, Russia
|
| jmac wrote: |
| When was the last time you ran a runstats rebind? |
Runstats about 2 weeks, rebind - long ago. Is it so bad? How often it should be done? |
|
| Back to top |
|
|
| jmac |
| Posted: Sat May 13, 2006 5:48 pm Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
On a system that is heavily used I would say once a week
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| hifive |
| Posted: Mon May 15, 2006 8:18 am Post subject: |
|
|
Acolyte
Joined: 06 May 2006
Posts: 52
|
| How do i c the deleted instance or workitems in the database, any table name specific??? |
|
| Back to top |
|
|
| jmac |
| Posted: Mon May 15, 2006 9:14 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
|
| Back to top |
|
|
| hifive |
| Posted: Mon May 15, 2006 9:21 am Post subject: |
|
|
Acolyte
Joined: 06 May 2006
Posts: 52
|
|
| Back to top |
|
|
|
|
