Informix has been hanging since Day 1 on this server -- before I got
here. We're running IDS 7.23.UC1 on Solaris 2.5.1/x86. Unix server has
128 MB RAM; SA's swear it's been patched appropriately. Symptoms
include CKPT REQ status after a project developer runs one of many
esql/c programs which migrate data from legacy database to current
instance; onresponse to onmode -c or even -ky. If Informix requires a
checkpoint, why didn't it simply execute one? I've attempted to tune
it, to little avail. Appreciate some input.
TIA
Informix output (sorry for volume):
##############################################################
DATE:080499
onall output
##############################################################
Disk-related output:
##############################################################
onstat -d Print DBspaces and chunks
###############################################
INFORMIX-OnLine Version 7.23.UC1 -- On-Line (CKPT REQ) -- Up 03:23:45
-- 101544 Kbytes
Blocked:CKPT
Dbspaces
address number flags fchunk nchunks flags owner name
5603c0ec 1 1 1 1 N informix rootdbs
5603c998 2 1 2 2 N informix pactsdbs
5603ca04 3 1 4 1 N informix pactsidbs
5603ca70 4 1 5 1 N informix
tomdbspace1
5603cadc 5 2001 6 1 N T informix
tmpdbspace1
5603cb48 6 2001 7 1 N T informix
tmpdbspace2
5603cbb4 7 1 8 1 N informix
pactslogdbs
7 active, 2047 maximum
Chunks
address chk/dbs offset size free bpages flags pathname
No response from server process.
No response from server process.
Warning: blob chunk page usage statistics may be inaccurate.
5603c158 1 1 0 100000 91747 PO-
/usr3/informix/rootchunk01
5603c3cc 2 2 0 250000 25482 PO-
/usr5/informix/pacts_dchunk01
5603c4a0 3 2 0 150000 97101 PO-
/usr5/informix/pacts_dchunk02
5603c574 4 3 0 100000 19424 PO-
/usr8/informix/pacts_ichunk01
5603c648 5 4 0 25000 13331 PO-
/usr8/informix/tomdbspace1
5603c71c 6 5 0 50000 49947 PO-
/usr8/informix/pacts_tmpchk1
5603c7f0 7 6 0 25000 24947 PO-
/usr5/informix/pacts_tmpchk2
5603c8c4 8 7 0 35000 27947 PO-
/usr8/informix/logchk1
8 active, 2047 maximum
##############################################################
onstat -D Print DBspaces and detailed chunk stats
###############################################
INFORMIX-OnLine Version 7.23.UC1 -- On-Line (CKPT REQ) -- Up 03:23:56
-- 101544 Kbytes
Blocked:CKPT
Dbspaces
address number flags fchunk nchunks flags owner name
5603c0ec 1 1 1 1 N informix rootdbs
5603c998 2 1 2 2 N informix pactsdbs
5603ca04 3 1 4 1 N informix pactsidbs
5603ca70 4 1 5 1 N informix
tomdbspace1
5603cadc 5 2001 6 1 N T informix
tmpdbspace1
5603cb48 6 2001 7 1 N T informix
tmpdbspace2
5603cbb4 7 1 8 1 N informix
pactslogdbs
7 active, 2047 maximum
Chunks
address chk/dbs offset page Rd page Wr pathname
No response from server process.
No response from server process.
Warning: blob chunk page usage statistics may be inaccurate.
5603c158 1 1 0 1093 237 /usr3/informix/rootchunk01
5603c3cc 2 2 0 11535 10649
/usr5/informix/pacts_dchunk01
5603c4a0 3 2 0 567 486
/usr5/informix/pacts_dchunk02
5603c574 4 3 0 3404 2779
/usr8/informix/pacts_ichunk01
5603c648 5 4 0 3 0 /usr8/informix/tomdbspace1
5603c71c 6 5 0 824 836 /usr8/informix/pacts_tmpchk1
5603c7f0 7 6 0 861 871 /usr5/informix/pacts_tmpchk2
5603c8c4 8 7 0 39 15661 /usr8/informix/logchk1
8 active, 2047 maximum
##############################################################
##############################################################
User/thread-related output:
##############################################################
onstat -u Print user threads
###############################################
INFORMIX-OnLine Version 7.23.UC1 -- On-Line (CKPT REQ) -- Up 03:24:07
-- 101544 Kbytes
Blocked:CKPT
Userthreads
address flags sessid user tty wait tout locks nreads
nwrites
5603e014 ---P--D 1 informix - 0 0 0 32
2098
5603e454 ---P--F 0 informix - 0 0 0 0
1789
5603e894 ---P--F 0 informix - 0 0 0 0
3971
5603ecd4 ---P--F 0 informix - 0 0 0 0
1756
5603f114 ---P--F 0 informix - 0 0 0 0
1534
5603f554 ---P--F 0 informix - 0 0 0 0
1404
5603f994 ---P--F 0 informix - 0 0 0 0
556
5603fdd4 ---P--F 0 informix - 0 0 0 0
1586
56040214 ---P--F 0 informix - 0 0 0 0
2399
56040654 ---P--B 9 informix - 0 0 0 0
0
56040a94 C--P--- 104 rnj 9 500127dc 0 3 178
228
56040ed4 Y--P--- 118 mac - 561f11ec 0 1 0
0
56041314 ---P--D 12 informix - 0 0 0 0
0
56041754 C--P--- 108 pactsadm - 500127dc 0 0 57
0
56041b94 C--P--- 120 thomas - 500127dc 0 1 0
0
56041fd4 Y--P--- 111 pactsadm - 56164910 0 1 2
0
56042414 C--P--- 112 pactsadm - 500127dc 0 0 44
0
56042854 C--P--- 113 pactsadm - 500127dc 0 0 0
0
56042c94 C--P--- 126 thomas - 500127dc 0 1 0
0
19 active, 128 total, 24 maximum concurrent
##############################################################
onstat -k Print locks
###############################################
INFORMIX-OnLine Version 7.23.UC1 -- On-Line (CKPT REQ) -- Up 03:24:07
-- 101544 Kbytes
Blocked:CKPT
Locks
address wtlist owner lklist type tblsnum rowid key#/bsiz
5008bde4 0 56040a94 0 HDR+S 100002 208 0
5008be44 0 56042c94 0 S 100002 203 0
5008be74 0 56041b94 0 HDR+S 100002 203 0
5008bea4 0 56042854 0 S 100002 204 0
5008bf04 0 56040ed4 0 HDR+S 100002 204 0
5008bf94 0 56041754 0 S 100002 204 0
5008c054 0 56041fd4 0 S 100002 204 0
5008c114 0 56040a94 5008c2f4 HDR+X 200913 bc01 0
5008c2f4 0 56040a94 5008bde4 HDR+IX 200913 0 0
5008c4a4 0 56042414 0 S 100002 204 0
10 active, 8000 total, 8192 hash buckets
##############################################################
onstat -g act Print active threads
###############################################
INFORMIX-OnLine Version 7.23.UC1 -- On-Line (CKPT REQ) -- Up 03:24:08
-- 101544 Kbytes
Blocked:CKPT
Running threads:
tid tcb rstcb prty status vp-class name
18 561c89ec 0 2 running 1cpu tlitcppoll
19 561c8e40 0 2 running 18shm sm_poll
##############################################################
onstat -g ath Print all threads
###############################################
INFORMIX-OnLine Version 7.23.UC1 -- On-Line (CKPT REQ) -- Up 03:24:08
-- 101544 Kbytes
Blocked:CKPT
Threads:
tid tcb rstcb prty status vp-class name
2 560ac218 0 2 sleeping(Forever) 3lio lio vp 0
3 560ac49c 0 2 sleeping(Forever) 4pio pio vp 0
4 560ac720 0 2 sleeping(Forever) 5aio aio vp 0
5 560ac9c4 0 2 sleeping(Forever) 6msc msc vp 0
6 560ad128 0 2 sleeping(Forever) 7aio aio vp 1
7 560ad418 0 2 sleeping(Forever) 8aio aio vp 2
8 560ad624 0 2 sleeping(Forever) 9aio aio vp 3
9 560ad914 0 2 sleeping(Forever) 10aio aio vp 4
10 560adb20 0 2 sleeping(Forever) 11aio aio vp 5
11 560ade10 0 2 sleeping(Forever) 12aio aio vp 6
12 560c0274 0 2 sleeping(Forever) 13aio aio vp 7
13 560c0528 0 2 sleeping(Forever) 14aio aio vp 8
14 560c0734 0 2 sleeping(Forever) 15aio aio vp 9
15 560c0940 0 2 sleeping(Forever) 16aio aio vp 10
16 560c0b4c 0 2 sleeping(Forever) 17aio aio vp 11
17 561c830c 5603e014 4 ready 1cpu main_loop()
18 561c89ec 0 2 running 1cpu tlitcppoll
19 561c8e40 0 2 running 18shm sm_poll
20 561dc60c 0 3 sleeping(Forever) 1cpu tlitcplst
21 561f0554 0 2 sleeping(Forever) 1cpu sm_listen
22 560e85ec 0 2 sleeping(secs: 1) 1cpu sm_discon
23 560e8870 5603e454 2 sleeping(Forever) 1cpu flush_sub(0)
24 560e8acc 5603e894 2 sleeping(Forever) 1cpu flush_sub(1)
25 560e8d28 5603ecd4 2 sleeping(Forever) 1cpu flush_sub(2)
26 560e8f84 5603f114 2 sleeping(Forever) 1cpu flush_sub(3)
27 560e91e0 5603f554 2 sleeping(Forever) 1cpu flush_sub(4)
28 560e943c 5603f994 2 sleeping(Forever) 1cpu flush_sub(5)
29 560e9698 5603fdd4 2 sleeping(Forever) 1cpu flush_sub(6)
30 560e98f4 56040214 2 sleeping(Forever) 1cpu flush_sub(7)
31 5613c8fc 56040654 2 sleeping(secs: 38) 1cpu btclean
47 56150694 56041314 4 ready 1cpu onmode_mon
140 561b4348 56040a94 2 cond wait( cp) 1cpu sqlexec
144 5635240c 56041754 2 cond wait( cp) 1cpu sqlexec
147 56346570 56041fd4 2 cond wait(netnorm) 1cpu sqlexec
148 56128500 56042414 2 cond wait( cp) 1cpu sqlexec
149 56291404 56042854 2 cond wait( cp) 1cpu sqlexec
154 56114394 56040ed4 2 cond
...
read more »