Этот баннер — требование Роскомнадзора для исполнения 152 ФЗ.
«На сайте осуществляется обработка файлов cookie, необходимых для работы сайта, а также для анализа использования сайта и улучшения предоставляемых сервисов с использованием метрической программы Яндекс.Метрика. Продолжая использовать сайт, вы даёте согласие с использованием данных технологий».
Политика конфиденциальности
|
|
|
запортился журнал логов
|
|||
|---|---|---|---|
|
#18+
после внезапного падения сервера (redhat) - informix 7.30 не удаётся запустить субд насколь мне обьяснили - при запускн информикс не может востановить журнал логов надо отключить журнал , но это можно делать только в online - а туда нам не выйти перевели в режим onmode -r Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery (CKPT REQ) -- Up 01:58:43 -- 97576 Kbytes Blocked:CKPT Dbspaces address number flags fchunk nchunks flags owner name 11f8a13c 1 1 1 4 N informix rootdbs 11f8a6c8 2 2001 5 1 N T informix temp 2 active, 2047 maximum Chunks address chk/dbs offset size free bpages flags pathname 11f8a1f8 1 1 0 1024128 818299 PO- /dbs/dbs001 11f8a348 2 1 0 1024128 78494 PO- /dbs/dbs002 11f8a428 3 1 0 1024128 1024125 PO- /dbs/dbs003 11f8a508 4 1 0 1024128 1024125 PO- /dbs/dbs004 11f8a5e8 5 2 0 228910 228857 PO- /dbs/dbs005 5 active, 2047 maximum что делать дальше непонятно..... есть у кого какие мысли ? ================================================================= Wed Oct 18 23:47:36 2006 23:47:36 Event alarms enabled. ALARMPROG = '/usr/informix/etc/log_full.sh' 23:47:41 DR: DRAUTO is 0 (Off) 23:47:42 Informix Dynamic Server Version 7.30.UC10 Software Serial Number CML#J120599 23:47:43 Informix Dynamic Server Initialized -- Shared Memory Initialized. 23:47:43 Physical Recovery Started. 23:47:46 Physical Recovery Complete: 10905 Pages Restored. 23:47:46 Logical Recovery Started. 23:47:47 Rollforward of log record failed. iserrno = 126 23:47:47 Log Record: log = 283, pos = 61eb040, type = OLDRSAM:HDELETE(41), trans = 23 23:47:48 Assert Failed: INFORMIX-OnLine Must ABORT Critical media failure. 23:47:48 Informix Dynamic Server Version 7.30.UC10 23:47:48 Who: Session(11, informix@leodb.leonet.ru, 0, 0) Thread(28, xchg_1.1, 0, 1) File: rsmirror.c Line: 1703 23:47:49 See Also: /tmp/af.1c4ca3 23:47:49 rsmirror.c, line 1703, thread 28, proc id 5219, INFORMIX-OnLine Must ABORT Critical media failure.. 23:47:49 PANIC: Attempting to bring system down 23:48:59 Segment locked: addr=0x10000000, size=32808960 23:48:59 Requested shared memory segment size rounded from 65535KB to 65536KB Wed Oct 18 23:48:59 2006 23:48:59 Event alarms enabled. ALARMPROG = '/usr/informix/etc/log_full.sh' 23:49:04 DR: DRAUTO is 0 (Off) 23:49:04 Informix Dynamic Server Version 7.30.UC10 Software Serial Number CML#J120599 23:49:06 Informix Dynamic Server Initialized -- Shared Memory Initialized. 23:49:06 Dataskip is now ON for all dbspaces 23:49:06 Recovery Mode =========================================================== 18:37:39 slotdelete: row already deleted 18:37:39 slotdelete: bad rowid 0x1f47406 in partnum 0x10019f 18:37:39 page 128116 page addr stamp slots flag type frptr frcnt next prev 11da3000 27eb32 -1945854474 12 1 DATA 1990 276 0 0 slot ptr len flg value 1 24 154 0 0002b160 007bc101 00000000 00033531 ╠`{а51 386f3030 f0f23733 80000000 00000000 8o00ПР73─ c1310000 00000000 c2013f23 00000000 а1б?# c2013f23 00000000 74303030 30303100 б?#t000001 20202020 202013f2 eff3f320 525520f0 РОСС RU П f2373320 42313730 35340000 97968000 Р73 B17054≈√─ 00000002 b160007b c1204300 00000000 ╠`{а C c2013f00 00000000 c1320000 00000000 б?а2 00008000 00000000 00000000 00009b65 ─⌡e 00000000 00000000 0000 2 178 155 0 0002be7c 0001c101 00000000 00043036 ╬|а06 30356f30 30c1d131 32c12f17 00000000 05o00ая12а/ 00c13f46 00000000 00c1361f 32000000 а?Fа62 00c13620 00000000 00743030 30303031 а6 t000001 00202020 20202013 f2eff3f3 20525520 РОСС RU e1f13132 20423036 35363700 00977780 АЯ12 B06567≈w─ 00000000 02ae3d00 06c1313c 00000000 ╝=а1< 00c13f46 00000000 00800000 00000000 а?F─ 00000080 00000000 00000000 0000009b ─⌡ a3000000 00000000 000000 ё 3 333 154 0 0002b160 007cc101 00000000 00033531 ╠`|а51 396f3030 f0f23733 80000000 00000000 9o00ПР73─ c1310000 00000000 c2013f23 00000000 а1б?# c2013f23 00000000 74303030 30303100 б?#t000001 20202020 202013f2 eff3f320 525520f0 РОСС RU П f2373320 42313730 35340000 97968000 Р73 B17054≈√─ 00000002 b160007c c1204300 00000000 ╠`|а C c2013f00 00000000 c1320000 00000000 б?а2 00008000 00000000 00000000 00009b65 ─⌡e 00000000 00000000 0000 4 487 154 0 0002b160 007dc101 00000000 00033532 ╠`}а52 306f3030 f0f23733 80000000 00000000 0o00ПР73─ c1310000 00000000 c2013f23 00000000 а1б?# c2013f23 00000000 74303030 30303100 б?#t000001 20202020 202013f2 eff3f320 525520f0 РОСС RU П f2373320 42313730 35340000 97968000 Р73 B17054≈√─ 00000002 b160007d c1204300 00000000 ╠`}а C c2013f00 00000000 c1320000 00000000 б?а2 00008000 00000000 00000000 00009b47 ─⌡G 00000000 00000000 0000 5 641 152 0 0002b160 007ec101 00000000 0001316f ╠`~а1o 3030f0f2 37338000 00000000 0000c144 00ПР73─аD 1e000000 0000c202 1b550000 0000c202 бUб 1b550000 00007430 30303030 31002020 Ut000001 20202020 13f2eff3 f3205255 20f0f237 РОСС RU ПР7 33204232 31313137 0000999c 80000000 3 B21117≥°─ 0002b160 007ec12d 39000000 0000c202 ╠`~а-9б 1b000000 0000c132 00000000 00000000 а2 80000000 00000000 00000000 995e0000 ─≥^ 00000000 00000000 6 0 134 0 32eb2700 f69d048c 0c000100 c6071401 2К'Ж²▄ф 00000000 00000000 0002b160 007bc101 ╠`{а 00000000 00033531 386f3030 f0f23733 518o00ПР73 80000000 00000000 c1310000 00000000 ─а1 c2013f23 00000000 c2013f23 00000000 б?#б?# 74303030 30303100 20202020 202013f2 t000001 Р eff3f320 525520f0 f2373320 42313730 ОСС RU ПР73 B170 35340000 97968000 00000002 b160007b 54≈√─╠`{ c1204300 0000 а C 7 1833 157 0 0002be7d 0001c101 00000000 00033130 ╬}а10 356f3030 30303038 c1541c00 00000000 5o000008аT c2011000 00000000 c2033a50 00000000 бб:P c2033a50 00000000 74303030 30303600 б:Pt000006 20202020 20201637 37203939 20323320 77 99 23 3320f520 31323933 20322030 3500009b 3 У 1293 2 05⌡ 28800000 000002bd 190001c1 59460000 (─╫аYF 000000c2 033a0000 00000080 00000000 б:─ 00000000 00800000 00000000 00000000 ─ 009b8400 00000000 00000000 00 ⌡└ 8 1063 157 0 0002be7d 0002c101 00000000 00063538 ╬}а58 31303035 6f303030 313033c1 1e280000 1005o000103а( 000000c1 29000000 000000c1 22600000 а)а"` 000000c1 22600000 00000074 30303030 а"`t0000 30330020 20202020 2013f2ef f3f32052 03 РОСС R 5520e6ed 303420e1 39373737 39000099 U ФМ04 А97779≥ f7800000 000002bd 1a0007c1 1f5c0000 В─╫а\ 000000c1 29000000 00000080 00000000 а)─ 00000000 00800000 00000000 00000000 ─ 0099f700 00000000 00000000 00 ≥В 9 1220 157 0 0002be7d 0003c101 00000000 00063336 ╬}а36 30383035 6f303030 306e6ec1 04600000 0805o0000nnа` 000000c1 063c0000 000000c1 05462800 а<аF( 000000c1 05400000 00000074 30303030 а@t0000 30330020 20202020 2013f2ef f3f32052 03 РОСС R 5520e6ed 303620e1 36353938 330000a2 U ФМ06 А65983╒ 4a800000 0000029d af0024c1 050e0000 J─²╞$а 000000c1 063c0000 00000080 00000000 а<─ 00000000 00800000 00000000 00000000 ─ 00a24a00 00000000 00000000 00 ╒J 10 1377 152 0 0002b160 0080c101 00000000 0001316f ╠`─а1o 3030f0f2 37338000 00000000 0000c144 00ПР73─аD 1e000000 0000c202 1b550000 0000c202 бUб 1b550000 00007430 30303030 31002020 Ut000001 20202020 13f2eff3 f3205255 20f0f237 РОСС RU ПР7 33204232 31313138 0000999c 80000000 3 B21118≥°─ 0002b160 0080c12d 39000000 0000c202 ╠`─а-9б 1b000000 0000c132 00000000 00000000 а2 80000000 00000000 00000000 9b650000 ─⌡e 00000000 00000000 11 1529 152 0 0002b160 0081c101 00000000 0001316f ╠`│а1o 3030f0f2 37338000 00000000 0000c149 00ПР73─аI 1e000000 0000c202 2c2d0000 0000c202 б,-б 2c2d0000 00007430 30303030 31002020 ,-t000001 20202020 13f2eff3 f3205255 20f0f237 РОСС RU ПР7 33204232 33333130 00009acc 80000000 3 B23310 л─ 0002b160 0081c130 59000000 0000c202 ╠`│а0Yб 2c000000 0000c132 00000000 00000000 ,а2 80000000 00000000 00000000 9b650000 ─⌡e 00000000 00000000 12 1681 152 0 0002b160 0082c101 00000000 0001316f ╠`┌а1o 3030f0f2 37338000 00000000 0000c149 00ПР73─аI 1e000000 0000c202 2c2d0000 0000c202 б,-б 2c2d0000 00007430 30303030 31002020 ,-t000001 20202020 13f2eff3 f3205255 20f0f237 РОСС RU ПР7 33204232 33333130 00009acc 80000000 3 B23310 л─ 0002b160 0082c130 59000000 0000c202 ╠`┌а0Yб 2c000000 0000c132 00000000 00000000 ,а2 80000000 00000000 00000000 9a160000 ─ 00000000 00000000 18:37:39 Log record (OLDRSAM:HDELETE) failed, partnum 10019f rowid 1f47406 iserrno 126 Log Record: log = 283, pos = 61eb040, type = OLDRSAM:HDELETE(41), trans = 23 122d6038: b4000000 00002900 12010000 17000000 ......). ........ 122d6048: 18b01e06 f49d048c 9f011000 9f011000 ........ ........ 122d6058: 0674f401 86000000 00000000 0002b160 .t...... .......` 122d6068: 007fc101 00000000 00013100 20202020 ........ ..1. 122d6078: 20208000 00000000 0000c201 12000000 ...... ........ 122d6088: 0000c203 5e320000 0000c203 5e320000 ....^2.. ....^2.. 122d6098: 00000020 20202020 20703030 30313030 ... p000100 122d60a8: 01008000 00008000 00000002 b160007f ........ .....`.. 122d60b8: c14e5a00 00000000 c2035e00 00000000 .NZ..... ..^..... 122d60c8: c1320000 00000000 00008000 00000000 .2...... ........ 122d60d8: 00000000 00009c77 00000000 00000000 .......w ........ 122d60e8: 00000003 .... 18:37:40 18:37:40 Informix Dynamic Server Version 7.30.UC10 Software Serial Number CML#J120599 18:37:40 Assert Failed: INFORMIX-OnLine Must ABORT Critical media failure. 18:37:40 Who: Session(11, informix@leodb.leonet.ru, 0, 0) Thread(28, xchg_1.1, 0, 1) File: rsmirror.c Line: 1703 --------------------------------- Begin System Alarm Program Output --------------------------------- Assertion Failure Type:\t\c CRASH Host Name:\t\tleodb.leonet.ru Database Server Name:\tengine2 Time of failure:\t\c Срд Окт 18 18:37:40 KRAST 2006 AF file:\t\t/tmp/af.1c03f3 Shared memory file:\tNone System Blocking:\t\c OFF ===========------------- - - - - - - tail -100 /usr/informix/online.log: 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:15:56 semctl: errno = 22 18:37:28 Segment locked: addr=0x10000000, size=32808960 18:37:28 Requested shared memory segment size rounded from 65535KB to 65536KB Wed Oct 18 18:37:28 2006 18:37:28 Event alarms enabled. ALARMPROG = '/usr/informix/etc/log_full.sh' 18:37:33 DR: DRAUTO is 0 (Off) 18:37:34 Informix Dynamic Server Version 7.30.UC10 Software Serial Number CML#J120599 18:37:35 Informix Dynamic Server Initialized -- Shared Memory Initialized. 18:37:35 Physical Recovery Started. 18:37:38 Physical Recovery Complete: 10905 Pages Restored. 18:37:38 Logical Recovery Started. 18:37:39 Rollforward of log record failed. iserrno = 126 18:37:39 Log Record: log = 283, pos = 61eb040, type = OLDRSAM:HDELETE(41), trans = 23 18:37:40 Assert Failed: INFORMIX-OnLine Must ABORT Critical media failure. 18:37:40 Informix Dynamic Server Version 7.30.UC10 18:37:40 Who: Session(11, informix@leodb.leonet.ru, 0, 0) Thread(28, xchg_1.1, 0, 1) File: rsmirror.c Line: 1703 ===========------------- - - - - - - /usr/informix/bin/onstat -g ath: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:12 -- 97576 Kbytes Threads: tid tcb rstcb prty status vp-class name 2 11fefa94 0 2 sleeping forever 3lio vp 0 3 11fefcac 0 2 sleeping forever 4pio vp 0 4 12068114 0 2 sleeping forever 5aio vp 0 5 12068268 0 2 sleeping forever 6msc vp 0 6 120684bc 0 2 sleeping forever 7aio vp 1 7 120687f4 11f8c014 4 join wait 24 1cpu main_loop() 8 12068fb4 0 2 sleeping forever 1cpu sm_poll 9 1207fe90 0 2 running 8soc soctcppoll 10 120824b8 0 3 sleeping forever 1cpu sm_listen 11 12082eec 0 2 sleeping secs: 1 1cpu sm_discon 12 120833d4 0 3 sleeping forever 1cpu soctcplst 13 12083880 11f8c4c8 2 sleeping forever 1cpu flush_sub(0) 14 12096228 0 2 sleeping forever 9aio vp 2 15 1209635c 0 2 sleeping forever 10aio vp 3 16 120965b0 0 2 sleeping forever 11aio vp 4 17 12096804 0 2 sleeping forever 12aio vp 5 18 12096a58 0 2 sleeping forever 13aio vp 6 19 12096cac 0 2 sleeping forever 14aio vp 7 20 12096f00 0 2 sleeping forever 15aio vp 8 21 12097154 0 2 sleeping forever 16aio vp 9 22 120975bc 11f8c97c 3 sleeping forever 1cpu aslogflush 23 120978f4 11f8ce30 2 sleeping secs: 55 1cpu btclean 24 12097c78 11f8d2e4 2 sleeping secs: 1 1cpu fast_rec 25 1209a160 11f8d798 2 sleeping secs: 1 1cpu bld_logrecs 26 1209a394 11f8dc4c 2 cond wait packet_con 1cpu logredo 27 1209aaf8 11f8e100 2 cond wait packet_con 1cpu xchg_1.0 *28 1209ad4c 11f8e5b4 2 running 1cpu xchg_1.1 29 1209afa0 11f8ea68 2 cond wait packet_con 1cpu xchg_1.2 30 1209b1f4 11f8ef1c 2 sleeping forever 1cpu xchg_1.3 31 1209b448 11f8f3d0 2 cond wait packet_con 1cpu xchg_1.4 32 1209b69c 11f8f884 2 cond wait packet_con 1cpu xchg_1.5 33 1209b8f0 11f8fd38 2 cond wait packet_con 1cpu xchg_1.6 34 1209bb44 11f901ec 2 cond wait packet_con 1cpu xchg_1.7 35 1209bd98 11f906a0 2 cond wait packet_con 1cpu xchg_1.8 36 120ae228 11f90b54 2 sleeping forever 1cpu xchg_1.9 37 120aeb84 11f91008 2 sleeping secs: 1 1cpu xchg_2.0 ===========------------- - - - - - - /usr/informix/bin/onstat -g stk 28 light: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:12 -- 97576 Kbytes Stack for thread: 28 xchg_1.1 base: 0x12342014 len: 131584 pc: 0x082bac29 tos: 0x12361900 state: running vp: 1 0x082bac29 (oninit)mt_system(0x12361d48, 0x12362094, 0x8455338, 0x10004800, 0x1, 0x1) 0x082cfa48 (oninit)afhandler(0x3, 0x8406976, 0x0, 0x0, 0x0, 0x0) 0x082cf65d (oninit)afcrash_interface(0x8406976, 0x0, 0x0, 0x840696b, 0x6a7, 0x122d6038) 0x081e4fc0 (oninit)bring_media_down(0x11f8a1f8, 0x0, 0x0, 0x10012438, 0x120f4, 0x123620f4) 0x082628a0 (oninit)rollfwd_error(0x1226a080, 0x122d602c, 0xfffffffd, 0x7e, 0x1231cd04, 0x1231cd04) 0x0828b5a4 (oninit)rlogm_redo(0x11fb4a14, 0x1226a080, 0x122d602c, 0x1231c188, 0x1231c150, 0x0) 0x0825cf3b (oninit)next_recvr(0x123abf70, 0x1236217c, 0xffffffff, 0x0, 0x1228cf64, 0x123abf70) 0x082d279a (oninit)prod_loop2(0x123621ac, 0x0, 0x0, 0x0, 0x1228d068, 0x1225bfa0) 0x082d2955 (oninit)producer_thread(0x1228dedc, 0x0, 0x0, 0xffffffff, 0x12366000, 0x12342000) 0x082bc27d (oninit)startup (0xffffffff, 0x12366000, 0x12342000, 0x1dec, 0x246a9ded, 0x12386228) 0x00000000 (***nosymtab***)0x0 ===========------------- - - - - - - /usr/informix/bin/onstat -u: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:12 -- 97576 Kbytes Userthreads address flags sessid user tty wait tout locks nreads nwrites 11f8c014 ---P-RD 1 informix - 0 0 0 11 0 11f8c4c8 ---P--F 0 informix - 0 0 0 0 0 11f8c97c ---P--- 9 informix - 0 0 0 0 0 11f8ce30 ---P--B 10 informix - 0 0 0 0 0 11f8d2e4 ---P-RD*11 informix - 0 0 0 11805 0 11f8d798 -------*11 informix - 0 0 0 0 0 11f8dc4c Y----RD*11 informix - 1209a6c4 0 0 0 0 11f8e100 Y----RD*11 informix - 120ae750 0 0 2 0 11f8e5b4 --B--RD*11 informix - 0 0 0 53 0 11f8ea68 Y----RD*11 informix - 120ae6c8 0 0 121 0 11f8ef1c T----RD*11 informix - 11fb4a14 0 0 10 0 11f8f3d0 Y----RD*11 informix - 120ae640 0 0 149 0 11f8f884 Y----RD*11 informix - 120ae5fc 0 0 74 0 11f8fd38 Y----RD*11 informix - 120ae5b8 0 0 7 0 11f901ec Y----RD*11 informix - 120ae574 0 0 0 0 11f906a0 Y----RD*11 informix - 120ae530 0 0 0 0 11f90b54 T----RD*11 informix - 11fb4624 0 0 0 0 11f91008 -----RD*11 informix - 0 0 0 0 0 18 active, 128 total, 0 maximum concurrent ===========------------- - - - - - - /usr/informix/bin/onstat -g ses 11: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:12 -- 97576 Kbytes session #RSAM total used id user tty pid hostname threads memory memory ===========------------- - - - - - - /usr/informix/bin/onstat -g sql 11: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:12 -- 97576 Kbytes ===========------------- - - - - - - /usr/informix/bin/onstat -c: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:12 -- 97576 Kbytes Configuration File: /usr/informix/etc/onconfig #************************************************************************** # # INFORMIX SOFTWARE, INC. # # Title: onconfig.std # Description: Informix Dynamic Server Configuration Parameters # #************************************************************************** # Root Dbspace Configuration ROOTNAME rootdbs # Root dbspace name ROOTPATH /dbs/dbs001 # Path for device containing root dbspace ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes) ROOTSIZE 2048256 # Size of root dbspace (Kbytes) # Disk Mirroring Configuration Parameters MIRROR 0 # Mirroring flag (Yes = 1, No = 0) MIRRORPATH # Path for device containing mirrored root MIRROROFFSET 0 # Offset into mirrored device (Kbytes) # Physical Log Configuration PHYSDBS rootdbs # Location (dbspace) of physical log PHYSFILE 102400 # Physical log file size (Kbytes) # Logical Log Configuration LOGFILES 6 # Number of logical log files LOGSIZE 51200 # Logical log size (Kbytes) # Diagnostics MSGPATH /usr/informix/online.log # System message log file path CONSOLE /dev/console # System console message path ALARMPROGRAM /usr/informix/etc/log_full.sh # Alarm program path SYSALARMPROGRAM /usr/informix/etc/evidence.sh # System Alarm program path TBLSPACE_STATS 1 # System Archive Tape Device TAPEDEV /dev/null # Tape device path TAPEBLK 16 # Tape block size (Kbytes) TAPESIZE 10240 # Maximum amount of data to put on tape (Kbytes) # Log Archive Tape Device LTAPEDEV /dev/null # Log tape device path LTAPEBLK 16 # Log tape block size (Kbytes) LTAPESIZE 10240 # Max amount of data to put on log tape (Kbytes) # Optical STAGEBLOB # Informix Dynamic Server/Optical staging area # System Configuration SERVERNUM 0 # Unique id corresponding to a Dynamic Server instance DBSERVERNAME engine2 # Name of default database server DBSERVERALIASES engine2_net # List of alternate dbservernames NETTYPE ipcshm,1,128,CPU # Configure poll thread(s) for nettype NETTYPE soctcp,1,128,NET # Configure poll thread(s) for nettype DEADLOCK_TIMEOUT 90 # Max time to wait of lock in distributed env. RESIDENT 1 # Forced residency flag (Yes = 1, No = 0) MULTIPROCESSOR 0 # 0 for single-processor, 1 for multi-processor NUMCPUVPS 1 # Number of user (cpu) vps SINGLE_CPU_VP 1 # If non-zero, limit number of cpu vps to one NOAGE 0 # Process aging AFF_SPROC 0 # Affinity start processor AFF_NPROCS 0 # Affinity number of processors # Shared Memory Parameters LOCKS 65536 # Maximum number of locks BUFFERS 13072 # Maximum number of shared buffers NUMAIOVPS # Number of IO vps PHYSBUFF 128 # Physical log buffer size (Kbytes) LOGBUFF 128 # Logical log buffer size (Kbytes) LOGSMAX 6 # Maximum number of logical log files CLEANERS 1 # Number of buffer cleaner processes SHMBASE 0x10000000 # Shared memory base address SHMVIRTSIZE 65535 # initial virtual shared memory segment size SHMADD 8192 # Size of new shared memory segments (Kbytes) SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited CKPTINTVL 300 # Check point interval (in sec) LRUS 8 # Number of LRU queues LRU_MAX_DIRTY 60 # LRU percent dirty begin cleaning limit LRU_MIN_DIRTY 50 # 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 128 # Stack size (Kbytes) # System Page Size # BUFFSIZE - Dynamic Server no longer supports this configuration parameter. # To determine the page size used by Dynamic Server 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 # Informix Storage Manager variables ISM_DATA_POOL ISMData # If the data pool name is changed, be sure to # update $INFORMIXDIR/bin/onbar. Change to # ism_catalog -create_bootstrap -pool <new name> ISM_LOG_POOL ISMLogs # Read Ahead Variables RA_PAGES # Number of pages to attempt to read ahead RA_THRESHOLD # Number of pages left before next group # DBSPACETEMP: # Dynamic Server equivalent of DBTEMP for SE. This is the list of dbspaces # that the Dynamic Server SQL Engine will use to create temp tables etc. # If specified it must be a colon separated list of dbspaces that exist # when the Dynamic Server 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 temp # 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 Dynamic Server 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 Dynamic Server) DUMPCNT 1 # Number of shared memory or gcore dumps for # a single user's session FILLFACTOR 90 # Fill factor for building indexes # method for Dynamic Server 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 2 # Dbspace down option: 0 = CONTINUE, 1 = ABORT, 2 = WAIT LBU_PRESERVE 0 # 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 # Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS OPT_GOAL -1 # Optimizer DIRECTIVES ON (1/Default) or OFF (0) DIRECTIVES 1 # Status of restartable restore RESTARTABLE_RESTORE off ===========------------- - - - - - - /usr/informix/bin/onstat -s: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:12 -- 97576 Kbytes Latches with lock or userthread set name address lock wait userthread ===========------------- - - - - - - /usr/informix/bin/onstat -k: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:12 -- 97576 Kbytes Locks address wtlist owner lklist type tblsnum rowid key#/bsiz 0 active, 65536 total, 32768 hash buckets ===========------------- - - - - - - /usr/informix/bin/onstat -b: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:12 -- 97576 Kbytes Buffers address userthread flgs pagenum memaddr nslots pgflgs xflgs owner waitlist 11325 modified, 0 resident, 13072 total, 16384 hash buckets, 2048 buffer size ===========------------- - - - - - - /usr/informix/bin/onstat -t: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:12 -- 97576 Kbytes Tblspaces n address flgs ucnt tblnum physaddr npages nused npdata nrows nextns resident 1 11f8b030 0 1 100001 10000e 550 534 0 0 11 0 2 11f8b5e4 2 1 1000d4 200653 48 43 16 531 6 0 3 124a61bc 0 1 100101 20092a 8 3 1 1 1 0 4 124a726c 2 1 10010d 200936 8 4 2 11 1 0 5 124a220c 0 1 10011e 200947 8 6 2 70 1 0 6 124a2a98 0 1 100121 20094a 16 16 5 371 2 0 7 124ba54c 2 1 100139 200b5e 69 69 5 101 7 0 8 124ba8c8 0 1 10013a 200b5f 1158 1135 671 25487 46 0 9 124a6504 2 1 100172 200f35 17169 16690 16153 80762 91 0 10 124a6ebc 2 1 100173 200f36 88 88 1 2 9 0 11 124a7a8c 2 1 100179 200f3c 6596 6345 4353 126219 68 0 12 124a2c80 0 1 10017a 200f3d 1856 1762 637 34380 52 0 13 124ba014 0 1 10017c 200f3f 7062 6875 3653 25570 38 0 14 124a31b4 2 1 100183 200f46 150021 149791 107830 2153958 84 0 15 11fb1a28 2 1 10018b 200f4e 46201 45017 22239 200020 105 0 16 124a75b4 0 1 10018c 200f4f 1978 1902 1051 21003 41 0 17 124a23f4 2 1 100190 2025aa 23237 22464 15792 600055 108 0 18 11fbdb18 2 1 100195 2025af 113249 112932 40316 1008183 85 0 19 11fbcb44 2 1 100196 2025b0 11010 10767 6475 154717 73 0 20 124a3b18 2 1 10019f 2025b9 231018 227785 175478 2153915 86 0 21 124a6b1c 2 1 1001b6 2025d0 24 23 1 22 3 0 22 11f8b9a8 2 1 1001bd 2025d7 2201 2102 790 199055 66 0 23 11fbd12c 2 1 1001cb 2033af 282440 269650 134883 2153962 177 0 24 11f8b3a0 0 1 200001 500004 50 2 0 0 1 0 24 active, 24 total ===========------------- - - - - - - /usr/informix/bin/onstat -d: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:12 -- 97576 Kbytes Dbspaces address number flags fchunk nchunks flags owner name 11f8a13c 1 1 1 4 N informix rootdbs 11f8a6c8 2 2001 5 1 N T informix temp 2 active, 2047 maximum Chunks address chk/dbs offset size free bpages flags pathname 11f8a1f8 1 1 0 1024128 0 PD- /dbs/dbs001 11f8a348 2 1 0 1024128 78494 PO- /dbs/dbs002 11f8a428 3 1 0 1024128 1024125 PO- /dbs/dbs003 11f8a508 4 1 0 1024128 1024125 PO- /dbs/dbs004 11f8a5e8 5 2 0 228910 228857 PO- /dbs/dbs005 5 active, 2047 maximum ===========------------- - - - - - - /usr/informix/bin/onstat -l: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:12 -- 97576 Kbytes Physical Logging Buffer bufused bufsize numpages numwrits pages/io P-1 0 64 0 0 0.00% phybegin physize phypos phyused %used 10003f 51200 41910 0 0.00 Logical Logging Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io L-1 0 64 0 0 0 0.0 0.0 Subsystem numrecs Log Space used address number flags uniqid begin size used %used 103d7ce4 1 U---C-L 283 10c83f 25600 25133 98.18% 103d7d00 2 U-B---- 278 112c3f 25600 25600 100.00% 103d7d1c 3 U-B---- 279 11903f 25600 25600 100.00% 103d7d38 4 U-B---- 280 11f43f 25600 25600 100.00% 103d7d54 5 U-B---- 281 12583f 25600 25600 100.00% 103d7d70 6 U-B---- 282 12bc3f 25600 25600 100.00% ===========------------- - - - - - - /usr/informix/bin/onstat -p: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:12 -- 97576 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 0 0 0 0.00 0 0 0 0.00 isamtot open start read write rewrite delete commit rollbk 0 0 0 0 0 0 0 0 0 gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs 0 0 0 0 0 0 0 ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes 0 0 0 0.14 0.10 0 0 bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans 0 0 0 0 0 0 0 0 ixda-RA idx-RA da-RA RA-pgsused lchwaits 0 0 0 0 0 ===========------------- - - - - - - /usr/informix/bin/onstat -x: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:12 -- 97576 Kbytes Transactions address flags userthread locks log begin isolation retrys coordinator 11fb2014 A---- 11f8c014 0 0 COMMIT 0 11fb2164 A---- 11f8c4c8 0 0 COMMIT 0 11fb22b4 A---- 11f8c97c 0 0 COMMIT 0 11fb2404 A---- 11f8ce30 0 0 COMMIT 0 11fb2554 A---- 11f8d2e4 0 0 COMMIT 0 11fb2a94 A-B-- 11f91008 0 283 COMMIT 0 11fb3ba4 A-B-- 11f91008 0 283 COMMIT 0 11fb4624 A-B-- 11f91008 0 283 COMMIT 0 11fb4a14 A-B-- 11f91008 0 283 COMMIT 0 11fb50a4 A-B-- 11f91008 0 283 COMMIT 0 10 active, 128 total, 0 maximum concurrent ===========------------- - - - - - - /usr/informix/bin/onstat -f: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:12 -- 97576 Kbytes dataskip is OFF for all dbspaces Changing data structure forced command termination. ===========------------- - - - - - - /usr/informix/bin/onstat -h: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:12 -- 97576 Kbytes buffer hash chain length histogram # of chains of len 8079 0 5820 1 1995 2 430 3 55 4 2 5 2 6 1 7 16384 total chains 8305 hashed buffs 13072 total buffs ===========------------- - - - - - - /usr/informix/bin/onstat -C: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:12 -- 97576 Kbytes Btree Cleaner Info btcleanr pool flags pools npend busypnum head tail free 11f8ce30 12244014 1 1 0 0 0 0 12244014 nreqs dups success dfrmv unnec ditems ditlks cmprs palcs 0 0 0 0 0 187 2 0 1 outstanding requests address next partnum pagenum keynum 0 pending, 1024 total, 1024 hash buckets, 1 pools ===========------------- - - - - - - /usr/informix/bin/onstat -F: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:12 -- 97576 Kbytes Fg Writes LRU Writes Chunk Writes 0 0 0 address flusher state data 11f8c4c8 0 I 0 = 0X0 states: Exit Idle Chunk Lru ===========------------- - - - - - - /usr/informix/bin/onstat -R: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:12 -- 97576 Kbytes 8 buffer LRU queue pairs priority levels # f/m pair total % of length LOW MED_LOW MED_HIGH HIGH 0 F 1634 13.9% 227 225 2 0 0 1 m 86.1% 1407 0 1389 18 0 2 f 1634 13.0% 212 209 3 0 0 3 m 87.0% 1422 0 1401 21 0 4 f 1633 12.9% 211 206 5 0 0 5 m 87.1% 1422 0 1407 15 0 6 f 1634 13.2% 215 211 4 0 0 7 m 86.8% 1419 0 1392 27 0 8 f 1633 13.3% 217 214 3 0 0 9 m 86.7% 1416 0 1403 13 0 10 f 1633 13.5% 220 216 4 0 0 11 m 86.5% 1413 0 1392 21 0 12 f 1634 13.8% 225 223 2 0 0 13 m 86.2% 1409 0 1389 20 0 14 f 1633 13.5% 220 219 1 0 0 15 m 86.5% 1413 0 1398 15 0 11321 dirty, 13068 queued, 13072 total, 16384 hash buckets, 2048 buffer size start clean at 60% (of pair total) dirty, or 980 buffs dirty, stop at 50% ===========------------- - - - - - - /usr/informix/bin/onstat -g glo: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:12 -- 97576 Kbytes MT global info: sessions threads vps lngspins 0 36 16 0 sched calls thread switches yield 0 yield n yield forever total: 64052 60586 17922 15615 6844 per sec: 55217 51761 17861 15571 2492 Virtual processor summary: class vps usercpu syscpu total cpu 1 0.14 0.08 0.22 aio 10 0.00 0.02 0.02 lio 1 0.00 0.00 0.00 pio 1 0.00 0.00 0.00 adm 1 0.00 0.00 0.00 soc 1 0.00 0.00 0.00 msc 1 0.00 0.00 0.00 total 16 0.14 0.10 0.24 Individual virtual processors: vp pid class usercpu syscpu total 1 2480 cpu 0.14 0.08 0.22 2 2481 adm 0.00 0.00 0.00 3 2482 lio 0.00 0.00 0.00 4 2483 pio 0.00 0.00 0.00 5 2484 aio 0.00 0.00 0.00 6 2485 msc 0.00 0.00 0.00 7 2486 aio 0.00 0.00 0.00 8 2487 soc 0.00 0.00 0.00 9 2488 aio 0.00 0.01 0.01 10 2489 aio 0.00 0.00 0.00 11 2490 aio 0.00 0.00 0.00 12 2491 aio 0.00 0.00 0.00 13 2492 aio 0.00 0.01 0.01 14 2493 aio 0.00 0.00 0.00 15 2494 aio 0.00 0.00 0.00 16 2495 aio 0.00 0.00 0.00 tot 0.14 0.10 0.24 ===========------------- - - - - - - /usr/informix/bin/onstat -g qst: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:12 -- 97576 Kbytes Queue statistics not enabled ===========------------- - - - - - - /usr/informix/bin/onstat -g wst: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:12 -- 97576 Kbytes Wait statistics not enabled ===========------------- - - - - - - /usr/informix/bin/onstat -g spi: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:12 -- 97576 Kbytes Spin locks with waits: Num Waits Num Loops Avg Loop/Wait Name 1 1 1.00 vproc vp_lock, id = 1 ===========------------- - - - - - - /usr/informix/bin/onstat -g lmx: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:12 -- 97576 Kbytes Locked mutexes: mid addr name holder lkcnt waiter waittime ===========------------- - - - - - - /usr/informix/bin/onstat -g wmx: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:12 -- 97576 Kbytes Mutexes with waiters: mid addr name holder lkcnt waiter waittime ===========------------- - - - - - - /usr/informix/bin/onstat -g con: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:12 -- 97576 Kbytes Conditions with waiters: cid addr name waiter waittime 232 1209a6c4 packet_cond 26 3 242 120ae530 packet_cond 35 1 243 120ae574 packet_cond 34 2 244 120ae5b8 packet_cond 33 1 245 120ae5fc packet_cond 32 1 246 120ae640 packet_cond 31 1 248 120ae6c8 packet_cond 29 1 250 120ae750 packet_cond 27 1 ===========------------- - - - - - - /usr/informix/bin/onstat -g stk all: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:12 -- 97576 Kbytes Stack for thread: 37 xchg_2.0 base: 0x1247e014 len: 131584 pc: 0x082b4b28 tos: 0x1249e08c state: sleeping vp: 1 0x082b4b28 (oninit)yield_processor_svp(0x12297bf8, 0x1, 0x12297bc8, 0x0, 0x1249e0cc, 0x8258d22) 0x082b6afb (oninit)mt_yield(0x1, 0x1209a114, 0x12297bc8, 0x1, 0x0, 0x1249e0f0) 0x08258d22 (oninit)wait_4_Qbuf(0x12297bc8, 0x2, 0x1, 0x1247d2ac, 0x1226a080, 0x1) 0x082586dc (oninit)get_full_Qbuf(0x12297bc8, 0x1, 0x1249e13c, 0x1249e138, 0x1231d9ac, 0x14) 0x0825d212 (oninit)next_lscan(0x1247d298, 0x1249e17c, 0xffffffff, 0x0, 0x12437b44, 0xa) 0x082d2518 (oninit)prod_loop1(0x1249e1ac, 0x0, 0x0, 0x0, 0x12437c90, 0x1225bfa0) 0x082d294a (oninit)producer_thread(0x12437d08, 0x0, 0x0, 0xffffffff, 0x11f50044, 0x1247e000) 0x082bc27d (oninit)startup (0xffffffff, 0x11f50044, 0x1247e000, 0x1dec, 0x243cfe31, 0x11f50038) 0x00000000 (***nosymtab***)0x0 Stack for thread: 36 xchg_1.9 base: 0x1245a014 len: 131584 pc: 0x082b4b28 tos: 0x1247a094 state: sleeping vp: 1 0x082b4b28 (oninit)yield_processor_svp(0x11f90b54, 0x11fb4624, 0x122c3148, 0x1247a0cc, 0x1247a0cc, 0x826065e) 0x082b6afb (oninit)mt_yield(0xffffffff, 0x0, 0x10012438, 0x1247a0f4, 0x828b4c4, 0x11fb4624) 0x0826065e (oninit)recvr_txatt(0x11fb4624, 0x1, 0x1231d0ec, 0x124379f0, 0x2, 0x82d36ec) 0x0828b4c4 (oninit)rlogm_redo(0x11fb4624, 0x1226a080, 0x122c313c, 0x1231c4c8, 0x1231c490, 0x0) 0x0825cf3b (oninit)next_recvr(0x124379e0, 0x1247a17c, 0xffffffff, 0x0, 0x1228cf64, 0x124379e0) 0x082d279a (oninit)prod_loop2(0x1247a1ac, 0x0, 0x0, 0x0, 0x1228d068, 0x1225bfa0) 0x082d2955 (oninit)producer_thread(0x1231ffcc, 0x0, 0x0, 0xffffffff, 0x1247e000, 0x1245a000) 0x082bc27d (oninit)startup (0xffffffff, 0x1247e000, 0x1245a000, 0x1dec, 0x248d9ded, 0x1249e228) 0x00000000 (***nosymtab***)0x0 Stack for thread: 35 xchg_1.8 base: 0x12438014 len: 131584 pc: 0x082b4b28 tos: 0x124580bc state: cond wait vp: 1 0x082b4b28 (oninit)yield_processor_svp(0x12437c34, 0x12437b44, 0x124580f8, 0x82d37cc, 0x120ae530, 0x120ae45c) 0x082b7bd7 (oninit)mt_wait (0x120ae530, 0x120ae45c, 0x82d36ec, 0x1226a080, 0x11, 0x0) 0x082d37cc (oninit)next_xchg(0x1247d1c4, 0x1245817c, 0x1231c460, 0x1231c428, 0x0, 0x122c5148) 0x0825cd0f (oninit)next_recvr(0x1243797c, 0x1245817c, 0xffffffff, 0x0, 0x1228cf64, 0x1243797c) 0x082d279a (oninit)prod_loop2(0x124581ac, 0x0, 0x0, 0x0, 0x1228d068, 0x1225bfa0) 0x082d2955 (oninit)producer_thread(0x1231ffa4, 0x0, 0x0, 0xffffffff, 0x1245a000, 0x12438000) 0x082bc27d (oninit)startup (0xffffffff, 0x1245a000, 0x12438000, 0x1dec, 0x24893ded, 0x1247a228) 0x00000000 (***nosymtab***)0x0 Stack for thread: 34 xchg_1.7 base: 0x12414014 len: 131584 pc: 0x082b4b28 tos: 0x124340bc state: cond wait vp: 1 0x082b4b28 (oninit)yield_processor_svp(0x12437c20, 0x12437b44, 0x124340f8, 0x82d37cc, 0x120ae574, 0x120ae45c) 0x082b7bd7 (oninit)mt_wait (0x120ae574, 0x120ae45c, 0x82d36ec, 0x1226a080, 0x1c, 0x0) 0x082d37cc (oninit)next_xchg(0x1247d12c, 0x1243417c, 0x1231c3f8, 0x1231c3c0, 0x0, 0x122ba8c0) 0x0825cd0f (oninit)next_recvr(0x12437918, 0x1243417c, 0xffffffff, 0x0, 0x1228cf64, 0x12437918) 0x082d279a (oninit)prod_loop2(0x124341ac, 0x0, 0x0, 0x0, 0x1228d068, 0x1225bfa0) 0x082d2955 (oninit)producer_thread(0x1228dfcc, 0x0, 0x0, 0xffffffff, 0x12438000, 0x12414000) 0x082bc27d (oninit)startup (0xffffffff, 0x12438000, 0x12414000, 0x1dec, 0x2484dded, 0x12458228) 0x00000000 (***nosymtab***)0x0 Stack for thread: 33 xchg_1.6 base: 0x123f2014 len: 131584 pc: 0x082b4b28 tos: 0x124120bc state: cond wait vp: 1 0x082b4b28 (oninit)yield_processor_svp(0x12437c0c, 0x12437b44, 0x124120f8, 0x82d37cc, 0x120ae5b8, 0x120ae45c) 0x082b7bd7 (oninit)mt_wait (0x120ae5b8, 0x120ae45c, 0x82d36ec, 0x1226a080, 0x49, 0x0) 0x082d37cc (oninit)next_xchg(0x1247d094, 0x1241217c, 0x1231c390, 0x1231c358, 0x0, 0x122c68c0) 0x0825cd0f (oninit)next_recvr(0x124378b4, 0x1241217c, 0xffffffff, 0x0, 0x1228cf64, 0x124378b4) 0x082d279a (oninit)prod_loop2(0x124121ac, 0x0, 0x0, 0x0, 0x1228d068, 0x1225bfa0) 0x082d2955 (oninit)producer_thread(0x1228dfa4, 0x0, 0x0, 0xffffffff, 0x12414000, 0x123f2000) 0x082bc27d (oninit)startup (0xffffffff, 0x12414000, 0x123f2000, 0x1dec, 0x24807ded, 0x12434228) 0x00000000 (***nosymtab***)0x0 Stack for thread: 32 xchg_1.5 base: 0x123ce014 len: 131584 pc: 0x082b4b28 tos: 0x123ee0bc state: cond wait vp: 1 0x082b4b28 (oninit)yield_processor_svp(0x12437bf8, 0x12437b44, 0x123ee0f8, 0x82d37cc, 0x120ae5fc, 0x120ae45c) 0x082b7bd7 (oninit)mt_wait (0x120ae5fc, 0x120ae45c, 0x82d36ec, 0x1226a080, 0x2, 0x0) 0x082d37cc (oninit)next_xchg(0x1247cffc, 0x123ee17c, 0x1231c328, 0x1231c2f0, 0x0, 0x122be038) 0x0825cd0f (oninit)next_recvr(0x12437850, 0x123ee17c, 0xffffffff, 0x0, 0x1228cf64, 0x12437850) 0x082d279a (oninit)prod_loop2(0x123ee1ac, 0x0, 0x0, 0x0, 0x1228d068, 0x1225bfa0) 0x082d2955 (oninit)producer_thread(0x1228df7c, 0x0, 0x0, 0xffffffff, 0x123f2000, 0x123ce000) 0x082bc27d (oninit)startup (0xffffffff, 0x123f2000, 0x123ce000, 0x1dec, 0x247c1ded, 0x12412228) 0x00000000 (***nosymtab***)0x0 Stack for thread: 31 xchg_1.4 base: 0x123ac014 len: 131584 pc: 0x082b4b28 tos: 0x123cc0bc state: cond wait vp: 1 0x082b4b28 (oninit)yield_processor_svp(0x12437be4, 0x12437b44, 0x123cc0f8, 0x82d37cc, 0x120ae640, 0x120ae45c) 0x082b7bd7 (oninit)mt_wait (0x120ae640, 0x120ae45c, 0x82d36ec, 0x1226a080, 0x49, 0x0) 0x082d37cc (oninit)next_xchg(0x1247cf64, 0x123cc17c, 0x1231c2c0, 0x1231c288, 0x0, 0x122cc038) 0x0825cd0f (oninit)next_recvr(0x124377ec, 0x123cc17c, 0xffffffff, 0x0, 0x1228cf64, 0x124377ec) 0x082d279a (oninit)prod_loop2(0x123cc1ac, 0x0, 0x0, 0x0, 0x1228d068, 0x1225bfa0) 0x082d2955 (oninit)producer_thread(0x1228df54, 0x0, 0x0, 0xffffffff, 0x123ce000, 0x123ac000) 0x082bc27d (oninit)startup (0xffffffff, 0x123ce000, 0x123ac000, 0x1dec, 0x2477bded, 0x123ee228) 0x00000000 (***nosymtab***)0x0 Stack for thread: 30 xchg_1.3 base: 0x12388014 len: 131584 pc: 0x082b4b28 tos: 0x123a8094 state: sleeping vp: 1 0x082b4b28 (oninit)yield_processor_svp(0x11f8ef1c, 0x11fb4a14, 0x122ce038, 0x123a80cc, 0x123a80cc, 0x826065e) 0x082b6afb (oninit)mt_yield(0xffffffff, 0x0, 0x10012438, 0x123a80f4, 0x828b4c4, 0x11fb4a14) 0x0826065e (oninit)recvr_txatt(0x11fb4a14, 0x1, 0x1231d3a8, 0x123f1ff0, 0x2, 0x82d36ec) 0x0828b4c4 (oninit)rlogm_redo(0x11fb4a14, 0x1226a080, 0x122ce02c, 0x1231c258, 0x1231c220, 0x0) 0x0825cf3b (oninit)next_recvr(0x123f1fe0, 0x123a817c, 0xffffffff, 0x0, 0x1228cf64, 0x123f1fe0) 0x082d279a (oninit)prod_loop2(0x123a81ac, 0x0, 0x0, 0x0, 0x1228d068, 0x1225bfa0) 0x082d2955 (oninit)producer_thread(0x1228df2c, 0x0, 0x0, 0xffffffff, 0x123ac000, 0x12388000) 0x082bc27d (oninit)startup (0xffffffff, 0x123ac000, 0x12388000, 0x1dec, 0x24735ded, 0x123cc228) 0x00000000 (***nosymtab***)0x0 Stack for thread: 29 xchg_1.2 base: 0x12366014 len: 131584 pc: 0x082b4b28 tos: 0x123860bc state: cond wait vp: 1 0x082b4b28 (oninit)yield_processor_svp(0x12437bbc, 0x12437b44, 0x123860f8, 0x82d37cc, 0x120ae6c8, 0x120ae45c) 0x082b7bd7 (oninit)mt_wait (0x120ae6c8, 0x120ae45c, 0x82d36ec, 0x1226a080, 0x49, 0x0) 0x082d37cc (oninit)next_xchg(0x1247ce54, 0x1238617c, 0x1231c1f0, 0x1231c1b8, 0x0, 0x122bf148) 0x0825cd0f (oninit)next_recvr(0x123abfd4, 0x1238617c, 0xffffffff, 0x0, 0x1228cf64, 0x123abfd4) 0x082d279a (oninit)prod_loop2(0x123861ac, 0x0, 0x0, 0x0, 0x1228d068, 0x1225bfa0) 0x082d2955 (oninit)producer_thread(0x1228df04, 0x0, 0x0, 0xffffffff, 0x12388000, 0x12366000) 0x082bc27d (oninit)startup (0xffffffff, 0x12388000, 0x12366000, 0x1dec, 0x246efded, 0x123a8228) 0x00000000 (***nosymtab***)0x0 Stack for thread: 28 xchg_1.1 base: 0x12342014 len: 131584 pc: 0x082bac29 tos: 0x12361900 state: running vp: 1 0x082bac29 (oninit)mt_system(0x12361d48, 0x12362094, 0x8455338, 0x10004800, 0x1, 0x1) 0x082cfa48 (oninit)afhandler(0x3, 0x8406976, 0x0, 0x0, 0x0, 0x0) 0x082cf65d (oninit)afcrash_interface(0x8406976, 0x0, 0x0, 0x840696b, 0x6a7, 0x122d6038) 0x081e4fc0 (oninit)bring_media_down(0x11f8a1f8, 0x0, 0x0, 0x10012438, 0x120f4, 0x123620f4) 0x082628a0 (oninit)rollfwd_error(0x1226a080, 0x122d602c, 0xfffffffd, 0x7e, 0x1231cd04, 0x1231cd04) 0x0828b5a4 (oninit)rlogm_redo(0x11fb4a14, 0x1226a080, 0x122d602c, 0x1231c188, 0x1231c150, 0x0) 0x0825cf3b (oninit)next_recvr(0x123abf70, 0x1236217c, 0xffffffff, 0x0, 0x1228cf64, 0x123abf70) 0x082d279a (oninit)prod_loop2(0x123621ac, 0x0, 0x0, 0x0, 0x1228d068, 0x1225bfa0) 0x082d2955 (oninit)producer_thread(0x1228dedc, 0x0, 0x0, 0xffffffff, 0x12366000, 0x12342000) 0x082bc27d (oninit)startup (0xffffffff, 0x12366000, 0x12342000, 0x1dec, 0x246a9ded, 0x12386228) 0x00000000 (***nosymtab***)0x0 Stack for thread: 27 xchg_1.0 base: 0x12320014 len: 131584 pc: 0x082b4b28 tos: 0x123400bc state: cond wait vp: 1 0x082b4b28 (oninit)yield_processor_svp(0x12437b94, 0x12437b44, 0x123400f8, 0x82d37cc, 0x120ae750, 0x120ae45c) 0x082b7bd7 (oninit)mt_wait (0x120ae750, 0x120ae45c, 0x82d36ec, 0x1226a080, 0x49, 0x0) 0x082d37cc (oninit)next_xchg(0x12437abc, 0x1234017c, 0x1231c120, 0x1231c0e8, 0x0, 0x122bd148) 0x0825cd0f (oninit)next_recvr(0x12365fe0, 0x1234017c, 0xffffffff, 0x0, 0x1228cf64, 0x0) 0x082d279a (oninit)prod_loop2(0x123401ac, 0x0, 0x0, 0x0, 0x1228d068, 0x1225bfa0) 0x082d2955 (oninit)producer_thread(0x1228d0e0, 0x0, 0x0, 0xffffffff, 0x12342000, 0x12320000) 0x082bc27d (oninit)startup (0xffffffff, 0x12342000, 0x12320000, 0x1dec, 0x24663ded, 0x12362228) 0x00000000 (***nosymtab***)0x0 Stack for thread: 26 logredo base: 0x122fa014 len: 131584 pc: 0x082b4b28 tos: 0x1231a120 state: cond wait vp: 1 0x082b4b28 (oninit)yield_processor_svp(0x1228cfb4, 0x1228cf64, 0x1231a15c, 0x82d37cc, 0x1209a6c4, 0x1209a634) 0x082b7bd7 (oninit)mt_wait (0x1209a6c4, 0x1209a634, 0x1231a198, 0x1228ce00, 0x1228ce10, 0x0) 0x082d37cc (oninit)next_xchg(0x1228cec0, 0x1231a198, 0x0, 0x1228ce00, 0x0, 0x1231a1a4) 0x0825c997 (oninit)next_precvr(0x1228ce10, 0x1231a198, 0x1228ccd8, 0x1228cd50, 0x1225bf8c, 0x1231a198) 0x08232c3f (oninit)gcc2_compiled.(0x1228cdc8, 0x0, 0x1231a1d8, 0x0, 0x1226a080, 0x0) 0x0825c1e8 (oninit)plogrecover(0x1226a080, 0x12297bc8, 0x122b6858, 0x0, 0x0, 0x0) 0x081b47bb (oninit)fast_logredo(0x1226a080, 0x0, 0x0, 0xffffffff, 0x12320000, 0x122fa000) 0x082bc27d (oninit)startup (0xffffffff, 0x12320000, 0x122fa000, 0x1dec, 0x2461bded, 0x12340228) 0x00000000 (***nosymtab***)0x0 Stack for thread: 25 bld_logrecs base: 0x122d8014 len: 131584 pc: 0x082b4b28 tos: 0x122f8160 state: sleeping vp: 1 0x082b4b28 (oninit)yield_processor_svp(0x12297bf4, 0x1, 0x12297bc8, 0x0, 0x122f81a0, 0x8258d22) 0x082b6afb (oninit)mt_yield(0x1, 0x1209a114, 0x12297bc8, 0x1, 0x0, 0x122f81c4) 0x08258d22 (oninit)wait_4_Qbuf(0x12297bc8, 0x1, 0x1, 0x34, 0x4e8, 0x122bf17c) 0x082585f8 (oninit)get_empty_Qbuf(0x12297bc8, 0x1, 0x122f81f4, 0x0, 0x0, 0x0) 0x081b44f8 (oninit)bld_logrecs(0x1226a080, 0x0, 0x0, 0xffffffff, 0x122fa000, 0x122d8000) 0x082bc27d (oninit)startup (0xffffffff, 0x122fa000, 0x122d8000, 0x1dec, 0x245d3ded, 0x1231a228) 0x00000000 (***nosymtab***)0x0 Stack for thread: 24 fast_rec base: 0x1225c014 len: 33280 pc: 0x082b4b28 tos: 0x12264120 state: sleeping vp: 1 0x082b4b28 (oninit)yield_processor_svp(0x1226a4b0, 0x1, 0x1226a484, 0x0, 0x12264160, 0x8258d22) 0x082b6afb (oninit)mt_yield(0x1, 0x12097fa0, 0x1226a484, 0x1, 0x0, 0x12264184) 0x08258d22 (oninit)wait_4_Qbuf(0x1226a484, 0x1, 0x1, 0x12287400, 0x36, 0x1226a080) 0x082585f8 (oninit)get_empty_Qbuf(0x1226a484, 0x1, 0x122641fc, 0x0, 0x0, 0x0) 0x081b3d81 (oninit)fast_recovery(0x2, 0x0, 0x0, 0xffffffff, 0x122d8000, 0x1225c000) 0x082bc27d (oninit)startup (0xffffffff, 0x122d8000, 0x1225c000, 0x1dec, 0x24535ded, 0x122f8228) 0x00000000 (***nosymtab***)0x0 Stack for thread: 23 btclean base: 0x1224e014 len: 33280 pc: 0x082b4b28 tos: 0x122561bc state: sleeping vp: 1 0x082b4b28 (oninit)yield_processor_svp(0x0, 0x0, 0x0, 0x0, 0x12256200, 0x826464d) 0x082b6afb (oninit)mt_yield(0x3c, 0x0, 0x0, 0x0, 0x0, 0x0) 0x0826464d (oninit)btclean_loop(0x0, 0x0, 0x0, 0xffffffff, 0x1225c000, 0x1224e000) 0x082bc27d (oninit)startup (0xffffffff, 0x1225c000, 0x1224e000, 0x1dec, 0x244abded, 0x12264228) 0x00000000 (***nosymtab***)0x0 Stack for thread: 22 aslogflush base: 0x1223a014 len: 33280 pc: 0x082b4b28 tos: 0x12242168 state: sleeping vp: 1 0x082b4b28 (oninit)yield_processor_svp(0x122340b0, 0xffffffff, 0x12234080, 0x12097440, 0x122421a8, 0x8258d22) 0x082b6afb (oninit)mt_yield(0xffffffff, 0x12097440, 0x12234080, 0xffffffff, 0x0, 0x122421cc) 0x08258d22 (oninit)wait_4_Qbuf(0x12234080, 0x2, 0xffffffff, 0x10004800, 0x122421fc, 0x122421f8) 0x082586dc (oninit)get_full_Qbuf(0x12234080, 0xffffffff, 0x122421fc, 0x122421f8, 0x0, 0x0) 0x0828d9b3 (oninit)aslogflush(0x0, 0x0, 0x0, 0xffffffff, 0x1224e000, 0x1223a000) 0x082bc27d (oninit)startup (0xffffffff, 0x1224e000, 0x1223a000, 0x1dec, 0x24489ded, 0x12256228) 0x00000000 (***nosymtab***)0x0 Stack for thread: 21 vp 9 base: 0x12222014 len: 33280 pc: 0x082b4e84 tos: 0x1222a18c state: sleeping vp: 16 0x082b4e84 (oninit)yield_processor_mvp(0x120edd8c, 0x11ff9c08, 0x120edd8c, 0x120edd8c, 0x1222a1c8, 0x82c2f17) 0x082b6b05 (oninit)mt_yield(0xffffffff, 0x0, 0x1222a1e4, 0x82c2df7, 0x120edd8c, 0x11ff9c08) 0x082c2f17 (oninit)ioidle (0x120edd8c, 0x11ff9c08, 0x120edd8c, 0x0, 0x0, 0x1222a200) 0x082c2df7 (oninit)iowork (0x120edd8c, 0x11ff9c08, 0x11ff9c08, 0x0, 0x0, 0x1222a20c) 0x082c2e9d (oninit)iothread(0x120edd8c, 0x0, 0x0, 0xffffffff, 0x1222c000, 0x12222000) 0x082bc27d (oninit)startup (0xffffffff, 0x1222c000, 0x12222000, 0x1dec, 0x2444fded, 0x1222e114) 0x00000000 (***nosymtab***)0x0 Stack for thread: 20 vp 8 base: 0x1220e014 len: 33280 pc: 0x082b4e84 tos: 0x1221618c state: sleeping vp: 15 0x082b4e84 (oninit)yield_processor_mvp(0x120edb20, 0x11ff9c08, 0x120edb20, 0x120edb20, 0x122161c8, 0x82c2f17) 0x082b6b05 (oninit)mt_yield(0xffffffff, 0x0, 0x122161e4, 0x82c2df7, 0x120edb20, 0x11ff9c08) 0x082c2f17 (oninit)ioidle (0x120edb20, 0x11ff9c08, 0x120edb20, 0x0, 0x0, 0x12216200) 0x082c2df7 (oninit)iowork (0x120edb20, 0x11ff9c08, 0x11ff9c08, 0x0, 0x0, 0x1221620c) 0x082c2e9d (oninit)iothread(0x120edb20, 0x0, 0x0, 0xffffffff, 0x12222000, 0x1220e000) 0x082bc27d (oninit)startup (0xffffffff, 0x12222000, 0x1220e000, 0x1dec, 0x24431ded, 0x1222a228) 0x00000000 (***nosymtab***)0x0 Stack for thread: 19 vp 7 base: 0x121f6014 len: 33280 pc: 0x082b4e84 tos: 0x121fe18c state: sleeping vp: 14 0x082b4e84 (oninit)yield_processor_mvp(0x120ed8b4, 0x11ff9c08, 0x120ed8b4, 0x120ed8b4, 0x121fe1c8, 0x82c2f17) 0x082b6b05 (oninit)mt_yield(0xffffffff, 0x0, 0x121fe1e4, 0x82c2df7, 0x120ed8b4, 0x11ff9c08) 0x082c2f17 (oninit)ioidle (0x120ed8b4, 0x11ff9c08, 0x120ed8b4, 0x0, 0x0, 0x121fe200) 0x082c2df7 (oninit)iowork (0x120ed8b4, 0x11ff9c08, 0x11ff9c08, 0x0, 0x0, 0x121fe20c) 0x082c2e9d (oninit)iothread(0x120ed8b4, 0x0, 0x0, 0xffffffff, 0x12200000, 0x121f6000) 0x082bc27d (oninit)startup (0xffffffff, 0x12200000, 0x121f6000, 0x1dec, 0x243f7ded, 0x12202114) 0x00000000 (***nosymtab***)0x0 Stack for thread: 18 vp 6 base: 0x121de014 len: 33280 pc: 0x082b4e84 tos: 0x121e618c state: sleeping vp: 13 0x082b4e84 (oninit)yield_processor_mvp(0x120ed648, 0x11ff9c08, 0x120ed648, 0x120ed648, 0x121e61c8, 0x82c2f17) 0x082b6b05 (oninit)mt_yield(0xffffffff, 0x0, 0x121e61e4, 0x82c2df7, 0x120ed648, 0x11ff9c08) 0x082c2f17 (oninit)ioidle (0x120ed648, 0x11ff9c08, 0x120ed648, 0x0, 0x0, 0x121e6200) 0x082c2df7 (oninit)iowork (0x120ed648, 0x11ff9c08, 0x11ff9c08, 0x0, 0x0, 0x121e620c) 0x082c2e9d (oninit)iothread(0x120ed648, 0x0, 0x0, 0xffffffff, 0x121e8000, 0x121de000) 0x082bc27d (oninit)startup (0xffffffff, 0x121e8000, 0x121de000, 0x1dec, 0x243c7ded, 0x121ea114) 0x00000000 (***nosymtab***)0x0 Stack for thread: 17 vp 5 base: 0x121c6014 len: 33280 pc: 0x082b4e84 tos: 0x121ce18c state: sleeping vp: 12 0x082b4e84 (oninit)yield_processor_mvp(0x120ed3dc, 0x11ff9c08, 0x120ed3dc, 0x120ed3dc, 0x121ce1c8, 0x82c2f17) 0x082b6b05 (oninit)mt_yield(0xffffffff, 0x0, 0x121ce1e4, 0x82c2df7, 0x120ed3dc, 0x11ff9c08) 0x082c2f17 (oninit)ioidle (0x120ed3dc, 0x11ff9c08, 0x120ed3dc, 0x0, 0x0, 0x121ce200) 0x082c2df7 (oninit)iowork (0x120ed3dc, 0x11ff9c08, 0x11ff9c08, 0x0, 0x0, 0x121ce20c) 0x082c2e9d (oninit)iothread(0x120ed3dc, 0x0, 0x0, 0xffffffff, 0x121d0000, 0x121c6000) 0x082bc27d (oninit)startup (0xffffffff, 0x121d0000, 0x121c6000, 0x1dec, 0x24397ded, 0x121d2114) 0x00000000 (***nosymtab***)0x0 Stack for thread: 16 vp 4 base: 0x121ae014 len: 33280 pc: 0x082b4e84 tos: 0x121b618c state: sleeping vp: 11 0x082b4e84 (oninit)yield_processor_mvp(0x120ed170, 0x11ff9c08, 0x120ed170, 0x120ed170, 0x121b61c8, 0x82c2f17) 0x082b6b05 (oninit)mt_yield(0xffffffff, 0x0, 0x121b61e4, 0x82c2df7, 0x120ed170, 0x11ff9c08) 0x082c2f17 (oninit)ioidle (0x120ed170, 0x11ff9c08, 0x120ed170, 0x0, 0x0, 0x121b6200) 0x082c2df7 (oninit)iowork (0x120ed170, 0x11ff9c08, 0x11ff9c08, 0x0, 0x0, 0x121b620c) 0x082c2e9d (oninit)iothread(0x120ed170, 0x0, 0x0, 0xffffffff, 0x121b8000, 0x121ae000) 0x082bc27d (oninit)startup (0xffffffff, 0x121b8000, 0x121ae000, 0x1dec, 0x24367ded, 0x121ba114) 0x00000000 (***nosymtab***)0x0 Stack for thread: 15 vp 3 base: 0x12192014 len: 33280 pc: 0x082b4e84 tos: 0x1219a18c state: sleeping vp: 10 0x082b4e84 (oninit)yield_processor_mvp(0x120ecf04, 0x11ff9c08, 0x120ecf04, 0x120ecf04, 0x1219a1c8, 0x82c2f17) 0x082b6b05 (oninit)mt_yield(0xffffffff, 0x0, 0x1219a1e4, 0x82c2df7, 0x120ecf04, 0x11ff9c08) 0x082c2f17 (oninit)ioidle (0x120ecf04, 0x11ff9c08, 0x120ecf04, 0x0, 0x0, 0x1219a200) 0x082c2df7 (oninit)iowork (0x120ecf04, 0x11ff9c08, 0x11ff9c08, 0x0, 0x0, 0x1219a20c) 0x082c2e9d (oninit)iothread(0x120ecf04, 0x0, 0x0, 0xffffffff, 0x1219c000, 0x12192000) 0x082bc27d (oninit)startup (0xffffffff, 0x1219c000, 0x12192000, 0x1dec, 0x2432fded, 0x1219e114) 0x00000000 (***nosymtab***)0x0 Stack for thread: 14 vp 2 base: 0x1217e014 len: 33280 pc: 0x082b4e84 tos: 0x1218618c state: sleeping vp: 9 0x082b4e84 (oninit)yield_processor_mvp(0x120ecc98, 0x11ff9c08, 0x120ecc98, 0x120ecc98, 0x121861c8, 0x82c2f17) 0x082b6b05 (oninit)mt_yield(0xffffffff, 0x0, 0x121861e4, 0x82c2df7, 0x120ecc98, 0x11ff9c08) 0x082c2f17 (oninit)ioidle (0x120ecc98, 0x11ff9c08, 0x120ecc98, 0x0, 0x0, 0x12186200) 0x082c2df7 (oninit)iowork (0x120ecc98, 0x11ff9c08, 0x11ff9c08, 0x0, 0x0, 0x1218620c) 0x082c2e9d (oninit)iothread(0x120ecc98, 0x0, 0x0, 0xffffffff, 0x12192000, 0x1217e000) 0x082bc27d (oninit)startup (0xffffffff, 0x12192000, 0x1217e000, 0x1dec, 0x24311ded, 0x1219a228) 0x00000000 (***nosymtab***)0x0 Stack for thread: 13 flush_sub(0) base: 0x12168014 len: 33280 pc: 0x082b4b28 tos: 0x121701bc state: sleeping vp: 1 0x082b4b28 (oninit)yield_processor_svp(0x11f8a2d8, 0x0, 0x10011fcc, 0x11f8a2d8, 0x12170200, 0x81e284b) 0x082b6afb (oninit)mt_yield(0xffffffff, 0x0, 0x0, 0x0, 0x0, 0x10004800) 0x081e284b (oninit)flush_sub(0x0, 0x0, 0x0, 0xffffffff, 0x1217e000, 0x12168000) 0x082bc27d (oninit)startup (0xffffffff, 0x1217e000, 0x12168000, 0x1dec, 0x242e7ded, 0x12186228) 0x00000000 (***nosymtab***)0x0 Stack for thread: 12 soctcplst base: 0x12156014 len: 33280 pc: 0x082b4b28 tos: 0x1215d864 state: sleeping vp: 1 0x082b4b28 (oninit)yield_processor_svp(0x12133bfc, 0x4, 0x12133bfc, 0x1215d898, 0x1215d898, 0x82eb743) 0x082b6afb (oninit)mt_yield(0xffffffff, 0x121630cc, 0x1215d93c, 0x8306291, 0x12133bfc, 0x1) 0x082eb743 (oninit)net_wait_for_io(0x12133bfc, 0x1, 0x121421a8, 0x121630bc, 0x12140260, 0xf) 0x08306291 (oninit)accpsocket(0x121630cc, 0x12141770, 0x1215dba0, 0x12140260, 0x121630bc, 0x121421a8) 0x0830308c (oninit)tlAccept(0x12140260, 0x12141770, 0x1215dba0, 0x1215dba4, 0x12163d70, 0x0) 0x08300712 (oninit)slSQIind(0x12140260, 0x12141770, 0x1215db9c, 0x1215dba0, 0x121417ec, 0x12140260) 0x082fc5a3 (oninit)pfConInd(0x12140260, 0x12141770, 0x1215df4c, 0x12141858, 0x121413a0, 0x1215df4c) 0x082f6166 (oninit)cmConInd(0x12140260, 0x12141770, 0x1215df4c, 0x4, 0x12133bfc, 0x1215df48) 0x082f44c9 (oninit)ascInd (0x12140260, 0x12140090, 0x1215df48, 0x1215df04, 0x12133bfc, 0x1215df18) 0x082ddd19 (oninit)gcc2_compiled.(0x1215e0dc, 0x1215df48, 0x1215df48, 0x0, 0x0, 0x0) 0x082e330e (oninit)sql_listener(0x0, 0x0, 0x0, 0xffffffff, 0x12168000, 0x12156000) 0x082bc27d (oninit)startup (0xffffffff, 0x12168000, 0x12156000, 0x1dec, 0x242bfded, 0x12170228) 0x00000000 (***nosymtab***)0x0 Stack for thread: 11 sm_discon base: 0x1214a014 len: 33280 pc: 0x082b4b28 tos: 0x121521c0 state: sleeping vp: 1 0x082b4b28 (oninit)yield_processor_svp(0x1213362c, 0xffffffff, 0x0, 0x0, 0x12152200, 0x82f06c3) 0x082b6afb (oninit)mt_yield(0x2, 0x0, 0x0, 0x0, 0x11fe980c, 0x1215220c) 0x082f06c3 (oninit)net_sm_discon_thread(0x0, 0x0, 0x0, 0xffffffff, 0x12156000, 0x1214a000) 0x082bc27d (oninit)startup (0xffffffff, 0x12156000, 0x1214a000, 0x1dec, 0x242a1ded, 0x1215e228) 0x00000000 (***nosymtab***)0x0 Stack for thread: 10 sm_listen base: 0x12136014 len: 33280 pc: 0x082b4b28 tos: 0x1213d8f4 state: sleeping vp: 1 0x082b4b28 (oninit)yield_processor_svp(0x11fde1c4, 0x80, 0x1213311c, 0x1214388c, 0x1213d93c, 0x82ed9fe) 0x082b6afb (oninit)mt_yield(0xffffffff, 0x1213310c, 0x12143224, 0x121327b8, 0x121323f0, 0x1) 0x082ed9fe (oninit)accpshm (0x12143234, 0x1214388c, 0x1213dba0, 0x121327b8, 0x12143224, 0x1213310c) 0x0830308c (oninit)tlAccept(0x121327b8, 0x1214388c, 0x1213dba0, 0x1213dba4, 0x12132cd8, 0x0) 0x08300712 (oninit)slSQIind(0x121327b8, 0x1214388c, 0x1213db9c, 0x1213dba0, 0x12143908, 0x121327b8) 0x082fc5a3 (oninit)pfConInd(0x121327b8, 0x1214388c, 0x1213df4c, 0x12143974, 0x121434bc, 0x1213df4c) 0x082f6166 (oninit)cmConInd(0x121327b8, 0x1214388c, 0x1213df4c, 0x4, 0x121323f0, 0x1213df48) 0x082f44c9 (oninit)ascInd (0x121327b8, 0x121325e8, 0x1213df48, 0x1213df04, 0x121323f0, 0x1213df18) 0x082ddd19 (oninit)gcc2_compiled.(0x1213e0dc, 0x1213df48, 0x1213df48, 0x0, 0x0, 0x0) 0x082e330e (oninit)sql_listener(0x0, 0x0, 0x0, 0xffffffff, 0x1214a000, 0x12136000) 0x082bc27d (oninit)startup (0xffffffff, 0x1214a000, 0x12136000, 0x1dec, 0x24281ded, 0x12152228) 0x00000000 (***nosymtab***)0x0 Stack for thread: 9 soctcppoll base: 0x12124014 len: 33280 pc: 0x082b4e84 tos: 0x1212c090 state: running vp: 8 0x082b4e84 (oninit)yield_processor_mvp(0x0, 0xffffffff, 0x3, 0x0, 0x82f10fd, 0x400) 0x00000003 (***nosymtab***)0x3 Stack for thread: 8 sm_poll base: 0x12114014 len: 33280 pc: 0x082b4b28 tos: 0x1211c1b4 state: sleeping vp: 1 0x082b4b28 (oninit)yield_processor_svp(0x0, 0x1211c200, 0x82f0a07, 0xa, 0x1211c1f4, 0x0) 0x082b7f94 (oninit)mt_poll_yield(0xa, 0x1211c1f4, 0x0, 0x0, 0x0, 0x0) 0x082f0a07 (oninit)net_sm_poll_thread(0x0, 0x0, 0x0, 0xffffffff, 0x12124000, 0x12114000) 0x082bc27d (oninit)startup (0xffffffff, 0x12124000, 0x12114000, 0x1dec, 0x24239ded, 0x1212c228) 0x00000000 (***nosymtab***)0x0 Stack for thread: 7 main_loop() base: 0x12108014 len: 33280 pc: 0x082b4b28 tos: 0x1210fab0 state: join wait vp: 1 0x082b4b28 (oninit)yield_processor_svp(0x5, 0x0, 0x10004800, 0x1210fb5c, 0x8051f94, 0x12097c78) 0x082b67bd (oninit)mt_join (0x12097c78, 0x1210fb00, 0x1211014c, 0x4, 0x8455930, 0x12000000) 0x08051f94 (oninit)initseg (0x1211014c, 0x1211014c, 0x83ea7af, 0x83ea77a, 0x8417f7d, 0xfffffbff) 0x0804d1a2 (oninit)main_loop(0x0, 0x0, 0x0, 0xffffffff, 0x12114000, 0x12108000) 0x082bc27d (oninit)startup (0xffffffff, 0x12114000, 0x12108000, 0x1dec, 0x2421dded, 0x11f510f8) 0x00000000 (***nosymtab***)0x0 Stack for thread: 6 vp 1 base: 0x120ee014 len: 33280 pc: 0x082b4e84 tos: 0x120f618c state: sleeping vp: 7 0x082b4e84 (oninit)yield_processor_mvp(0x11ffd82c, 0x11ff9c08, 0x11ffd82c, 0x11ffd82c, 0x120f61c8, 0x82c2f17) 0x082b6b05 (oninit)mt_yield(0xffffffff, 0x0, 0x120f61e4, 0x82c2df7, 0x11ffd82c, 0x11ff9c08) 0x082c2f17 (oninit)ioidle (0x11ffd82c, 0x11ff9c08, 0x11ffd82c, 0x0, 0x0, 0x120f6200) 0x082c2df7 (oninit)iowork (0x11ffd82c, 0x11ff9c08, 0x11ff9c08, 0x0, 0x0, 0x120f620c) 0x082c2e9d (oninit)iothread(0x11ffd82c, 0x0, 0x0, 0xffffffff, 0x120f8000, 0x120ee000) 0x082bc27d (oninit)startup (0xffffffff, 0x120f8000, 0x120ee000, 0x1dec, 0x241e7ded, 0x120fa114) 0x00000000 (***nosymtab***)0x0 Stack for thread: 5 vp 0 base: 0x120be014 len: 131584 pc: 0x082b4e84 tos: 0x120de18c state: sleeping vp: 6 0x082b4e84 (oninit)yield_processor_mvp(0x11ffb99c, 0x11ffb82c, 0x11ffb99c, 0x11ffb99c, 0x120de1c8, 0x82c2f17) 0x082b6b05 (oninit)mt_yield(0xffffffff, 0x0, 0x120de1e4, 0x82c2df7, 0x11ffb99c, 0x11ffb82c) 0x082c2f17 (oninit)ioidle (0x11ffb99c, 0x11ffb82c, 0x11ffb99c, 0x0, 0x453603ed, 0x120de200) 0x082c2df7 (oninit)iowork (0x11ffb99c, 0x11ffb82c, 0x11ffb82c, 0x0, 0x0, 0x120de20c) 0x082c2e9d (oninit)iothread(0x11ffb99c, 0x0, 0x0, 0xffffffff, 0x120e0000, 0x120be000) 0x082bc27d (oninit)startup (0xffffffff, 0x120e0000, 0x120be000, 0x1dec, 0x2419fded, 0x120e2114) 0x00000000 (***nosymtab***)0x0 Stack for thread: 4 vp 0 base: 0x120a6014 len: 33280 pc: 0x082b4e84 tos: 0x120ae18c state: sleeping vp: 5 0x082b4e84 (oninit)yield_processor_mvp(0x11ff9d78, 0x11ff9c08, 0x11ff9d78, 0x11ff9d78, 0x120ae1c8, 0x82c2f17) 0x082b6b05 (oninit)mt_yield(0xffffffff, 0x0, 0x120ae1e4, 0x82c2df7, 0x11ff9d78, 0x11ff9c08) 0x082c2f17 (oninit)ioidle (0x11ff9d78, 0x11ff9c08, 0x11ff9d78, 0x0, 0x0, 0x120ae200) 0x082c2df7 (oninit)iowork (0x11ff9d78, 0x11ff9c08, 0x11ff9c08, 0x0, 0x0, 0x120ae20c) 0x082c2e9d (oninit)iothread(0x11ff9d78, 0x0, 0x0, 0x23, 0x120ae348, 0x120a6000) 0x082bc27d (oninit)startup (0x23, 0x120ae348, 0x120a6000, 0x134, 0x2415447d, 0x120ae35c) 0x00000000 (***nosymtab***)0x0 Stack for thread: 3 vp 0 base: 0x1208e014 len: 33280 pc: 0x082b4e84 tos: 0x1209618c state: sleeping vp: 4 0x082b4e84 (oninit)yield_processor_mvp(0x11ff999c, 0x11ff982c, 0x11ff999c, 0x11ff999c, 0x120961c8, 0x82c2f17) 0x082b6b05 (oninit)mt_yield(0xffffffff, 0x0, 0x120961e4, 0x82c2df7, 0x11ff999c, 0x11ff982c) 0x082c2f17 (oninit)ioidle (0x11ff999c, 0x11ff982c, 0x11ff999c, 0x0, 0x0, 0x12096200) 0x082c2df7 (oninit)iowork (0x11ff999c, 0x11ff982c, 0x11ff982c, 0x0, 0x0, 0x1209620c) 0x082c2e9d (oninit)iothread(0x11ff999c, 0x0, 0x0, 0x23, 0x12096348, 0x1208e000) 0x082bc27d (oninit)startup (0x23, 0x12096348, 0x1208e000, 0x134, 0x2412447d, 0x12083eec) 0x00000000 (***nosymtab***)0x0 Stack for thread: 2 vp 0 base: 0x12076014 len: 33280 pc: 0x082b4e84 tos: 0x1207e18c state: sleeping vp: 3 0x082b4e84 (oninit)yield_processor_mvp(0x11ff7ce4, 0x11ff7b74, 0x11ff7ce4, 0x11ff7ce4, 0x1207e1c8, 0x82c2f17) 0x082b6b05 (oninit)mt_yield(0xffffffff, 0x0, 0x1207e1e4, 0x82c2df7, 0x11ff7ce4, 0x11ff7b74) 0x082c2f17 (oninit)ioidle (0x11ff7ce4, 0x11ff7b74, 0x11ff7ce4, 0x0, 0x0, 0x1207e200) 0x082c2df7 (oninit)iowork (0x11ff7ce4, 0x11ff7b74, 0x11ff7b74, 0x0, 0x0, 0x1207e20c) 0x082c2e9d (oninit)iothread(0x11ff7ce4, 0x0, 0x0, 0x25, 0x1207e260, 0x12076000) 0x082bc27d (oninit)startup (0x25, 0x1207e260, 0x12076000, 0x4c, 0x240f42ad, 0x12080000) 0x00000000 (***nosymtab***)0x0 ===========------------- - - - - - - /usr/informix/bin/onstat -g mem: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:12 -- 97576 Kbytes Pool Summary: name class addr totalsize freesize #allocfrag #freefrag resident R 10002014 5955584 12160 2 2 res-buff R 105b0014 26787840 14208 2 2 global V 11f4c014 344064 83236 523 19 mt V 11f50014 3342336 351780 891 47 rsam V 11f8a014 237568 4764 183 1 aio V 11fe0014 622592 75048 198 24 gls V 11fe6014 49152 5832 696 5 dictpool V 11fea014 8192 7428 2 1 procpool V 11fec014 8192 7148 4 1 XTF_mem V 12002014 409600 17488 4 3 main_loop() V 12106014 16384 3184 109 2 2 V 12112014 8192 3308 8 1 shmcon M 15f4c014 1368064 16256 2 2 3 V 12122014 8192 3308 8 1 4 V 12134014 16384 100 309 1 5 V 12146014 8192 3308 8 1 6 V 12148014 8192 3308 8 1 7 V 12154014 16384 100 309 1 8 V 12172014 8192 3308 8 1 lgflushpool V 12234014 8192 7932 3 1 aslogflush V 12236014 16384 7004 108 1 btclean V 1224a014 16384 7004 108 1 fast_rec V 12258014 229376 4044 354 1 LGR V 1226a014 311296 66424 122 41 xchgpool V 1231c014 8192 940 72 1 Blkpool Summary: name class addr size #blks global V 11f4de50 0 0 ===========------------- - - - - - - /usr/informix/bin/onstat -g seg: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:12 -- 97576 Kbytes Segment Summary: id key addr size ovhd class blkused blkfree 688129 1381386241 10000000 32808960 1360 R* 3998 7 720898 1381386242 11f4a000 67108864 1620 V 697 7495 786436 1381386244 15f4a000 1425408 620 M 168 6 Total: - - 101343232 - - 4863 7508 (* segment locked in memory) ===========------------- - - - - - - /usr/informix/bin/onstat -g rbm: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:12 -- 97576 Kbytes Block bitmap for resident segment address 10000000: (bitmap address = 10000250, bitmap size = 504) 10000250:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff 10000270:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff 10000290:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff 100002b0:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff 100002d0:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff 100002f0:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff 10000310:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff 10000330:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff 10000350:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff 10000370:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff 10000390:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff 100003b0:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff 100003d0:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff 100003f0:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff 10000410:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff 10000430:ffffffff ffffffff ffffffff ffffffff fcffffff 00000000 ===========------------- - - - - - - /usr/informix/bin/onstat -g nbm: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:12 -- 97576 Kbytes Block bitmap for virtual segment address 11f4a000: (bitmap address = 11f4a250, bitmap size = 1024) 11f4a250:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff 11f4a270:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff 11f4a290:ffffffff ffffffff ffffffff ffffffff ffffffff 80ffffff 00000000 00000000 11f4a2b0:00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 11f4a2d0:00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 11f4a2f0:00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 11f4a310:00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 11f4a330:00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 11f4a350:00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 11f4a370:00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 11f4a390:00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 11f4a3b0:00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 11f4a3d0:00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 11f4a3f0:00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 11f4a410:00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 11f4a430:00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 11f4a450:00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 11f4a470:00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 11f4a490:00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 11f4a4b0:00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 11f4a4d0:00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 11f4a4f0:00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 11f4a510:00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 11f4a530:00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 11f4a550:00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 11f4a570:00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 11f4a590:00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 11f4a5b0:00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 11f4a5d0:00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 11f4a5f0:00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 11f4a610:00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 11f4a630:00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 ===========------------- - - - - - - /usr/informix/bin/onstat -g dic: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:12 -- 97576 Kbytes Dictionary Cache: Number of lists: 31, Maximum list size: 10 list# size refcnt dirty? heapptr table name -------------------------------------------------------- Dictionary cache is empty ===========------------- - - - - - - /usr/informix/bin/onstat -g dsc: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:13 -- 97576 Kbytes Distribution Cache: Number of lists : 31 DS_POOLSIZE : 127 Number of entries : 0 Number of entries in use : 0 Distribution Cache Entries: list# id ref_cnt dropped? heap_ptr distribution name ----------------------------------------------------------------- Distribution Cache is empty. ===========------------- - - - - - - /usr/informix/bin/onstat -g prc: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:13 -- 97576 Kbytes Stored Procedure Cache: Number of lists : 31 PC_POOLSIZE : 127 Number of entries : 0 Number of entries in use : 0 Stored Procedure Cache Entries: list# id ref_cnt dropped? heap_ptr procedure name -------------------------------------------------------------- Stored Procedure Cache is empty. ===========------------- - - - - - - /usr/informix/bin/onstat -g cac: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:13 -- 97576 Kbytes ===========------------- - - - - - - /usr/informix/bin/onstat -g sch: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:13 -- 97576 Kbytes VP Scheduler Statistics: vp pid class semops busy waits spins/wait 1 2480 cpu 80 0 0 2 2481 adm 0 0 0 3 2482 lio 2 0 0 4 2483 pio 2 0 0 5 2484 aio 345 0 0 6 2485 msc 7 0 0 7 2486 aio 386 0 0 8 2487 soc 2 0 0 9 2488 aio 336 0 0 10 2489 aio 223 0 0 11 2490 aio 301 0 0 12 2491 aio 294 0 0 13 2492 aio 298 0 0 14 2493 aio 256 0 0 15 2494 aio 259 0 0 16 2495 aio 275 0 0 ===========------------- - - - - - - /usr/informix/bin/onstat -g pos: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:13 -- 97576 Kbytes 1 7 0 infos ver/size 2 136 2 1 0 snum 0 52564801 10000000 engine2 3 4 0 onconfig path /usr/informix/etc/onconfig 4 5 0 host leodb.leonet.ru 5 6 0 oninit ver Informix Dynamic Server Version 7.30.UC10 6 8 0 del ===========------------- - - - - - - /usr/informix/bin/onstat -g ioa: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:13 -- 97576 Kbytes AIO global info: 6 aio classes 7 open files 64 max global files AIO I/O queues: q name/id len maxlen totalops dskread dskwrite dskcopy adt 0 0 0 0 0 0 0 msc 0 0 1 5 0 0 0 aio 0 0 8 73 14 2 0 pio 0 0 0 0 0 0 0 lio 0 0 0 0 0 0 0 gfd 4 0 5 417 417 0 0 gfd 5 0 1 1 1 0 0 gfd 6 0 1 1 1 0 0 gfd 7 0 1 1 1 0 0 AIO I/O vps: class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup errors msc 0 i 0.4 5 0 0 0 6 0.8 0 aio 0 i 32.2 418 386 1 0 342 1.2 0 aio 1 i 30.5 397 377 1 0 384 1.0 0 aio 2 i 26.2 341 338 0 0 333 1.0 0 aio 3 i 25.5 332 330 0 0 220 1.5 0 aio 4 i 24.2 315 314 0 0 298 1.1 0 aio 5 i 23.5 306 305 0 0 291 1.1 0 aio 6 i 22.5 293 293 0 0 297 1.0 0 aio 7 i 22.2 289 289 0 0 255 1.1 0 aio 8 i 21.5 280 280 0 0 258 1.1 0 aio 9 i 20.8 271 271 0 0 274 1.0 0 pio 0 i 0.0 0 0 0 0 1 0.0 0 lio 0 i 0.0 0 0 0 0 1 0.0 0 AIO global files: gfd pathname totalops dskread dskwrite io/s 4 /dbs/dbs002 417 417 0 32.1 5 /dbs/dbs003 1 1 0 0.1 6 /dbs/dbs004 1 1 0 0.1 7 /dbs/dbs005 1 1 0 0.1 AIO big buffer usage summary: class reads writes pages ops pgs/op holes hl-ops hls/op pages ops pgs/op kio 0 0 0.00 0 0 0.00 0 0 0.00 adt 0 0 0.00 0 0 0.00 0 0 0.00 msc 0 0 0.00 0 0 0.00 0 0 0.00 aio 12232 3169 3.86 0 0 0.00 0 0 0.00 pio 0 0 0.00 0 0 0.00 0 0 0.00 lio 0 0 0.00 0 0 0.00 0 0 0.00 ===========------------- - - - - - - /usr/informix/bin/onstat -g nta: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:13 -- 97576 Kbytes global network information: #netscb connects read write q-free q-limits q-exceed 5/ 5 0 0 0 0/ 0 189/ 10 0/ 0 Individual thread network information (basic): netscb type thread name sid fd poll reads writes q-nrm q-exp 12133bfc soctcp soctcplst 7 1 5 0 0 0/ 0 0/ 0 1213362c ipcshm sm_discon 6 0 0 0 0 0/ 0 0/ 0 121323f0 ipcshm sm_listen 4 0 0 0 0 0/ 0 0/ 0 12120c78 soctcp soctcppoll 3 0 5 0 0 0/ 0 0/ 0 11fe9524 ipcshm sm_poll 2 0 0 0 0 0/ 0 0/ 0 Individual thread network information (times): netscb thread name sid open read write address 12133bfc soctcplst 7 18:37:34 leodb.leonet.ru|1526|soctcp 1213362c sm_discon 6 18:37:33 121323f0 sm_listen 4 18:37:33 12120c78 soctcppoll 3 18:37:33 11fe9524 sm_poll 2 18:37:28 Network mailbox information: box netscb thread name max received in box max in box full signal 5 12120c78 soctcppoll 10 3 0 2 0 yes 6 12133bfc soctcplst 10 0 0 0 0 no Client Type Calls Accepted Rejected Read Write sqlexec no 0 0 0 0 srvinfx no 0 0 0 0 onspace no 0 0 0 0 onlog yes 0 0 0 0 onparam no 0 0 0 0 oncheck yes 0 0 0 0 onload no 0 0 0 0 onunload no 0 0 0 0 onmonitor yes 0 0 0 0 dr_accept yes 0 0 0 0 cdraccept no 0 0 0 0 ontape yes 0 0 0 0 srvstat yes 0 0 0 0 asfecho yes 0 0 0 0 listener yes 0 0 0 0 crsamexec yes 0 0 0 0 safe yes 0 0 0 0 Totals 0 0 0 0 ===========------------- - - - - - - /usr/informix/bin/onstat -g nsd: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:13 -- 97576 Kbytes Network Shared Memory Data for Poll Thread: 0 Free Message Buffer Bitmap (bitmap address = 11fe9e20, bitmap size 1228) 11fe9e20:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff 11fe9e40:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff 11fe9e60:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff 11fe9e80:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff 11fe9ea0:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffff Free Message Buffer Status Bitmap (bitmap address = 15f5e01c, bitmap size 128) 15f5e01c:ffffffff ffffffff ffffffff ffffffff Message Buffer Table bufid clientid addr Message Buffer Status Table clientid netscb addr addr offset ===========------------- - - - - - - /usr/informix/bin/onstat -g nsc: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:13 -- 97576 Kbytes clientid clientPID state #serverbufs #clientbufs #rdwrts ===========------------- - - - - - - /usr/informix/bin/onstat -g nss: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:13 -- 97576 Kbytes clientid clientPID state #serverbufs #clientbufs #rdwrts ===========------------- - - - - - - /usr/informix/bin/onstat -g sts: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:13 -- 97576 Kbytes Stack usage: TID Total Max Current Thread Name bytes % bytes % 2 32768 519 1 136 0 vp 0 3 32768 518 1 136 0 vp 0 4 32768 2747 8 136 0 vp 0 5 131072 3031 2 136 0 vp 0 6 32768 2747 8 136 0 vp 1 7 32768 7451 22 1892 5 main_loop() 8 32768 2191 6 96 0 sm_poll 9 32768 2751 8 388 1 soctcppoll 10 32768 8791 26 2336 7 sm_listen 11 32768 107 0 84 0 sm_discon 12 32768 8791 26 2480 7 soctcplst 13 32768 435 1 88 0 flush_sub(0) 14 32768 2747 8 136 0 vp 2 15 32768 2747 8 136 0 vp 3 16 32768 2747 8 136 0 vp 4 17 32768 2747 8 136 0 vp 5 18 32768 1771 5 136 0 vp 6 19 32768 1567 4 136 0 vp 7 20 32768 1567 4 136 0 vp 8 21 32768 843 2 136 0 vp 9 22 32768 175 0 172 0 aslogflush 23 32768 91 0 88 0 btclean 24 32768 3759 11 244 0 fast_rec 25 131072 2171 1 180 0 bld_logrecs 26 131072 2639 2 244 0 logredo 27 131072 4379 3 344 0 xchg_1.0 28 131072 4915 3 2324 1 xchg_1.1 29 131072 4379 3 344 0 xchg_1.2 30 131072 4731 3 384 0 xchg_1.3 31 131072 4379 3 344 0 xchg_1.4 32 131072 4798 3 344 0 xchg_1.5 33 131072 4723 3 344 0 xchg_1.6 34 131072 4047 3 344 0 xchg_1.7 35 131072 4047 3 344 0 xchg_1.8 36 131072 4227 3 384 0 xchg_1.9 37 131072 2307 1 392 0 xchg_2.0 ===========------------- - - - - - - /usr/informix/bin/onstat -g ses: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:13 -- 97576 Kbytes session #RSAM total used id user tty pid hostname threads memory memory 8 informix - 0 - 0 8192 4884 7 informix - 0 - 0 16384 16284 6 informix - 0 - 0 8192 4884 5 informix - 0 - 0 8192 4884 4 informix - 0 - 0 16384 16284 3 informix - 0 - 0 8192 4884 2 informix - 0 - 0 8192 4884 ===========------------- - - - - - - /usr/informix/bin/onstat -g sql: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:13 -- 97576 Kbytes ===========------------- - - - - - - /usr/informix/bin/onstat -g stq: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:13 -- 97576 Kbytes ===========------------- - - - - - - /usr/informix/bin/onstat -g opn: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:13 -- 97576 Kbytes tid rstcb isfd op_mode op_flags partnum ucount ocount lockmode 27 0x11f8e100 0 0x00000002 0x00000043 0x0010013a 1 1 0 28 0x11f8e5b4 0 0x00000002 0x00000043 0x001001bd 1 1 0 28 0x11f8e5b4 1 0x00000002 0x00000043 0x0010018b 1 1 0 28 0x11f8e5b4 2 0x00000002 0x00000043 0x00100195 1 1 0 28 0x11f8e5b4 3 0x00000002 0x00000043 0x0010019f 1 1 0 29 0x11f8ea68 0 0x00000002 0x00000043 0x00100196 1 1 0 29 0x11f8ea68 1 0x00000002 0x00000043 0x0010011e 1 1 0 29 0x11f8ea68 2 0x00000002 0x00000043 0x0010018c 1 1 0 30 0x11f8ef1c 0 0x00000002 0x00000043 0x00100183 1 1 0 30 0x11f8ef1c 1 0x00000002 0x00000043 0x00100101 1 1 0 30 0x11f8ef1c 2 0x00000002 0x00000043 0x00100179 1 1 0 31 0x11f8f3d0 0 0x00000002 0x00000043 0x0010017a 1 1 0 31 0x11f8f3d0 1 0x00000002 0x00000043 0x001001b6 1 1 0 32 0x11f8f884 0 0x00000002 0x00000043 0x001001cb 1 1 0 32 0x11f8f884 1 0x00000002 0x00000043 0x00100121 1 1 0 32 0x11f8f884 2 0x00000002 0x00000043 0x0010010d 1 1 0 33 0x11f8fd38 0 0x00000002 0x00000043 0x00100190 1 1 0 33 0x11f8fd38 1 0x00000002 0x00000043 0x00100172 1 1 0 33 0x11f8fd38 2 0x00000002 0x00000043 0x0010017c 1 1 0 34 0x11f901ec 0 0x00000002 0x00000043 0x00100173 1 1 0 35 0x11f906a0 0 0x00000002 0x00000043 0x001000d4 1 1 0 36 0x11f90b54 0 0x00000002 0x00000043 0x00100139 1 1 0 ===========------------- - - - - - - /usr/informix/bin/onstat -g dri: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:13 -- 97576 Kbytes Data Replication: Type State Paired server Last DR CKPT (id/pg) standard off -1 / -1 DRINTERVAL 30 DRTIMEOUT 30 DRAUTO 0 DRLOSTFOUND /usr/informix/etc/dr.lostfound ===========------------- - - - - - - /usr/informix/bin/onstat -g ppf: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:13 -- 97576 Kbytes Partition profiles partnum lkrqs lkwts dlks touts isrd iswrt isrwt isdel bfrd bfwrt seqsc 1048577 0 0 0 0 0 0 0 0 0 0 0 1048788 0 0 0 0 0 0 0 0 1 1 0 1048833 0 0 0 0 0 0 0 0 10 5 0 1048845 0 0 0 0 0 0 0 0 10 6 0 1048862 0 0 0 0 0 0 0 0 37 17 0 1048865 0 0 0 0 0 0 0 0 52 26 0 1048889 0 0 0 0 0 0 0 0 9 7 0 1048890 0 0 0 0 0 0 0 0 4 2 0 1048946 0 0 0 0 0 0 0 0 21 14 0 1048947 0 0 0 0 0 0 0 0 11 9 0 1048953 0 0 0 0 0 0 0 0 6 4 0 1048954 0 0 0 0 0 0 0 0 816 408 0 1048956 0 0 0 0 0 0 0 0 6 4 0 1048963 0 0 0 0 0 0 0 0 2458 1813 0 1048971 0 0 0 0 0 0 0 0 900 812 0 1048972 0 0 0 0 0 0 0 0 18 11 0 1048976 0 0 0 0 0 0 0 0 287 163 0 1048981 0 0 0 0 0 0 0 0 2905 2501 0 1048982 0 0 0 0 0 0 0 0 1936 1714 0 1048991 0 0 0 0 0 0 0 0 3398 2658 0 1049014 0 0 0 0 0 0 0 0 111 69 0 1049021 0 0 0 0 0 0 0 0 81 44 0 1049035 0 0 0 0 0 0 0 0 7382 6419 0 2097153 0 0 0 0 0 0 0 0 0 0 0 ===========------------- - - - - - - /usr/informix/bin/onstat -g tpf: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:13 -- 97576 Kbytes Thread profiles tid lkreqs lkw dl to lgrs isrd iswr isrw isdl isct isrb lx bfr bfw lsus lsmx seq 0 0 0 0 0 0 0 0 0 0 0 0 0 8 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10916 10908 0 0 0 25 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 26 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 27 0 0 0 0 0 0 0 0 0 20 0 0 7 2 0 0 0 28 0 0 0 0 0 0 0 0 0 420 0 0 7296 6015 0 0 0 29 0 0 0 0 0 0 0 0 0 3 0 0 1994 1742 0 0 0 30 0 0 0 0 0 0 0 0 0 38 0 0 2477 1822 0 0 0 31 0 0 0 0 0 0 0 0 0 32 0 0 933 477 0 0 0 32 0 0 0 0 0 0 0 0 0 55 0 0 7450 6451 0 0 0 33 0 0 0 0 0 0 0 0 0 3 0 0 317 181 0 0 0 34 0 0 0 0 0 0 0 0 0 13 0 0 14 9 0 0 0 35 0 0 0 0 0 0 0 0 0 2 0 0 4 1 0 0 0 36 0 0 0 0 0 0 0 0 0 563 0 0 12 7 0 0 0 37 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ===========------------- - - - - - - /usr/informix/bin/onstat -g tgp: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:13 -- 97576 Kbytes Generic Page Thread profiles tid read write rewrite delete alloc free cursor opens 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 25 0 0 0 0 0 0 0 26 0 0 0 0 0 0 0 27 0 0 0 0 0 0 0 28 0 0 0 0 0 0 0 29 0 0 0 0 0 0 0 30 0 0 0 0 0 0 0 31 0 0 0 0 0 0 0 32 0 0 0 0 0 0 0 33 0 0 0 0 0 0 0 34 0 0 0 0 0 0 0 35 0 0 0 0 0 0 0 36 0 0 0 0 0 0 0 37 0 0 0 0 0 0 0 ===========------------- - - - - - - /usr/informix/bin/onstat -g pgp: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:13 -- 97576 Kbytes Generic Page Partition profiles partnum read write rewrite delete alloc free cursor opens 1048788 0 0 0 0 0 0 0 1048845 0 0 0 0 0 0 0 1048889 0 0 0 0 0 0 0 1048946 0 0 0 0 0 0 0 1048947 0 0 0 0 0 0 0 1048953 0 0 0 0 0 0 0 1048963 0 0 0 0 0 0 0 1048971 0 0 0 0 0 0 0 1048976 0 0 0 0 0 0 0 1048981 0 0 0 0 0 0 0 1048982 0 0 0 0 0 0 0 1048991 0 0 0 0 0 0 0 1049014 0 0 0 0 0 0 0 1049021 0 0 0 0 0 0 0 1049035 0 0 0 0 0 0 0 ===========------------- - - - - - - /usr/informix/bin/onstat -g mgm: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:13 -- 97576 Kbytes Memory Grant Manager (MGM) -------------------------- MAX_PDQPRIORITY: 100 DS_MAX_QUERIES: 2 DS_MAX_SCANS: 1048576 DS_TOTAL_MEMORY: 256 KB Queries: Active Ready Maximum 0 0 2 Memory: Total Free Quantum (KB) 256 256 128 Scans: Total Free Quantum 1048576 1048576 1 Load Control: (Memory) (Scans) (Priority) (Max Queries) (Reinit) Gate 1 Gate 2 Gate 3 Gate 4 Gate 5 (Queue Length) 0 0 0 0 0 Active Queries: None Ready Queries: None Free Resource Average # Minimum # -------------- --------------- --------- Memory 0.0 +- 0.0 32 Scans 0.0 +- 0.0 1048576 Queries Average # Maximum # Total # -------------- --------------- --------- ------- Active 0.0 +- 0.0 0 0 Ready 0.0 +- 0.0 0 0 Resource/Lock Cycle Prevention count: 0 ===========------------- - - - - - - /usr/informix/bin/onstat -g smb: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:13 -- 97576 Kbytes ===========------------- - - - - - - /usr/informix/bin/onstat -g lsc: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:13 -- 97576 Kbytes Light Scan Info descriptor address next_lpage next_ppage ppage_left bufcnt look_aside ===========------------- - - - - - - /usr/informix/bin/onstat -g lap: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:13 -- 97576 Kbytes Light Append Info session id address cur_ppage la_npused la_ndata la_nrows bufcnt ===========------------- - - - - - - /usr/informix/bin/onstat -g ddr: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:13 -- 97576 Kbytes DDR -- Down -- ===========------------- - - - - - - /usr/informix/bin/onstat -g dis: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:13 -- 97576 Kbytes There are 2 servers found Server : test Server Number : 0 Server Type : ODS Server Status : Down Server Version: Informix Dynamic Server Version 7.30.UC10 Shared Memory : 0x10000000 INFORMIXDIR : /usr/informix ONCONFIG : /usr/informix/etc/onconfig SQLHOSTS : /usr/informix/etc/sqlhosts Host : ix1.infoart.spb.su Server : engine2 Server Number : 0 Server Type : ODS Server Status : Up Server Version: Informix Dynamic Server Version 7.30.UC10 Shared Memory : 0x10000000 INFORMIXDIR : /usr/informix ONCONFIG : /usr/informix/etc/onconfig SQLHOSTS : /usr/informix/etc/sqlhosts Host : leodb.leonet.ru ===========------------- - - - - - - /usr/informix/bin/onstat -g arc: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:13 -- 97576 Kbytes num DBSpace Q Size Q Len Buffer partnum size scanner Dbspaces - Archive Status name number level date log log-position rootdbs 1 0 01/17/2005.19:45 2 0x3419018 ===========------------- - - - - - - /usr/informix/bin/onstat -g dll: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:13 -- 97576 Kbytes ===========------------- - - - - - - /usr/informix/bin/onstat -g sym: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:13 -- 97576 Kbytes Symbol tables: total 1 addr symbols mode lowsaddr highsaddr symlist namepool slot symtabname 11f5136c 9977 abs 804b140 83e09a0 11f56014 11f6a014 0 oninit ===========------------- - - - - - - /usr/informix/bin/onstat -g ras: Informix Dynamic Server Version 7.30.UC10 -- Fast Recovery -- Up 00:00:13 -- 97576 Kbytes Diagnostics Current Settings AFCRASH 0x00000201 AFFAIL 0x00000001 AFWARN 0x00000001 AFDEBUG 0 AFLINES 0 BLOCKTIMEOUT 3600 Block Status Unblocked DUMPCORE 0 DUMPGCORE 0 DUMPSHMEM 0 DUMPCNT 1 DUMPDIR /tmp SYSALARMPROGRAM /usr/informix/etc/evidence.sh ===========------------- - - - - - - Environment Variables: LESSOPEN=|/usr/bin/lesspipe.sh %s USERNAME= CC8BITLEVEL=2 HISTSIZE=1000 HOSTNAME=leodb.leonet.ru LOGNAME=informix MAIL=/var/spool/mail/informix DBMONEY=$. DB_LOCALE=ru_RU.KOI-8 TERM=xterm HOSTTYPE=i386 PATH=/usr/bin:/usr/kerberos/bin:/usr/informix/bin:/bin:/usr/bin:/usr/local/bin:/usr/bin/X11:/usr/informix/bin:/usr/informix/bin HOME=/usr/informix DBLANG=ru_RU.KOI-8 INPUTRC=/etc/inputrc CLIENT_LOCALE=ru_RU.KOI-8 SHELL=/bin/bash USER=informix DBCENTURY=C BASH_ENV=/usr/informix/.bashrc INFORMIXDIR=/usr/informix INFORMIXSERVER=engine2 LANG=ru_RU.KOI-8 SERVER_LOCALE=ru_RU.KOI-8 OSTYPE=Linux MM_CHARSET=KOI8-R DBDATE=DMY2/ SHLVL=3 LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35: _=/usr/bin/env ===========------------- - - - - - - /usr/informix/bin/oninit -V: Informix Dynamic Server Version 7.30.UC10 Software Serial Number CML#J120599 Wed Oct 6 18:52:38 PDT 1999 ===========------------- - - - - - - /usr/informix/bin/onstat -V: Informix Dynamic Server Version 7.30.UC10 Software Serial Number CML#J120599 ===========------------- - - - - - - /usr/informix/bin/oncheck -V: Informix Dynamic Server Version 7.30.UC10 Software Serial Number CML#J120599 ===========------------- - - - - - - /usr/informix/bin/onmode -V: Informix Dynamic Server Version 7.30.UC10 Software Serial Number CML#J120599 ===========------------- - - - - - - uname -a: Linux leodb.leonet.ru 2.4.18-5 #1 Mon Jun 10 15:38:12 EDT 2002 i686 unknown ------------------------------- End System Alarm Program Output ------------------------------- 18:37:41 sh /usr/informix/etc/evidence.sh 3 0 /tmp/af.1c03f3 11 0x0 28 0x1209ad4c 513 0 0 0 0 18:37:41 See Also: /tmp/af.1c03f3 18:37:41 ------------------ End of assertion failure 0 ----------------- ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 18.10.2006, 21:48 |
|
||
|
запортился журнал логов
|
|||
|---|---|---|---|
|
#18+
Восстанавливаться из архива. Или звонить в саппорт. В таком вот аксепте ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 18.10.2006, 23:25 |
|
||
|
запортился журнал логов
|
|||
|---|---|---|---|
|
#18+
Кстати, объяснили вам неправильно. информикс не может накатить транзакции, случившиеся между последним чекпойнтом и моментом падения. "отключить" журнал логов нельзя, но его можно "обрезать" до записи, на которой сервер вылетает. Как это делать - смотрите тему tbzero. Естетственно, согласованность и целостность данных потом придется долго проверять. В таком вот аксепте ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 18.10.2006, 23:29 |
|
||
|
запортился журнал логов
|
|||
|---|---|---|---|
|
#18+
т.е в режиме onmode -r к базе , таблицам уже ни как не достучаться ? (чёрт с ними с логами) ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 19.10.2006, 01:05 |
|
||
|
запортился журнал логов
|
|||
|---|---|---|---|
|
#18+
Вот аналогичная проблема: невозможность восстановить логический журнал. Решилась просто - удалением журнала: Informix Dynamic Server Version 9.40.FC1 Compaq Tru64 UNIX V5.1B (Rev. 2650) And this is a part of online.log... 16:59:33 DR: Reservation of the last logical log for log backup turned on 16:59:33 Physical Recovery Started at Page (1:102061). 16:59:33 Physical Recovery Complete: 527 Pages Examined, 527 Pages Restored. 16:59:33 Logical Recovery Started. 16:59:33 10 recovery worker threads will be started. 16:59:43 Fast Recovery Switching to Log 1008 16:59:46 Logical Recovery has reached the transaction cleanup phase. 16:59:46 Assert Failed: Rollback error 126 16:59:46 Informix Dynamic Server Version 9.40.FC1 16:59:46 Who: Session(17, root@deimos.icrcosmetics.local, 0, 22c3fec78) Thread(34, fast_rec, 22c3baa58, 1) File: rstrans.c Line: 2378 16:59:46 Results: Log record (OLDRSAM:HDELETE) in log 1008, offset 0xd867f0 was not rolled back 16:59:46 Action: Use 'onlog' to view the transaction and repair manually. 16:59:46 stack trace for pid 650335 written to /tmp/af.40a1e72 16:59:46 See Also: /tmp/af.40a1e72 16:59:51 Rollback error 126 16:59:52 Assert Failed: Rollback error 126 16:59:52 Informix Dynamic Server Version 9.40.FC1 16:59:52 Who: Session(17, root@deimos.icrcosmetics.local, 0, 22c3fec78) Thread(34, fast_rec, 22c3baa58, 1) File: rsextlog.c Line: 1636 16:59:52 Results: Log record (OLDRSAM:HDELETE) in log 1008, offset 0xd867f0 was not rolled back 16:59:52 Action: Use 'onlog' to view the transaction and repair manually. 16:59:52 stack trace for pid 650335 written to /tmp/af.40a1e72 16:59:52 See Also: /tmp/af.40a1e72 16:59:57 Rollback error 126 16:59:57 Assert Failed: Dynamic Server must abort We cannot bring the system online: during the fast recovery it crash. Is it possible to restart the system without the log 1008 or to drop this log? What does it means 'repair manually'? How can I do? Can someone help to bring up the sistem however? Thanks in advance. Ciao. Marino Decaro sending to informix-list Thank you, Hiten Informix Technical Support has just resolved the problem: they deleted manually the log 1008 and now the system is online. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 19.10.2006, 04:59 |
|
||
|
запортился журнал логов
|
|||
|---|---|---|---|
|
#18+
а вот , однако, описание ошибки 126: ISAM error: bad row id. The ISAM processor was asked to retrieve a row by its physical location but could not find a row at that location. For C-ISAM programs, if you are using access by record number, review the number stored in isrecnum; it is invalid. Otherwise, the current index might be damaged; run the bcheck or secheck utility. For SQL products, the index has been damaged. Run the oncheck utility to check and repair the index if you are using IBM Informix Dynamic Server, IBM Informix Universal Server, or IBM Informix OnLine Dynamic Server. Run bcheck or secheck if you are using the IBM Informix SE database server. Run tbcheck if you are using the IBM Informix OnLine database server. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 19.10.2006, 05:14 |
|
||
|
запортился журнал логов
|
|||
|---|---|---|---|
|
#18+
aist-pskнадо отключить журнал , но это можно делать только в online - а туда нам не выйти перевели в режим onmode -r А можно узнать, что же это за режим такой интересный ? И что он дает ? Код: plaintext 1. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 19.10.2006, 12:32 |
|
||
|
запортился журнал логов
|
|||
|---|---|---|---|
|
#18+
anjeyВот аналогичная проблема: невозможность восстановить логический журнал. Решилась просто - удалением журнала: ... Informix Technical Support has just resolved the problem: they deleted manually the log 1008 and now the system is online. Скорее всего, саппорт не утруждал себя долгим объяснением деталей, а сказал "по простому", чтобы клиенту было "быстро и понятно". Ведь транзакции могут легко переходить из журнала в журнал, существует порядок журналов и пр., т.е. я больше верю Выбегалло, что журналы урезаются (очищаются от транзакций), а не удаляются . ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 19.10.2006, 12:40 |
|
||
|
запортился журнал логов
|
|||
|---|---|---|---|
|
#18+
vasilis anjeyВот аналогичная проблема: невозможность восстановить логический журнал. Решилась просто - удалением журнала: ... Informix Technical Support has just resolved the problem: they deleted manually the log 1008 and now the system is online. Скорее всего, саппорт не утруждал себя долгим объяснением деталей, а сказал "по простому", чтобы клиенту было "быстро и понятно". Ведь транзакции могут легко переходить из журнала в журнал, существует порядок журналов и пр., т.е. я больше верю Выбегалло, что журналы урезаются (очищаются от транзакций), а не удаляются . "удалить" журнал невозможно - это не отдельный файл, а область либо в rootdbs либо в каком другом дбспейсе, куда админ перенес журналы после инициализации. информикс в reserved pages хранит информацию о месте последней записи в logical log. Чтобы "стереть" журнал, надо поменять эту информацию, что делается утилитой tbzero или вручную сотрудниками сапппорта. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 20.10.2006, 00:53 |
|
||
|
запортился журнал логов
|
|||
|---|---|---|---|
|
#18+
если сделать и поменять в онконфиге LTAPEDEV /dev/null и сделать ontape -a ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 24.10.2006, 21:46 |
|
||
|
|

start [/forum/topic.php?fid=44&fpage=48&tid=1608575]: |
0ms |
get settings: |
7ms |
get forum list: |
15ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
34ms |
get topic data: |
10ms |
get forum data: |
2ms |
get page messages: |
37ms |
get tp. blocked users: |
1ms |
| others: | 267ms |
| total: | 379ms |

| 0 / 0 |
