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/log_full.sh 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.

Hi,

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

I had this problem because I started informix as root.

Thats weird, I always start my server as root and I've never had a problem with it