onstat -g monitoring options
The options that you can use with onstat -g command are used for support and debugging only. You can include only one of these options in the onstat -g command.
The onstat -g imc command prints information about Informix® MaxConnect instances that are connected to the database server. If Informix MaxConnect is not connected to the database server, this command displays No MaxConnect servers are connected.
The onstat -g nta command prints combined network statistics from the -g ntd, -g ntm, -g ntt, and -g ntu commands. If Informix MaxConnect is installed, this command prints statistics that you can use to tune Informix MaxConnect performance.
- onstat -g act command: Print active threads
Use the onstat -g act command to display information about the active threads. - onstat -g afr command: Print allocated memory fragments
Use the onstat -g afr command to display information about the allocated memory fragments for a specified session or shared-memory pool. Each session is allocated a pool of shared memory. - onstat -g all command: Print diagnostic information
Use the onstat -g all command to gather diagnostic information if advised to do so by IBM® Support. For normal administrative purposes, use the onstat -g command with individual options. - onstat -g aqt command: Print data mart and accelerated query table information
Use the onstat -g aqt command to display information about the data marts and the associated accelerated query tables (AQTs). - onstat -g arc command: Print archive status
Use the onstat -g arc command to display information about the last committed archive for each dbspace and also information about any current ongoing archives. - onstat -g ath command: Print information about all threads
Use the onstat -g ath command to display information about all threads. - onstat -g bth and -g BTH: Print blocked and waiting threads
Use the onstat -g bth command to display the dependencies between blocking and waiting threads. Use the onstat -g BTH command to display session and stack information for the blocking threads. - onstat -g buf command: Print buffer pool profile information
Use the onstat -g buf command to show profile information for each buffer pool. - onstat -g cac command: Print information about caches
Use the onstat -g cac command to see summary and detailed information about all caches or about a single cache. - onstat -g ckp command: Print checkpoint history and configuration recommendations
Use the onstat -g ckp command to print checkpoint history and show configuration recommendations if a suboptimal configuration is detected. - onstat -g cfg command: Print the current values of configuration parameters
Use the onstat -g cfg command to print a list of configuration parameters with their current values. You can use more command options to print more information about the configuration parameters. - onstat -g cluster command: Print high-availability cluster information
Use the onstat -g cluster command to display information about the servers in a high-availability cluster environment. - onstat -g cmsm command: Print Connection Manager information
Use the onstat -g cmsm command to display information about a specific Connection Manager, or all of the Connection Managers that are attached to the database server the command is run on. - onstat -g con command: Print condition and thread information
Use the onstat -g con command to display information about conditions and the threads that are waiting for the conditions. - onstat -g cpu: Print runtime statistics
Use the onstat -g cpu command to display information about runtime statistics for each thread that is running in the server. - onstat -g dbc command: Print dbScheduler and dbWorker thread statistics
Use the onstat -g dbc command to display statistics about the Scheduler tasks that are currently running, which are handled by dbWorker threads, or scheduled to be run, which are handled by the dbScheduler thread. - onstat -g defragment command: Print defragment partition extents
Use the onstat -g defragment command to display information about the active requests to defragment partition extents. - onstat -g dic command: Print table information
Use the onstat -g dic command to display a line of information about each table that is cached in the shared-memory dictionary. If you specify a table name, this command prints internal SQL information about that particular table. - onstat -g dis command: Print database server information
Use the onstat -g dis command to display a list of database servers, the status of each server, and information about each server, including the location of the INFORMIXDIR directory, sqlhosts file, and ONCONFIG file. You can use this command in any database server mode, including offline. - onstat -g dll command: Print dynamic link library file list
Use the onstat -g dll command to display a list of and the status of dynamic link library (DLL) files that were loaded. - onstat -g dmp command: Print raw memory
Use the onstat -g dmp command to display information about raw memory at a given address for a number of given bytes. - onstat -g dri command: Print high-availability data replication information
Use the onstat -g dri command, either alone or with the ckpt or que options, to print information about high-availability data replication statistics on the current server. - onstat -g dsc command: Print distribution cache information
Use the onstat -g dsc command to display information about the distribution cache. - onstat -g dsk command: Print the progress of the currently running compression operation
Use the onstat -g dsk command to print information that shows the progress of currently running compression operations, such as compress, repack, and shrink. - onstat -g env command: Print environment variable values
Use the onstat -g env command to display the values of the environment variables that the database server currently uses. - onstat -g ffr command: Print free fragments
Use the onstat -g ffr command to display information about the free memory fragments for a specified session or shared-memory pool. - onstat -g glo command: Print global multithreading information
Use the onstat -g glo command to display global information about multithreading, information about each virtual processor that is running, and cumulative statistics for each virtual-processor class. This information includes CPU use information about the virtual processors, the total number of sessions, and other multithreading global counters. - onstat -g his command: Print SQL trace information
Use the onstat -g his command to display SQL trace information from the collection of syssqltrace tables (syssqltrace, syssqltrace_info, syssqltrace_hvar and syssqltrace_itr) in the sysmaster database. - onstat -g ioa command: Print combined onstat -g information
Use the onstat -g ioa command to display combined information from the onstat -g iob, onstat -g iof, onstat -g ioq, and onstat -g iov commands. - onstat -g iob command: Print big buffer use summary
Use the onstat -g iob command to display a summary of big buffer use. - onstat -g iof command: Print asynchronous I/O statistics
Use the onstat -g iof command to display the asynchronous I/O statistics by chunk or file. - onstat -g iog command: Print AIO global information
Use the onstat -g iog command to display global information about AIO. - onstat -g ioq command: Print I/O queue information
Use the onstat -g ioq command to display statistics about the number and types of operations performed by I/O queues. - onstat -g ipl command: Print index page logging status information
Use the onstat -g ipl command to display information about the status of index page logging. - onstat -g iov command: Print AIO VP statistics
Use the onstat -g iov command to display asynchronous I/O statistics for each virtual processor. - onstat -g lap command: Print light appends status information
Use the onstat -g lap command to display information about the status of light appends occurring in the system. - onstat -g laq command: Print secondary server queues
Use the onstat -g laq command to print information about queues on the secondary server that apply log information received from the primary server. - onstat -g lmm command: Print low memory management information
Use the onstat -g lmm command to display information about automatic low memory management settings and recent activity. - onstat -g lmx command: Print all locked mutexes
Use the onstat -g lmx command to display information about all locked mutexes. - onstat -g lsc command: Print active light scan status (deprecated)
The onstat -g lsc command has been superseded by the onstat -g scn command. - onstat -g mem command: Print pool memory statistics
Use the onstat -g mem command to display the memory statistics for a pool. - onstat -g mgm command: Print MGM resource information
Use the onstat -g mgm command to show resource information about Memory Grant Manager (MGM). - onstat -g nbm command: Print a block bit map
Use the onstat -g nbm command to display the block bit map for the nonresident segments. - onstat -g nsc command: Print current shared memory connection information
Use the onstat -g nsc command to display information about shared memory connections either for all of the current connections or for a specified connection ID. - onstat -g nsd command: Print poll threads shared-memory data
Use the onstat -g nsd command to display information about shared-memory data for poll threads. - onstat -g nss command: Print shared memory network connections status
Use the onstat -g nss sessionid command to display information about the status of the shared memory network connections. - onstat -g ntd command: Print network statistics
Use the onstat -g ntd command to display network statistics by service. - onstat -g ntm command: Print network mail statistics
Use the onstat -g ntm command to display statistics about network mail. - onstat -g ntt command: Print network user times
Use the onstat -g ntt command to display information about network user times. - onstat -g ntu command: Print network user statistics
Use the onstat -g ntu command to display information about network user statistics. - onstat -g opn command: Print open partitions
Use the onstat -g opn command to display a list of the partitions (tables and indexes), by thread ID, that are currently open in the system. - onstat -g osi: Print operating system information
Use the onstat -g osi command to display information on your operating system resources and parameters, including shared memory and semaphore parameters, the amount of memory currently configured on the computer, and the amount of memory that is unused. - onstat -g pd command: Print push data session-related information
Use the onstat -g pd command to display information about the push data session. - onstat -g pd event command: Print push data event-related information
Use the onstat -g pd event command to display information about the push data event. - onstat -g pos command: Print file values
Use the onstat -g pos command to display the values in the $INFORMIXDIR/etc/.infos.DBSERVERNAME file. - onstat -g ppd command: Print partition compression dictionary information
Use the onstat –g ppd command to display information about the active compression dictionaries that were created for compressed tables and table fragments or compressed B-tree indexes. You can choose to print information for a particular numbered partition or for all open partitions. - onstat -g ppf command: Print partition profiles
Use the onstat -g ppf partition_number command to display the partition profile for the specified partition number. - onstat -g pqs command: Print operators for all SQL queries
Use the onstat –g pqs command to display information about the operators used in all of the SQL queries that are currently running. - onstat -g prc command: Print sessions using UDR or SPL routines
Use the onstat -g prc command to display the number of sessions that are currently using the UDR or SPL routine. - onstat -g proxy command: Print proxy distributor information
Use the onstat -g proxy command to display information about proxy distributors. The output of the onstat -g proxy command differs slightly depending on whether the command is run on a primary server or on a secondary server. - onstat -g qst command: Print wait options for mutex and condition queues
Use the onstat -g qst command to display the wait statistics for mutex queues and condition queues (queues of waiters for a mutex or a condition). - onstat -g rah command: Print read-ahead request statistics
Use the onstat -g rah command to display information about read-ahead requests. - onstat -g rbm command: Print a block map of shared memory
Use the onstat -g rbm command to display a hexadecimal bitmap of the free and used blocks within the resident segment of shared memory. - onstat -g rea command: Print ready threads
Use the onstat -g rea command to display information about the virtual processor threads whose current status is ready. - onstat -g rss command: Print RS secondary server information
Use the onstat -g rss commands to display information about remote standalone secondary servers. - onstat -g rwm command: Print read and write mutexes
Use the onstat -g rwm command to display information about read, write, and waiting mutex threads, and to list the addresses of the tickets that these threads have acquired. - onstat -g sch command: Print VP information
Use the onstat -g sch command to display information about thread migration and the number of semaphore operations, spins, and busy waits for each virtual processor. - onstat -g scn command: Print scan information
Use the onstat -g scn command to display the status of a current scan and information about the scan. - onstat -g sds command: Print SD secondary server information
Use the onstat -g sds command to display information about shared-disk secondary servers. - onstat -g seg command: Print shared memory segment statistics
Use the onstat -g seg command to show the statistics for shared memory segments. - onstat -g ses command: Print session-related information
Use the onstat -g ses command to display information about the session. - onstat -g shard command: Print information about the shard definition
Use the onstat -g shard command to display information about the sharding definition. - onstat -g sle command: Print all sleeping threads
Use the onstat -g sle command to print all sleeping threads. - onstat -g smb command: Print sbspaces information
Use the onstat -g smb command to display detailed information about sbspaces. - onstat -g smx command: Print multiplexer group information
Use the onstat -g smx command to display information about the server multiplexer group for servers using SMX. - onstat -g spi command: Print spin locks with long spins
Use the onstat -g spi command to display information about spin locks with long spins. - onstat -g sql command: Print SQL-related session information
Use the onstat -g sql command to display SQL-related information about a session. - onstat -g spf: Print prepared statement profiles
Use the onstat -g spf command to display current statistics about SQL queries. - onstat -g src command: Patterns in shared memory
Use the onstat -g src command to search for patterns in shared memory. - onstat -g ssc command: Print SQL statement occurrences
Use the onstat -g ssc command to monitor the number of times that the database server reads the SQL statement in the cache. - onstat -g stk command: Print thread stack
Use the onstat -g stk tid command to display the stack of the thread specified by thread ID. - onstat -g stm command: Print SQL statement memory usage
Use the onstat -g stm command to display the memory that each prepared SQL statement uses. - onstat -g stq command: Print queue information
Use the onstat -g stq command to display information about the queue. - onstat -g sts command: Print stack usage for each thread
Use the onstat -g sts command to display information about the maximum and current stack use for each thread. - onstat -g sym command: Print symbol table information for the oninit utility
Use the onstat -g sym command to display symbol table information for the oninit utility. - onstat -g tpf command: Print thread profiles
Use the onstat -g tpf command to display thread profiles. - onstat -g ufr command: Print memory pool fragments
Use the onstat -g ufr command to display a list of the fragments that are currently in use in the specified memory pool. - onstat -g vpcache command: Print CPU virtual processor and tenant virtual processor private memory cache statistics
Run the onstat -g vpcache command to display statistics about CPU virtual processor and tenant virtual processor private memory caches. - onstat -g wai command: Print wait queue thread list
Use the onstat -g wai command to display a list of the threads in the system that are currently in the wait queue and not currently executing. The output is sorted by thread ID. - onstat -g wmx command: Print all mutexes with waiters
Use the onstat -g wmx command to display all of the mutexes with waiters. - onstat -g wst command: Print wait statistics for threads
Use the onstat -g wst command to show the wait statistics for the threads within the system.
Parent topic: The onstat utility
Related information: