Question On Onstat "-u"

hi, what does this mean? c78d2598 L-BP--- 17924 informix - 3bf058a8 -1 11 260 129 c78d2db0 L-BP--- 17925 informix - 3bf058a8 -1 11 122 0 c78d35c8 L-BP--- 17926 informix - 3bf058a8 -1 15 171 6 c78d3de0 L-BP--- 17927 informix - 3bf058a8 -1 11 66 1 i can't seem to find documentation on what the third position indicates. for first column, it says L - waiting for lock http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?topic=%2Fcom.ibm .adref.doc%2Fids_adr_0608.htm Thanks

It means that the thread is running with LOCK MODE WAIT set and it has encountered a locked record or key and is waiting for the lock to be released. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Feb 22, 2012 at 3:15 AM, NATYURAL HORACIO < horacio.natyural@gmail.com> wrote: > hi, > > what does this mean? > > c78d2598 L-BP--- 17924 informix - 3bf058a8 -1 11 260 129 > c78d2db0 L-BP--- 17925 informix - 3bf058a8 -1 11 122 0 > c78d35c8 L-BP--- 17926 informix - 3bf058a8 -1 15 171 6 > c78d3de0 L-BP--- 17927 informix - 3bf058a8 -1 11 66 1 > > i can't seem to find documentation on what the third position indicates. > for first column, > it says > > L - waiting for lock > > > > http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?topic=%2Fcom.ibm .adref.doc%2Fids_adr_0608.htm > > Thanks > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --e89a8f2349cb07847c04b98b6489

Here are some flags significations when you run onstat -u (userthreads): Flags in position 1 B - Waiting on a buffer C - Waiting on a checkpoint G - W aiting on a logical log buffer write L - Waiting on a lock S - Waiting on a mutex T - Waiting on a transaction Y - Waiting on a condition X - Waiting on a transaction rollback Flags in position 2 * - Transaction active during I/O error Flags in position 3 A - Dbspace backup thread B - Begin work P - Prepared for commit work X - TP/XA prepeared for commit work C - Committing work R - Rolling back work H - Heuristically rolling back work Flags in position 4 P - Primary thread for a session Flags in position 5 R - Reading call X - Transaction is committing Flags in position 6 None Flags in position 7 B - Btree cleaner thread C - Cleanup of terminated user D - Daemon thread F - Page flusher thread M - ON-Monitor user thread In your case, all of the 4 userthreads are waiting on the same LOCK 3bf058a8 You can get info on this particular lock using onstat -k in order to find out which table or page or row or index is being locked and by whom. Cordialement, Regards, Khaled Bentebal Directeur Général - ConsultiX Président UGIF - User Group Informix France IIUG - Board of Directors Tél: 33 (0) 1 39 12 18 00 Fax: 33 (0) 1 39 12 18 18 Mobile: 33 (0) 6 07 78 41 97 Email: khaled.bentebal@consult-ix.fr Site Web: www.consult-ix.fr Le 22/02/12 09:15, NATYURAL HORACIO a écrit : > hi, > > what does this mean? > > c78d2598 L-BP--- 17924 informix - 3bf058a8 -1 11 260 129 > c78d2db0 L-BP--- 17925 informix - 3bf058a8 -1 11 122 0 > c78d35c8 L-BP--- 17926 informix - 3bf058a8 -1 15 171 6 > c78d3de0 L-BP--- 17927 informix - 3bf058a8 -1 11 66 1 > > i can't seem to find documentation on what the third position indicates. > for first column, > it says > > L - waiting for lock > > > http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?topic=%2Fcom.ibm .adref.doc%2Fids_adr_0608.htm > > Thanks > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >