onstat -g tpf Thread Profiles

The onstat -g tpf command displays the profiles for threads which have an RSAM thread control block (rstcb).

Thread profiles                                                                 
tid lkreqs lkw dl to lgrs isrd iswr isrw isdl isct isrb lx bfr bfw lsus lsmx seq
0   3      0   0  0  1163 0    0    0    0    0    0    0  3236 159 381900 0   
0                                                                             
0   0      0   0  0  0    0    0    0    0    0    0    0  0   0   0    0    0  
0   0      0   0  0  0    0    0    0    0    0    0    0  0   0   0    0    0  
519 1356   0   0  0  112  15039 70   1    13   3    0    0  54882 254 0  4928 79 
520 2049   0   0  0  95   14338 201  6    19   4    0    0  64668 557 0  14820 111
6931 131    0   0  0  6    58   0    2    0    2    0    0  148 2   0    132  0
768 1461   0   0  0  134  64886 519  9    17   7    0    0  214752 1331 0  4872 141
2760 3585   0   0  0  372  18909 381  5    79   4    0    0  74269 1102 0  59192 120 

Output Description

Heading Description Format See Also
tid The thread ID. Dec onstat -u
lkreqs The number of lock requests. Dec onstat -p
lkw The number of lock waits. Dec onstat -p
dl The number of deadlock conditions. Dec onstat -p
to The number of deadlock timeouts. Dec onstat -p
lgrs The number of log records written. Dec onstat -l
isrd The number of read calls. Dec onstat -p
iswr The number of write calls. Dec onstat -p
isrw The number of re-write (update) calls. Dec onstat -p
isdl The number of delete calls. Dec onstat -p
isct The number of commits. Dec onstat -p
isrb The number of rollbacks. Dec onstat -p
lx The number of long transactions. Dec onstat -l
bfr The number of buffer reads. Dec onstat -p
bfw The number of buffer writes. Dec onstat -p
lsus The amount of log space currently used. Dec onstat -l
lsmx The maximum amount of log space ever used by this thread. Dec onstat -l
seq The number of sequential scans. Dec onstat -p

Notes

    Information is relative to the time the thread became active or the last onstat -z command.

Monitoring and Tuning

    The onstat -g tpf command will take a thread ID as an optional argument. By monitoring the change in values for one or more threads, it is possible to determine the amount of work being performed.