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.