Other Total Calls 1 Avg Elapsed 0.000470 Avg CPU 0.000170
#Old Pages 127 #New Pages 2
- Commit
-
- Count
- Number of Commit requests (field: WTASCMN).
- Avg Elapsed
- Average Commit elapsed time (field: WTASCMET/WTASCMN).
- Avg CPU
- Average Commit CPU time (field: WTASCMCT/WTASCMN).
- Backout
-
- Count
- Number of Backout calls (field: WTASBAN).
- Avg Elapsed
- Average Backout elapsed time (field: WTASBAET/WTASBAN).
- Avg CPU
- Average Backout CPU time (field: WTASBACT/WTASBAN).
- P/S 0
- Page Set 00 logging activity
- Count
- Number of logging requests (field: WTASPSN0).
- Avg Elapsed
- Average logging request elapsed time (WTASPSE0/WTASPSN0).
- Latch
-
- Count Max
- Maximum number of times a latch wait occurred (field: WTASLWN).
- Elapsed Max
- Average maximum latch wait time (field: WTASMLW/WTASLWN).
- Other
- Non-queue other statistics.
- Total Calls
- Total number of 'Other' calls (field: WTASOTN).
- Av Elapsed
- Average elapsed time per 'Other' call (field: WTASOTET/WTASOTN).
- Av CPU
- Average CPU time per 'Other' call (field: WTASOTCT/WTASOTN).
- #Old Pages
- Number of old pages retrieved (field: WTASGPO).
- #New Pages
- Number of new pages retrieved (field: WTASGPN).
- Jnl/Log
-
- Bytes
- Total number of bytes written to the Journal (field: WTASJWB).
- FORCEs
- Total number of times the log was forced (field: WTASJCN).
- Avg WAIT Elp
- Average elapsed time waiting for the log to be forced (field:
WTASJCET/WTASJCN).
- Avg SUSPEND Elp
- Average suspend time (field: WTASSUSE/WTASJCN).
- DB2® Mgr
-
- Requests
- Total number of DB2 calls
(field: WTASDBCT).
- Avg Jnl/Log Thread Elapsed
- Average elapsed time per DB2 call
(field: WTASDBET/WTASDBCT).
- Avg Jnl/Log Server Elapsed
- Average server elapsed time per DB2 call
(field: WTASDBES/WTASDBCT).
- Jnl/Log Thd Elp (Max)
- Maximum DB2 thread elapsed
time (field: WTASDBMT).
- Jnl/Log Svr Elp (Max)
- Maximum DB2 server elapsed
time (field: WTASDBMS).