Oninit cdi / Archive
Talk to an expert →

onstat flags

Posted in 2003

Topics: Performance & Tuning

Merrill, Douglas D. — — source: IIUG Forums & Mailing Lists

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_000_01C2C163.7472F850 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C2C163.7472F850" ------_=_NextPart_001_01C2C163.7472F850 Content-Type: text/plain; charset="iso-8859-1" What does it mean when the flag in position 1 is "-"? We cannot find documentation to indicate what the dash means in position 1 of an onstat -u. Some of us believe these are "hanging" and degrade performance. Anybody know? Did I miss this in one of the reference books? C:\\\\INFORMIX\\\\bin>onstat -u | find " ---" 50eec018 ---P--D 1 informix - 0 0 0 10 78 50eec500 ---P--F 0 informix - 0 0 0 0 5402 50eec9e8 ---P--F 0 informix - 0 0 0 0 304 50eeced0 ---P--F 0 informix - 0 0 0 0 584 50eed3b8 ---P--F 0 informix - 0 0 0 0 660 50eed8a0 ---P--F 0 informix - 0 0 0 0 349 50eedd88 ---P--F 0 informix - 0 0 0 0 509 50eee270 ---P--F 0 informix - 0 0 0 0 1111 50eee758 ---P--F 0 informix - 0 0 0 0 4190 50eeec40 ---P--- 8 informix - 0 0 0 0 0 50eef128 ---P--B 9 informix - 0 0 0 0 0 50eeffe0 ---P--D 12 informix - 0 0 0 0 0 55c3f868 ---PR-M 157020 informix END3 0 0 1 0 0 5816dc38 ---P--- 157010 ascupd SA12 0 0 1 1 0 Doug Merrill <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /> 847-377-2186 ------_=_NextPart_001_01C2C163.7472F850 Content-Type: text/html; charset="iso-8859-1" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META content="MSHTML 5.50.4807.2300" name=GENERATOR></HEAD> <BODY> <DIV><FONT face=Arial size=2><SPAN class=234243215-21012003>What does it mean when the flag in position 1 is "-"?&nbsp; We cannot find documentation to indicate what the dash means in position 1 of an onstat -u.&nbsp; Some of us believe these are "hanging" and degrade performance.&nbsp; </SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=234243215-21012003></SPAN></FONT>&nbsp;</DIV> <DIV><FONT face=Arial size=2><SPAN class=234243215-21012003>Anybody know?&nbsp; Did I miss this in one of the reference books?</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV> <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV> <DIV><FONT face=Arial size=2></FONT><FONT face=Arial size=2></FONT><BR><FONT face=Arial size=2>C:\\\\INFORMIX\\\\bin&gt;onstat -u&nbsp; | find " ---" <BR>50eec018 ---P--D 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class=234243215-21012003>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>informix -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 78<BR>50eec500 ---P--F 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class=234243215-21012003>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>informix -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5402<BR>50eec9e8 ---P--F 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class=234243215-21012003>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>informix -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 304<BR>50eeced0 ---P--F 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class=234243215-21012003>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>informix -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 584<BR>50eed3b8 ---P--F 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class=234243215-21012003>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>informix -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 660<BR>50eed8a0 ---P--F 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class=234243215-21012003>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>informix -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 349<BR>50eedd88 ---P--F 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class=234243215-21012003>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>informix -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 509<BR>50eee270 ---P--F 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class=234243215-21012003>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>informix -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1111<BR>50eee758 ---P--F 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class=234243215-21012003>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>informix -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4190<BR>50eeec40 ---P--- 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class=234243215-21012003>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>informix -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0<BR>50eef128&nbsp;<SPAN class=234243215-21012003> </SPAN>---P--B 9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class=234243215-21012003>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>informix -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0<BR>50eeffe0&nbsp;<SPAN class=234243215-21012003>&nbsp; </SPAN>---P--D 12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class=234243215-21012003>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</SPAN>informix -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0<BR>55c3f868&nbsp;<SPAN class=234243215-21012003> </SPAN>---PR-M 157020&nbsp;&nbsp; informix END3&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0<BR>5816dc38 ---P--- 157010&nbsp;&nbsp;&nbsp;<SPAN class=234243215-21012003>&nbsp;&nbsp; </SPAN>ascupd&nbsp;&nbsp; SA12&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0<BR></F

↪ replying to Merrill, Douglas D.
Michael Lowe — — source: IIUG Forums & Mailing Lists

