Dear All,

Our unix machine crashed and after that our informix is not coming to Online mode.

It stays in "Fast Recovery (CKPT REQ)"

Checked the DBSPACES etc and all looks to be up.

Any ideas what could be wrong ?

Thanks,
Srinivas

Please post online.log and the onstat -d output

Thank you .

Here is online log:

------------------------------------------------------------------
----------------------------------------------------------------


Thu Oct 5 21:50:15 2006

21:50:15 Checkpoint Completed: duration was 0 seconds.
21:54:15 Checkpoint Completed: duration was 0 seconds.
22:02:15 Checkpoint Completed: duration was 0 seconds.
22:06:15 Checkpoint Completed: duration was 0 seconds.
22:10:15 Checkpoint Completed: duration was 0 seconds.
22:14:15 Checkpoint Completed: duration was 0 seconds.
22:18:15 Checkpoint Completed: duration was 0 seconds.
22:22:15 Checkpoint Completed: duration was 0 seconds.
22:26:15 Checkpoint Completed: duration was 0 seconds.
22:30:15 Checkpoint Completed: duration was 0 seconds.
22:34:15 Checkpoint Completed: duration was 0 seconds.

Fri Oct 6 00:29:46 2006

00:29:46 Checkpoint Completed: duration was 0 seconds.
00:29:47 Level 0 Archive started on rootdbs, eu_datadbs2, eu_idxdbs4, tr_idxdbs1, tr_datadbs8, eu_datadbs7, eu_datadbs3, tr_datadbs9, eu_datadbs6, eu_datadbs1, eu_idxdbs3, tr_idxdbs4, eu_idxdbs2, tr_datadbs3, tr_idxdbs2, tr_datadbs4, eu_datadbs4, tr_datadbs13, tr_datadbs2, eu_datadbs5, tr_datadbs5, eu_idxdbs1, tr_datadbs10, tr_datadbs7, tr_idxdbs3, tr_datadbs11, logdbs, tr_datadbs12, tr_idxdbs5, tr_datadbs6, tr_datadbs1, logdbs2
00:34:15 Checkpoint Completed: duration was 0 seconds.
00:38:15 Checkpoint Completed: duration was 0 seconds.
00:42:15 Checkpoint Completed: duration was 0 seconds.
00:46:01 Archive on rootdbs, eu_datadbs2, eu_idxdbs4, tr_idxdbs1, tr_datadbs8, eu_datadbs7, eu_datadbs3, tr_datadbs9, eu_datadbs6, eu_datadbs1, eu_idxdbs3, tr_idxdbs4, eu_idxdbs2, tr_datadbs3, tr_idxdbs2, tr_datadbs4, eu_datadbs4, tr_datadbs13, tr_datadbs2, eu_datadbs5, tr_datadbs5, eu_idxdbs1, tr_datadbs10, tr_datadbs7, tr_idxdbs3, tr_datadbs11, logdbs, tr_datadbs12, tr_idxdbs5, tr_datadbs6, tr_datadbs1, logdbs2 Completed.
00:46:01 Checkpoint Completed: duration was 0 seconds.
00:50:15 Checkpoint Completed: duration was 0 seconds.
21:50:15 Checkpoint Completed: duration was 0 seconds.
21:54:15 Checkpoint Completed: duration was 0 seconds.
22:02:15 Checkpoint Completed: duration was 0 seconds.
22:06:15 Checkpoint Completed: duration was 0 seconds.
22:10:15 Checkpoint Completed: duration was 0 seconds.
22:14:15 Checkpoint Completed: duration was 0 seconds.
22:18:15 Checkpoint Completed: duration was 0 seconds.
22:22:15 Checkpoint Completed: duration was 0 seconds.
22:26:15 Checkpoint Completed: duration was 0 seconds.
22:30:15 Checkpoint Completed: duration was 0 seconds.
22:34:15 Checkpoint Completed: duration was 0 seconds.

Sat Oct 7 21:50:15 2006

