Other Avg Count 1.0 Avg Elapsed 0.018721 Avg CPU 0.000258
Avg #Old Pages 120.0 Avg #New Pages 0.0
- Commit
-
- Count
- Average Commit requests per thread (field: WTASCMN/Number of threads).
- Avg Elapsed
- Average Commit elapsed time per thread (field: WTASCMET/Number
of threads).
- Avg CPU
- Average Commit CPU time per thread (field: WTASCMCT/Number of
threads).
- Backout
-
- Count
- Average Backout calls per thread (field: WTASBAN/Number of threads).
- Avg Elapsed
- Average Backout elapsed time per thread (field: WTASCBAET/Number
of threads).
- Avg CPU
- Average Backout CPU time per thread (field: WTASCBACT/Number of
threads).
- P/S 0
- Page Set 00 logging activity.
- Count
- Average number of P/S 0 logging requests per thread (field: WTASPSN0/Number
of threads).
- Avg Elapsed
- Average P/S 0 logging elapsed time per thread (field: WTASPSE0/Number
of threads).
- Latch
-
- Count Max
- The highest latch class for which the longest waiting elapsed
time occurred.
- Elapsed Max
- Average elapsed time processing commit requests per thread (field:
WTASCMET/Number of threads).
- Other
- Non-queue other statistics.
- Total Calls
- Average number of 'Other' calls per thread (field: WTASOTN/Number
of threads).
- Av Elapsed
- Average 'Other' calls elapsed time per thread (field: WTASOTET/Number
of threads).
- Av CPU
- Average 'Other' calls CPU time per thread (field: WTASOTCT/Number
of threads).
- #Old Pages
- Average number of old pages retrieved per thread (field: WTASGPO/Number
of threads).
- #New Pages
- Average number of new pages retrieved per thread (field: WTASGPN/Number
of threads).
- Jnl/Log
-
- Bytes
- Average number of bytes written to the Journal per thread (field:
WTASJWB/Number of threads).
- FORCEs
- Average number of times the log was forced per thread (field:
WTASJCN/Number of threads).
- Avg WAIT Elp
- Average elapsed time waiting for the log to be forced per thread
(field: WTASJWET/Number of threads)
- Avg SUSPEND Elp
- Average suspend time per thread (field: WTASSUSE/Number of threads).
- DB2® Mgr
-
- Requests
- Average number of DB2 calls
per thread (field: WTASDBCT/Number of threads).
- Avg Jnl/Log Thread Elapsed
- Average DB2 calls elapsed
time per thread (field: WTASCDBET/Number of threads).
- Avg Jnl/Log Server Elapsed
- Average DB2 calls server
elapsed time per thread (field: WTASCDBES/Number of threads).
- Jnl/Log Thd Elp (Max)
- Maximum DB2 thread elapsed
time.
- Jnl/Log Svr Elp (Max)
- Maximum DB2 server elapsed
time.
- CF Mgr
-
- Avg Count (IXLLSTE)
- Average number of IXLLSTE calls per thread (field: WTASCSEC/Number
of threads).
- Avg Redrives (IXLLSTE)
- Average number of IXLLSTE redrives per thread (field: WTASRSEC/Number
of threads).
- Avg Count (IXLLSTM)
- Average number of IXLLSTM calls per thread (field: WTASCMEC/Number
of threads).
- Avg Redrives (IXLLSTM)
- Average number of IXLLSTM redrives per thread (field: WTASRMEC/Number
of threads).