Syntax

Home | Previous Page | Next Page Administrative Utilities > The onstat Utility >

Syntax

>>-onstat------------------------------------------------------->
 
                          .-----------------------------.
                          V                             | (1)
>--+-+-----------------+----+-------------------------+-+------+-><
   | '-filename_source-'    +- -a---------------------+        |
   |                        +- -b---------------------+        |
   |                        +- -B---------------------+        |
   |                        +- -c---------------------+        |
   |                        +- -C---------------------+        |
   |                        +- -d---------------------+        |
   |                        +- -D---------------------+        |
   |                        +- -f---------------------+        |
   |                        +- -F---------------------+        |
   |                        +- -g--Monitoring options-+        |
   |                        +- -G---------------------+        |
   |                        +- -i---------------------+        |
   |                        +- -k---------------------+        |
   |                        +- -K---------------------+        |
   |                        +- -l---------------------+        |
   |                        +- -m---------------------+        |
   |                        +- -o--+---------------+--+        |
   |                        |      '-filename_dest-'  |        |
   |                        +- -O---------------------+        |
   |                        +- -p---------------------+        |
   |                        +- -P---------------------+        |
   |                        +- -r--+---------+--------+        |
   |                        |      '-seconds-'        |        |
   |                        +- -R---------------------+        |
   |                        +- -s---------------------+        |
   |                        +- -t---------------------+        |
   |                        +- -T---------------------+        |
   |                        +- -u---------------------+        |
   |                        +- -x---------------------+        |
   |                        +- -X---------------------+        |
   |                        '- -z---------------------'        |
   +- ---------------------------------------------------------+
   '- ---------------------------------------------------------'

Notes:

Only one occurrence of each item is allowed. More than one option can be specified on a single onstat command invocation.

Element	Purpose	Key Considerations
-	Displays the output header	References: See Output Header.
--	Displays a listing of all onstat options and their functions	Additional Information: This option is the only option flag that you cannot combine with any other flag. References: See onstat --.
-a	Interpreted as onstat -cuskbtdlp. Displays output in that order	References: See onstat -a.
-b	Displays information about buffers currently in use, including number of resident pages in the buffer pool	References: See onstat -b.
-B	Obtains information about all database server buffers, not just buffers currently in use. See the entry for -b in this table	Additional Information: The -B output display fields are the same as the fields that appear in the -b output.
-c	Displays the ONCONFIG file: $INFORMIXDIR/etc/ $ONCONFIG for UNIX %INFORMIXDIR%\etc\ %ONCONFIG% for Windows	References: See onstat -c.
-C	Prints B-tree scanner information	References: See " onstat -C.
-d	Displays information for chunks in each storage space	References: See onstat -d.
-D	Displays page-read and page-write information for the first 50 chunks in each dbspace	References: See onstat -D.
-f	Lists the dbspaces currently affected by the DATASKIP feature	References: See onstat -f.
-F	Displays a count for each type of write that flushes pages to disk	References: See onstat -F.
-g	Provides monitoring options	References: See onstat -g Monitoring Options.
-G	Prints global transaction IDs	References: See onstat -G.
-i	Puts the onstat utility into interactive mode	References: See onstat -i.
-j	Prints the interactive status of the active onpload process	References : See onstat -j.
-k	Displays information about active locks	References: See onstat -k.
-l	Displays information about physical and logical logs, including page addresses	References: See onstat -l.
-m	Displays the 20 most recent lines of the database server message log	Additional Information: Output from this option lists the full pathname of the message-log file and the 20 file entries. A date-and-time header separates the entries for each day. A time stamp prefaces single entries within each day. The name of the message log is specified as MSGPATH in the ONCONFIG file. References: See onstat -m.
-o	Saves copies of the shared-memory segments to filename	Additional Information: If you omit a filename in the onstat command, the copy of shared memory is saved to onstat.out in the current directory.
-O	Displays information about the Optical Subsystem memory cache and staging-area blobspace	References: See onstat -O.
-p	Displays profile counts.	References: See onstat -p.
-P	Displays for all partitions the partition number and the break-up of the buffer-pool pages that belong to the partition	References: See onstat -P.
-r	Repeats the accompanying onstat options after they wait the specified seconds between each execution. The default value of seconds is 5.	Additional Information: To end execution, press `DEL` or `CTRL-C`.
-R	Displays detailed information about the LRU queues, FLRU queues, and MLRU queues	References: See onstat -R.
-s	Displays general latch information	References: See onstat -s.
-t	Displays tblspace information, including residency state, for active tblspaces	References: See onstat -t and -T.
-T	Displays tblspace information for all tblspaces	References: See onstat -t and -T.
-u	Prints a profile of user activity	References: See onstat -u.
-x	Displays information about transactions	References: See onstat -x.
-X	Obtains precise information about the threads that are sharing and waiting for buffers	References: See onstat -X.
-z	Sets the profile counts to 0	References: See onstat -z.
filename_dest	Specifies destination file for the copy of the shared-memory segments	Restrictions: Name must not match the name of any existing file. References: For pathname syntax, see your operating-system documentation.
filename_source	Specifies file that onstat reads as source for the requested information	Restrictions: This file must include a previously stored shared-memory segment that you created with the -o option of onstat. References: For specific details on this option, see Statistics Culled from Source File. For pathname syntax, see your operating-system documentation.
Monitoring options	Specifies which onstat -g monitoring option to use	References: See onstat -g Monitoring Options.
seconds	Specifies number of seconds between each execution of the onstat -r command	Restrictions: This value must be an unsigned integer greater than 0.