Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Informix Logical Log file full

David Tang_1
Advisor

Informix Logical Log file full

Hi all,
Was wondering if anybody could tell me if there is any way to monitor the logical log files of informix so that warning could be generated if a predetermined level is reached.

Thanks.
6 REPLIES
CHRIS ANORUO
Honored Contributor

Re: Informix Logical Log file full

You can use find to check if the size grows more than 100,000.
find /directory -name *.log +100000c -exec ll {} ;
When We Seek To Discover The Best In Others, We Somehow Bring Out The Best In Ourselves.
Danny Engelbarts
Frequent Advisor

Re: Informix Logical Log file full

David,

We use the attached shell script to estimate the current logical log usage, maybe this is helpful?

Greetz, Danny
David Tang_1
Advisor

Re: Informix Logical Log file full

I have tried to run the script but not able to. There is no file in the created directory. Pls advise.
Danny Engelbarts
Frequent Advisor

Re: Informix Logical Log file full

David,

I yhink you need to create the /tmp/logicallogs directory, then when the logicallog is started you should run "estimatelogs.ksh start". Whenever you want to know the status run "estimatelogs.ksh check" and when the logicallog is stopped run "estimatelogs.ksh stop".

Greetz, Danny
David Tang_1
Advisor

Re: Informix Logical Log file full

The directory is already created and when i try and run estimatelogs.ksh start, I have the following error:-
ksh: estimatelogs.ksh: not found
Danny Engelbarts
Frequent Advisor

Re: Informix Logical Log file full

David,

Try "./estimatelogs.ksh"! The script isn't found in your path (for root user the current dir isn't in the path for securitty reasons)

Greetz, Danny.