Syntax

Home | Previous Page | Next Page Utility Reference > onstat: Monitor Database Server Operations > In This Chapter >

Syntax

    (1)
>>--------onstat------------------------------------------------>

                        .----------------------------.
                        V                            |
>--+-----------------+----+------------------------+-+---------><
   '-filename_source-'    +- -a--------------------+
                          +- -b--tblspace_num------+
                          +- -B--------------------+
                          +- -c--------------------+
                          +- -C--------------------+
                          +- -d--------------------+
                          +- -D--------------------+
                          +- -f--------------------+
                          +- -F--------------------+
                          +- -g--------------------+
                          +- -h--------------------+
                          +- -i--------------------+
                          +- -j--+---------------+-+
                          |      '-filename_dest-' |
                          +- -k--------------------+
                          +- -K--------------------+
                          +- -l--------------------+
                          +- -m--------------------+
                          +- -p--------------------+
                          +- -P--------------------+
                          +- -r--+---------+-------+
                          |      '-seconds-'       |
                          +- -R--------------------+
                          +- -s--------------------+
                          +- -t--------------------+
                          +- -u--------------------+
                          +- -x--------------------+
                          +- -X--------------------+
                          +- -z--------------------+
                          '- -o--+---------------+-'
                                 '-filename_dest-'

Notes:

Each item can occur only once. However, multiple items may occur in a single invocation of the command.

Element	Purpose	Key Considerations
--	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 The onstat -- Option.
-a	Interpreted as onstat -cuskbtdlp. Displays output in that order.	References: See The onstat -a Option.
-b	Displays information about buffers currently in use, including number of resident pages in the buffer pool.	References: See The onstat -b Option.
-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	References: See The onstat -c Options.
-C	Prints B-tree cleaner information.	None.
-d	Displays information for chunks in each storage space.	References: See The onstat -d Option.
-D	Displays page-read and page-write information for the first 50 chunks in each dbspace.	References: See The onstat -D Option.
-f	Lists the dbspaces currently affected by the DATASKIP feature.	References: See The onstat -f Option.
-F	Displays a count for each type of write that flushes pages to disk.	References: See The onstat -F Option.
-g	Provides monitoring options.	References: See The onstat -g Monitoring Options.
-G	Prints global transaction IDs	References: See The onstat -G Option.
-h	Prints information about buffer hash chain.	None.
-i	Puts the onstat utility into interactive mode.	References: See The onstat -i Option.
-k	Displays information about active locks.	References: See The onstat -k Option.
-K	Displays information about byte-range locks.	References: See The onstat -K Option.
-l	Displays information about physical and logical logs, including page addresses.	References: See The onstat -l Option.
-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 The onstat -m Option.
-o	Saves a copy of the shared-memory segment 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.
-p	Displays profile counts.	References: See The onstat -p Option.
-P	Displays for all partitions the partition number and the break-up of the buffer-pool pages that belong to the partition.	References: See The onstat -P Option.
-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 The onstat -R Option.
-s	Displays general latch information.	References: See The onstat -s Option.
-t	Displays tblspace information, including residency state, for active tblspaces.	References: See The onstat -t Option.
-u	Prints a profile of user activity.	References: See The onstat -u Option.
-x	Displays information about transactions.	References: See The onstat -x Option.
-X	Obtains precise information about the threads that are sharing and waiting for buffers.	References: See The onstat -X Option.
-z	Sets the profile counts to 0.	References: See The onstat -z Option.
filename_dest	Specifies destination file for the copy of the shared-memory segment.	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.
seconds	Specifies number of seconds between each execution of the onstat -r command.	Restrictions: This value must be an unsigned integer greater than 0.

Statistics Culled from Source File

Use the filename_source parameter with other option flags to derive the requested onstat statistics from the shared-memory segment that filename_source contains. You must first use the onstat -o command to create a file that contains a shared-memory segment.

Interactive Execution

To put the onstat utility in interactive mode, use the -i option. Interactive mode allows you to enter multiple options, one after the other, without exiting the program. For information on using interactive mode, see The onstat -i Option.

Continuous onstat Execution

Use the seconds parameter with the -r option flag to cause all other flags to execute repeatedly after they wait the specified seconds between each execution.