RE: Logical logs - how to tell if full?
Geezer From The Freezer asked how to tell when logical logs are full. Tsutomu Ogiwara suggested the ALARMPROGRAM script, which receives event class 23 on log full and can trigger a backup. Neil Truby confirmed logical logs can safely be backed up at any time. Neil Truby and scottishpoet also remarked that the employer should fund DBA training.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi Geezer.
How about using ALARMPROGRAM ?
i.e)
In onconfig:
ALARMPROGRAM /informix/ins1/7.31.UD4/etc/log_full.sh # Alarm program path
Here is a part of log_full.sh
23 is log full.
case "$EVENT_CLASS" in
23)
# onbar assumes no operator is present, # so all messages are written to the activity
# log and there shouldn't be any output, but
# send everything to /dev/null just in case
$BACKUP_CMD 2>&1 >> /dev/null
EXIT_STATUS=$?
;;
I think you modify this shell script.
Regards.
--
Tsutomu Ogiwara from Tokyo Japan.
ICQ#:168106592
>From: Geezer From The Freezer <Geezer@Freezer.com>
>Reply-To: Geezer From The Freezer <Geezer@Freezer.com>
>To: informix-list@iiug.org
>Subject: Logical logs - how to tell if full?
>Date: Mon, 07 Jun 2004 09:38:53 +0100
>
>I know 'onstat -l' can be used - but what am I looking for to tell me that
>the
>logical logs are full?
>
>Also if I want to archive them do I need to bring informix into quiescent
>mode
>or can it be online?
_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*
http://join.msn.com/?page=features/virus
sending to informix-list
Notbeen on anysystem admin courses whatsoever - and unlikely to.. Is it safe to back up the logical logs at anytime?
"Geezer From The Freezer" <Geezer@Freezer.com> wrote in message news:40C57F79.67D842BA@Freezer.com... > Notbeen on anysystem admin courses whatsoever - and unlikely to.. > > Is it safe to back up the logical logs at anytime? Is that because money is tight? Are the company's bean counters stopped from going on their accountancy courses too by any chance? Or do economies not stretch to such "critical business areas" ...?! It is safe to back up logical logs at any time.
This is really a false economy by your business not sending you on the training! When you have a critical system issue, what will you do if you haven't gone through the training. If you are unclear about how to backup the system, how does your company expect you to restore it when it fails? Unfortuately, like so many companies, they'll wait till there has been a major problem before the understand the benefit of having the proper training!! "Neil Truby" <neil.truby@ardenta.com> wrote in message news:<2ili53Fom9gjU1@uni-berlin.de>... > "Geezer From The Freezer" <Geezer@Freezer.com> wrote in message > news:40C57F79.67D842BA@Freezer.com... > > Notbeen on anysystem admin courses whatsoever - and unlikely to.. > > > > Is it safe to back up the logical logs at anytime? > > Is that because money is tight? > Are the company's bean counters stopped from going on their accountancy > courses too by any chance? Or do economies not stretch to such "critical > business areas" ...?! > > It is safe to back up logical logs at any time.