7-78 IBM Informix OnLine Database Server Administrator’s Guide

tbstat: Monitor OnLine Operation

tbstat: Monitor OnLine Operation
Thetbstat utility reads shared-memory structures and provides statistics that
areaccurate at the instant that the command executes. The contents of shared
memory might change as thetbstat output displays. The tbstat utility does
not place any locks on shared memory so running the utility does not affect
performance.For information about disk usage and data storage, refer to the
tbcheckoptions described in the table in the section beginning on page 7-36.
The table below lists eachtbstat option flag and its function.
Topic or Function Option Flag
Alltbstat options --
Big buffer reads -P
Buffers in use -b
Buffers, all (in use or not) -B
Buffers, includes addresses of waiting processes -X
Configuration file information
($INFORMIXDIR/etc/$TBCONFIG)-c
Dbspace chunks, general information -d
Dbspace chunks, pages reads/writes -D
Latches -s
Locks held -k
Logging information (logical and physical logs, including page
addresses) -l
LRU queues -R
OnLine message log -m
OnLine profile of activity -p
Repeat thistbstat command periodically -r
(1 of 2)