Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2003
    Melbourne, Australia

    Unanswered: Informix Logical Log

    Hi All,

    I am very much new to Informix database and currently i have a client who is on Informix v7.24.UC7. Its with this that i have question

    I am getting this msg,

    10:10:55 Process exited with return code 152: /bin/sh /bin/sh -c /informix/etc/ 2 23 "Logical Log 11 Complete." "Logical Log 11 Complete.",
    while backing up the logical log.

    What does this mean ? Is there anything wrong here ?

    FYI -- the allocated size of the logical log chunk is 320MB and of that 300 MB is used. How do i free the logical log space ?

    Any help appreciated.

  2. #2
    Join Date
    Aug 2004

    I dont see an error message here, its telling you that the logical log is full and that it is going to be backed up, for example, my log file will state:

    <TIME> Logical Log <NUMBER> Complete.
    <TIME> Logical Log <NUMBER> - Backup Started.
    <TIME> Logical Log <NUMBER> - Backup Completed.

    The only time you will see the F (Free) flag on the logs (onstat -l) is when you start the engine (bounce it), from there on you will allways see them like U (used) or U-B (used and backed up), the percentage used will allways be 100%, but dont let that fool you, as long as the log is backed up then its free to be used.

    Hope this helps

    Luis Torres

  3. #3
    Join Date
    Feb 2005
    I had this problem because I started informix as root.

  4. #4
    Join Date
    Aug 2004
    Thats weird, I always start my server as root and I've never had a problem with it

Posting Permissions

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