| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| clean up Runtime DB |
« View previous topic :: View next topic » |
| Author |
Message
|
| hamao |
 Posted: Fri Jul 08, 2005 4:41 am Post subject: clean up Runtime DB |
 |
|
Newbie
Joined: 26 Aug 2004
Posts: 4
|
I deleted ALL ProcessInstances from my MQWorkflow Runtime DB.
Of course, with MQWorkflow API.
I checked Runtime DB and counted records of "PROCESS_INST" table.
The number of records of PROCESS_INST is Zero.
But, I found "BLOCK_INST", "CONTAINER", "PROGRAM_ACT_INST",
"WORK_ITEM" tables have some records.
Can I delete all records from these tables in this case?
regards
hamao |
|
| Back to top |
|
 |
| jmac |
| Posted: Fri Jul 08, 2005 5:29 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
I would not do any deletes against the SQL tables. Only use the api. I am not sure what it is that you are seeing in these tables. Perhaps you should run the Process Template Delete Tool (I think this is installed in the bin directory when you install MQWF V3.6, not sure about 3.5, but you can definitely search the IBM MQWF site and find it). It could be that the remnants you are seeing will be cleaned up by the PTDT tool.
If you just want a clean database, just delete and readd the configuration.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| hamao |
| Posted: Sat Jul 09, 2005 2:33 am Post subject: |
|
|
Newbie
Joined: 26 Aug 2004
Posts: 4
|
Thanks, jmac.
I reminded that "clean up server" (fmccmain) did not run in my MQWorkflow environment and started it.
It seems ALL unnecessary records cleared...
I believed that, when PI deleted, all related ITEM records and INSTANCE records are deleted at the same time.
But, exceptional case exists .
My ProcessTemplates have one or more BLOCKs.
If any ProcessInstances go around the same BLOCK more two times,
only deletion PI do NOT cause all related records clear (BLOCK_INST etc).
is this a specification?
I hoped PT delete tool. Thank you for tool information.
regards.
hamao |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
