Results 1 to 3 of 3

Thread: Log cleaning

  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Lightbulb Unanswered: Log cleaning

    Hallo Again,
    do anyone know how to clean informix log? We found that when this log reaches some lageness the servers hang with no possibility to work!
    Thanks again

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780

    Re: Log cleaning

    Originally posted by rej1977
    Hallo Again,
    do anyone know how to clean informix log? We found that when this log reaches some lageness the servers hang with no possibility to work!
    Thanks again
    Hi,

    It may be occurring that you have the parametro CONSOLE to a /dev/tty and if this this blocked the motor hang.
    Change CONSOLE to /dev/null in Unix or nul in Windows.

    Gustavo.

  3. #3
    Join Date
    Dec 2002
    Location
    Portland, OR, USA
    Posts
    26

    Post How to clean up log file

    Hi, rej1977!

    When you have logging on, the file can grow quite large, quite fast, depending on the volume of INSERT and UPDATE txns you have, size of rows, etc.

    What you have to do is periodically init the log file. Good practice is to do this at the same time you do a backup. You didn't mention what OS/version of Informix you are using, etc., but with SE (what I am using right now), you have to shut down all of the connections (dbaccess, sqlexecd daemon), do the backup, and then init the log file as follows:

    cat /dev/null > /yourpath/yourlogfilename

    Restart the sqlexecd daemon, allow your app(s) to re-establish connections, and you are off to the races.

    For purposes of controlling the server behavior when the log file fills up, I recommend keeping it in its own physical disk partition if you are in a UNIX environment.

    There are any number of ways to do this, depending on your requirements (uptime, etc.), so it's hard to say what approach would be best for your particular situation.

    Hope this helps, though.

    Regards,
    Joe

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •