RE: help with sessid
Posted in 2009
If you issue an onstat -g ses 6579097
Towards the top it will give you all the threads the session is using. I am assuming you are using pdq .
From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of emaus
Sent: Tuesday, August 04, 2009 10:14 AM
To: informix-list@iiug.org
Subject: help with sessid
Hi all:
IBM Informix 10.00FC10 + HDR
IBM AIX 6.1
When I run the command:
$ onstat -u |grep 6579097
7000001e2809660 Y------ 6579097 user01 host01 7000001f8291f90 0 4 0 0
7000001e2809da8 Y------ 6579097 user01 host01 7000001e8847600 0 4 0 0
7000001eb9654c0 Y------ 6579097 user01 host01 7000001f8291f90 0 4 0 0
7000001eb969648 Y------ 6579097 user01 host01 7000001e8847600 0 4 0 0
7000001eb98b860 Y------ 6579097 user01 host01 7000001f8291f90 0 4 0 0
7000001edfb3338 Y------ 6579097 user01 host01 7000001ef606400 0 4 0 0
7000001edfbdab0 Y------ 6579097 user01 host01 7000001f91723e0 0 4 0 0
7000001f2f01f30 Y------ 6579097 user01 host01 7000001f8291f90 0 4 0 0
7000001f2f0a988 Y------ 6579097 user01 host01 70000020485bd68 0 4 0 0
7000001f2f1ffc0 Y------ 6579097 user01 host01 7000001f8291f90 0 4 0 0
7000001f6d31618 Y------ 6579097 user01 host01 7000001ef606400 0 4 0 0
7000001f6d3f088 Y------ 6579097 user01 host01 7000001f8291f90 0 4 0 0
7000001f6d5bb40 Y------ 6579097 user01 host01 7000001fc52a878 0 4 0 0
7000001f9b67770 Y------ 6579097 user01 host01 7000001e8847600 0 4 0 0
7000001f9b72d78 Y------ 6579097 user01 host01 7000001ef606400 0 4 0 0
7000001f9b923e0 Y------ 6579097 user01 host01 7000001f91723e0 0 4 0 0
7000001f9b96568 Y------ 6579097 user01 host01 7000001f91723e0 0 4 0 0
7000001fe8f2598 Y--P--- 6579097 user01 host01 7000001efba50b0 0 4 2502 1269
70000020637cae0 Y------ 6579097 user01 host01 7000001f91723e0 0 4 0 0
700000206387258 Y------ 6579097 user01 host01 7000001f91723e0 0 4 0 0
70000020af9fd90 Y------ 6579097 user01 host01 7000001ef606400 0 4 0 0
70000020afa2940 Y------ 6579097 user01 host01 7000001f91723e0 0 4 0 0
70000020afabae0 Y------ 6579097 user01 host01 7000001ef0c0578 0 4 0 0
70000020bbec678 Y------ 6579097 user01 host01 7000001f91723e0 0 4 0 0
70000020bbecdc0 Y------ 6579097 user01 host01 7000001e2f3d8a0 0 4 0 0
70000020bc05e38 Y------ 6579097 user01 host01 7000001f91723e0 0 4 0 0
700000211099a98 Y------ 6579097 user01 host01 7000001f2507248 0 4 0 0
7000002110a07d0 Y------ 6579097 user01 host01 7000001f8291f90 0 4 0 0
7000002110c1b58 Y------ 6579097 user01 host01 7000001f8291f90 0 4 0 0
7000002150434c0 Y------ 6579097 user01 host01 7000001e8847600 0 4 0 0
70000021504f958 Y------ 6579097 user01 host01 7000001f0d55e00 0 4 0 0
I shows the same number of threads with the same user and same sessid. This same event is repeated for other user's
I would appreciate help to get the problem
Thank you very much
________________________________
Guardá correos, fotos, archivos, documentos, todo. ¡Ahora Hotmail te da espacio ILIMITADO!<http://www.microsoft.com/latam/windows/windowslive/default.aspx>