The DB2T10 query generates two daily charts for each DB2 Region. The charts shows resource usage for the top nn (default 10) DB2 Plans by count of threads initiated. Both charts show the number of threads initiated, using vertical bars. One of the charts shows the number of GETPAGE requests, and the other chart shows Class 1, Class 2, and Specialty engine CPU time use for the top ten plans.
The top example shows the daily GETPAGE and thread count for DB2 region D81A running on SYSID CA31. DB2 Plan "LATB140S" only had 27 threads initiated, but had almost eight million GETPAGE requests.
The second example shows the CPU time use for the same DB2 region. DB2 Plan "RCMOR121" used the most Class 1 CPU Time—3.65 minutes.
|
Copyright © 2014 CA.
All rights reserved.
|
|