Informix - Duda onstat -k

 
Vista:
sin imagen de perfil

Duda onstat -k

Publicado por Guillermo (3 intervenciones) el 21/04/2009 19:25:34
tengo una aplicacion que se esta bloquenado y no encuentro la razon del por que. El onstat me da las siguientes salidas:

C:>onstat -k

IBM Informix Dynamic Server Version 11.10.TC2 -- On-Line -- Up 01:28:27 -- 4
54400 Kbytes

Locks
address wtlist owner lklist type tblsnum rowid key#/bsiz
c2f4d40 0 102d4b98 0 HDR+S 100002 204 0
c2f4da0 0 102d4028 0 HDR+S 100002 20e 0
c2f4e00 0 102d5cc0 0 S 100002 20e 0
c2f4ec0 0 102d4028 c2f4da0 S 100002 201 0
c2f4f80 0 102d5150 0 S 100002 204 0
c2f4fe0 0 102d5708 0 S 100002 204 0
c2f5100 0 102d5cc0 c2f4e00 HDR+S 100002 201 0
c2f51c0 0 102d6de8 0 S 100002 20e 0
c2f5220 0 102d5708 c2f4fe0 S 100002 201 0
c2f52e0 0 102d6de8 c2f51c0 S 100002 201 0
c2f5400 0 102d5150 c2f4f80 S 100002 201 0
c2f5460 0 102d3a70 0 S 100002 20e 0
c2f54c0 0 102d6830 0 S 100002 20e 0
c2f5520 0 102d6830 c2f54c0 S 100002 201 0
c2f56a0 0 102d73a0 0 S 100002 201 0
15 active, 500000 total, 65536 hash buckets, 0 lock table overflows

C:>onstat -x

IBM Informix Dynamic Server Version 11.10.TC2 -- On-Line -- Up 01:29:05 -- 4
54400 Kbytes

Transactions
address flags userthread locks beginlg curlog logposit isol retrys coord

102fd018 A---- 102cf018 0 0 481 0x2018 COMMIT 0
102fd238 A---- 102cf5d0 0 0 0 0x0 COMMIT 0
102fd458 A---- 102cfb88 0 0 0 0x0 COMMIT 0
102fd678 A---- 102d0140 0 0 0 0x0 COMMIT 0
102fd898 A---- 102d06f8 0 0 0 0x0 COMMIT 0
102fdab8 A---- 102d0cb0 0 0 0 0x0 COMMIT 0
102fdcd8 A---- 102d1268 0 0 0 0x0 COMMIT 0
102fdef8 A---- 102d1820 0 0 0 0x0 COMMIT 0
102fe118 A---- 102d1dd8 0 0 0 0x0 COMMIT 0
102fe338 A---- 102d2390 0 0 0 0x0 COMMIT 0
102fe558 A---- 102d2948 0 0 0 0x0 COMMIT 0
102fe778 A---- 102d2f00 0 0 0 0x0 COMMIT 0
102fe998 A---- 102d34b8 0 0 0 0x0 COMMIT 0
102febb8 A---- 102d3a70 1 0 0 0x0 COMMIT 0
102fedd8 A---- 102d45e0 0 0 0 0x0 COMMIT 0
102feff8 A---- 102d4028 2 0 0 0x0 COMMIT 0
102ff218 A---- 102d4b98 1 0 0 0x0 DIRTY 0
102ff438 A---- 102d4b98 0 0 0 0x0 NOTRANS 0
102ff658 A---- 102d5150 2 0 0 0x0 DIRTY 0
102ff878 A---- 102d5708 2 0 0 0x0 DIRTY 0
102ffa98 A---- 102d5cc0 2 0 0 0x0 COMMIT 0
102ffcb8 A---- 102d5cc0 0 0 0 0x0 COMMIT 0
102ffed8 A---- 102d5cc0 0 0 0 0x0 NOTRANS 0
103000f8 A---- 102d4028 0 0 0 0x0 NOTRANS 0
10300318 A---- 102d4028 0 0 0 0x0 COMMIT 0
10300538 A---- 102d6830 0 0 0 0x0 COMMIT 0
10300758 A---- 102d6de8 2 0 0 0x0 COMMIT 0
10300978 A---- 102d6830 2 0 0 0x0 COMMIT 0
10300b98 A---- 102d6830 0 0 0 0x0 NOTRANS 0
10300db8 A---- 102d6278 0 0 0 0x0 COMMIT 0
10300fd8 A---- 102d6de8 0 0 0 0x0 COMMIT 0
103011f8 A---- 102d73a0 1 0 0 0x0 COMMIT 0
10301418 A---- 102d5708 0 0 0 0x0 NOTRANS 0
33 active, 128 total, 35 maximum concurrent

C:>onstat -u

IBM Informix Dynamic Server Version 11.10.TC2 -- On-Line -- Up 01:29:38 -- 4
54400 Kbytes

Userthreads
address flags sessid user tty wait tout locks nreads nwrites

102cf018 ---P--D 1 informix - 0 0 0 55 232
102cf5d0 ---P--F 0 informix - 0 0 0 0 53
102cfb88 ---P--F 0 informix - 0 0 0 0 162
102d0140 ---P--F 0 informix - 0 0 0 0 23
102d06f8 ---P--F 0 informix - 0 0 0 0 0
102d0cb0 ---P--F 0 informix - 0 0 0 0 0
102d1268 ---P--F 0 informix - 0 0 0 0 0
102d1820 ---P--F 0 informix - 0 0 0 0 0
102d1dd8 ---P--F 0 informix - 0 0 0 0 0
102d2390 ---P--F 0 informix - 0 0 0 0 0
102d2948 ---P--F 0 informix - 0 0 0 0 0
102d2f00 ---P--- 6 informix - 0 0 0 0 0
102d34b8 ---P--B 7 informix - 0 0 0 0 0
102d3a70 Y--P--- 24 sde G-SOFT30 10c9a748 0 1 158 0
102d4028 Y--P--- 5 sde SERCIDET 10a83cb0 0 2 357 0
102d45e0 ---P--D 10 informix - 0 0 0 0 0
102d4b98 ---P--- 17 informix - 0 0 1 151 1
102d5150 ---P--- 18 informix - 0 0 2 52 10
102d5708 ---P--- 19 informix - 0 0 2 105 26
102d5cc0 Y--P--- 15 sde SERCIDET 10b35748 0 2 143 8
102d6278 Y--P--D 26 informix - c0de570 0 0 0 0
102d6830 Y--P--- 25 sde SERCIDET 10db2220 0 2 3891 2994
102d6de8 Y--P--- 27 sde SERCIDET 10db2e18 0 2 109 46
102d73a0 Y--P--- 28 informix G-SOFT30 10ed5800 0 1 81 2
24 active, 128 total, 27 maximum concurrent

la duda principal es el HDR+S que me da el onstat -k, me han dicho que ese no indica ningun problema, pero la aplicacion nomas no avanza

Agradezco de antemano la ayuda
Valora esta pregunta
Me gusta: Está pregunta es útil y esta claraNo me gusta: Está pregunta no esta clara o no es útil
0
Responder