Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
cancel
Showing results for 
Search instead for 
Did you mean: 

Informix Logical Logs Question

SOLVED
Go to solution
Bruno Cunha
Frequent Advisor

Informix Logical Logs Question

Hello all,

can anyone tell me where and what is needed to configure in a Informix db to backup logical logs when a certain threshold is reached ?

Thanks
Do it today, don't leave for tomorrow
2 REPLIES
Pete Randall
Outstanding Contributor
Solution

Re: Informix Logical Logs Question

Bruno,

In your Informix config, you specify an alarm program, something like this:
ALARMPROGRAM /opt/informix/etc/log_full.sh

You then edit the log_full.sh script to specify your required parameters. We use onbar to feed OBII, here's ours:

export OB2BARLIST=Log
export OB2APPNAME=y2

PROG=`basename $0`
USER_LIST=informix
BACKUP_CMD="onbar -l"
EXIT_STATUS=0

EVENT_SEVERITY=$1
EVENT_CLASS=$2
EVENT_MSG="$3"
EVENT_ADD_TEXT="$4"
EVENT_FILE="$5"

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=$?
;;

# One program is shared by all event alarms. If this ever gets expanded to
# handle more than just archive events, uncomment the following:
*)
# EXIT_STATUS=1
;;
esac

exit $EXIT_STATUS



Hope this helps,

Pete

Pete
Bruno Cunha
Frequent Advisor

Re: Informix Logical Logs Question

Yes, it was that what I was looking for.

Thanks Pete
Do it today, don't leave for tomorrow