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.
Percent Either Percent of Total Time or Percent of DBRM SQL Time depending on SETUP option. This is the percentage of time that SQL processing for the indicated DBRM was observed to be in WAIT state.

SQL request detail line

This is the second-level detail line shown directly under the DBRM/Module detail line. It quantifies the wait 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 of the SQL statement.
SQL Function The SQL function.
Percent The percentage of the total time or of the DBRM time (depending on SETUP option) for which SQL processing for the indicated statement was in WAIT state.

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 ]