Monitoring modes
You can use in standard or advanced monitoring mode.
Standard mode generates standard metrics across the subsystem. The metrics are based on the contents of the dynamic statement cache for dynamic statements, and the environmental descriptor manager (EDM) pool skeleton package tables for static statements. Standard mode does not filter data; it monitors all dynamic and static statements. It also supports error capture and allows selective activation of advanced metrics based on the program, user, and correlation ID. Standard mode without error detection does not inject collection routines into the SQL execution path. Running standard mode ensures the lowest possible overhead in the Db2 thread.
Advanced mode generates advanced metrics in accordance with the Apptune filter specifications. This is the default mode.
You must establish the mode at the subsystem level. The setting for the subsystem in the DOMPLEX option set determines the default monitoring mode. You can override this by using the APPON command. If monitoring starts automatically, or if you use the APPON command without specifying any value for MODE, runs in the default mode provided in the DOMPLEX option sets for that Db2 subsystem.
When you view reports, by default the reports reflect the monitoring mode in the intervals selected. You can also explicitly set the initial reporting mode by selecting option 2 (Initial report) from the SQL Workload Analysis Menu panel. For more information, see Workload-analysis-tasks and Preparing-for-workload-analysis.
The name of the initial report is determined by the combination of the selected initial report and mode. In the following table, any initial report not listed requires Advanced mode, and there is no change in the initial report.
Initial report | Advanced mode | Standard mode | Hybrid mode |
|---|---|---|---|
Db2 Subsystem ID | SQMCACTS | SQMCBASS - STANDARD ANALYSIS SUBSYSTEM | SQMHYBRD - HYBRID WORKLOAD ANALYSIS |
Program/DBRM | SQMCACTR | SQMCBASR - STANDARD ANALYSIS PROGRAM | Not applicable |
User/Operator ID | SQMCACTU | SQMCBASU - STANDARD ANALYSIS USER | Not applicable |
Application Group | SQMCACTG | SQMCBASG - STANDARD ANALYSIS APPL GROUP | Not applicable |
SQL Statement | SQMCACTX | SQMCBASX - STANDARD ANALYSIS STATEMENT | Not applicable |
SQL Error Code | SQMCERRC | SQMCERRB - STANDARD ANALYSIS ERRORS | Not applicable |
Interval | SQMCACTV | SQMCBASV - STANDARD ANALYSIS INTERVAL | Not applicable |
Logical Db2 | SQMCACTL | SQMCBASL - STANDARD ANALYSIS LOGICAL Db2 | SQMHYBRD - HYBRID WORKLOAD ANALYSIS |
In addition to the reports listed in the preceding table, the following report is also available:
SQMCBAS7 - STANDRAD ANALYSIS COLLID
From any line in Standard mode reports, you can display all basic statistics using T-Detl expand, errors using E-Errors zoom, and the corresponding advanced report using 9-Advanced zoom. You can traverse zooms by using the same convention as advanced reports (7 for COLLID).
SQMHYBRD displays one line per Db2 subsystem grouped by logical Db2 or data-sharing group. Each line includes columns for mode, SQL calls, elapsed and CPU time, getpages and wait time. The values reported on each line are the totals from Standard mode or Advanced mode (not intermingled). On each line, "A" zoom corresponds to the Advanced report, and "B" zoom corresponds to the Standard report.