powered by simpleCommunicator - 2.0.59     © 2026 Programmizd 02
Целевая тема:
Создать новую тему:
Автор:
Закрыть
Цитировать
Форумы / Informix [игнор отключен] [закрыт для гостей] / запортился журнал логов
11 сообщений из 11, страница 1 из 1
запортился журнал логов
    #34065081
Фотография aist-psk
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
после внезапного падения сервера (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 -----------------
...
Рейтинг: 0 / 0
запортился журнал логов
    #34065201
Выбегалло
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
Восстанавливаться из архива. Или звонить в саппорт.

В таком вот аксепте
...
Рейтинг: 0 / 0
запортился журнал логов
    #34065207
Выбегалло
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
Кстати, объяснили вам неправильно.
информикс не может накатить транзакции, случившиеся между последним чекпойнтом и моментом падения. "отключить" журнал логов нельзя, но его можно "обрезать" до записи, на которой сервер вылетает. Как это делать - смотрите тему tbzero. Естетственно, согласованность и целостность данных потом придется долго проверять.

В таком вот аксепте
...
Рейтинг: 0 / 0
запортился журнал логов
    #34065283
Фотография aist-psk
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
т.е в режиме onmode -r к базе , таблицам уже ни как не достучаться ? (чёрт с ними с логами)
...
Рейтинг: 0 / 0
запортился журнал логов
    #34065326
anjey
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
Вот аналогичная проблема: невозможность восстановить логический журнал.
Решилась просто - удалением журнала:

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.
...
Рейтинг: 0 / 0
запортился журнал логов
    #34065328
anjey
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
а вот , однако, описание ошибки 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.
...
Рейтинг: 0 / 0
запортился журнал логов
    #34066174
vasilis
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
aist-pskнадо отключить журнал , но это можно делать только в online - а туда нам не выйти
перевели в режим onmode -r

А можно узнать, что же это за режим такой интересный ? И что он дает ?
Код: plaintext
1.
     -R   Rebuild the /INFORMIXDIR/etc/.infos.DBSERVERNAME file
     -r   Set shared memory buffer cache to resident
И какое это имеет отношение к данной проблеме ?
...
Рейтинг: 0 / 0
запортился журнал логов
    #34066207
vasilis
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
anjeyВот аналогичная проблема: невозможность восстановить логический журнал.
Решилась просто - удалением журнала:
...
Informix Technical Support has just resolved the problem: they deleted
manually the log 1008 and now the system is online.
Скорее всего, саппорт не утруждал себя долгим объяснением деталей, а сказал "по простому", чтобы клиенту было "быстро и понятно".
Ведь транзакции могут легко переходить из журнала в журнал, существует порядок журналов и пр., т.е. я больше верю Выбегалло, что журналы урезаются (очищаются от транзакций), а не удаляются .
...
Рейтинг: 0 / 0
запортился журнал логов
    #34068227
Выбегалло
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
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 или вручную сотрудниками сапппорта.
...
Рейтинг: 0 / 0
запортился журнал логов
    #34078519
sabit
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
если сделать и поменять в онконфиге LTAPEDEV /dev/null
и сделать ontape -a
...
Рейтинг: 0 / 0
запортился журнал логов
    #34078527
Выбегалло
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
sabitесли сделать и поменять в онконфиге LTAPEDEV /dev/null
и сделать ontape -a

не поможет.
...
Рейтинг: 0 / 0
11 сообщений из 11, страница 1 из 1
Форумы / Informix [игнор отключен] [закрыт для гостей] / запортился журнал логов
Найденые пользователи ...
Разблокировать пользователей ...
Читали форум (0):
Пользователи онлайн (0):
x
x
Закрыть


Просмотр
0 / 0
Close
Debug Console [Select Text]