21:50:15 Checkpoint Completed: duration was 0 seconds.
21:54:15 Checkpoint Completed: duration was 0 seconds.
22:02:16 Checkpoint Completed: duration was 0 seconds.
22:06:15 Checkpoint Completed: duration was 0 seconds.
22:10:15 Checkpoint Completed: duration was 0 seconds.
22:14:15 Checkpoint Completed: duration was 0 seconds.
22:18:15 Checkpoint Completed: duration was 0 seconds.
22:22:15 Checkpoint Completed: duration was 0 seconds.
22:26:15 Checkpoint Completed: duration was 0 seconds.
22:30:15 Checkpoint Completed: duration was 0 seconds.
22:34:15 Checkpoint Completed: duration was 0 seconds.

Fri Oct 13 14:43:20 2006

14:43:20 Event alarms enabled. ALARMPROG = '/usr/informix/etc/log_full.sh'
14:43:26 DR: DRAUTO is 0 (Off)
14:43:28 INFORMIX-OnLine Initialized -- Shared Memory Initialized.
14:43:28 Physical Recovery Started.
14:43:29 Physical Recovery Complete: 0 Pages Restored.
14:43:29 Logical Recovery Started.
14:43:31 Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks


Fri Oct 13 14:59:14 2006

14:59:14 Event alarms enabled. ALARMPROG = '/usr/informix/etc/log_full.sh'
14:59:19 DR: DRAUTO is 0 (Off)
19:44:25 INFORMIX-OnLine Initialized -- Shared Memory Initialized.
19:44:25 Physical Recovery Started.
19:44:25 Physical Recovery Complete: 0 Pages Restored.
19:44:25 Logical Recovery Started.
19:44:29 Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks


Tue Oct 17 08:57:05 2006

08:57:05 Event alarms enabled. ALARMPROG = '/usr/informix/etc/log_full.sh'
08:57:11 DR: DRAUTO is 0 (Off)
08:57:13 INFORMIX-OnLine Initialized -- Shared Memory Initialized.
08:57:13 Physical Recovery Started.
08:57:13 Physical Recovery Complete: 0 Pages Restored.
08:57:13 Logical Recovery Started.
08:57:16 Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks


Fri Oct 27 02:01:33 2006



-----------------------------------------------------------------
----------------------------------------------------------------



Thanks and best regards,
Srinivas

And here is onstat -d output

INFORMIX-OnLine Version 7.24.FC6 -- Fast Recovery (CKPT REQ) -- Up 02:05:34 -- 991496 Kbytes
Blocked:CKPT

Dbspaces
address number flags fchunk nchunks flags owner name
214dc8170 1 1 1 1 N informix rootdbs
214e0b1c0 2 2001 2 1 N T informix tempdbs1
214e0b258 3 1 3 1 N informix eu_datadbs2
214e0b2f0 4 1 4 1 N informix eu_idxdbs4
214e0b388 5 1 5 1 N informix tr_idxdbs1
214e0b420 6 1 6 1 N informix tr_datadbs8
214e0b4b8 7 1 7 1 N informix eu_datadbs7
214e0b550 8 2001 8 1 N T informix tempdbs2
214e0b5e8 9 1 9 1 N informix eu_datadbs3
214e0b680 10 1 10 2 N informix tr_datadbs9
214e0b718 11 1 11 1 N informix eu_datadbs6
214e0b7b0 12 1 12 2 N informix eu_datadbs1
214e0b848 13 2001 13 1 N T informix tempdbs3
214e0b8e0 14 1 14 1 N informix eu_idxdbs3
214e0b978 15 1 15 3 N informix tr_idxdbs4
214e0ba10 16 1 16 1 N informix eu_idxdbs2
214e0baa8 17 1 17 3 N informix tr_datadbs3
214e0bb40 18 1 18 1 N informix tr_idxdbs2
214e0bbd8 19 2001 19 1 N T informix tempdbs4
214e0bc70 20 1 20 2 N informix tr_datadbs4
214e0bd08 21 1 21 1 N informix eu_datadbs4
214e0bda0 22 1 22 3 N informix tr_datadbs13
214e0be38 23 1 23 1 N informix tr_datadbs2
214e0bed0 24 1 24 1 N informix eu_datadbs5
214e0bf68 25 1 25 1 N informix tr_datadbs5
2151d2028 26 1 26 2 N informix eu_idxdbs1
2151d20c0 27 1 27 1 N informix tr_datadbs10
2151d2158 28 1 28 2 N informix tr_datadbs7
2151d21f0 29 1 29 2 N informix tr_idxdbs3
2151d2288 30 1 30 2 N informix tr_datadbs11
2151d2320 31 1 31 1 N informix logdbs
2151d23b8 32 1 32 1 N informix tr_datadbs12
2151d2450 33 1 33 1 N informix tr_idxdbs5
2151d24e8 34 1 34 2 N informix tr_datadbs6
2151d2580 35 1 35 1 N informix tr_datadbs1
2151d2618 36 1 36 1 N informix logdbs2
36 active, 2047 maximum

