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
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 |
To discuss how Oninit ® can assist please call on +1-913-674-0360 or alternatively just send an email specifying your requirements.