Types of Apptune batch reports
The following
BMC AMI Apptune for Db2
reports generate easy-to-read printed reports. You can generate them in batch mode only.
- Batch SQL Comparison Analysis report (SQMBDIFF) (available if you applied PTF BQU0737)
This report compares performance for the same statement across multiple intervals. The report displays the following:- A text identifier (text hash)
- Statement performance statistics
- The statement text
The product reports statistics for each text hash across each time period that you specify. If you change the statement text, you can do the following:
To do this | Perform this action |
|---|---|
Compare performances of the changed and original versions of statements that ran in in earlier intervals. | Use the TEXTGROUP statement to include both versions of the statement in the comparison. The product compares the statements that you identified by text hash. |
Display only new statements that executed during the latest period and determine the text hash. | Use the NEW keyword in the DOMBRPT1 control statement. |
Batch Active Index With No Reads (SQMBNIDX)
This report shows indexes for the specified database that have had update activity (UPDATE, INSERT, or DELETE), but no READ activity. While indexes can make improve SELECT processing efficiency, update activity can be costly. Use this report to see the indexes that are not used at all for READs. These indexes might generate overhead on the system without conferring any benefit for SELECTs.
Batch Object Detail Analysis (SQMBOBJD)
This report provides access statistics about objects and details of the ten statements that most frequently accessed each object. The report is sorted by GETPAGEs, so you can use the OUTLIM parameter to produce a "Top Ten" report of the most heavily-used objects and the statements that most frequently access them. See Batch-Object-Detail-Analysis-report-example for an example that includes the Batch Object Detail Analysis report.
Batch SQL Statement Analysis (SQMBSTMT)
This report provides details of the SQL statements that consume the most resources. It is sorted by elapsed time, so you can use the OUTLIM parameter to produce a "Top Ten" report of the least-efficient SQL statements. See Batch-SQL-Statement-Analysis-report-example for an example of the Batch SQL Statement Analysis report. See Sort values for batch reporting for a list of measures and formulas you can use for sorting data in this report.
Batch SQL Text (SQMBTEXT)
This report displays all the text of a SQL statement. It is used primarily to display long SQL statements (over 32K). See Batch-SQL-Text-report-example for an example of the Batch SQL Text report.
Batch SQL Exceptions Analysis (SQMBXCEP)
This report displays the SQL text and host variable values for static and dynamic SQL statements that exceed any of the Apptune filter exception thresholds. The report is sorted by the date and time that the exception occurred.
See Batch-SQL-Exceptions-Analysis-report-example for an example of the Batch SQL Exceptions Analysis report.
Related topic