Chunks
address chk/dbs offset size free bpages flags pathname
214dc8208 1 1 5 30000 18895 PO- /usr/informix/dbspaces/fo_raw1
214dc8870 2 2 30010 125000 124947 PO- /usr/informix/dbspaces/fo_raw1
214dc8958 3 3 5 50000 47729 PO- /usr/informix/dbspaces/fo_raw2
214dc8a40 4 4 5 50000 49947 PO- /usr/informix/dbspaces/fo_raw30
214dc8b28 5 5 5 125000 98553 PO- /usr/informix/dbspaces/fo_raw3
214dc8c10 6 6 5 200000 50000 PO- /usr/informix/dbspaces/fo_raw4
214dc8cf8 7 7 200010 49500 38814 PO- /usr/informix/dbspaces/fo_raw4
214dc8de0 8 8 5 125000 124947 PO- /usr/informix/dbspaces/fo_raw5
214dc8ec8 9 9 5 50000 39322 PO- /usr/informix/dbspaces/fo_raw6
214dc8fb0 10 10 50010 75000 19947 PO- /usr/informix/dbspaces/fo_raw6
214dc9098 11 11 5 50000 49947 PO- /usr/informix/dbspaces/fo_raw34
214dc9180 12 12 5 125000 75 PO- /usr/informix/dbspaces/fo_raw26
214dc9268 13 13 5 125000 124947 PO- /usr/informix/dbspaces/fo_raw9
214dc9350 14 14 5 50000 48310 PO- /usr/informix/dbspaces/fo_raw27
214dc9438 15 15 5 75000 36831 PO- /usr/informix/dbspaces/fo_raw33
214dc9520 16 16 200010 49950 45373 PO- /usr/informix/dbspaces/fo_raw14
214dc9608 17 17 5 125000 71947 PO- /usr/informix/dbspaces/fo_raw12
214dc96f0 18 18 5 75000 73852 PO- /usr/informix/dbspaces/fo_raw23
214dc97d8 19 19 5 125000 124947 PO- /usr/informix/dbspaces/fo_raw13
214dc98c0 20 20 125010 50000 11447 PO- /usr/informix/dbspaces/fo_raw13
214dc99a8 21 21 175015 74950 49273 PO- /usr/informix/dbspaces/fo_raw13
214dc9a90 22 22 5 249950 64897 PO- /usr/informix/dbspaces/fo_raw11
214dc9b78 23 23 5 125000 64947 PO- /usr/informix/dbspaces/fo_raw21
214dc9c60 24 24 5 50000 39173 PO- /usr/informix/dbspaces/fo_raw15
214dc9d48 25 25 5 75000 54947 PO- /usr/informix/dbspaces/fo_raw25
214dc9e30 26 26 5 50000 0 PO- /usr/informix/dbspaces/fo_raw16
214dc9f18 27 27 50010 100000 84447 PO- /usr/informix/dbspaces/fo_raw16
214dfd050 28 28 5 125000 447 PO- /usr/informix/dbspaces/fo_raw18
214dfd138 29 29 5 125000 31319 PO- /usr/informix/dbspaces/fo_raw28
214dfd220 30 30 125010 124990 4937 PO- /usr/informix/dbspaces/fo_raw5
214dfd308 31 31 5 249990 437 PO- /usr/informix/dbspaces/fo_raw7
214dfd3f0 32 32 125010 124990 59937 PO- /usr/informix/dbspaces/fo_raw9
214dfd4d8 33 33 5 249950 96822 PO- /usr/informix/dbspaces/fo_raw17
214dfd5c0 34 34 5 75000 28947 PO- /usr/informix/dbspaces/fo_raw29
214dfd6a8 35 35 5 249950 132272 PO- /usr/informix/dbspaces/fo_raw24
214dfd790 36 36 5 249995 42 PO- /usr/informix/dbspaces/fo_raw8
214dfd878 37 30 125015 50000 44997 PO- /usr/informix/dbspaces/fo_raw6
214dfd960 38 22 125010 120000 5000 PO- /usr/informix/dbspaces/fo_raw12
214dfda48 39 28 125010 120000 104497 PO- /usr/informix/dbspaces/fo_raw18
214dfdb30 40 17 5 125000 74997 PO- /usr/informix/dbspaces/fo_raw10
214dfdc18 41 29 125020 120000 119997 PO- /usr/informix/dbspaces/fo_raw28
214dfdd00 42 17 125015 120000 119997 PO- /usr/informix/dbspaces/fo_raw10
214dfdde8 43 15 75015 170000 163465 PO- /usr/informix/dbspaces/fo_raw33
214dfded0 44 15 5 50000 49997 PO- /usr/informix/dbspaces/fo_raw31
214e0ac50 45 20 5 50000 49997 PO- /usr/informix/dbspaces/fo_raw32
214e0ad38 46 26 150030 50000 15795 PO- /usr/informix/dbspaces/fo_raw16
214e0ae20 47 34 75010 50000 49997 PO- /usr/informix/dbspaces/fo_raw29
214e0af08 48 22 5 100000 99997 PO- /usr/informix/dbspaces/fo_raw35
214e0aff0 49 10 5 50000 49997 PO- /usr/informix/dbspaces/fo_raw20
214e0b0d8 50 12 125010 120000 114173 PO- /usr/informix/dbspaces/fo_raw26
50 active, 2047 maximum

