The onstat -g command of Extended Parallel Server supports more than fifty documented options that can immediately follow the -g flag, including the following monitoring commands:
| Option | Type of Information Displayed |
|---|---|
| act | Attributes of each active thread |
| afr | Allocated memory fragments for a specified session or shared-memory pool |
| all | All multithreading |
| ath | Attributes of all threads |
| bus | Current backup scheduler sessions, and backups in progress or to be performed |
| bus_sm | The current storage manager configuration and active work |
| con | All conditions with waiters |
| dcm | Full or specialty capabilities and enabled or disabled status of coservers |
| dic | Tables cached in the shared-memory dictionary |
| dll | Dynamic libraries that have been loaded |
| dsc | Distribution cache attributes |
| env | Values of the server environment variables |
| ffr | Free fragments for a pool of shared memory |
| glo | Multithreading information |
| hwm | How many pages of each dbspace are in use, and the used space threshold |
| imc | Information about the MaxConnect instances connected to a connection coserver |
| ioa | Combined information from -g ioq, -g iov, and -g iob |
| iob | Big buffer use by the I/O virtual-processor class |
| iof | Asynchronous I/O statistics, by chunk or by file |
| iog | Global asynchronous I/O information |
| ioq | Statistics about the number and types of operations performed by I/O queues |
| iov | Asynchronous I/O statistics for each virtual processor |
| lap | Light append statistics for all active sessions |
| lmx | All locked mutexes |
| mem | Memory statistics for session pools |
| mut | Mutability value of session variables that have the mutability attribute |
| nbm | The block bit map for the nonresident segments. |
| nsc | Current shared memory connections to the database server |
| nsd | Shared-memory data for poll threads |
| nss | Network shared-memory status for a session or for all sessions |
| ntd | Network statistics by service |
| ntm | Network mail statistics |
| ntt | Network user times |
| ntu | Network user statistics |
| pos | Values for the$INFORMIXDIR/etc/.infos.DBSERVERNAME file |
| ppf | Partition profile for a specified partition, or for all partitions |
| prc | Attributes of the SPL routine cache |
| rbm | Block bitmap of the resident segment (the communication message area) |
| rea | Ready threads |
| rgm | Resource Grant Manager information (accessible from coserver 1 only) |
| sch | Semaphore operations, spins, and busy waits for each virtual processor |
| seg | How many shared memory segments are attached, and their sizes |
| ses | Attributes of a session, or a one-line summary of all sessions |
| sle | All sleeping threads |
| spl | Spin locks that virtual processors have spun more than 10,000 times to acquire |
| sql | SQL attributes of a session, or a one-line summary of all sessions |
| stk | The stack of a specific thread |
| sts | The maximum and current stack use per thread |
| tmp | Usage statistics for spaces that might store temporary files |
| wmx | All mutexes with waiters |
| wst | Wait statistics |
| xmf | Communication information between coservers |
| xmp | Currently executing iterator instances for the query, or for all queries |
| xqs | Attributes of finished iterator instances. |
All of these command-line options are described in Chapter 10 of Extended Parallel Server Administrator's Reference, Version 8.50, with the exceptions of the dcm, imc, and lap options, which are described in Chapter 2 of the Feature Enhancements Guide for IBM Informix Extended Parallel Server, Version 8.32.
See also the Performance Guide for IBM Informix Extended Parallel Server, Version 8.50, and the section onstat -g in Chapter 10 of this manual, for more information about onstat -g command-line options and their output displays.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]