- This topic has 4 replies, 3 voices, and was last updated 4 years, 9 months ago by .
-
Topic
-
We recently had an issue where our recovery DB became very large due to an interface downtime on a thread where the messages coming across were very large – larger than we usually expect. Every month we do a patching process where we do a cleanup including reinitialization of the databases using the command HCIDBINIT -iC . In order to fix the large unstable database problem we had to do a destructive db init using HCIDNINIT -ACf
I understand the -iC clears the ICL registry and the control files. What I don’t understand is that all our other site databases are “normal” size and we, at least during my tenure (4 years), have never done a destructive reinit of databases. We do “clear” the recovery and error database using hcidbdump as needed and during recovery.
I’ve also found http://174.138.42.153/forums/topic/how-big-is-your-recovery-error-db/ this post which seems to suggest that using hcidbdump does not actually reduce database size. Im talking about hcidbdump -e -D and -r -D. I could be misunderstanding that post though.
My questions:
- Does hcidbdump actually reduce recover/error database size?
- Should we be doing a hcidbinit -ACf every patching cycle – after shutting down inbounds, clearing Qs, etc, etc?
- I have both documents from infor regarding destructive and nondestructive DB init processes Im just not understanding the distinction of when to use them.
Thanks
Rob
- You must be logged in to reply to this topic.