---------------------------------------------

Wild guess, but what are the values of the LTXHWM and LTXEHWM parameters in the onconfig file?

What's the output of onstat -l?

please post $ONCONFIG, ipcs -a and onstat -l output

You have hit a bug. I would contact technical support. Also, I would upgrade to 7.31, it is much more stable.

Thank you. Here are the
Answers:

LTXHWM : 50
LTXEHWM : 60

Thanks,
Here is the output.


INFORMIX-OnLine Version 7.24.FC6 -- Fast Recovery (CKPT REQ) -- Up 00:01:08 -- 991496 Kbytes
Blocked:CKPT

Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-1 0 32 0 0 0.00
phybegin physize phypos phyused %used
10003f 10000 6204 0 0.00

Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-1 0 16 0 0 0 0.0 0.0

address number flags uniqid begin size used %used
20127e390 1 U-B---- 7436 1f2dca1 12500 12500 100.00
20127e3ac 2 U-B---- 7437 1f30d75 12500 12500 100.00
20127e3c8 3 U-B---- 7438 1f33e49 12500 12500 100.00
20127e3e4 4 U-B---- 7439 1f00035 12500 12500 100.00
20127e400 5 U-B---- 7440 1f03109 12500 12500 100.00
20127e41c 6 U-B---- 7441 1f061dd 12500 12500 100.00
20127e438 7 U-B---- 7442 1f092b1 12500 12500 100.00
20127e454 8 U---C-L 7443 1f0c385 12500 10565 84.52
20127e470 9 U-B---- 7404 1f0f459 12500 12500 100.00
20127e48c 10 U-B---- 7405 1f1252d 12500 12500 100.00
20127e4a8 11 U-B---- 7406 1f15601 12500 12500 100.00
20127e4c4 12 U-B---- 7407 1f186d5 12500 12500 100.00
20127e4e0 13 U-B---- 7408 1f1b7a9 12500 12500 100.00
20127e4fc 14 U-B---- 7409 1f1e87d 12500 12500 100.00
20127e518 15 U-B---- 7410 1f21951 12500 12500 100.00
20127e534 16 U-B---- 7411 1f24a25 12500 12500 100.00
20127e550 17 U-B---- 7412 1f27af9 12500 12500 100.00
20127e56c 18 U-B---- 7413 1f2abcd 12500 412 3.30
20127e588 19 U-B---- 7414 1f36f1d 12500 12500 100.00
20127e5a4 20 U-B---- 7415 1f39ff1 12000 12000 100.00
20127e5c0 21 U-B---- 7416 2400035 12500 12500 100.00
20127e5dc 22 U-B---- 7417 2403109 12500 12500 100.00
20127e5f8 23 U-B---- 7418 24061dd 12500 12500 100.00
20127e614 24 U-B---- 7419 24092b1 12500 12500 100.00
20127e630 25 U-B---- 7420 240c385 12500 12500 100.00
20127e64c 26 U-B---- 7421 240f459 12500 12500 100.00
20127e668 27 U-B---- 7422 241252d 12500 12500 100.00
20127e684 28 U-B---- 7423 2415601 12500 12500 100.00
20127e6a0 29 U-B---- 7424 24186d5 12500 12500 100.00
20127e6bc 30 U-B---- 7425 241b7a9 12500 12500 100.00
20127e6d8 31 U-B---- 7426 241e87d 12500 12500 100.00
20127e6f4 32 U-B---- 7427 2421951 12500 12500 100.00
20127e710 33 U-B---- 7428 2424a25 12500 12500 100.00
20127e72c 34 U-B---- 7429 2427af9 12500 12500 100.00
20127e748 35 U-B---- 7430 242abcd 12500 12500 100.00
20127e764 36 U-B---- 7431 242dca1 12500 12500 100.00
20127e780 37 U-B---- 7432 2430d75 12500 12500 100.00
20127e79c 38 U-B---- 7433 2433e49 12500 12500 100.00
20127e7b8 39 U-B---- 7434 2436f1d 12500 12500 100.00
20127e7d4 40 U-B---- 7435 2439ff1 12400 12400 100.00

