Oninit cdi / Archive
Talk to an expert →

querying sysmaster to find time wait

Posted in 2007

Topics: General Discussion

PAULO RAFAEL PADILLA — — source: IIUG Forums & Mailing Lists

Hi all, Does anyone can advice me how I can query sysmaster database to get "set lock mode to wait" values for all my user sessions? I need a report of them. Thanks for your help Regards

↪ replying to PAULO RAFAEL PADILLA
ART KAGEL, BLOOMBERG/ — — source: IIUG Forums & Mailing Lists

Try: sysmaster:sysrstcb.lktout select x0.sid, x0.pid, x0.uid, x0.hostname, x1.lktout from sysscblst x0 ,sysrstcb x1 where ((x0.address = x1.scb ) AND (bitval(x1.flags ,'0x80000')= 1 ) ); Art S. Kagel ----- Original Message ----- From: Paulo Rafael Padilla Velazquez <ids@iiug.org> At: 3/06 13:22:53 Hi all, Does anyone can advice me how I can query sysmaster database to get "set lock mode to wait" values for all my user sessions? I need a report of them. Thanks for your help Regards ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to ART KAGEL, BLOOMBERG/
Roger Kee — — source: IIUG Forums & Mailing Lists

Paulo, The sql below will definitely show you the values for the sessions that are currently waiting, but will not show you the current lock mode value ("set lock mode to wait X") for each session. If that is what you are looking for, you can try the following sql: select scb_sessionid, scb_lockmode from sysmaster:syssqscb; The value for scb_lockmode can be: -1 wait 0 not wait # of secs to wait As with all sysmaster queries, check to insure that this table/columns exist in your version of the product (test was run against IDS 10.00.xC4 and 7.31.xD7). Thank you, Roger Kee #include <disclaimer.h> ids-bounces@iiug.org wrote on 03/06/2007 02:12:58 PM: > Try: sysmaster:sysrstcb.lktout > > select x0.sid, x0.pid, x0.uid, x0.hostname, x1.lktout > from sysscblst x0 ,sysrstcb x1 > where ((x0.address = x1.scb ) AND (bitval(x1.flags ,'0x80000')= 1 ) );> > Art S. Kagel > > ----- Original Message ----- > From: Paulo Rafael Padilla Velazquez <ids@iiug.org> > At: 3/06 13:22:53 > > Hi all, > > Does anyone can advice me how I can query sysmaster database to get "set lock > mode to wait" values for all my user sessions? > > I need a report of them. > > Thanks for your help > Regards > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

↪ replying to Roger Kee
PAULO RAFAEL PADILLA — — source: IIUG Forums & Mailing Lists

Thanks all for your help. I was looking for "set lock mode" values established by every session. This last response was what I was looking for, but i have a question: is Art's response oriented to find sessions using locking time out in the way that INFORMIX attends them ?

↪ replying to PAULO RAFAEL PADILLA
Roger Kee — — source: IIUG Forums & Mailing Lists

Paulo, Art's sql will show the lock timeout value for sessions that are currently waiting. My sql will show the value for "set lock mode to wait" that is currently set, not established (it can change during the life of the session). Also, when replying to an IIUG post, you should include the history so that all can follow the line of thought that occurs. Thank you, Roger Kee #include <disclaimer.h> ids-bounces@iiug.org wrote on 03/07/2007 11:34:29 AM: > Thanks all for your help. > > I was looking for "set lock mode" values established by every session. > This last response was what I was looking for, but i have a question: > > is Art's response oriented to find sessions using locking time out in the way > that INFORMIX attends them ? > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >