My Informix server seemed hung there, can someone help me

[pengzhang]

Hi there,

After some load test, my Informix server seemed hung there. I checked the Informix log, didn't seem to see anything wrong; and I checked the locks and no deadlock.

The following is some output from onstat command, seemed to me that some user threads are waiting for a condition, but how can I know what's this condition.

If I restarted Informix server, it's OK again. One of the running thread is doing some update statistic SQL statement. Not sure if it's caused this problem

I'm not sure if it's caused by the following reasons:
1) Deadlock, but seemed to me no deadlock there
2) Log is full, I set the log back to NUL. And seemed to me that if log is full, restart Informix would not help.
3) Buffer is full. How can I know if buffer is full? I tried onstat -r, it's using roughly 168 MB, and I've set the shared memory with no limit.
4) Maximum connection is reached. How can I check this?

Can someone help me what's wrong going there?

Your help would be greatly appreciated.

Thanks

pengzhang


d:\onstat -u

Informix Dynamic Server 2000 Version 9.21.TC5 -- On-Line -- Up 1 days 23:12:36 -- 165952 Kbytes

Userthreads
address flags sessid user tty wait tout locks nreads nwrites
1131e018 ---P--D 1 informix - 0 0 0 69 3984
1131e604 ---P--F 0 informix - 0 0 0 0 3792
1131ebf0 ---P--F 0 informix - 0 0 0 0 1570
1131f1dc ---P--F 0 informix - 0 0 0 0 1128
1131f7c8 ---P--- 6 informix - 0 0 0 0 171
1131fdb4 ---P--B 7 informix - 0 0 0 0 0
113203a0 Y--P--- 14 informix AZKABAN 114467f0 0 1 42 0
1132098c ---P--D 11 informix - 0 0 0 0 0
11320f78 Y--P--- 15 informix AZKABAN 11846b88 0 1 42 0
11321564 Y--P--- 16 informix AZKABAN 117d1b50 0 1 47 0
11321b50 Y--P--- 17 informix AZKABAN 1176acc0 0 1 44 0
1132213c Y--P--- 18 informix AZKABAN 117a3e20 0 1 44 0
11322728 Y--P--- 19 informix AZKABAN 118140f0 0 1 0 0
11322d14 Y--P--- 20 informix AZKABAN 11814d70 0 1 0 0
11323300 Y--P--- 21 informix AZKABAN 118539f0 0 1 326 14
113238ec Y--P--- 22 informix AZKABAN 11892670 0 1 0 0
11323ed8 Y--P--- 23 informix AZKABAN 119002e8 0 1 0 0
113244c4 Y--P--- 24 informix AZKABAN 11900f60 0 1 0 0
11324ab0 Y--P--- 25 informix AZKABAN 11936bd8 0 1 0 0
1132509c Y--P--- 26 informix AZKABAN 1197a860 0 1 0 0
11325688 Y--P--- 27 informix AZKABAN 119c7510 0 1 0 0
11325c74 Y--P--- 28 informix AZKABAN 119c7fd0 0 1 0 0
11326260 Y--P--- 29 informix AZKABAN 119f9dd8 0 1 0 0
1132684c Y--P--- 30 informix AZKABAN 11a39a68 0 1 0 0
11326e38 Y--P--- 31 informix AZKABAN 11a7a7f8 0 1 0 0
11327424 Y--P--- 32 informix AZKABAN 11ac0380 0 1 0 0
11327a10 Y--P--- 33 informix AZKABAN 11ac0fd0 0 1 0 0
11327ffc Y--P--- 34 informix AZKABAN 11af6c48 0 1 0 0
113285e8 Y--P--- 35 informix AZKABAN 11b3a8d8 0 1 0 0
11328bd4 Y--P--- 36 informix AZKABAN 11b84560 0 1 0 0
113291c0 Y--P--- 37 informix AZKABAN 11bb91f0 0 1 0 0
113297ac Y--P--- 38 informix AZKABAN 11bb9e68 0 1 0 0
11329d98 Y--P--- 39 informix AZKABAN 11bf5ae0 0 1 0 0
1132a384 Y--P--- 40 informix AZKABAN 11c3b7f8 0 1 0 0
1132a970 Y--P--- 41 informix AZKABAN 11c823d0 0 1 0 0
1132af5c Y--P--- 42 informix AZKABAN 11cb5068 0 1 0 0
1132b548 Y--P--- 43 informix AZKABAN 11cb5cc0 0 1 0 0
1132bb34 Y--P--- 44 informix AZKABAN 11cf8950 0 1 0 0
1132c120 Y--P--- 45 informix AZKABAN 11d44600 0 1 0 0
1132c70c Y--P--- 46 informix AZKABAN 11d78290 0 1 0 0
1132ccf8 Y--P--- 47 informix AZKABAN 11d78ee0 0 1 0 0
1132d2e4 Y--P--- 48 informix AZKABAN 11dafb58 0 1 0 0
1132d8d0 Y--P--- 49 informix AZKABAN 11df67d0 0 1 0 0
1132debc Y--P--- 50 informix AZKABAN 11e3b470 0 1 0 0
1132e4a8 Y--P--- 51 informix AZKABAN 11e3bfd0 0 1 0 0
1132ea94 Y--P--- 52 informix AZKABAN 11e6cd38 0 1 0 0
1132f080 Y--P--- 53 informix AZKABAN 11ead9c8 0 1 0 0
1132f66c Y--P--- 54 informix AZKABAN 11efb648 0 1 0 0
1132fc58 Y--P--- 55 informix AZKABAN 11f2f2e0 0 1 0 0
11330244 Y--P--- 56 informix AZKABAN 11f2ff38 0 1 0 0
11330830 Y--P--- 57 informix AZKABAN 11f64bb0 0 1 0 0
11330e1c Y--P--- 58 informix AZKABAN 11fa5840 0 1 0 0
11331408 Y--P--- 59 informix AZKABAN 11ff24c0 0 1 0 0
113319f4 Y--P--- 60 informix AZKABAN 12023158 0 1 0 0
11331fe0 Y--P--- 61 informix AZKABAN 12023db0 0 1 0 0
113325cc Y--P--- 62 informix AZKABAN 12060a40 0 1 0 0
11332bb8 Y--P--- 63 informix AZKABAN 120a16c0 0 1 0 0
113331a4 Y--P--- 64 informix AZKABAN 120e6338 0 1 0 0
11333790 Y--P--- 65 informix AZKABAN 120e6fb0 0 1 0 0
11333d7c Y--P--- 66 informix AZKABAN 1211bc28 0 1 0 0
11334368 Y--P--- 67 informix AZKABAN 1215c8b0 0 1 0 0
11334954 Y--P--- 68 informix AZKABAN 121a6560 0 1 0 0
11334f40 Y--P--- 69 informix AZKABAN 121da1f0 0 1 0 0
1133552c Y--P--- 70 informix AZKABAN 121dae40 0 1 0 0
11335b18 Y--P--- 71 informix AZKABAN 12215ab8 0 1 0 0
11336104 Y--P--- 72 informix AZKABAN 122587f8 0 1 0 0
113366f0 Y--P--- 73 informix AZKABAN 1229d3d0 0 1 0 0
11336cdc Y--P--- 74 informix AZKABAN 1229dfd0 0 1 0 0
113372c8 Y--P--- 75 informix AZKABAN 122cec98 0 1 0 0
113378b4 Y--P--- 76 informix AZKABAN 12313928 0 1 0 0
11337ea0 Y--P--- 77 informix AZKABAN 1235d5b0 0 1 0 0
1133848c Y--P--- 78 informix AZKABAN 12391240 0 1 0 0
11338a78 Y--P--- 79 informix AZKABAN 12391eb8 0 1 0 0
11339064 Y--P--- 80 informix AZKABAN 123c8b30 0 1 0 0
11339650 Y--P--- 81 informix AZKABAN 1240f7a8 0 1 0 0
11339c3c Y--P--- 82 informix AZKABAN 12454420 0 1 0 0
1133a228 Y--P--- 83 informix AZKABAN 124860b8 0 1 0 0
1133a814 Y--P--- 84 informix AZKABAN 12486d10 0 1 0 0
1133ae00 Y--P--- 85 informix AZKABAN 124c89a0 0 1 0 0
1133b3ec Y--P--- 86 informix AZKABAN 12516620 0 1 0 0
1133b9d8 Y--P--- 87 informix AZKABAN 1254b298 0 1 0 0
1133bfc4 Y--P--- 88 informix AZKABAN 1254bf10 0 1 0 0
1133c5b0 Y--P--- 89 informix AZKABAN 1257fb88 0 1 0 0
1133cb9c Y--P--- 90 informix AZKABAN 125bd818 0 1 0 0
1133d188 Y--P--- 91 informix AZKABAN 1260a4c0 0 1 0 0
1133d774 Y--P--- 92 informix AZKABAN 1260afd0 0 1 0 0
1133dd60 Y--P--- 93 informix AZKABAN 1263ad88 0 1 0 0
1133e34c Y--P--- 94 informix AZKABAN 12676a18 0 1 0 0
1133e938 Y--P--- 95 informix AZKABAN 126b5698 0 1 0 0
1133ef24 Y--P--- 96 informix AZKABAN 126f9330 0 1 0 0
1133f510 Y--P--- 97 informix AZKABAN 126f9f88 0 1 0 0
1133fafc Y--P--- 98 informix AZKABAN 1272dc00 0 1 0 0
113400e8 Y--P--- 99 informix AZKABAN 1276b888 0 1 0 0
113406d4 Y--P--- 100 informix AZKABAN 127b8510 0 1 0 0
11340cc0 Y--P--- 101 informix AZKABAN 127e81a8 0 1 0 0
113412ac Y--P--- 102 informix AZKABAN 127e8e00 0 1 0 0
11341898 Y--P--- 103 informix AZKABAN 12820a90 0 1 0 0
11341e84 Y--P--- 104 informix AZKABAN 128637f8 0 1 0 0
11342470 Y--P--- 105 informix AZKABAN 128a7380 0 1 0 0
11342a5c Y--P--- 106 informix AZKABAN 128db018 0 1 0 0
11343048 Y--P--- 107 informix AZKABAN 128dbc70 0 1 0 0
11343634 Y--P--- 108 informix AZKABAN 12919900 0 1 0 0
11343c20 Y--P--- 109 informix AZKABAN 129635b0 0 1 0 0
1134420c Y--P--- 110 informix AZKABAN 12996240 0 1 0 0
113447f8 Y--P--- 111 informix AZKABAN 12996e90 0 1 0 0
11344de4 Y--P--- 112 informix AZKABAN 129ccb08 0 1 0 0
113453d0 Y--P--- 113 informix AZKABAN 12a11780 0 1 0 0
113459bc Y--P--- 114 informix AZKABAN 12a55420 0 1 0 0
11345fa8 Y--P--- 115 informix AZKABAN 12a55fd0 0 1 0 0
11346594 Y--P--- 116 informix AZKABAN 12a85ce8 0 1 0 0
11346b80 Y--P--- 117 informix AZKABAN 12ac5978 0 1 0 0
1134716c Y--P--- 118 informix AZKABAN 12b11600 0 1 0 0
11347758 Y--P--- 119 informix AZKABAN 12b44290 0 1 0 0
11347d44 Y--P--- 120 informix AZKABAN 12b44f08 0 1 0 0
11348330 Y--P--- 121 informix AZKABAN 12b78b80 0 1 0 0
1134891c Y--P--- 122 informix AZKABAN 12bbf7f8 0 1 0 0
11348f08 Y--P--- 123 informix AZKABAN 12c03470 0 1 0 0
113494f4 Y--P--- 124 informix AZKABAN 12c33108 0 1 0 0
11349ae0 Y--P--- 125 informix AZKABAN 12c33d60 0 1 0 0
1134a0cc Y--P--- 126 informix AZKABAN 12c709f0 0 1 0 0
1134a6b8 Y--P--- 127 informix AZKABAN 12cb1670 0 1 0 0
1134aca4 Y--P--- 128 informix AZKABAN 12cf62e8 0 1 0 0
1134b290 Y--P--- 129 informix AZKABAN 12cf6f60 0 1 0 0
1134b87c Y--P--- 130 informix AZKABAN 12d2bbd8 0 1 0 0
1134be68 Y--P--- 131 informix AZKABAN 12d68860 0 1 0 0
1134c454 Y--P--- 132 informix AZKABAN 12db5510 0 1 0 0
1134ca40 Y--P--- 133 informix AZKABAN 12db5fd0 0 1 0 0
1134d02c Y--P--- 134 informix AZKABAN 12de4dd8 0 1 0 0
12e5a018 Y--P--- 135 informix AZKABAN 12e1ba68 0 1 0 0
12e5a604 Y--P--- 136 informix AZKABAN 12e9bb78 0 1 0 0
12e5abf0 Y--P--- 137 informix AZKABAN 12ecc7d0 0 1 0 0
12e5b1dc Y--P--- 138 informix AZKABAN 12f0f420 0 1 0 0
12e5b7c8 Y--P--- 139 informix AZKABAN 12f3e0b8 0 1 0 0
12e5bdb4 Y--P--- 140 informix AZKABAN 12f3ed10 0 1 0 0
12e5c3a0 Y--P--- 141 informix AZKABAN 12f799a0 0 1 0 0
12e5c98c Y--P--- 142 informix AZKABAN 12fc7620 0 1 0 0
12e5cf78 Y--P--- 143 informix AZKABAN 12ff9298 0 1 0 0
12e5d564 Y--P--- 144 informix AZKABAN 12ff9f10 0 1 0 0
12e5db50 Y--P--- 145 informix AZKABAN 1302cb88 0 1 0 0
12e5e13c Y--P--- 146 informix AZKABAN 13067818 0 1 0 0
12e5e728 Y--P--- 147 informix AZKABAN 130b44c0 0 1 0 0
12e5ed14 Y--P--- 148 informix AZKABAN 130b4fd0 0 1 0 0
12e5f300 Y--P--- 150 informix AZKABAN 131ff368 0 1 94 1521
12e5f8ec Y--P--- 151 informix AZKABAN 131e57f0 0 1 99 108
12e5fed8 Y--P--- 152 informix AZKABAN 13284470 0 1 14 54
12e604c4 Y--P--- 153 informix AZKABAN 132b1108 0 1 0 0
12e60ab0 Y--P--- 154 informix AZKABAN 132b1d60 0 1 137 0
12e6109c Y--P--- 155 informix AZKABAN 132ec9f0 0 1 294 52
12e61688 Y--P--- 158 informix AZKABAN 132ecfc0 0 1 0 0
12e61c74 Y--P--- 157 informix AZKABAN 1336e2e8 0 1 0 0
12e62260 Y--P--- 161 informix AZKABAN 118bfbd0 0 1 15 9
12e6284c Y--P--- 160 informix AZKABAN 133a2c80 0 1 0 0
12e62e38 Y--P--- 162 informix AZKABAN 1332b8a8 0 1 0 0
12e63424 Y--P--- 163 informix AZKABAN 1340a7f8 0 1 0 29
12e63a10 Y--P--- 164 informix AZKABAN 13457470 0 1 0 0
12e63ffc Y--P--- 165 informix AZKABAN 13486108 0 1 0 0
12e645e8 Y--P--- 166 informix AZKABAN 13486d60 0 1 0 0
12e64bd4 Y--P--- 167 informix AZKABAN 134bf9f0 0 1 0 0
12e651c0 Y--P--- 168 informix AZKABAN 134fe670 0 1 5 1168
12e657ac Y--P--- 169 informix AZKABAN 135422e8 0 1 0 11
12e65d98 Y--P--- 170 informix AZKABAN 13542f60 0 1 5 1354
12e66384 Y--P--- 171 informix AZKABAN 13576bd8 0 1 0 4
12e66970 Y--P--- 172 informix AZKABAN 135b2860 0 1 0 0
12e66f5c Y--P--- 173 informix AZKABAN 13601510 0 1 0 0
12e67548 Y--P--- 174 informix AZKABAN 13601fd0 0 1 0 0
12e67b34 Y--P--- 175 informix AZKABAN 13631dd8 0 1 0 0
12e68120 Y--P--- 176 informix AZKABAN 13665a68 0 1 0 0
12e6870c Y--P--- 177 informix AZKABAN 136a67f8 0 1 115 341
12e68cf8 Y--P--- 178 informix AZKABAN 136e8460 0 1 21 0
12e692e4 Y--P--- 179 informix AZKABAN 13707838 0 1 60 0
12e698d0 Y--P--- 180 informix AZKABAN 1374b5e0 0 1 31 9
12e69ebc Y--P--- 181 informix AZKABAN 137cd538 0 1 0 0
12e6a4a8 Y--P--- 182 informix AZKABAN 1380a4c0 0 1 12 0
12e6aa94 Y--P--- 183 informix AZKABAN 1390a060 0 1 16 9
12e6b080 Y--P--- 184 informix AZKABAN 14056018 0 1 0 0
175 active, 256 total, 176 maximum concurrent

