SQLCODEs - fields (ISPF)
This topic describes the fields that are available for use on the various SQLCODEs panels.
- QM Subsystem
- The active Query Monitor subsystem ID.
- Interval Start Date/Time
- The date (MM/DD/YYYY) and time (HH:MM:SS) that the interval started.
- Interval End Date/Time
- The date (MM/DD/YYYY) and time (HH:MM:SS) that the interval ended. This value is always CURRENT when viewing activity using option A (View Current Activity).
- Group By
- The method by which information is grouped and displayed on the DB2 QM SQL Code Summary panel. Valid Group By options are:
- P - Plan
- Group by plan.
- D - DBRM/Package
- Group by DBRM package.
- A - AuthID
- Group by authorization ID.
- S - SQLCODE
- Show each SQLCODE and the number of times it occurred during the displayed interval.
- I - CORRID
- Group by CORRID.
- N - CORRNAME
- Group by CORRNAME.
- No Grouping (Group by *)
- If you select No Grouping, the DB2® QM SQL Code Detail Display panel is displayed and shows SQLCODE information without any grouping.