CA MICS Analyzer Option for DB2 (DB2) Queries › DB2T10 – DB2 Daily Top Ten Plans by Thread Count › Data Extracts

Previous Topic: Uses

Next Topic: Query Defaults

Data Extracts

DB2 Daily Top 10 Plans Threads and GPage

Left Y-axis

DSPNTHRD – Count of Threads Initiated

Right Y-axis

DSPSGPGR – Total GETPAGE Requests

X-axis

DB2PLAN – Plan Name

DB2 Daily Top 10 Plans Threads and CPU

Left Y-axis

DSPNTHRD – Count of Threads Initiated

Right Y-axis

DSPCP1TM – Total CP Class 1 CPU Time

DSPCP2TM – Total CP Class 2 CPU Time

DSPCPUZ1 – Accum CPU Tm used on z/OS Spec Eng

X-axis

DB2PLAN – Plan Name