I have an old Sun machine running an Informix DB on Solaris 10. This has been running for years without issues. Recently the Informix DB stopped, and now it will run. I can start it, without showing any errors, but it only stays up for about 30 seconds, and then dies again. Anyone experienced this issue, and have any steps to repair?
This is what I'm seeing. Check if DB is running (onstat) and shows down. I can then start it (oninit -v), and it starts with all "succeeded". onstat then shows it up and "On-Line". Check again after ~30 seconds, and down again:
bash-3.00# onstat
shared memory not initialized for INFORMIXSERVER 'dncsDbServer'
bash-3.00# oninit -v
Checking group membership to determine server run mode...succeeded
Reading configuration file '/export/home/informix/etc/onconfig'...succeeded
Creating /INFORMIXTMP/.infxdirs...succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 278796 kbytes...succeeded
Allocating 1677736 kbytes for buffer pool of 2K page size...succeeded
Creating infos file "/export/home/informix/etc/.infos.dncsDbServer"...succeeded
Linking conf file "/export/home/informix/etc/.conf.dncsDbServer"...succeeded
Initializing rhead structure...succeeded
Writing to infos file...succeeded
Initialization of Encryption...succeeded
Initializing ASF...succeeded
Initializing Dictionary Cache and SPL Routine Cache...succeeded
Bringing up ADM VP...succeeded
Creating VP classes...succeeded
Onlining 1 additional cpu vps...succeeded
Onlining 1 IO vps...succeeded
Forking main_loop thread...succeeded
Initializing dataskip structure...succeeded
Checking for temporary tables to drop...succeeded
Forking onmode_mon thread...succeeded
Creating periodic thread...succeeded
Starting scheduling system...succeeded
Verbose output complete: mode = 5
bash-3.00# onstat
IBM Informix Dynamic Server Version 11.50.FC6 -- On-Line (CKPT INP) -- Up 00:00:20 -- 2587648 Kbytes
Userthreads
address flags sessid user tty wait tout locks nreads nwrites
184c81028 ---P--D 1 root - 0 0 0 41 8
184c81880 ---P--F 0 root - 0 0 0 0 77
184c820d8 ---P--F 0 root - 0 0 0 0 4
184c82930 ---P--F 0 root - 0 0 0 0 44
184c83188 ---P--F 0 root - 0 0 0 0 26
184c839e0 ---P--F 0 root - 0 0 0 0 0
184c84238 ---P--F 0 root - 0 0 0 0 0
184c84a90 ---P--F 0 root - 0 0 0 0 0
184c852e8 ---P--F 0 root - 0 0 0 0 0
184c85b40 ---P--- 12 root - 0 0 0 0 0
184c86398 ---P--B 13 root - 0 0 0 0 0
184c86bf0 ---P--- 15 root - 0 0 0 0 0
184c87448 ---P--D 17 root - 0 0 0 0 0
184c87ca0 C-BP--- 16 informix - 10b7d3d38 0 2 37 1
184c884f8 ---P--D 18 root - 0 0 0 1 0
184c895a8 --B---- 16 informix - 0 0 2 0 0
184c89e00 --B---- 16 informix - 0 0 2 0 0
184c8aeb0 ---PR-- 25 informix - 0 0 1 66 0
18 active, 128 total, 25 maximum concurrent
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
172 1211 13303 98.71 137 144 5072 97.30
isamtot open start read write rewrite delete commit rollbk
5134 242 73 269 1 1 1 721 1
gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
2 0 0 0 0 0 1
ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
0 0 0 2.12 2.67 0 1
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
3 0 593 0 0 1 1408 1
ixda-RA idx-RA da-RA RA-pgsused lchwaits
3 0 0 3 457
bash-3.00# onstat
shared memory not initialized for INFORMIXSERVER 'dncsDbServer'