| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| [SOLVED] CleanupServer and Runtime Database |
« View previous topic :: View next topic » |
| Author |
Message
|
| Liquid |
 Posted: Tue Jul 03, 2007 7:05 am Post subject: [SOLVED] CleanupServer and Runtime Database |
 |
|
Acolyte
Joined: 08 Sep 2004
Posts: 52
Location: Hungary, Europe
|
Hello!
Our client has a production environment (call it A) and about a month ago they exported the runtime DB and imported it into another host, where they had previously built up the same production environment (call it B).
A is in every day use, B is recently not used.
After executing the cleanup server (manually) on B machine, the record number of PROCESS_INST, WORK_ITEM, BLOCK_ACT_INST, PROCESS_ACT_INST, PROGRAM_ACT_INST etc. tables decreased dramatically (more than 80%, because the last run was quite a long ago).
Than, we executed the cleanup server on machine A and the result was almost the same, except that the PROGRAM_ACT_INST record number decreased only just about 10%.
Has anybody have seen similar like this?
What is the explanation the the difference??
Thanks,
Liquid
BUT
Last edited by Liquid on Wed Jul 25, 2007 12:22 am; edited 1 time in total |
|
| Back to top |
|
 |
| jmac |
| Posted: Tue Jul 03, 2007 11:40 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Are both of these systems at the exact same version level (including fixpacks). I seem to recall there was a fixpack a while back that did something to the PROGRAM_ACT_INST cleanup.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| Liquid |
| Posted: Thu Jul 05, 2007 12:38 am Post subject: |
|
|
Acolyte
Joined: 08 Sep 2004
Posts: 52
Location: Hungary, Europe
|
| jmac wrote: |
| Are both of these systems at the exact same version level (including fixpacks). I seem to recall there was a fixpack a while back that did something to the PROGRAM_ACT_INST cleanup. |
I'll ckeck it.
By the way, I know it's not the proper way, but can't we delete the content of there tables (or just the content of the PROGRAM_ACT_INST) table manually with sql, where the record status is deleted? I guess, it will cause inconsistency in the RT DB, isn't it?
Thanks,
Liquid |
|
| Back to top |
|
|
| jmac |
| Posted: Thu Jul 05, 2007 5:16 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
I do not know if this would put the RTDB in an inconsistent state. I always use cleanup server, not sql to do deletions.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| hos |
| Posted: Thu Jul 05, 2007 10:28 pm Post subject: |
|
|
Chevalier
Joined: 03 Feb 2002
Posts: 470
|
DONT'T DELETE RT DB CONTENT MANUALLY UNLESS INSTRUCTED BY IBM SUPPORT!!!
It will definitely cause inconsistencies and in worst case make your DB unusable. In either case you will loose support from IBM. If you have 'garbage' in the DB that is not removed, move to the latest Service Pack and then retry. |
|
| Back to top |
|
|
| Liquid |
| Posted: Mon Jul 09, 2007 3:27 am Post subject: |
|
|
Acolyte
Joined: 08 Sep 2004
Posts: 52
Location: Hungary, Europe
|
| hos wrote: |
DONT'T DELETE RT DB CONTENT MANUALLY UNLESS INSTRUCTED BY IBM SUPPORT!!!
It will definitely cause inconsistencies and in worst case make your DB unusable. In either case you will loose support from IBM. If you have 'garbage' in the DB that is not removed, move to the latest Service Pack and then retry. |
Ok, thanks, my question was just theoretical according to the manual deleting.
Meanwhile we saw that the service pack are different on the two machine, so, we try that way.
Thanks,
Liquid |
|
| 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
|
|
|
|