Thanks.

onstat -l
---------


INFORMIX-OnLine Version 7.24.FC6 -- Fast Recovery (CKPT REQ) -- Up 00:01:08 -- 991496 Kbytes
Blocked:CKPT

Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-1 0 32 0 0 0.00
phybegin physize phypos phyused %used
10003f 10000 6204 0 0.00

Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-1 0 16 0 0 0 0.0 0.0

address number flags uniqid begin size used %used
20127e390 1 U-B---- 7436 1f2dca1 12500 12500 100.00
20127e3ac 2 U-B---- 7437 1f30d75 12500 12500 100.00
20127e3c8 3 U-B---- 7438 1f33e49 12500 12500 100.00
20127e3e4 4 U-B---- 7439 1f00035 12500 12500 100.00
20127e400 5 U-B---- 7440 1f03109 12500 12500 100.00
20127e41c 6 U-B---- 7441 1f061dd 12500 12500 100.00
20127e438 7 U-B---- 7442 1f092b1 12500 12500 100.00
20127e454 8 U---C-L 7443 1f0c385 12500 10565 84.52
20127e470 9 U-B---- 7404 1f0f459 12500 12500 100.00
20127e48c 10 U-B---- 7405 1f1252d 12500 12500 100.00
20127e4a8 11 U-B---- 7406 1f15601 12500 12500 100.00
20127e4c4 12 U-B---- 7407 1f186d5 12500 12500 100.00
20127e4e0 13 U-B---- 7408 1f1b7a9 12500 12500 100.00
20127e4fc 14 U-B---- 7409 1f1e87d 12500 12500 100.00
20127e518 15 U-B---- 7410 1f21951 12500 12500 100.00
20127e534 16 U-B---- 7411 1f24a25 12500 12500 100.00
20127e550 17 U-B---- 7412 1f27af9 12500 12500 100.00
20127e56c 18 U-B---- 7413 1f2abcd 12500 412 3.30
20127e588 19 U-B---- 7414 1f36f1d 12500 12500 100.00
20127e5a4 20 U-B---- 7415 1f39ff1 12000 12000 100.00
20127e5c0 21 U-B---- 7416 2400035 12500 12500 100.00
20127e5dc 22 U-B---- 7417 2403109 12500 12500 100.00
20127e5f8 23 U-B---- 7418 24061dd 12500 12500 100.00
20127e614 24 U-B---- 7419 24092b1 12500 12500 100.00
20127e630 25 U-B---- 7420 240c385 12500 12500 100.00
20127e64c 26 U-B---- 7421 240f459 12500 12500 100.00
20127e668 27 U-B---- 7422 241252d 12500 12500 100.00
20127e684 28 U-B---- 7423 2415601 12500 12500 100.00
20127e6a0 29 U-B---- 7424 24186d5 12500 12500 100.00
20127e6bc 30 U-B---- 7425 241b7a9 12500 12500 100.00
20127e6d8 31 U-B---- 7426 241e87d 12500 12500 100.00
20127e6f4 32 U-B---- 7427 2421951 12500 12500 100.00
20127e710 33 U-B---- 7428 2424a25 12500 12500 100.00
20127e72c 34 U-B---- 7429 2427af9 12500 12500 100.00
20127e748 35 U-B---- 7430 242abcd 12500 12500 100.00
20127e764 36 U-B---- 7431 242dca1 12500 12500 100.00
20127e780 37 U-B---- 7432 2430d75 12500 12500 100.00
20127e79c 38 U-B---- 7433 2433e49 12500 12500 100.00
20127e7b8 39 U-B---- 7434 2436f1d 12500 12500 100.00
20127e7d4 40 U-B---- 7435 2439ff1 12400 12400 100.00



