Home | Previous Page | Next Page   Administrative Utilities > The onstat Utility > onstat -g Monitoring Options >

The onstat -g tpf tid Option

Prints thread profile for tid; 0 prints profiles for all threads.

Example Output

Figure 99. onstat -g tpf Output 
onstat -g tpf 945
IBM Informix Dynamic Server Version 10.00.UC1 -- On-Line -- Up 00:21:39 -- 29696 Kbytes
Thread profiles
tid lkreqs lkw dl to lgrs isrd iswr isrw isdl isct isrb lx bfr bfw lsus lsmx seq
945 1969   0   0  0  6181 1782 2069 13   0    0    0    0  16183 7348 743580 0    6
Output Description

tid
Thread ID
lkreqs
Lock requests
lkw
Lock waits
dl
Deadlocks
to
Remote deadlock timeout
lgrs
Log records
isrd
Number of reads
iswr
Number of writes
isrw
Number of rewrites
isdl
Number of deletes
isct
Number of commits
isrb
Number of rollbacks
lx
Long transactions
bfr
Buffer reads
bfw
Buffer writes
lsus
Log space currently used
lsmx
Max log space used
seq
Sequence scans
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]