Userthread flag values in IDS onstat -u output

Problem(Abstract)

This document describes the flag values of an onstat -u output for IBM® Informix® Dynamic Server (IDS).

Resolving the problem

Q. What are the meanings for the character flag values in the IDS onstat -u command output?

A. The onstat -u command displays a profile of the user activity or thread currently running in the system. In the onstat -u command output, the flagscolumn describes the status of the thread in that session. The total width of the flag is seven characters long. The table below lists the different character values for each position:

 

Position	Value	Description
1	B  C  G  L  S  T  Y	Waiting for a buffer Waiting for checkpoint Waiting for write of log buffer Waiting for a lock Waiting on mutex Waiting for a transaction Waiting on condition
2	*	Transaction active while I/O failure occurred
3	A  B  C  H  P  R  X	Archive thread Begin work Committing OR Committed Heuristically aborted OR heuristically rolling back Begin prepare or prepared work Aborting OR aborted XA prepared
4	P	Primary thread for a session
5	R  X	Reading (RSAM call) Process in critical section
6	R	Recovery
7	B  C  D  F  M	Special btree cleaner thread Cleanup dead process Special daemon process Special buffer flusher process Monitor user

 

Example: 

$ onstat -u 

IBM Informix Dynamic Server Version 10.00.UC3     -- on-Line -- Up 10:02:59 -- 28672 Kbytes 

Userthreads 
address flags   sessid  user  tty wait    tout locks nreads writes 
a570018 ---P--D      1  root  -   0       0    0     23     7 
a570544 ---P--F      0  root  -   0       0    0     0      144 
a570a70 ---P---      5  root  -   0       0    0     0      0 
a570f9c ---P--B      6  root  -   0       0    0     0      0 
a5714c8 Y--P---     18  anupn 3   ab0bfa8 0    1     0      0 
a5719f4 Y--P--D     12  root  -   a07c134 0    0     0      0 
a571f20 ---P--D      9  root  -   0       0    0     0      0 
 7 active, 128 total, 0 maximum concurrent 

From the above reference, for session 18 the flag values ' Y--P---' signifies that it is a primary thread for this session and waiting on a condition.

http://www-01.ibm.com/support/docview.wss?uid=swg21206337