-------------------------
----------------------

ipcs -a
----------------------

Message Queues:
T ID KEY MODE OWNER GROUP CREATOR CGROUP CBYTES QNUM QBYTES LSPID LRPID STIME RTIME CTIME
q 0 0x417e06d8 --rw------- root system root system 0 0 16384 3 4853 9:23:59 9:23:59 7:56:32
q 1 0x73ff6f8c --rw-rw-rw- root system root system 0 0 16384 0 0 no-entry no-entry 7:58:19
q 2 0x73ffa899 --rw-rw-rw- root system root system 0 0 16384 0 0 no-entry no-entry 7:58:20

Shared Memory:
T ID KEY MODE OWNER GROUP CREATOR CGROUP NATTCH SEGSZ CPID LPID ATIME DTIME CTIME
m 0 0x3253bc5c --rw-rw-rw- root system root system 2 648 1363 1371 7:57:53 7:57:53 7:57:52
m 513 0x525e4801 --rw-rw---- root informix root informix 10 349691904 5182 5205 19:08:30 19:08:30 19:07:14
m 514 0x525e4802 --rw-rw---- root informix root informix 10 665600000 5182 5205 19:08:30 19:08:30 19:07:18
m 259 0x525e4803 --rw-rw-rw- root informix root informix 10 2785280 5182 5205 19:08:30 19:08:30 19:07:25
m 260 0x525e4804 --rw-rw-rw- root informix root informix 10 2785280 5184 5205 19:08:30 19:08:30 19:07:25

Semaphores:
T ID KEY MODE OWNER GROUP CREATOR CGROUP NSEMS OTIME CTIME
s 0 0x417e06d8 --ra------- root system root system 1 7:56:32 7:56:32
s 1025 0 --ra------- root informix root informix 11 19:07:30 19:07:18
s 514 0 --ra-ra-ra- root informix root informix 100 no-entry 19:07:25
s 515 0 --ra-ra-ra- root informix root informix 100 no-entry 19:07:25
s 516 0 --ra-ra-ra- root informix root informix 52 19:08:39 19:07:25
s 517 0 --ra-ra-ra- root informix root informix 100 no-entry 19:07:25
s 518 0 --ra-ra-ra- root informix root informix 100 no-entry 19:07:25
s 519 0 --ra-ra-ra- root informix root informix 52 19:08:39 19:07:25

Here is onconfig:

#************************************************* *************************
#
# INFORMIX SOFTWARE, INC.
#
# Title: onconfig.fo ---- 7.24.FC6
# Description: INFORMIX-OnLine Configuration Parameters
#
#************************************************* *************************

# Root Dbspace Configuration

ROOTNAME rootdbs # Root dbspace name
ROOTPATH /usr/informix/dbspaces/fo_raw1
# Path for device containing root dbspace
ROOTOFFSET 10 # Offset of root dbspace into device (Kbytes)
ROOTSIZE 60000 # Size of root dbspace (Kbytes)

