Application Performance Analyzer for z/OS, Version 11.1, User's Guide

Detail line descriptions

SQL DBRM (Module) detail line

This is the first-level detail line. Each line shows information about a DBRM (Module) for which SQL request measurement data was recorded.

Under Heading This is Displayed
Name The DBRM name. The DBRM name is often the same name as the corresponding module in which SQL requests were issued.
Percent of Time The percentage of the measurement interval duration SQL Requests for the indicated DBRM Name were being processed.

SQL request detail line

This is the second-level detail line shown directly under the DBRM/Module detail line. It quantifies the aggregated service time for a specific SQL request.

Under Heading This is Displayed
Name A sequence number. This is assigned by Application Performance Analyzer to uniquely identify the SQL request. Either "S" or "D" precedes the sequence number indicating if the SQL statement is static or dynamic.
Stmt# The precompiler statement number. This is the statement number assigned by the precompiler to the SQL request.
SQL Function The SQL function. The is the name of the SQL function: SELECT, FETCH, UPDATE, etc.
Percent of Time The percentage of the measurement interval duration the indicated SQL Request was being processed.
Note:
It is normal for the counts for the second-level items to add up to a higher value than the first level line. The reason for this is that the program level line shows the percentage of time DB2® processing is active. For a sample, DB2 is counted as being active only once, regardless of the number of SQL statements being processed (concurrently). So its percentage can be lower than the sum of the individual SQL request statement percentages because of overlaps.

SQL statement text detail line

This is third-level detail line shown directly under the SQL request detail line. It shows the SQL statement text. If necessary, more than one line is displayed in order to show the full SQL text.




Rate this page

[ Top of Page | Previous Page | Next Page | Contents | Index ]