| Author |
Message
|
| kwcwong |
 Posted: Wed Feb 19, 2003 10:58 pm Post subject: Cleanup Runtime DB |
 |
|
Newbie
Joined: 18 Feb 2003
Posts: 3
|
Hi all,
Do there any utility/method that I can use to cleanup the runtime database? I don't want to drop the runtime database and rebuild a new one.
Thanks and regards,
Chris. |
|
| Back to top |
|
 |
| yaakovd |
| Posted: Thu Feb 20, 2003 12:02 am Post subject: |
|
|
Partisan
Joined: 20 Jan 2003
Posts: 319
Location: Israel
|
1. connect to DB
2. run LIST TABLES and receive all names (more than 60):
ACT_NOT_TEMPL
ACT_TEMPL_RES_ASG
ACTIVITY_TEMPL
ACTIVITY_WORK_ITEM
AUDIT_TRAIL
BLOCK_ACT_INST
BLOCK_INST
BLOCK_TEMPL
CATEGORY
CONTAINER...
3. create script for all wanted tables: DELETE FROM TABLE [name]
Make sure if you want cleanup tables like:
PROCESS_TEMPL, PERSON, ROLE, SERVER, etc.
_________________
Best regards.
Yaakov
SWG, IBM Commerce, Israel |
|
| Back to top |
|
|
| fbaril3 |
| Posted: Thu Feb 20, 2003 1:20 am Post subject: |
|
|
Acolyte
Joined: 14 Jun 2002
Posts: 53
|
In the case you use the audit to DB option, you can clean the audit records (which can be quite important if you have not cleared the DB for long) with the "fmcsclad" command.
Hope this Help. |
|
| Back to top |
|
|
| jet |
| Posted: Fri Feb 21, 2003 11:14 am Post subject: |
|
|
Apprentice
Joined: 04 Dec 2002
Posts: 49
Location: New York
|
| can you explain more about what information you want to clean up? work iem? or process instances? or audit trail DB? |
|
| Back to top |
|
|
| kwcwong |
| Posted: Tue Feb 25, 2003 8:18 am Post subject: |
|
|
Newbie
Joined: 18 Feb 2003
Posts: 3
|
Thanks all for help.
My problem is to remove a user from the runtime db, together with the workitem(s) assigned to him/her. I find that I can't remove a user if there have already been some workitem(s) assigned to that user.
Any suggestion?
Thx in advance. |
|
| Back to top |
|
|
| yaakovd |
| Posted: Tue Feb 25, 2003 8:31 am Post subject: |
|
|
Partisan
Joined: 20 Jan 2003
Posts: 319
Location: Israel
|
You just need unlock all WorkItems in state (CHECKED_OUT).
Administrator or user itself can do it.
Then you can delete user from DB. Removing of WorkItem is not must, becouse it will be removed after processing of activity by another user.
_________________
Best regards.
Yaakov
SWG, IBM Commerce, Israel |
|
| Back to top |
|
|
|
|