# Disk Mirroring Configuration Parameters

MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH /usr/informix/dbspaces/rootdbsm
# Path for device containing mirrored root
MIRROROFFSET 10 # Offset into mirrored device (Kbytes)

# Physical Log Configuration

PHYSDBS rootdbs # Location (dbspace) of physical log
PHYSFILE 20000 # Physical log file size (Kbytes)

# Logical Log Configuration

LOGFILES 40 # Number of logical log files
LOGSIZE 5000 # Logical log size (Kbytes)

# Diagnostics

MSGPATH /usr/informix/eurodbs/fo.log # System message log file path
CONSOLE /usr/informix/eurodbs/fo.mesg # System console message path
ALARMPROGRAM /usr/informix/etc/log_full.sh # Alarm program path
TBLSPACE_STATS 1

# System Archive Tape Device

#TAPEDEV /dev/rmt1h # Tape device path
TAPEDEV /dev/null # Tape device path
TAPEBLK 16 # Tape block size (Kbytes)
TAPESIZE 30102400 # Maximum amount of data to put on tape (Kbytes)

# Log Archive Tape Device

#LTAPEDEV /dev/rmt0h # Log tape device path
LTAPEDEV /dev/null # Log tape device path
#LTAPEDEV /dev/rmt0h # Log tape device path
LTAPEBLK 16 # Log tape block size (Kbytes)
LTAPESIZE 4102400 # Max amount of data to put on log tape (Kbytes)

# Optical

STAGEBLOB # INFORMIX-OnLine/Optical staging area

# System Configuration

SERVERNUM 8 # Unique id corresponding to a OnLine instance
DBSERVERNAME euronet_fo # Name of default database server
DBSERVERALIASES euronet_foshm # List of alternate dbservernames
NETTYPE soctcp,2,250,NET # Configure poll thread(s) for nettype
NETTYPE ipcshm,2,250,CPU # Configure poll thread(s) for nettype
DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env.
RESIDENT 0 # Forced residency flag (Yes = 1, No = 0)

MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-processor
NUMCPUVPS 2 # Number of user (cpu) vps
SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one

NOAGE 1 # Process aging
AFF_SPROC 2 # Affinity start processor
AFF_NPROCS 2 # Affinity number of processors

# Shared Memory Parameters

LOCKS 200000 # Maximum number of locks
#LOCKS 80000 # Maximum number of locks
BUFFERS 150000 # Maximum number of shared buffers
NUMAIOVPS 2 # Number of IO vps
PHYSBUFF 64 # Physical log buffer size (Kbytes)
LOGBUFF 32 # Logical log buffer size (Kbytes)
LOGSMAX 50 # Maximum number of logical log files
CLEANERS 8 # Number of buffer cleaner processes
SHMBASE 0x200000000 # Shared memory base address
SHMVIRTSIZE 650000 # initial virtual shared memory segment size
SHMADD 20000 # Size of new shared memory segments (Kbytes)
#SHMADD 8192 # Size of new shared memory segments (Kbytes)
SHMTOTAL 1000000 # Total shared memory (Kbytes). 0=>unlimited
CKPTINTVL 240 # Check point interval (in sec)
LRUS 16 # Number of LRU queues
LRU_MAX_DIRTY 2 # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY 1 # LRU percent dirty end cleaning limit
LTXHWM 50 # Long transaction high water mark percentage
LTXEHWM 60 # Long transaction high water mark (exclusive)
TXTIMEOUT 0x12c # Transaction timeout (in sec)
STACKSIZE 64 # Stack size (Kbytes)

# System Page Size
# BUFFSIZE - OnLine no longer supports this configuration parameter.
# To determine the page size used by OnLine on your platform
# see the last line of output from the command, 'onstat -b'.


# Recovery Variables
# OFF_RECVRY_THREADS:
# Number of parallel worker threads during fast recovery or an offline restore.
# ON_RECVRY_THREADS:
# Number of parallel worker threads during an online restore.

OFF_RECVRY_THREADS 10 # Default number of offline worker threads
ON_RECVRY_THREADS 1 # Default number of online worker threads

