Informix Logical Log file full

[David Tang_1]

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.

[CHRIS ANORUO]

You can use find to check if the size grows more than 100,000.
find /directory -name *.log +100000c -exec ll {} ;

[Danny Engelbarts]

David,

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

Greetz, Danny

[David Tang_1]

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

[Danny Engelbarts]

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]

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]

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.