CA MICS Analyzer Option for DB2 (DB2) Queries › DB2T10 – DB2 Daily Top Ten Plans by Thread Count › Modifications
Modifications
The following modifications can be made to the DB2T10 query:
- You can add filter statements to select only a single SYSID or DB2 Region (DB2ID).
- You can adjust the TOPnn value to something other than the default of 10.
- If you do not have the DAYS timespan DB2DSP file active, you can run the query against the DETAIL timespan, Cycles 01 and 02.
