Monitoring modes
You can use Apptune in Basic or Advanced monitoring mode.
Basic mode generates basic metrics across the subsystem. It provides support for capturing errors and selectively activating the capture of advanced metrics based on the program, user, and correlation ID. Basic mode without error detection does not inject collection routines into the SQL execution path. You can achieve the lowest possible overhead in the Db2 thread by running Basic mode.
Advanced mode generates advanced metrics as per 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 Apptune monitoring starts automatically, or if you use the APPON command without specifying any value for MODE, Apptune runs in the default mode provided in the DOMPLEX option sets for that Db2 subsystem.
When you view Apptune 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-reports 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 | Basic mode | Hybrid mode |
|---|---|---|---|
Db2 Subsystem ID | SQMCACTS | SQMCBASS - BASIC ANALYSIS SUBSYSTEM | SQMHYBRD - HYBRID WORKLOAD ANALYSIS |
Program/DBRM | SQMCACTR | SQMCBASR - BASIC ANALYSIS PROGRAM | Not applicable |
User/Operator ID | SQMCACTU | SQMCBASU - BASIC ANALYSIS USER | Not applicable |
Application Group | SQMCACTG | SQMCBASG - BASIC ANALYSIS APPL GROUP | Not applicable |
SQL Statement | SQMCACTX | SQMCBASX - BASIC ANALYSIS STATEMENT | Not applicable |
SQL Error Code | SQMCERRC | SQMCERRB - BASIC ANALYSIS ERRORS | Not applicable |
Interval | SQMCACTV | SQMCBASV - BASIC ANALYSIS INTERVAL | Not applicable |
Logical Db2 | SQMCACTL | SQMCBASL - BASIC ANALYSIS LOGICAL Db2 | SQMHYBRD - HYBRID WORKLOAD ANALYSIS |
In addition to the reports listed in the preceding table, the following report is also available:
SQMCBAS7 - BASIC ANALYSIS COLLID
From any line in Basic 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 Basic mode or Advanced mode (not intermingled). On each line, "A" zoom corresponds to the Advanced report, and "B" zoom corresponds to the Basic report.