Whence cometh these log backups?
Posted in 2000
IDS 9.20 on HP-UX 11.0
A funny thing has started happening to three out of my four production
servers. The Ops break continuous logging each night and do a level 0
archive. When they come to re-start the logging, it fails saying that a log
backup is already in progress. And so it is! Tracing back from onstat -u
it turns out that an onbar process is running. We do not use and never have
used ohnbar. What is starting them up - any ideas?
Below is an onstat -u; onstat -g ses and various ps commands that identify
the backup process, in case anyone's interested.
thanks
Neil
----------------------------------------------------------------------------
---------------------------------------------------------------------------
informix@SElmsall $ onstat -u
Informix Dynamic Server 2000 Version 9.20.FC2 -- On-Line -- Up 9 days
07:41:53
-- 300604 Kbytes
Userthreads
address flags sessid user tty wait tout
locks
nreads nwrites
c00000006d95e028 ---P--D 1 informix - 0 0 0
2423 29286
c00000006d95e7c8 ---P--F 0 informix - 0 0 0
0 1170694
c00000006d95ef68 ---P--- 9 informix - 0 0 0
0 9888
c00000006d95f708 ---P--B 10 informix - 0 0 0
295 29766
c00000006d960648 ---P--D 14 informix - 0 0 0
0 0
c00000006d965a28 ------- 68806 root - 0 0 0
309 0
c00000006d9687e8 Y--P--M 68806 root - c000000071638ef8 0 0
0 0
7 active, 128 total, 49 maximum concurrent
informix@SElmsall $ onstat -g ses 68806
Informix Dynamic Server 2000 Version 9.20.FC2 -- On-Line -- Up 9 days
07:42:09
-- 300604 Kbytes
session #RSAM total used
id user tty pid hostname threads memory memory
68806 root - 3978 archer 2 741376 707544
tid name rstcb flags curstk status
69088 ontape c00000006d9687e8 Y--P--M 65632 c00000006d9687e8cond
wait(s
m_read)
69089 logbacku c00000006d965a28 ------- 133128
c00000006d965a28sleeping(Fo
rever)
Memory pools count 1
name class addr totalsize freesize #allocfrag
#freefrag
68806 V c00000006e23a040 741376 33832 124 28
name free used name free used
overhead 0 3256 scb 0 144
opentable 0 5184 filetable 0 1888
log 0 4336 temprec 0 10104
keys 0 624 gentcb 0 2496
ostcb 0 3416 net 0 646600
sqscb 0 17568 rdahead 0 352
hashfiletab 0 1128 log_backup 0 1192
osenv 0 2480 sqtcb 0 6536
fragman 0 80 sapi 0 160
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers
68806 - - - Wait 300 0 0 9.03
informix@SElmsall $
informix@SElmsall $ ps -fp 3978
UID PID PPID C STIME TTY TIME COMMAND
root 3978 3976 0 21:13:02 ? 0:00
/opt/informix/9.20/bin/onbar_d -
l
informix@SElmsall $ ps -ef | grep 3976
root 3978 3976 0 21:13:02 ? 0:00
/opt/informix/9.20/bin/onbar_d -
l
informix 3976 3973 0 21:13:02 ? 0:00 onbar
/opt/informix/9.20/bin/onb
ar -l
informix 13633 12447 1 22:07:02 pts/tz 0:00 grep 3976
informix@SElmsall $ ps -ef | grep 3973
informix 3973 3972 0 21:13:02 ? 0:00 /usr/bin/sh
/opt/informix/9.20/e
tc/log_full.sh 2 23 Logical
informix 3976 3973 0 21:13:02 ? 0:00 onbar
/opt/informix/9.20/bin/onb
ar -l
informix 13635 12447 1 22:07:14 pts/tz 0:00 grep 3973
informix@SElmsall $ ps -ef | grep 3972
informix 3973 3972 0 21:13:02 ? 0:00 /usr/bin/sh
/opt/informix/9.20/e
tc/log_full.sh 2 23 Logical
informix 13650 12447 1 22:07:49 pts/tz 0:00 grep 3972
informix 3972 2709 0 21:13:02 ? 0:00 /bin/sh -c
/opt/informix/9.20/et
c/log_full.sh 2 23 "Logical
informix@SElmsall $ onstat -c | grep -i full
ALARMPROGRAM /opt/informix/9.20/etc/log_full.sh # Alarm program path