The following onstat -g options are provided for support and debugging only. You can include only one of these options per onstat -g command. For more information, see your IBM Informix Performance Guide.
| onstat -g Option | Topic or Function |
|---|---|
| -g act | Prints active threads. For example output, see The onstat -g act Option. |
| -g afr pool name | session id | Prints allocated memory fragments for a specified session or shared-memory pool. Each session is allocated a pool of shared memory. To obtain the pool name, see the -mem option. For example output, see The onstat -g afr pool name | session id Option. |
| -g all | Prints all multithreading information. |
| -g ath | Prints all threads. The sqlmain threads represent client sessions. The rstcb value corresponds to the user field of the onstat -u command. For example output, see The onstat -g ath Option. For information on using onstat -g ath to print Enterprise Replication threads, see the IBM Informix Dynamic Server Enterprise Replication Guide. |
| -g cat [modifier] | Prints information from the Enterprise Replication global catalog. The global catalog contains a summary of information about the defined servers, replicates, and replicate sets on each of the servers within the enterprise. For more information and sample output, see The onstat -g cat Option. |
| -g cac agg | Prints the definitions for user-defined aggregates that are currently in the cache. |
| -g cac stmt | Prints the contents of the SQL statement cache. Prints the same output as the -g ssc statement. |
| -g con | Prints conditions with waiters. For example output, see The onstat -g con Option. |
| -g ddr | Prints the status of the Enterprise Replication database log reader. If log reading is blocked, data might not be replicated until the problem is resolved. For more information and sample output, see The onstat -g ddr Option. |
| -g dic table | Without any parameters, prints one line of information for each table cached in the shared-memory dictionary. If given a specific table name as a parameter, prints internal SQL information for that table. For more information, see your IBM Informix Performance Guide. For sample output, see The onstat -g dic table Option. |
| -g dis | Prints a list of database servers and their status, and information about each database server, INFORMIXDIR, sqlhosts file, ONCONFIG file, and hostname. For example output, see The onstat -g dis Option. |
| -g dll | Prints a list of dynamic libraries that have been loaded. For example output, see The onstat -g dis Option. |
| -g dri | Prints data-replication information. See monitoring High-Availability Data-Replication status in the IBM Informix Administrator's Guide. For example output, see The onstat -g dri Option. |
| -g dsc | Prints data-distribution cache information. For example output, see The onstat -g dsc Option. |
| -g dss [modifier] | Prints detailed statistical information about the activity of individual data sync threads and about user-defined data types. For more information and sample output, see The onstat -g dss Option. |
| -g dtc | Prints statistics about the delete table cleaner which removes rows from the delete table when they are no longer needed. For more information and sample output, see The onstat -g dtc Option. |
| -g env | Prints the values of environment variables the database server currently uses. For more information, see The onstat -g env Option. |
| -g ffr pool name | session id | Prints free fragments for a pool of shared memory. For example output, see The onstat -g ffr pool name | session id Option. |
| -g glo | Prints global multithreading information. This information includes CPU use information about the virtual processors, the total number of sessions, and other multithreading global counters. On Windows, the virtual processors are operating system threads. The values displayed under the 'pid' field are thread ids not process ids. (Windows). For example output, see The onstat -g glo Option. |
| -g grp [modifier] | Prints statistics about the Enterprise Replication grouper. The grouper evaluates the log records, rebuilds the individual log records into the original transaction, packages the transaction, and queues the transaction for transmission. For more information and sample output, see The onstat -g grp Option. |
| -g imc | Prints information about MaxConnect instances that are connected to the database server. If MaxConnect is not connected to the database server, this command displays No MaxConnect servers are connected. |
| -g ioa | Prints combined information from -g ioq and -g iov. For example output, see The onstat -g ioa Option. |
| -g iob | Prints the big buffer usage summary. For example output, see The onstat -g iob Option. |
| -g iof | Prints asynchronous I/O statistics by chunk or file. This option is similar to the -D option, except it also displays information on nonchunk, temporary, and sort-work files. For example output, see The onstat -g iof Option. |
| -g iog | Prints AIO global information. For example output, see The onstat -g iog Option. |
| -g ioq queue name | Prints pending I/O operations for the queue name. If given the gfd or kaio queue name, a queue for each CPU VP is displayed. If queue name is omitted, I/O statistics for all queues are displayed. For example output, see The onstat -g ioq queue name Option. |
| -g iov | Prints asynchronous I/O statistics by virtual processor. For example output, see The onstat -g iov Option. |
| -g lmx | Prints all locked mutexes. For example output, see The onstat -g lmx Option. |
| -g lsc | Displays information about light scans. |
| -g mem pool name | session id | Prints statistics for a memory pool. Also displays the pool name, type of shared memory segment that contains the pool, the address of the pool, the total size of the pool, the number of bytes of free memory that it contains, and the number of free and allocated fragments in the pool. If no argument is provided, displays information about all pools. The block pools are listed in a separate section after the main pool list. You also can use ISA to obtain detailed information about a memory pool. If you run an SQL query that allocates memory from the PER_STMT_EXEC and PER_STMT_PREP memory duration pools, onstat -g mem displays information on the PRP.sessionid.threadid pool and the EXE.sessionid.threadid pool. For example output, see The onstat -g mem pool name | session id Option. For more information, see the IBM Informix DataBlade API Programmer's Guide. |
| -g mgm | Prints Memory Grant Manager resource information. For example output, see The onstat -g mgm Option. |
| -g nbm | Prints block bit map for the nonresident segments, one bit per 8-kilobyte block. Bit set indicates block free. For example output, see The onstat -g nbm Option. |
| -g nif [modifier] | Prints statistics about the network interface. Useful to determine why data is not replicating. For more information and sample output, see The onstat -g nif Option. |
| -g nsc client id | Prints shared-memory status by client id. If client id is omitted, all client status areas are displayed. This command prints the same status data as the nss command. For example output, see The onstat -g nsc client_id Option. |
| -g nsd | Prints network shared-memory data for poll threads. For example output, see The onstat -g nsd Option. |
| -g nss session id | Prints network shared-memory status by session id. If session id is omitted, all session status areas are displayed. This command prints the same status data as the nsc command. |
| -g nta | Prints combined network statistics from -g ntd, -g ntm, -g ntt, and -g ntu. If MaxConnect is installed, this command prints statistics that you can use to tune MaxConnect performance. |
| -g ntd | Prints network statistics by service. For example output, see The onstat -g ntd Option. |
| -g ntm | Prints network mail statistics. For example output, see The onstat -g ntm Option. |
| -g ntt | Prints network user times. For example output, see The onstat -g ntt Option. |
| -g ntu | Prints network user statistics. For example output, see The onstat -g ntu Option. |
| -g pos | Prints $INFORMIXDIR/etc/ .infos.DBSERVERNAME file for UNIX and %INFORMIXDIR%\etc\ .infos.DBSERVERNAME for Windows. For example output, see The onstat -g pos Option. |
| -g ppf partition number | 0 | Prints partition profile for partition number; 0 prints profiles for all partitions. If TBLSPACE_STATS configuration parameter is set to 0, displays: Partition profiles is disabled. For example output, see The onstat -g ppf partition number | 0 Option. |
| -g prc | Prints information about SPL routine cache. For example output, see The onstat -g prc Option. |
| -g qst | Prints queue statistics. |
| -g que | Prints statistics for the high-level queue interface (which are common to all the queues of the Enterprise Replication Queue Manager. For more information and sample output, see The onstat -g que Option. |
| -g rbm | Prints block bit map for the resident segment (communication message area). For example output, see The onstat -g rbm Option. |
| -g rcv [serverid] | Prints statistics about the receive manager, which is a set of service routines between the receive queues and data sync. For more information and sample output, see The onstat -g rcv Option. |
| -g rea | Prints ready threads. For example output, see The onstat -g rea Option. |
| -g rep [replname] | Prints events that are in the queue for the schedule manager. For more information and sample output, see The onstat -g rep Option. |
| -g rqm [modifier] | Prints statistics and contents of the low-level queues (each individual queue) managed by the Reliable Queue Manager (RQM). For more information and sample output, see The onstat -g rqm Option. |
| -g rwm | Prints read/write mutexes. For example output, see The onstat -g rwm Option. |
| -g sch | Prints the number of semaphore operations, spins, and busy waits for each virtual processor. On Windows, the virtual processors are operating system threads. The values displayed under the 'pid' field are thread ids not process ids. (Windows) For example output, see The onstat -g sch Option. |
| -g seg | Prints shared-memory-segment statistics. This option shows the number and size of shared-memory segments that the database server is currently using. For example output, see The onstat -g seg Option. |
| -g ses sessionid | Prints session information by sessionid. If sessionid is missing, a one-line summary of each session prints. For more information, see The onstat -g ses Option. |
| -g sle | Prints all sleeping threads. For example output, see The onstat -g sle Option. |
| -g smb option | Prints detailed information about sbspaces:
|
| -g spi | Prints spin locks that virtual processors have spun more than 10,000 times to acquire. These spin locks are called longspins. The total number of longspins is printed in the heading of the glo command. Excessive longspins might indicate an overloaded system, too many virtual processors for a given computer or node, or an internal problem. To reduce longspins, reduce the number of virtual processors (generally class CPU), reduce the load on the computer, or use the no-age or processor affinity features. |
| -g sql session id | Prints SQL information by session id. If session id is omitted, a one-line summary for each session prints. For more information, see The onstat -g sql Option. |
| -g ssc | Monitors the number of times that the database server reads
the SQL statement in the cache. For example output, see The onstat -g ssc Option
Displays the same output as onstat -g cac stmt. For more information, see improving query performance in the IBM Informix Performance Guide. |
| -g ssc all | Reports the key-only cache entries
as well as the fully cached statements. If the value in the hits column is less than the STMT_CACHE_HITS value, that entry is a key-only cache entry.
For more information, see memory utilization in the IBM Informix Performance Guide. |
| -g ssc pool | Reports usage of all memory pools for the SQL statement
cache. The output displays information on the name, class, address, and total
size of the memory pools.
For more information, see improving query performance in the IBM Informix Performance Guide. |
| -g stk tid | all | Dumps stack of thread specified by thread ID or stacks for all threads. This option is not supported on all platforms and is not always accurate. For example output, see The onstat -g stk tid Option. |
| -g stm [session id] | Displays the memory that each prepared SQL statement
uses. For example output, see The onstat -g stm Option.
For more information, see memory utilization and improving query performance in the IBM Informix Performance Guide. |
| -g sts | Prints maximum and current stack use per thread. For example output, see The onstat -g sts Option. |
| 4-g sync | 4Shows which sync is active. For example output, see The onstat -g sync Option. |
| -g tpf tid | Prints thread profile for a specific thread ID. For example output, see The onstat -g tpf tid Option. |
| -g ufr pool name | session id | Prints allocated fragments by use. |
| -g wai | Prints waiting threads; all threads waiting on mutex or condition, or yielding. |
| -g wmx | Prints all mutexes with waiters. For example output, see The onstat -g wmx Option. |
| -g wst | Prints wait statistics. |