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.
onstat -g act command: Print active threads onstat -g act command to display information about the active threads.onstat -g afr command: Print allocated memory fragments 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 onstat -g all command to gather diagnostic information if advised to do so by HCL Support. For normal administrative purposes, use the onstat -g command with individual options. onstat -g arc command: Print archive status 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 onstat -g ath command to display information about all threads.onstat -g bth and -g BTH: Print blocked and waiting threads 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 onstat -g buf command to show profile information for each buffer pool.onstat -g cac command: Print information about caches 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 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 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 onstat -g cluster command to display information about the servers in a high-availability cluster environment.onstat -g cmsm command: Print Connection Manager information 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 onstat -g con command to display information about conditions and the threads that are waiting for the conditions.onstat -g cpu: Print runtime statistics 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 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 onstat -g defragment command to display information about the active requests to defragment partition extents.onstat -g dic command: Print table information 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 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 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 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 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 onstat -g dsc command to display information about the distribution cache.onstat -g dsk command: Print the progress of the currently running compression operation 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 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 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 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 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 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 onstat -g iob command to display a summary of big buffer use. onstat -g iof command: Print asynchronous I/O statistics onstat -g iof command to display the asynchronous I/O statistics by chunk or file. onstat -g iog command: Print AIO global information onstat -g iog command to display global information about AIO.onstat -g ioq command: Print I/O queue information 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 onstat -g ipl command to display information about the status of index page logging.onstat -g iov command: Print AIO VP statistics onstat -g iov command to display asynchronous I/O statistics for each virtual processor.onstat -g lap command: Print light appends status information 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 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 onstat -g lmm command to display information about automatic low memory management settings and recent activity.onstat -g lmx command: Print all locked mutexes onstat -g lmx command to display information about all locked mutexes.onstat -g lsc command: Print active light scan status (deprecated) onstat -g lsc command has been superseded by the onstat -g scn command. onstat -g mem command: Print pool memory statistics onstat -g mem command to display the memory statistics for a pool.onstat -g mgm command: Print MGM resource information onstat -g mgm command to show resource information about Memory Grant Manager (MGM). onstat -g nbm command: Print a block bit map onstat -g nbm command to display the block bit map for the nonresident segments.onstat -g nsc command: Print current shared memory connection information 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 onstat -g nsd command to display information about shared-memory data for poll threads.onstat -g nss command: Print shared memory network connections status onstat -g nss sessionid command to display information about the status of the shared memory network connections.onstat -g ntd command: Print network statistics onstat -g ntd command to display network statistics by service.onstat -g ntm command: Print network mail statistics onstat -g ntm command to display statistics about network mail.onstat -g ntt command: Print network user times onstat -g ntt command to display information about network user times.onstat -g ntu command: Print network user statistics onstat -g ntu command to display information about network user statistics.onstat -g opn command: Print open partitions 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 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 onstat -g pd command to display information about the push data session.onstat -g pd event command: Print push data event-related information onstat -g pd event command to display information about the push data event.onstat -g pos command: Print file values onstat -g pos command to display the values in the $INFORMIXDIR/etc/.infos.DBSERVERNAME file.onstat -g ppd command: Print partition compression dictionary information 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 onstat -g ppf partition_number onstat -g pqs command: Print operators for all SQL queries 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 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 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 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 onstat -g rah command to display information about read-ahead requests.onstat -g rbm command: Print a block map of shared memory 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 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 onstat -g rss commands to display information about remote standalone secondary servers.onstat -g rwm command: Print read and write mutexes 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 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 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 onstat -g sds command to display information about shared-disk secondary servers.onstat -g seg command: Print shared memory segment statistics onstat -g seg command to show the statistics for shared memory segments.onstat -g ses command: Print session-related information onstat -g ses command to display information about the session.onstat -g shard command: Print information about the shard definition onstat -g shard command to display information about the sharding definition.onstat -g sle command: Print all sleeping threads onstat -g sle command to print all sleeping threads.onstat -g smb command: Print sbspaces information onstat -g smb command to display detailed information about sbspaces. onstat -g smx command: Print multiplexer group information 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 onstat -g spi command to display information about spin locks with long spins.onstat -g sql command: Print SQL-related session information onstat -g sql command to display SQL-related information about a session. onstat -g spf: Print prepared statement profiles onstat -g spf command to display current statistics about SQL queries.onstat -g src command: Patterns in shared memory onstat -g src command to search for patterns in shared memory.onstat -g ssc command: Print SQL statement occurrences 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 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 onstat -g stm command to display the memory that each prepared SQL statement uses. onstat -g stq command: Print queue information onstat -g stq command to display information about the queue. onstat -g sts command: Print stack usage for each thread 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 onstat -g sym command to display symbol table information for the oninit utility.onstat -g tpf command: Print thread profiles onstat -g tpf command to display thread profiles.onstat -g ufr command: Print memory pool fragments 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 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 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 onstat -g wmx command to display all of the mutexes with waiters.onstat -g wst command: Print wait statistics for threads onstat -g wst command to show the wait statistics for the threads within the system. Have feedback? Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.