Re: logical logs

Nigel Gall wrote: > > At 06:42 PM 12/11/97 EDT, you wrote: > } > } > }Hi > } > }I am running Online 7.23 on HP 10.20 > } > }Why was logical log backed up every 2-3 minutes? > > Under normal circumstances, you may have had Continuous Backup on, which > would backup any freed logical log as it's available for backup. In your > case, I'm seeing something I never saw before, which is an output message > from a script log_full.sh. What does this do? Your logs filled up pretty > quickly (log 609 took nearly 3 mins to fill), and this seems to spark off > your log_full.sh program. Check your cronjobs or ps -ef, to see if user > informix is running it. Then confirm if log_full.sh is a readable text, > UNIX script, and see if it's your culprit. > This is an automatic function of Informix Online (we're currently at 7.23.UC4). Under 7.1x there was an ONCONFIG parameter for ALARMPROGRAM; you could leave it blank with no problems. Under 7.23, Informix by default will set that variable in the ONCONFIG file. If by some chance you leave the ONCONFIG variable blank, Informix automatically looks for the 'log_full.sh' script. The only way I could get around it (where the messages would not be shown) was to set the ALARMPROGRAM variable to '$INFORMIXDIR/no_log.sh', which does nothing. John Carlson Informix DBA WH Smith, Inc.