Cleaning out error and recovery databases

[herm ernst]

I have a client on version 3.8.1P with 6000 messages in the error database

and 3200 in the recovery database. What is the best way to clean these up? Or should I leave them?

Topic

[herm ernst]

Further note: Most of these messages in the error and recovery database are several years old and the site personnel do not monitor it.

Since it’s an old version 3.8.1 of Cloverleaf just curious if there’s any side effects I need to be aware of.

[Max Drown (Infor)]

I can’t think of any reason why you couldn’t use hcidbdump to clean them out.

-- Max Drown (Infor)

[Michael Hertel]

I would shut the site down and do a hcidbinit -AC.

Especially if nobody has been monitoring for years.

This way you can reclaim the disk space too.

[herm ernst]

Is there a way to just delete messages older than a certain date?

Don’t want to delete any recovery db messages from current activity.

I’ve tried the -E option but can’t seem to figure out the date/time format.

Anyone have an example?

[Tom Rioux]

Try something like this:

hcidbdump -e -D -E 20100113 000000

Make sure you keep a space between the date and time.

Hope this helps…

Tom Rioux

[herm ernst]

If all threads are up and functioning correctly, is it OK to delete all messages from the recovery DB?

Couldn’t determine from my quick glance thru the online documentation.

[Michael Hertel]

You do not want to delete messages of running threads.

It will throw all sorts of errors.

You could possibly be killing messages “in flight” as well.

[herm ernst]

What about errror messages and recovery messages that are several years old, do the threads have to be shutdown first also?

What cleanup, if any can be performed with the threads up and running?

[Author]

Replies