| Author |
Message
|
| sanghaviamit |
 Posted: Sun Nov 19, 2006 11:21 pm Post subject: Keep Finished Processes in MQ Runtime (KEEP_PROC_PERIOD) |
 |
|
Novice
Joined: 26 Jul 2006
Posts: 12
Location: India
|
Hi,
I got a shock last week when I found from my FMCDB that more than 64K processes were in finished state but not cleaned up. Those are my cleanup server settings,
Cleanup server settings
Check interval PT1M
Start mode Immediate
Cleanup time PT1M
Cleanup delay time PT1M
The value of KEEP_PROC_PERIOD in FMCDB is 2, But I dont know what does that mean?
Is is something wrong in my cleanup server settings or is it the "Keep Finished Process" value which is causing the problem???
Pls help!!!
_________________
Regards & Thanks,
Amit Sanghavi. |
|
| Back to top |
|
 |
| jmac |
| Posted: Mon Nov 20, 2006 8:15 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
These are the default values for the cleanup server
| Code: |
SERVER TYPE CLEANUP_SERVER
START_MODE DEFERRED
START_TIME EVERY DAY AT 0:00
STOP_TIME EVERY DAY AT 6:00
CHECK_INTERVAL 300 SECONDS
CLEANUP_TIME 604800 SECONDS
CLEANUP_DELAY_TIME 3600 SECONDS |
You have radically changed the settings of the cleanup server, I would revert to the defaults and see what happens. You don't necessarily need to change the START_MODE, but I would change the other parameters if I were you.
| sanghaviamit wrote: |
| The value of KEEP_PROC_PERIOD in FMCDB is 2, But I dont know what does that mean? |
What is KEEP_PROC_PERIOD?
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| sanghaviamit |
| Posted: Mon Nov 20, 2006 9:34 pm Post subject: KEEP_PROC_PERIOD |
|
|
Novice
Joined: 26 Jul 2006
Posts: 12
Location: India
|
There is a tab in Domain, "Process Times" which gives you option abt how much time you want keep the finished process in the system.
The options are Never, Forever and any specified period in Mins, Days, etc...
From what I found is that this option is set to "Forever" in my system. I would like to know will there be any impact in performance, if all my finished processes are not cleaned up?
_________________
Regards & Thanks,
Amit Sanghavi. |
|
| Back to top |
|
|
| jmac |
| Posted: Tue Nov 21, 2006 6:39 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Your database will grow continually. KEEP FOREVER is NOT a good idea. Generally in a production system I would specify KEEP NEVER, which will have completed instances and workitems cleaned up once they are finished during the next run of the cleanup server.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| sanghaviamit |
| Posted: Tue Nov 21, 2006 6:55 am Post subject: |
|
|
Novice
Joined: 26 Jul 2006
Posts: 12
Location: India
|
What kind of impact it can have on system apart from increase in database size?
_________________
Regards & Thanks,
Amit Sanghavi. |
|
| Back to top |
|
|
| jmac |
| Posted: Tue Nov 21, 2006 6:58 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
It seems to me that the bigger the database, the longer it will take to do queries etc. I really don't have any statistics on this, I just think that a smaller db will perform better.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| k4mik4z3 |
| Posted: Wed Nov 22, 2006 11:10 pm Post subject: |
|
|
Novice
Joined: 03 Aug 2006
Posts: 24
Location: India
|
| And if you want to find a particular process instance, unless your following a certain convention for naming process instances, you may have to search through a large number of process instances to find the one you want (for debugging or whatever the need may be) |
|
| Back to top |
|
|
|
|