# Data Replication Variables
# DRAUTO: 0 manual, 1 retain type, 2 reverse type
DRAUTO 0 # DR automatic switchover
DRINTERVAL 30 # DR max time between DR buffer flushes (in sec)
DRTIMEOUT 30 # DR network timeout (in sec)
DRLOSTFOUND /usr/informix/etc/dr.lostfound # DR lost+found file path

# CDR Variables
CDR_LOGBUFFERS 2048 # size of log reading buffer pool (Kbytes)
CDR_EVALTHREADS 1,2 # evaluator threads (per-cpu-vp,additional)
CDR_DSLOCKWAIT 5 # DS lockwait timeout (seconds)
CDR_QUEUEMEM 4096 # Maximum amount of memory for any CDR queue (Kbytes)

# Backup/Restore variables
BAR_ACT_LOG /tmp/bar_act.log
BAR_MAX_BACKUP 0
BAR_RETRY 1
BAR_NB_XPORT_COUNT 10
BAR_XFER_BUF_SIZE 31

# Read Ahead Variables
RA_PAGES 15 # Number of pages to attempt to read ahead
RA_THRESHOLD 12 # Number of pages left before next group

# DBSPACETEMP:
# OnLine equivalent of DBTEMP for SE. This is the list of dbspaces
# that the OnLine SQL Engine will use to create temp tables etc.
# If specified it must be a colon separated list of dbspaces that exist
# when the OnLine system is brought online. If not specified, or if
# all dbspaces specified are invalid, various ad hoc queries will create
# temporary files in /tmp instead.

DBSPACETEMP tempdbs1,tempdbs2,tempdbs3,tempdbs4 # Default temp dbspaces

# DUMP*:
# The following parameters control the type of diagnostics information which
# is preserved when an unanticipated error condition (assertion failure) occurs
# during OnLine operations.
# For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.

DUMPDIR /tmp # Preserve diagnostics in this directory
DUMPSHMEM 0 # Dump a copy of shared memory
DUMPGCORE 0 # Dump a core image using 'gcore'
DUMPCORE 0 # Dump a core image (Warning:this aborts OnLine)
DUMPCNT 1 # Number of shared memory or gcore dumps for
# a single user's session

FILLFACTOR 90 # Fill factor for building indexes

# method for OnLine to use when determining current time
USEOSTIME 0 # 0: use internal time(fast), 1: get time from OS(slow)

# Parallel Database Queries (pdq)
MAX_PDQPRIORITY 100 # Maximum allowed pdqpriority
DS_MAX_QUERIES # Maximum number of decision support queries
DS_TOTAL_MEMORY # Decision support memory (Kbytes)
DS_MAX_SCANS 1048576 # Maximum number of decision support scans
DATASKIP off # List of dbspaces to skip

# OPTCOMPIND
# 0 => Nested loop joins will be preferred (where
# possible) over sortmerge joins and hash joins.
# 1 => If the transaction isolation mode is not
# "repeatable read", optimizer behaves as in (2)
# below. Otherwise it behaves as in (0) above.
# 2 => Use costs regardless of the transaction isolation
# mode. Nested loop joins are not necessarily
# preferred. Optimizer bases its decision purely
# on costs.
OPTCOMPIND 2 # To hint the optimizer

ONDBSPACEDOWN 0 # Dbspace down option: 0 = CONTINUE, 1 = ABORT, 2 = WAIT
LBU_PRESERVE 1 # Preserve last log for log backup
OPCACHEMAX 0 # Maximum optical cache size (Kbytes)

# HETERO_COMMIT (Gateway participation in distributed transactions)
# 1 => Heterogeneous Commit is enabled
# 0 (or any other value) => Heterogeneous Commit is disabled
HETERO_COMMIT 0

Hello All,

I have updated with all the logs here.
I would really appreciate for any help.

FYI: This DB server was built in 1999 and never had any issues until now.
It was used heavily until last year but since last one year this server ]
is used very sparingly.

Thanks,
Srinivas

try to bring the instance down..gracefullly ...onmode -ky
if that does not bring down the instance..then kill the master oninit process
then try to bring the instance up again... onint

Thaks!
Did that.
Even re-booted the machine that did not help.