Clovertech

Cleaning out error and recovery databases

› Clovertech Forums › Read Only Archives › Cloverleaf › Cloverleaf › Cleaning out error and recovery databases

  • Creator
    Topic
  • January 14, 2010 at 12:40 am #51485
    herm ernst
    Participant

      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?

    • Creator
      Topic
    Viewing 7 reply threads
    • Author
      Replies
      • January 14, 2010 at 2:59 pm #70473
        herm ernst
        Participant

          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.

        • January 14, 2010 at 3:22 pm #70474
          Max Drown (Infor)
          Keymaster

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

            -- Max Drown (Infor)

          • January 14, 2010 at 3:49 pm #70475
            Michael Hertel
            Participant

              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.

            • January 14, 2010 at 6:13 pm #70476
              herm ernst
              Participant

                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?

              • January 14, 2010 at 6:46 pm #70477
                Tom Rioux
                Participant

                  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

                • January 16, 2010 at 1:12 am #70478
                  herm ernst
                  Participant

                    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.

                  • January 16, 2010 at 2:54 pm #70479
                    Michael Hertel
                    Participant

                      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.

                    • January 18, 2010 at 5:26 pm #70480
                      herm ernst
                      Participant

                        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
                    Viewing 7 reply threads
                    • The forum ‘Cloverleaf’ is closed to new topics and replies.