Oninit cdi / Archive
Talk to an expert →

RE: Logical logs - how to tell if full?

Posted in 2004

Topics: Backup & Restore, SQL Development & Query Writing, Server Administration, Logging & Checkpoints

Tsutomu Ogiwara — — source: Usenet: comp.databases.informix

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

↪ replying to Tsutomu Ogiwara
Geezer From The Freezer — — source: Usenet: comp.databases.informix

Notbeen on anysystem admin courses whatsoever - and unlikely to.. Is it safe to back up the logical logs at anytime?

↪ replying to Geezer From The Freezer
Neil Truby — — source: Usenet: comp.databases.informix

"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.

↪ replying to Neil Truby
scottishpoet — — source: Usenet: comp.databases.informix

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.

Related threads

Glossary