Informix Logical Logs Question

[Bruno Cunha]

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

[Pete Randall · Accepted solution]

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

[Bruno Cunha]

Yes, it was that what I was looking for.

Thanks Pete