| Author |
Message
|
| aghallab |
 Posted: Mon Apr 23, 2007 5:31 am Post subject: database size |
 |
|
Apprentice
Joined: 20 Jul 2004
Posts: 31
|
Each day I take backup for database (db2) I notice the database size increase although the pending processes finished and work item table reduced from 1700000 record to 200000 and audit table is empty ? can any one explain that
Thanks . |
|
| Back to top |
|
 |
| hos |
| Posted: Tue Apr 24, 2007 5:19 am Post subject: |
|
|
Chevalier
Joined: 03 Feb 2002
Posts: 470
|
| Check that the cleanup server is running on a regulary base in oder to get the obsolete records physically deleted. |
|
| Back to top |
|
|
| aghallab |
| Posted: Wed Apr 25, 2007 5:23 am Post subject: |
|
|
Apprentice
Joined: 20 Jul 2004
Posts: 31
|
| i check that and it's run properly. |
|
| Back to top |
|
|
| jmac |
| Posted: Wed Apr 25, 2007 6:27 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
You might want to run the following query against the Process Instance table
| Code: |
| select count(*) from fmc.process_inst where state=128 |
This will show you how many processes you have that are awaiting cleanup. If the number is quite large, I would say you are having Cleanup server issues, In fact since you indicate that the Cleanup server is running it should be very close to 0. Let us know what you are seeing and maybe someone can come up with an answer for you.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| aghallab |
| Posted: Sun Apr 29, 2007 5:49 am Post subject: |
|
|
Apprentice
Joined: 20 Jul 2004
Posts: 31
|
| after running this command i get about 100 record . that's mean no problem in cleanup server |
|
| Back to top |
|
|
| jmac |
| Posted: Sun Apr 29, 2007 6:58 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Since it appears that your cleanup server is running properly, the answer must be that you are just running more work and you have not reached an equilibrium for your RTDB yet.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
|
|
