onmode -ky kangs again
HI,All
Our IDS hangs again for some reason. Basically, it can answer onstat
commands, but NOT onmode, i.e., onmode -c, onmode -ky,..
The following is some info, hope can give some tips,
Thanks,
Frank
informix@dora $ onstat -m
IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line (CKPT REQ) --
Up 20:53:39 -- 1976112 KbytesBlocked:CKPT
Message Log File: /dbbackup/online_log/online_int2.log
14:25:11 Maximum server connections 4
14:30:12 Fuzzy Checkpoint Completed: duration was 0 seconds, 33 buffers
not flushed.
14:30:12 Checkpoint loguniq 195, logpos 0x2c13250, timestamp: 0x2dfce9ca
14:30:12 Maximum server connections 4
14:35:11 Fuzzy Checkpoint Completed: duration was 0 seconds, 30 buffers
not flushed.
14:35:11 Checkpoint loguniq 195, logpos 0x2c16220, timestamp: 0x2dfceaad
14:35:11 Maximum server connections 4
14:48:33 Assert Failed: ptmap
14:48:33 IBM Informix Dynamic Server Version 10.00.UC5
14:48:33 Who: Session(98, saatmgr@gustav-dat, 401514, b0310ed0)
Thread(161, sqlexec, b02ec938, 1)
File: rspartn.c Line: 2426
14:48:33 Results: Could not complete operation on
'noaa:"informix".cman_clean_specs'
14:48:33 Action: Run 'oncheck -cDI noaa:"informix".cman_clean_specs'
14:48:33 stack trace for pid 282910 written to /tmp/af.4891c40
14:48:33 See Also: /tmp/af.4891c40, shmem.4891c40.0
14:48:39 Error writing '/tmp/shmem.4891c40.0' errno = 28
14:48:39 ptmap
informix@dora $ onstat -u
IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line (CKPT REQ) --
Up 20:57:01 -- 1976112 KbytesBlocked:CKPT
Userthreads
address flags sessid user tty wait tout locks nreads
nwrites
b02e5018 ---P--D 1 informix - 0 0 0 129 620
b02e5524 ---P--F 0 informix - 0 0 0 0
332094
b02e5a30 ---P--F 0 informix - 0 0 0 0
54060
b02e5f3c ---P--F 0 informix - 0 0 0 0
40075
b02e6448 ---P--F 0 informix - 0 0 0 0
28388
b02e6954 ---P--F 0 informix - 0 0 0 0
27867
b02e6e60 ---P--F 0 informix - 0 0 0 0
15648
b02e736c ---P--F 0 informix - 0 0 0 0
27848
b02e7878 ---P--F 0 informix - 0 0 0 0
19935
b02e7d84 ---P--F 0 informix - 0 0 0 0
34797
b02e8290 ---P--F 0 informix - 0 0 0 0
32678
b02e879c ---P--F 0 informix - 0 0 0 0
17602
b02e8ca8 ---P--F 0 informix - 0 0 0 0
38163
b02e91b4 ---P--F 0 informix - 0 0 0 0
36215
b02e96c0 ---P--F 0 informix - 0 0 0 0
27917
b02e9bcc ---P--F 0 informix - 0 0 0 0
29085
b02ea0d8 ---P--F 0 informix - 0 0 0 0
32569
b02ea5e4 ---P--- 12 informix - 0 0 0 0
170316
b02eaaf0 ---P--B 13 informix - 0 0 0 66478 176
b02eb508 Y--P--D 19 informix - 40089b44 0 0 0 0
b02eba14 ---P--D 16 informix - 0 0 0 0 0
b02ec938 ---PX-- 98 saatmgr 0 0 0 2 6464
35114
22 active, 128 total, 0 maximum concurrent
informix@dora $ onstat -g ses
IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line (CKPT REQ) --
Up 20:59:38 -- 1976112 KbytesBlocked:CKPT
session #RSAM total used
dynamic
id user tty pid hostname threads memory memory
explain
104 informix - 0 - 0 12288 8168
off
99 informix - 0 - 0 12288 8168
off
98 saatmgr 0 401514 gustav-d 1 122880 96440
off
11 informix - 0 - 0 12288 8168
off
10 informix - 0 - 0 12288 9392
off
9 informix - 0 - 0 12288 8168
off
6 informix - 0 - 0 12288 9392
off
5 informix - 0 - 0 12288 9392
off
4 informix - 0 - 0 12288 8744
off
3 informix - 0 - 0 12288 8168
off
2 informix - 0 - 0 12288 8168
off
informix@dora $ onstat -g seg
IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line (CKPT REQ) --
Up 20:57:38 -- 1976112 KbytesBlocked:CKPT
Segment Summary:
id key addr size ovhd class blkused blkfree
5 1382041603 30000000 540672 672 M 132 0
1048577 1382041601 40000000 1708425216 269028 R* 417091 5
4 1382041602 b0000000 314572800 10248 V 9937 66863
Total: - - 2023538688 - - 427160 66868
(* segment locked in memory)
informix@dora $ onstat -g stm
IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line (CKPT REQ) --
Up 20:58:02 -- 1976112 KbytesBlocked:CKPT
session 98 ---------------------------------------------------------------
sdblock heapsz statement ('*' = Open cursor)
b15ba018 7280 SELECT * FROM cman_clean_specs
b15ba14c 5120 select * from cman_clean_specs
b15ba280 6352 *INSERT INTO cman_clean_specs values(?,?,?)
informix@dora $ onstat -g ath
IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line (CKPT REQ) --
Up 20:58:19 -- 1976112 KbytesBlocked:CKPT
Threads:
tid tcb rstcb prty status vp-class name
2 b083ceb8 0 2 sleeping forever 9lio lio vp 0
3 b086e968 0 2 sleeping forever 10pio pio vp 0
4 b088c968 0 2 sleeping forever 11aio aio vp 0
5 b08aa968 0 2 sleeping forever 12msc msc vp 0
6 b08e0968 0 2 sleeping forever 13aio aio vp 1
7 b08feb70 b02e5018 2 sleeping secs: 1 7cpu
main_loop()
8 b088ccc0 0 2 running 14soc
soctcppoll
9 b08aaab0 0 2 running 15soc
soctcppoll
10 b08aac50 0 2 sleeping forever 1cpu sm_poll
11 b0846ec8 0 3 ready 1cpu
soctcplst
12 b097e380 0 3 sleeping forever 1cpu
sm_listen
13 b0997d00 0 2 sleeping secs: 1 5cpu
sm_discon
14 b09a85d0 0 3 sleeping forever 4cpu
soctcplst
15 b09a8a10 b02e5524 2 sleeping secs: 1 8cpu
flush_sub(0)
16 b09a8b98 b02e5a30 2 sleeping secs: 1 8cpu
flush_sub(1)
17 b09a8d20 b02e5f3c 2 sleeping secs: 1 8cpu
flush_sub(2)
18 b09a8ea8 b02e6448 2 sleeping secs: 1 5cpu
flush_sub(3)
19 b09f6058 b02e6954 2 sleeping secs: 1 8cpu
flush_sub(4)
20 b09f61e0 b02e6e60 2 sleeping secs: 1 5cpu
flush_sub(5)
21 b09f6368 b02e736c 2 sleeping secs: 1 8cpu
flush_sub(6)
22 b09f64f0 b02e7878 2 sleeping secs: 1 8cpu
flush_sub(7)
23 b09f6678 b02e7d84 2 sleeping secs: 1 8cpu
flush_sub(8)
24 b09f6800 b02e8290 2 sleeping secs: 1 8cpu
flush_sub(9)
25 b09f6988 b02e879c 2 sleeping secs: 1 8cpu
flush_sub(10)
26 b09f6b10 b02e8ca8 2 sleeping secs: 1 5cpu
flush_sub(11)
27 b09f6c98 b02e91b4 2 sleeping secs: 1 5cpu
flush_sub(12)
28 b09f6e20 b02e96c0 2 sleeping secs: 1 5cpu
flush_sub(13)
29 b0ade018 b02e9bcc 2 sleeping secs: 1 5cpu
flush_sub(14)
30 b0ade1a0 b02ea0d8 2 sleeping secs: 1 8cpu
flush_sub(15)
31 b0ade3f8 0 4 sleeping forever 1cpu kaio
32 b0c57dd8 b02ea5e4 3 sleeping secs: 1 8cpu
aslogflush
33 b0cf23e0 b02eaaf0 2 sleeping secs: 126 6cpu
btscanner_0
35 b0cf2bc0 0 4 sleeping forever 4cpu kaio
50 b136a1a0 0 4 sleeping forever 5cpu kaio
51 b136a328 b02eba14 4 ready 1cpu
onmode_mon
54 b136a4b0 b02eb508 2 cond wait bp_cond 5cpu
bf_priosweep()
57 b136a638 0 4 sleeping forever 7cpu kaio
58 b136a018 0 2 sleeping forever 16lio lio vp 1
59 b0d15968 0 2 sleeping forever 17pio pio vp 1
64 b1314338 0 4 sleeping forever 8cpu kaio
70 b0e76780 0 4 sleeping forever 6cpu kaio
161 b0fc3748 b02ec938 2 running 1cpu sqlexec
informix@dora $ onstat -g glo
IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line (CKPT REQ) --
Up 20:58:34 -- 1976112 KbytesBlocked:CKPT
MT global info:
sessions threads vps lngspins
1 42 17 0
sched calls thread switche
FRANK said: > > (CKPT REQ) -- There might be a clue right there. -- Bye now, Obnoxio "... no bill is required as no value was provided." -- Christine Normile -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.
Hi,
Goods news. After we saw our LOG backup process was still running, we
killed it, then IDS answered and stoped.
informix 335942 282910 0 14:48:39 - 0:00 /usr/local/bin/perl -w
/dbbackup/logbackup/EventAlarm.pl 5 6 Internal Subsystem failure: 'MT' ptmap
informix 348248 192724 0 15:29:30 - 0:00 /usr/local/bin/perl -w
/dbbackup/logbackup/EventAlarm.pl 4 1 Table failure: 'noaa:
informix.cman_clean_specs'. ptmap /tmp/af.4891c40
see follwoing online log. But what is the reason caused this?
Thanks,
Frank
4:30:12 Maximum server connections 4
14:35:11 Fuzzy Checkpoint Completed: duration was 0 seconds, 30 buffers
not flushed.
14:35:11 Checkpoint loguniq 195, logpos 0x2c16220, timestamp: 0x2dfceaad
14:35:11 Maximum server connections 4
14:48:33 Assert Failed: ptmap
14:48:33 IBM Informix Dynamic Server Version 10.00.UC5
14:48:33 Who: Session(98, saatmgr@gustav-dat, 401514, b0310ed0)
Thread(161, sqlexec, b02ec938, 1)
File: rspartn.c Line: 2426
14:48:33 Results: Could not complete operation on
'noaa:"informix".cman_clean_specs'
14:48:33 Action: Run 'oncheck -cDI noaa:"informix".cman_clean_specs'
14:48:33 stack trace for pid 282910 written to /tmp/af.4891c40
14:48:33 See Also: /tmp/af.4891c40, shmem.4891c40.0
14:48:39 Error writing '/tmp/shmem.4891c40.0' errno = 28
14:48:39 ptmap
15:29:30 invoke_alarm(): /bin/sh -c '/dbbackup/logbackup/EventAlarm.pl 5 6
"Internal Subsystem failure: 'MT'" "ptmap" '
15:29:30 invoke_alarm(): mt_exec failed, status 589833, errno 0
15:29:31 Fuzzy Checkpoint Completed: duration was 2359 seconds, 62 buffers
not flushed.
15:29:31 Checkpoint loguniq 195, logpos 0x2c3e8c4, timestamp: 0x2dfcec8e
15:29:31 Maximum server connections 4
15:29:32 listener-thread: err = -25587: oserr = 0: errstr = : Network
receive failed.
15:29:32 listener-thread: err = -25587: oserr = 0: errstr = : Network
receive failed.
15:30:01 Checkpoint Completed: duration was 0 seconds.
15:30:01 Checkpoint loguniq 195, logpos 0x2c40018, timestamp: 0x2dfceca1
15:30:01 Maximum server connections 4
15:30:02 IBM Informix Dynamic Server Stopped.
On 10/27/06, FRANK <yunyaoqu@gmail.com> wrote:
>
>
> HI,All
>
> Our IDS hangs again for some reason. Basically, it can answer onstat
> commands, but NOT onmode, i.e., onmode -c, onmode -ky,..
>
> The following is some info, hope can give some tips,
>
> Thanks,
> Frank
>
> informix@dora $ onstat -m
>
> IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line (CKPT REQ) --
> Up 20:53:39 -- 1976112 Kbytes> Blocked:CKPT
>
> Message Log File: /dbbackup/online_log/online_int2.log
> 14:25:11 Maximum server connections 4
> 14:30:12 Fuzzy Checkpoint Completed: duration was 0 seconds, 33 buffers
> not flushed.
> 14:30:12 Checkpoint loguniq 195, logpos 0x2c13250, timestamp: 0x2dfce9ca
>
> 14:30:12 Maximum server connections 4
> 14:35:11 Fuzzy Checkpoint Completed: duration was 0 seconds, 30 buffers
> not flushed.
> 14:35:11 Checkpoint loguniq 195, logpos 0x2c16220, timestamp: 0x2dfceaad
>
> 14:35:11 Maximum server connections 4
> 14:48:33 Assert Failed: ptmap
> 14:48:33 IBM Informix Dynamic Server Version 10.00.UC5
> 14:48:33 Who: Session(98, saatmgr@gustav-dat, 401514, b0310ed0)
>
> Thread(161, sqlexec, b02ec938, 1)
>
> File: rspartn.c Line: 2426
> 14:48:33 Results: Could not complete operation on
> 'noaa:"informix".cman_clean_specs'
> 14:48:33 Action: Run 'oncheck -cDI noaa:"informix".cman_clean_specs'
> 14:48:33 stack trace for pid 282910 written to /tmp/af.4891c40
> 14:48:33 See Also: /tmp/af.4891c40, shmem.4891c40.0
> 14:48:39 Error writing '/tmp/shmem.4891c40.0' errno = 28
> 14:48:39 ptmap
>
> informix@dora $ onstat -u
>
> IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line (CKPT REQ) --
> Up 20:57:01 -- 1976112 Kbytes> Blocked:CKPT
>
> Userthreads
> address flags sessid user tty wait tout locks nreads
> nwrites
> b02e5018 ---P--D 1 informix - 0 0 0 129 620
> b02e5524 ---P--F 0 informix - 0 0 0 0
> 332094
> b02e5a30 ---P--F 0 informix - 0 0 0 0
> 54060
> b02e5f3c ---P--F 0 informix - 0 0 0 0
> 40075
> b02e6448 ---P--F 0 informix - 0 0 0 0
> 28388
> b02e6954 ---P--F 0 informix - 0 0 0 0
> 27867
> b02e6e60 ---P--F 0 informix - 0 0 0 0
> 15648
> b02e736c ---P--F 0 informix - 0 0 0 0
> 27848
> b02e7878 ---P--F 0 informix - 0 0 0 0
> 19935
> b02e7d84 ---P--F 0 informix - 0 0 0 0
> 34797
> b02e8290 ---P--F 0 informix - 0 0 0 0
> 32678
> b02e879c ---P--F 0 informix - 0 0 0 0
> 17602
> b02e8ca8 ---P--F 0 informix - 0 0 0 0
> 38163
> b02e91b4 ---P--F 0 informix - 0 0 0 0
> 36215
> b02e96c0 ---P--F 0 informix - 0 0 0 0
> 27917
> b02e9bcc ---P--F 0 informix - 0 0 0 0
> 29085
> b02ea0d8 ---P--F 0 informix - 0 0 0 0
> 32569
> b02ea5e4 ---P--- 12 informix - 0 0 0 0
> 170316
> b02eaaf0 ---P--B 13 informix - 0 0 0 66478 176
> b02eb508 Y--P--D 19 informix - 40089b44 0 0 0 0
> b02eba14 ---P--D 16 informix - 0 0 0 0 0
> b02ec938 ---PX-- 98 saatmgr 0 0 0 2 6464
> 35114
> 22 active, 128 total, 0 maximum concurrent
>
> informix@dora $ onstat -g ses
>
> IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line (CKPT REQ) --
> Up 20:59:38 -- 1976112 Kbytes> Blocked:CKPT
>
> session #RSAM total used
> dynamic
> id user tty pid hostname threads memory memory
> explain
> 104 informix - 0 - 0 12288 8168
> off
> 99 informix - 0 - 0 12288 8168
> off
> 98 saatmgr 0 401514 gustav-d 1 122880 96440
> off
> 11 informix - 0 - 0 12288 8168
> off
> 10 informix - 0 - 0 12288 9392
> off
> 9 informix - 0 - 0 12288 8168
> off
> 6 informix - 0 - 0 12288 9392
> off
> 5 informix - 0 - 0 12288 9392
> off
> 4 informix - 0 - 0 12288 8744
> off
> 3 informix - 0 - 0 12288 8168
> off
> 2 informix - 0 - 0 12288 8168
> off
>
> informix@dora $ onstat -g seg
>
> IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line (CKPT REQ) --
> Up 20:57:38 -- 1976112 Kbytes> Blocked:CKPT
>
> Segment Summary:
> id key addr size ovhd class blkused blkfree
> 5 1382041603 30000000 540672 672 M 132 0
> 1048577 1382041601 40000000 1708425216 269028 R* 417091 5
> 4 1382041602 b0000000 314572800 10248 V 9937 66863
> Total: - - 2023538688 - - 427160 66868
>
> (* segment locked in memory)
>
> informix@dora $ onstat -g stm
>
> IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line (CKPT REQ) --
> Up 20:58:02 -- 1976112 Kbytes> Blocked:CKPT
>
> session 98 ---------------------------------------------------------------
> sdblock heapsz statement ('*' = Open cursor)
> b15ba018 7280 SELECT * FROM cman_clean_specs
> b15ba14c 5120 select * from cman_clean_specs
> b15ba280 6352 *INSERT INTO cman_clean_specs values(?,?,?)
>
> informix@dora $ onstat -g ath
>
> IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line (CKPT REQ) --
> Up 20:58:19 -- 1976112 Kbytes> Blocked:CKPT
>
> Threads:
> tid tcb rstcb prty status vp-class name
> 2 b083ceb8 0 2 slee
Seems Informix detected a problem during Checkpoint and is stuck.
Do what IDS tells you to do:
oncheck -cDI noaa:"informix".cman_clean_specs
If this does not help or is not able to work, contact support and send
/tmp/af.4891c40 together with your report.
Maybe the database is not lost, and you should try to kill the engine and
restart (hope you have a valid backup).
If it restarts to online, execute the oncheck command, which will detect
maybe a wrong page in an index or a table.
Marcus
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of FRANK
Sent: Friday, October 27, 2006 5:21 PM
To: ids@iiug.org
Subject: onmode -ky kangs again [7682]
HI,All
Our IDS hangs again for some reason. Basically, it can answer onstat
commands, but NOT onmode, i.e., onmode -c, onmode -ky,..
The following is some info, hope can give some tips,
Thanks,
Frank
informix@dora $ onstat -m
IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line (CKPT REQ) -- Up
20:53:39 -- 1976112 Kbytes Blocked:CKPT
Message Log File: /dbbackup/online_log/online_int2.log14:25:11 Maximum server connections 4
14:30:12 Fuzzy Checkpoint Completed: duration was 0 seconds, 33 buffers not
flushed.
14:30:12 Checkpoint loguniq 195, logpos 0x2c13250, timestamp: 0x2dfce9ca
14:30:12 Maximum server connections 4
14:35:11 Fuzzy Checkpoint Completed: duration was 0 seconds, 30 buffers not
flushed.
14:35:11 Checkpoint loguniq 195, logpos 0x2c16220, timestamp: 0x2dfceaad
14:35:11 Maximum server connections 4
14:48:33 Assert Failed: ptmap
14:48:33 IBM Informix Dynamic Server Version 10.00.UC5
14:48:33 Who: Session(98, saatmgr@gustav-dat, 401514, b0310ed0)
Thread(161, sqlexec, b02ec938, 1)
File: rspartn.c Line: 2426
14:48:33 Results: Could not complete operation on
'noaa:"informix".cman_clean_specs'
14:48:33 Action: Run 'oncheck -cDI noaa:"informix".cman_clean_specs'
14:48:33 stack trace for pid 282910 written to /tmp/af.4891c40
14:48:33 See Also: /tmp/af.4891c40, shmem.4891c40.0
14:48:39 Error writing '/tmp/shmem.4891c40.0' errno = 28
14:48:39 ptmap
informix@dora $ onstat -u
IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line (CKPT REQ) -- Up
20:57:01 -- 1976112 Kbytes Blocked:CKPT
Userthreads
address flags sessid user tty wait tout locks nreads nwrites
b02e5018 ---P--D 1 informix - 0 0 0 129 620
b02e5524 ---P--F 0 informix - 0 0 0 0
332094
b02e5a30 ---P--F 0 informix - 0 0 0 0
54060
b02e5f3c ---P--F 0 informix - 0 0 0 0
40075
b02e6448 ---P--F 0 informix - 0 0 0 0
28388
b02e6954 ---P--F 0 informix - 0 0 0 0
27867
b02e6e60 ---P--F 0 informix - 0 0 0 0
15648
b02e736c ---P--F 0 informix - 0 0 0 0
27848
b02e7878 ---P--F 0 informix - 0 0 0 0
19935
b02e7d84 ---P--F 0 informix - 0 0 0 0
34797
b02e8290 ---P--F 0 informix - 0 0 0 0
32678
b02e879c ---P--F 0 informix - 0 0 0 0
17602
b02e8ca8 ---P--F 0 informix - 0 0 0 0
38163
b02e91b4 ---P--F 0 informix - 0 0 0 0
36215
b02e96c0 ---P--F 0 informix - 0 0 0 0
27917
b02e9bcc ---P--F 0 informix - 0 0 0 0
29085
b02ea0d8 ---P--F 0 informix - 0 0 0 0
32569
b02ea5e4 ---P--- 12 informix - 0 0 0 0
170316
b02eaaf0 ---P--B 13 informix - 0 0 0 66478 176
b02eb508 Y--P--D 19 informix - 40089b44 0 0 0 0
b02eba14 ---P--D 16 informix - 0 0 0 0 0
b02ec938 ---PX-- 98 saatmgr 0 0 0 2 6464
35114
22 active, 128 total, 0 maximum concurrent
informix@dora $ onstat -g ses
IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line (CKPT REQ) -- Up
20:59:38 -- 1976112 Kbytes Blocked:CKPT
session #RSAM total used
dynamic
id user tty pid hostname threads memory memory explain
104 informix - 0 - 0 12288 8168
off
99 informix - 0 - 0 12288 8168
off
98 saatmgr 0 401514 gustav-d 1 122880 96440 off
11 informix - 0 - 0 12288 8168
off
10 informix - 0 - 0 12288 9392
off
9 informix - 0 - 0 12288 8168
off
6 informix - 0 - 0 12288 9392
off
5 informix - 0 - 0 12288 9392
off
4 informix - 0 - 0 12288 8744
off
3 informix - 0 - 0 12288 8168
off
2 informix - 0 - 0 12288 8168
off
informix@dora $ onstat -g seg
IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line (CKPT REQ) -- Up
20:57:38 -- 1976112 Kbytes Blocked:CKPT
Segment Summary:
id key addr size ovhd class blkused blkfree
5 1382041603 30000000 540672 672 M 132 0
1048577 1382041601 40000000 1708425216 269028 R* 417091 5
4 1382041602 b0000000 314572800 10248 V 9937 66863
Total: - - 2023538688 - - 427160 66868
(* segment locked in memory)
informix@dora $ onstat -g stm
IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line (CKPT REQ) -- Up
20:58:02 -- 1976112 Kbytes Blocked:CKPT
session 98 ---------------------------------------------------------------sdblock heapsz statement ('*' = Open cursor)
b15ba018 7280 SELECT * FROM cman_clean_specs b15ba14c 5120 select * from
cman_clean_specs b15ba280 6352 *INSERT INTO cman_clean_specs values(?,?,?)
informix@dora $ onstat -g ath
IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line (CKPT REQ) -- Up
20:58:19 -- 1976112 Kbytes Blocked:CKPT
Threads:tid tcb rstcb prty status vp-class name
2 b083ceb8 0 2 sleeping forever 9lio lio vp 0
3 b086e968 0 2 sleeping forever 10pio pio vp 0
4 b088c968 0 2 sleeping forever 11aio aio vp 0
5 b08aa968 0 2 sleeping forever 12msc msc vp 0
6 b08e0968 0 2 sleeping forever 13aio aio vp 1
7 b08feb70 b02e5018 2 sleeping secs: 1 7cpu
main_loop()
8 b088ccc0 0 2 running 14soc
soctcppoll
9 b08aaab0 0 2 running 15soc
soctcppoll
10 b08aac50 0 2 sleeping forever 1cpu sm_poll
11 b0846ec8 0 3 ready 1cpu
soctcplst
12 b097e380 0 3 sleeping forever 1cpu
sm_listen
13 b0997d00 0 2 sleeping secs: 1 5cpu
sm_discon
14 b09a85d0 0 3 sleeping forever 4cpu
soctcplst
15 b09a8a10 b02e5524 2 sleeping secs: 1 8cpu
flush_sub(0)
16 b09a8b98 b02e5a30 2 sleeping secs: 1 8cpu
flush_sub(1)
17 b09a8d20 b02e5f3c 2 sleeping secs: 1 8cpu
flush_sub(2)
18 b09a8ea8 b02e6448 2 sleeping secs: 1 5cpu
flush_sub(3)
19 b09f6058 b02e6954 2 sleeping secs: 1 8cpu
flush_sub(4)
20 b09f61e0 b02e6e60 2 sleeping secs: 1 5cpu
flush_sub(5)
21 b09f6368 b02e736c 2 sleeping secs: 1 8cpu
flush_sub(6)
22 b09f64f0 b02e7878 2 sleeping secs: 1 8cpu
flush_sub(7)
23 b09f6678 b02e7d84 2 sleeping secs: 1 8cpu
flush_sub(8)
24 b09f6800 b02e8290 2 sleeping secs: 1 8cpu
flush_sub(9)
25 b09f6988 b02e879c 2 sleeping secs: 1 8cpu
flush_sub(10)
26 b09f6b10 b02e8ca8 2 sleeping secs: 1 5cpu
flush_sub(11)
27 b09f6c98 b02e91b4 2 sleeping secs: 1 5cpu
flush_sub(12)
28 b09f6e20 b02e96c0 2 sleeping secs: 1 5cpu
flush_sub(13)
29 b0ade018 b02e9bcc 2 sleeping secs: 1 5cpu
flush_sub(14)
30 b0ade1a0 b02ea0d8 2 sleeping secs: 1 8cpu
flush_sub(15)
31 b0ade3f8 0 4 sleeping forever 1cpu kaio
32 b0c57dd8 b02ea5e4 3 sleeping secs: 1 8cpu aslogflush
33 b0cf23e0 b02eaaf0 2 sleeping secs: 126 6cpu btscanner_0
35 b0cf2bc0 0 4 sleeping forever 4cpu kaio 50 b136a1a0 0