Doug; In your sample, all the 'informix' sessions are the engine. They all have a flag in the last position - page cleaners, btree cleaner, etc. Session 8 is also part of the engine. The '-' flag in position 1 for user session 'ascupd' just means that thread was currently actively running at the time the onstat was run. It does not by itself mean the thread has 'hung', or anything else other than it is running at that moment. As a matter of fact, you would most likely get a specific flag in that first position if the the thread had 'hung'. The flags are documented in the Administrator's Reference (this is not the Administrator's Guide), which you can find in the Answers OnLine CD you get in class, or in our on-line documentation at: http://www-3.ibm.com/software/data/informix/pubs/library/ HTH... Mike =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Mike Lowe Certified Consulting Education Specialist Data Management Solutions IBM Software Group Tel: 303-773-5216 Tie Line: 565-5216 e-Fax: 413-674-2415 mlowe0@us.ibm.com WWW: ibm.com/software/data "Merrill, Do...." <DMerrill@co.lake To: ids@iiug.org .il.us> cc: Sent by: Subject: onstat flags [49] forum.subscriber@ iiug.org 01/21/2003 08:43 AM This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_000_01C2C163.7472F850 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C2C163.7472F850" ------_=_NextPart_001_01C2C163.7472F850 Content-Type: text/plain; charset="iso-8859-1" What does it mean when the flag in position 1 is "-"? We cannot find documentation to indicate what the dash means in position 1 of an onstat -u. Some of us believe these are "hanging" and degrade performance. Anybody know? Did I miss this in one of the reference books? C:\\\\INFORMIX\\\\bin>onstat -u | find " ---" 50eec018 ---P--D 1 informix - 0 0 0 10 78 50eec500 ---P--F 0 informix - 0 0 0 0 5402 50eec9e8 ---P--F 0 informix - 0 0 0 0 304 50eeced0 ---P--F 0 informix - 0 0 0 0 584 50eed3b8 ---P--F 0 informix - 0 0 0 0 660 50eed8a0 ---P--F 0 informix - 0 0 0 0 349 50eedd88 ---P--F 0 informix - 0 0 0 0 509 50eee270 ---P--F 0 informix - 0 0 0 0 1111 50eee758 ---P--F 0 informix - 0 0 0 0 4190 50eeec40 ---P--- 8 informix - 0 0 0 0 0 50eef128 ---P--B 9 informix - 0 0 0 0 0 50eeffe0 ---P--D 12 informix - 0 0 0 0 0 55c3f868 ---PR-M 157020 informix END3 0 0 1 0 0 5816dc38 ---P--- 157010 ascupd SA12 0 0 1 1 0 Doug Merrill <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /> 847-377-2186 ------_=_NextPart_001_01C2C163.7472F850 Content-Type: text/html; charset="iso-8859-1" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META content="MSHTML 5.50.4807.2300" name=GENERATOR></HEAD> <BODY> <DIV><FONT face=Arial size=2><SPAN class=234243215-21012003>What does it mean when the flag in position 1 is "-"?&nbsp; We cannot find documentation to indicate what the dash means in position 1 of an onstat -u.&nbsp; Some of us believe these are "hanging" and degrade performance.&nbsp; </SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=234243215-21012003></SPAN></FONT>&nbsp;</DIV> <DIV><FONT face=Arial size=2><SPAN class=234243215-21012003>Anybody know?&nbsp; Did I miss this in one of the reference books?</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV> <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV> <DIV><FONT face=Arial size=2></FONT><FONT face=Arial size=2></FONT><BR><FONT face=Arial size=2>C:\\\\INFORMIX\\\\bin&gt;onstat -u&nbsp; | find " ---" <BR>50eec018 ---P--D 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class=234243215-21012003>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>informix -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 78<BR>50eec500 ---P--F 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class=234243215-21012003>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>informix -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5402<BR>50eec9e8 ---P--F 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class=234243215-21012003>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>informix -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 304<BR>50eeced0 ---P--F 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class=234243215-21012003>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>informix -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 584<BR>50eed3b8 ---P--F 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class=234243215-21012003>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>informix -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 660<BR>50eed8a0 ---P--F 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class=234243215-21012003>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>informix -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 349<BR>50eedd88 ---P--F 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class=234243215-21012003>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>informix -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 509<BR>50eee270 ---P--F 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class=234243215-21012003>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>informix -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1111<BR>50eee758 ---P--F 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class=234243215-21012003>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>informix -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4190<BR>50eeec40 ---P--- 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class=234243215-21012003>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>informix -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp

Related threads

Glossary