d:\onstat -k
Informix Dynamic Server 2000 Version 9.21.TC5 -- On-Line -- Up 1 days 23:04:21 -- 165952 Kbytes

Locks
address wtlist owner lklist type tblsnum rowid key#/bsiz
c06d61c 0 113203a0 0 HDR+S 100002 201 0
c06d670 0 11320f78 0 HDR+S 100002 205 0
c06d6c4 0 11321564 0 HDR+S 100002 204 0
c06d718 0 11321b50 0 HDR+S 100002 206 0
c06d76c 0 1132213c 0 HDR+S 100002 207 0
c06d7c0 0 11322728 0 HDR+S 100002 203 0
c06d814 0 11322d14 0 S 100002 203 0
c06d868 0 11323300 0 S 100002 203 0
c06d8bc 0 113238ec 0 S 100002 203 0
c06d910 0 11323ed8 0 S 100002 203 0
c06d964 0 113244c4 0 S 100002 203 0
c06d9b8 0 11324ab0 0 S 100002 203 0
c06da0c 0 1132509c 0 S 100002 203 0
c06da60 0 11325688 0 S 100002 203 0
c06dab4 0 11325c74 0 S 100002 203 0
c06db08 0 11326260 0 S 100002 203 0
c06db5c 0 1132684c 0 S 100002 203 0
c06dbb0 0 11326e38 0 S 100002 203 0
c06dc04 0 11327424 0 S 100002 203 0
c06dc58 0 11327a10 0 S 100002 203 0
c06dcac 0 11327ffc 0 S 100002 203 0
c06dd00 0 113285e8 0 S 100002 203 0
c06dd54 0 11328bd4 0 S 100002 203 0
c06dda8 0 113291c0 0 S 100002 203 0
c06ddfc 0 113297ac 0 S 100002 203 0
c06de50 0 11329d98 0 S 100002 203 0
c06dea4 0 1132a384 0 S 100002 203 0
c06def8 0 1132a970 0 S 100002 203 0
c06df4c 0 1132af5c 0 S 100002 203 0
c06dfa0 0 1132b548 0 S 100002 203 0
c06dff4 0 1132bb34 0 S 100002 203 0
c06e048 0 1132c120 0 S 100002 203 0
c06e09c 0 1132c70c 0 S 100002 203 0
c06e0f0 0 1132ccf8 0 S 100002 203 0
c06e144 0 1132d2e4 0 S 100002 203 0
c06e198 0 1132d8d0 0 S 100002 203 0
c06e1ec 0 1132debc 0 S 100002 203 0
c06e240 0 1132e4a8 0 S 100002 203 0
c06e294 0 1132ea94 0 S 100002 203 0
c06e2e8 0 1132f080 0 S 100002 203 0
c06e33c 0 1132f66c 0 S 100002 203 0
c06e390 0 1132fc58 0 S 100002 203 0
c06e3e4 0 11330244 0 S 100002 203 0
c06e438 0 11330830 0 S 100002 203 0
c06e48c 0 11330e1c 0 S 100002 203 0
c06e4e0 0 11331408 0 S 100002 203 0
c06e534 0 113319f4 0 S 100002 203 0
c06e588 0 11331fe0 0 S 100002 203 0
c06e5dc 0 113325cc 0 S 100002 203 0
c06e630 0 11332bb8 0 S 100002 203 0
c06e684 0 113331a4 0 S 100002 203 0
c06e6d8 0 11333790 0 S 100002 203 0
c06e72c 0 11333d7c 0 S 100002 203 0
c06e780 0 11334368 0 S 100002 203 0
c06e7d4 0 11334954 0 S 100002 203 0
c06e828 0 11334f40 0 S 100002 203 0
c06e87c 0 1133552c 0 S 100002 203 0
c06e8d0 0 11335b18 0 S 100002 203 0
c06e924 0 11336104 0 S 100002 203 0
c06e978 0 113366f0 0 S 100002 203 0
c06e9cc 0 11336cdc 0 S 100002 203 0
c06ea20 0 113372c8 0 S 100002 203 0
c06ea74 0 113378b4 0 S 100002 203 0
c06eac8 0 11337ea0 0 S 100002 203 0
c06eb1c 0 1133848c 0 S 100002 203 0
c06eb70 0 11338a78 0 S 100002 203 0
c06ebc4 0 11339064 0 S 100002 203 0
c06ec18 0 11339650 0 S 100002 203 0
c06ec6c 0 11339c3c 0 S 100002 203 0
c06ecc0 0 1133a228 0 S 100002 203 0
c06ed14 0 1133a814 0 S 100002 203 0
c06ed68 0 1133ae00 0 S 100002 203 0
c06edbc 0 1133b3ec 0 S 100002 203 0
c06ee10 0 1133b9d8 0 S 100002 203 0
c06ee64 0 1133bfc4 0 S 100002 203 0
c06eeb8 0 1133c5b0 0 S 100002 203 0
c06ef0c 0 1133cb9c 0 S 100002 203 0
c06ef60 0 1133d188 0 S 100002 203 0
c06efb4 0 1133d774 0 S 100002 203 0
c06f008 0 1133dd60 0 S 100002 203 0
c06f05c 0 1133e34c 0 S 100002 203 0
c06f0b0 0 1133e938 0 S 100002 203 0
c06f104 0 1133ef24 0 S 100002 203 0
c06f158 0 1133f510 0 S 100002 203 0
c06f1ac 0 1133fafc 0 S 100002 203 0
c06f200 0 113400e8 0 S 100002 203 0
c06f254 0 113406d4 0 S 100002 203 0
c06f2a8 0 11340cc0 0 S 100002 203 0
c06f2fc 0 113412ac 0 S 100002 203 0
c06f350 0 11341898 0 S 100002 203 0
c06f3a4 0 11341e84 0 S 100002 203 0
c06f3f8 0 11342470 0 S 100002 203 0
c06f44c 0 11342a5c 0 S 100002 203 0
c06f4a0 0 11343048 0 S 100002 203 0
c06f4f4 0 11343634 0 S 100002 203 0
c06f548 0 11343c20 0 S 100002 203 0
c06f59c 0 1134420c 0 S 100002 203 0
c06f5f0 0 113447f8 0 S 100002 203 0
c06f644 0 11344de4 0 S 100002 203 0
c06f698 0 113453d0 0 S 100002 203 0
c06f6ec 0 113459bc 0 S 100002 203 0
c06f740 0 11345fa8 0 S 100002 203 0
c06f794 0 11346594 0 S 100002 203 0
c06f7e8 0 11346b80 0 S 100002 203 0
c06f83c 0 1134716c 0 S 100002 203 0
c06f890 0 11347758 0 S 100002 203 0
c06f8e4 0 11347d44 0 S 100002 203 0
c06f938 0 11348330 0 S 100002 203 0
c06f98c 0 1134891c 0 S 100002 203 0
c06f9e0 0 11348f08 0 S 100002 203 0
c06fa34 0 113494f4 0 S 100002 203 0
c06fa88 0 11349ae0 0 S 100002 203 0
c06fadc 0 1134a0cc 0 S 100002 203 0
c06fb30 0 1134a6b8 0 S 100002 203 0
c06fb84 0 1134aca4 0 S 100002 203 0
c06fbd8 0 1134b290 0 S 100002 203 0
c06fc2c 0 1134b87c 0 S 100002 203 0
c06fc80 0 1134be68 0 S 100002 203 0
c06fcd4 0 1134c454 0 S 100002 203 0
c06fd28 0 1134ca40 0 S 100002 203 0
c06fd7c 0 1134d02c 0 S 100002 203 0
c06fdd0 0 12e5a018 0 S 100002 203 0
c06fe24 0 12e5a604 0 S 100002 203 0
c06fe78 0 12e5abf0 0 S 100002 203 0
c06fecc 0 12e5b1dc 0 S 100002 203 0
c06ff20 0 12e5b7c8 0 S 100002 203 0
c06ff74 0 12e5bdb4 0 S 100002 203 0
c06ffc8 0 12e5c3a0 0 S 100002 203 0
c07001c 0 12e5c98c 0 S 100002 203 0
c070070 0 12e5cf78 0 S 100002 203 0
c0700c4 0 12e5d564 0 S 100002 203 0
c070118 0 12e5db50 0 S 100002 203 0
c07016c 0 12e5e13c 0 S 100002 203 0
c0701c0 0 12e5e728 0 S 100002 203 0
c070214 0 12e5ed14 0 S 100002 203 0
c070268 0 12e6109c 0 S 100002 205 0
c0702bc 0 12e61c74 0 S 100002 205 0
c070310 0 12e62260 0 S 100002 201 0
c070364 0 12e6284c 0 S 100002 205 0
c0703b8 0 12e61688 0 S 100002 205 0
c07040c 0 12e5f300 0 S 100002 205 0
c070460 0 12e60ab0 0 S 100002 205 0
c0704b4 0 12e604c4 0 S 100002 205 0
c070508 0 12e5fed8 0 S 100002 205 0
c07055c 0 12e5f8ec 0 S 100002 205 0
c0705b0 0 12e62e38 0 S 100002 204 0
c070604 0 12e63424 0 S 100002 204 0
c070658 0 12e63a10 0 S 100002 204 0
c0706ac 0 12e63ffc 0 S 100002 204 0
c070700 0 12e645e8 0 S 100002 204 0
c070754 0 12e64bd4 0 S 100002 204 0
c0707a8 0 12e651c0 0 S 100002 204 0
c0707fc 0 12e657ac 0 S 100002 204 0
c070850 0 12e65d98 0 S 100002 204 0
c0708a4 0 12e66384 0 S 100002 204 0
c0708f8 0 12e66970 0 S 100002 204 0
c07094c 0 12e66f5c 0 S 100002 204 0
c0709a0 0 12e67548 0 S 100002 204 0
c0709f4 0 12e67b34 0 S 100002 204 0
c070a48 0 12e68120 0 S 100002 204 0
c070a9c 0 12e6870c 0 S 100002 204 0
c070af0 0 12e68cf8 0 S 100002 206 0
c070b44 0 12e692e4 0 HDR+S 100002 208 0
c070b98 0 12e6a4a8 0 S 100002 208 0
c070bec 0 12e6b080 0 S 100002 208 0
c070c40 0 12e69ebc 0 S 100002 208 0
c070c94 0 12e698d0 0 S 100002 206 0
c070ee0 0 12e6aa94 0 S 100002 206 0
168 active, 8000 total, 8192 hash buckets, 0 lock table overflows

 

[breizhti]

Hi,
based on your informations we cannot diagnose anything.

Your sessions are all in waiting for condition (flag Y in
your onstat -u) but it's normal if no sql is running in these sessions.
If you start in a windows dbaccess and select a database
and do nothing. Your session will have the same flag Y.

If you want to see what's happen, run onstat with
options -g sql <sessid> or -g ses <sessid>

If you have a deadlock situation, look at your message
file IDS will write some lines if it detect it.

To understand what could happen you can run :
onstat -g rea to see if there are a lot of thread that are waiting
onstat -D to see if there are I/O on the chunks
onstat -p to check if there is still activity.

regards,

jean