| Author |
Message
|
| koko |
 Posted: Wed Feb 01, 2006 9:06 am Post subject: Cleanup Server + Runstats problem |
 |
|
Master
Joined: 26 Sep 2003
Posts: 206
|
We run the cleanup server everynight from 12 AM to 6AM. Recently we asked the DBAs to run the runstats/rebinds everynight at 1AM. Is this a prorblem??
I think it is as the cleanup guy is trying to delete some stuff, the runstats are trying to gather incorrect data.
How do I know when I can schedule my cleanup server without impacting runstats. How long does it really need to run. Can I make it run from 12 to 2AM and then run the runstats at 2 AM everynight?
_________________
Thanks
Koko |
|
| Back to top |
|
 |
| vennela |
| Posted: Wed Feb 01, 2006 11:03 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
| Quote: |
| How do I know when I can schedule my cleanup server without impacting runstats. How long does it really need to run. Can I make it run from 12 to 2AM and then run the runstats at 2 AM everynight? |
You should ask the DBA's how they do that for other application databases.
Anyway, 2 hours for cleanup server should be just fine. |
|
| Back to top |
|
|
| koko |
| Posted: Fri Feb 03, 2006 8:14 pm Post subject: |
|
|
Master
Joined: 26 Sep 2003
Posts: 206
|
| Quote: |
Cleanup time
Specifies how long the cleanup server should be deleting process instances. The specified amount of time that the cleanup server deletes process instances is the minimum amount. The cleanup server may be deleting longer than the specified amount of time.
Cleanup delay time
Specifies how long the cleanup server should be idle before checking again whether process instances are to be deleted. This only applies to the situation where the server has deleted all process instances.
|
I have cleanup server running every night from 12 AM to 6 AM.
- Cleanup time P1W
- Cleanup delay time PT1H
are my current settings. Does the cleanup time , cleanup delay time matter for me?
_________________
Thanks
Koko |
|
| Back to top |
|
|
| jmac |
| Posted: Sat Feb 04, 2006 4:03 pm Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
I dont remember the command off the top of my head but if you look in the Production Considerations support pac by Wolfgang K. you will see the commands SQL commands that will tell you how many Instances and workitems there are to cleanup. If you want to know how long your Cleanup server is running, simply put those commands on a cron and when you see that the number is 0 you know the cleanup server has completed.
Also, see the FMC_NO_WORKITEM_CLEANUP parameter for possible performance improvement... I believe the doc is in the Install guide.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| praveenchhangani |
| Posted: Sun Feb 05, 2006 4:08 pm Post subject: |
|
|
Disciple
Joined: 20 Sep 2002
Posts: 192
Location: Chicago, IL
|
You can verify the number of business processes that are pending for deletion by using the following SQL command:
select count(*) from fmc.process_inst where state=128
_________________
Praveen K. Chhangani,
IBM Certified Solutions Designer -
MQ Workflow 3.4. |
|
| Back to top |
|
|
| koko |
| Posted: Mon Feb 06, 2006 7:17 pm Post subject: |
|
|
Master
Joined: 26 Sep 2003
Posts: 206
|
Hello Praveen,
Welcome back to the group. Its been a long time since you posted something here. LOL
_________________
Thanks
Koko |
|
| Back to top |
|
|
| praveenchhangani |
| Posted: Tue Feb 07, 2006 10:37 am Post subject: |
|
|
Disciple
Joined: 20 Sep 2002
Posts: 192
Location: Chicago, IL
|
Thanks! For a while now I was involved in some WPI/WPS efforts. Anyway, now that I'm back in the Workflow world you'll probably see more of me! 
_________________
Praveen K. Chhangani,
IBM Certified Solutions Designer -
MQ Workflow 3.4. |
|
| Back to top |
|
|
| latelatif |
| Posted: Wed Feb 08, 2006 4:34 pm Post subject: |
|
|
Novice
Joined: 08 Feb 2006
Posts: 21
|
| And me as well KoKo |
|
| Back to top |
|
|
| zaklum |
| Posted: Thu Feb 09, 2006 11:03 am Post subject: |
|
|
Voyager
Joined: 17 Mar 2005
Posts: 96
Location: Boca Raton
|
Guys,
Where do I set the clean up server parameters to execute every hour of the day as opposed to 12 to 6 AM?
This is how it looks like currently:
- Cleanup server settings
- Check interval PT5M
- Start mode Deferred
- Server start time Everyday at 00:00
- Server stop time 06:00
- Cleanup time P1W
- Cleanup delay time PT1H
thanks |
|
| Back to top |
|
|
| jmac |
| Posted: Thu Feb 09, 2006 11:13 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
| zaklum wrote: |
Where do I set the clean up server parameters to execute every hour of the day as opposed to 12 to 6 AM?
|
There is no setting that will do what you want.
The cleanup server can be started
Automatically (i.e its always up)
Deferred (that's the default and what you currently have)
Manually (i.e you start it with fmcautil)
The best you could do is change to Manual and start/stop the Cleanup server manually with fmcautil via a cron. I would not recommend this without doing some testing to ensure it would meet your needs
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| praveenchhangani |
| Posted: Sun Feb 12, 2006 11:14 pm Post subject: |
|
|
Disciple
Joined: 20 Sep 2002
Posts: 192
Location: Chicago, IL
|
| zaklum wrote: |
Guys,
Where do I set the clean up server parameters to execute every hour of the day as opposed to 12 to 6 AM?
This is how it looks like currently:
- Cleanup server settings
- Check interval PT5M
- Start mode Deferred
- Server start time Everyday at 00:00
- Server stop time 06:00
- Cleanup time P1W
- Cleanup delay time PT1H
thanks |
Zaklum,
The Cleanup server should really be run during off business or production hours for performance reasons, however, I suppose if you really had a need to start and stop the cleanup server selectively you could develop an automated script that issues the "fmccmain" command for your workflow configuration. Depending on the platform, you could run these jobs through Scheduled Tasks / Cron jobs etc.
I ran a quick test on windows.
1. I went in through the fmcautil and started the cleanup server
2. After this I check in the windows task manager and noticed a corresponding "fmccmain.exe" running.
[ fmccmain.exe represents the cleanup server BTW]
3. Next I issued a stop to the cleanup server through the fmcautil and verified that the fmccmain.exe process also terminated respectively.
I then wrote a quick script to start and stop the cleanupserver and sure enough after running the start script the process was reflected in the windows task manager as well as the fmcautil utility after performing a query command. Running the stop script yielded in expected results as well both in the fmcautil and the task manager.
I'm not sure if I would adopt or recommend this techique myself, except perhaps for situations where one was trying to measure cleanup server performance, but it's good to know as it is, in my opinion.
Thanks,
_________________
Praveen K. Chhangani,
IBM Certified Solutions Designer -
MQ Workflow 3.4. |
|
| Back to top |
|
|
| zaklum |
| Posted: Mon Feb 13, 2006 7:51 am Post subject: |
|
|
Voyager
Joined: 17 Mar 2005
Posts: 96
Location: Boca Raton
|
Praveen,
Thank you very much for your help. I will certainly take this into account.
-Zaklum |
|
| Back to top |
|
|
|
|
