topic Re: Informix Logical Log file full in Operating System - HP-UX

Informix Logical Log file full

David Tang_1 — Tue, 31 Oct 2000 02:05:29 GMT

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.

Re: Informix Logical Log file full

CHRIS_ANORUO — Tue, 31 Oct 2000 12:41:23 GMT

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

Re: Informix Logical Log file full

Danny Engelbarts — Tue, 31 Oct 2000 13:42:40 GMT

David,

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

Greetz, Danny

Re: Informix Logical Log file full

David Tang_1 — Thu, 02 Nov 2000 09:05:57 GMT

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

Re: Informix Logical Log file full

Danny Engelbarts — Thu, 02 Nov 2000 14:29:18 GMT

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

Re: Informix Logical Log file full

David Tang_1 — Fri, 03 Nov 2000 02:58:19 GMT

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

Re: Informix Logical Log file full

Danny Engelbarts — Fri, 03 Nov 2000 10:44:12 GMT

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.