RE: Onbar
A log switch can be forced before a log is 100% full.
We use the following commands in our scripts.
integer FULL_LOGS=0
FULL_LOGS=`$INFORMIXDIR/bin/onstat -l | grep -c 'U--'`
However, I am not a korn shelling scripting expert.
Therefore, there may be a better way.
-----Original Message-----
From: Info Temp [mailto:inf999@cap-az.com]
Sent: Wednesday, January 12, 2000 10:31 AM
To: Peter Dzvonyar
Cc: informix-list@iiug.org
Subject: Re: Onbar
Disclaimer: I am not a DBA
Question: Shouldn't the grep below be something more like 'grep 100.00$` to
capture all of the logs at 100.00
percent? Running the grep as shown in your script from the command line
resulted in one line on our system for a
log that was 96.16 percent full and didn't come up with any of the 10 that
showed 100 percent. In fact, it
appears to me that the line it grabbed might be the log that is currently in
use.
Am I correct, or do I need to have my IQ (ignorance quotient) adjusted?
carlos
Peter Dzvonyar wrote:
> LOG_FILLED=`onstat -l | grep "U--" | wc -l` # Query
> of how many logs being full
>
--
----------------------------------------------------------------------------
---
Carlos Benjamin, Jr. (623) 869 - 2364
Programmer/Analyst/Consultant
Currently Assigned to Central Arizona Project
mailto:inf999@cap-az.com
----------------------------------------------------------------------------
---