questions onstat -g

Where can I find reading about meanings of onstat -g ... columns. By example onstat -g ioq: dskcopy onstat -g sch: busy wait, spin/waits

Is this a trick question? Type onstat -g at the prompt and you will be presented with the options and descriptions of each. Of course there are so many options, pipe it to a page break, i.e. | pg or | more. Is that the answer you are a looking for? Or how about this? (I don't know...is it legal for me to reprint part of the manual without permission?) 35-76 Administrator's Guide for Informix Dynamic Server -g Monitoring Options The following onstat -g options are provided for support and debugging only. You can include only one of these options per onstat -g command: act Prints active threads. 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. See -mem option for pool name. all Prints all multithreading information. ath Prints all threads. The sqlmain threads represent client sessions, and the rstcb value corresponds to the user field of the onstat -u command. con Prints conditions with waiters. dic table Without any parameters, this option will print one line of information for each table cached in the shared-memory dictionary. If given a specific table name as a parameter, it will print internal SQL information for that table. dll Prints a list of dynamic libraries that have been loaded. dri Prints data-replication information. (See "Monitoring High-Availability Data-Replication Status" on page 29-71 for a description of the information that is displayed.) dsc Prints data-distribution cache information. ffr pool name | session id Prints free fragments for a pool of shared memory. glo Prints global multithreading information. This information includes CPU use information about the virtual processors, the total number of sessions, and other multi-threading global counters. iob Prints big-buffer use by I/O virtual processor class. iof Prints asynchronous I/O statistics by chunk/file. This option is similar to -d option, except that information on nonchunk files is also displayed. I t includes information about temporary files and sort-work files. iog Prints asynchronous I/O global information. ioq Prints asynchronous I/O queuing statistics. iov Prints asynchronous I/O statistics by virtual processor. lmx Prints all locked mutexes. mem pool name | session id Prints memory statistics for a pool. Session pools are named with the session number. If no argument is provided, information about all pools is displayed. mgm Print MGM resource information. nbm Prints block bit map for the nonresident segments, one bit per 8-kilobyte block. Bit set indicates block free. nsc client id Prints shared-memory status by client id. If client id is omitted, all client status areas are displayed. nsd Prints network shared-memory data for poll threads. nss session id Prints network shared- memory status by session id. If session id is omitted, all session status areas are displayed. ntd Prints network statistics by service. ntm Prints network mail statistics. ntt Prints network user times. ntu Prints network user statistics. pos Prints .infos.DBSERVERNAME file. ppf partition number | 0 Prints partition profile for partition number; 0 prints profiles for all partitions. prc Prints stored procedure cache information. qst Prints queue statistics. rbm Prints block bit map for the resident segment (communication message area). rea Prints ready threads. sch For each virtual processor, this command prints the number of semaphore operations, spins, and busy waits. seg Prints shared-memory-segment statistics. This option shows how many segments are attached and their sizes. ses session id Prints session information by session id. If it is missing, a one-line summary of each session is printed. sle Prints all sleeping threads. 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 an internal problem. To reduce longspins, reduce the number of (generally class CPU) virtual processors, reduce the load on the computer, or use the no-age or processor affinity features. sql session id Prints SQL information by session id. If session id is omitted, a one-line summary for each session is printed. stk tid Dumps stack of specified thread specified by thread ID. This option is not supported on all platforms and is not always accurate. sts Prints maximum and current stack use per thread. tpf tid Prints thread profile for tid; 0 prints profiles for all threads. ufr pool name | session id Prints allocated fragments by use. wai Prints waiting threads; all threads waiting on mutex or condition, or yielding. wmx Prints all mutexes with waiters. wst Prints wait statistics. "Marat S. Salimov" <maratkotik@mail.ru> wrote in message news:3A1A86EF.5BF41204@mail.ru... > Where can I find reading about meanings of onstat -g ... columns. > By example > onstat -g ioq: dskcopy > onstat -g sch: busy wait, spin/waits