This is the first-level detail line. Each line shows information about a Requester Location for which SQL request measurement data was recorded.
Under Heading | This is Displayed |
---|---|
Name | The Requester Location name. |
Nbr of Calls | The number of SQL calls counted for this Requester Location. |
CPU Time: Total | The total CPU time for all SQL calls counted for this Requester Location. |
CPU Time: Mean | The mean CPU time per SQL call. |
CPU time: Pct | The percent of total CPU time this requestor location used. |
Svc Time: Total | The total service time for all SQL calls for this Requester Location. |
Svc Time: Mean | The mean service time per SQL call. |
Svc time: Pct | The percent of total service time this requestor location used. |
This is the second-level detail line shown directly under the Requester Location detail line. It quantifies an individual SQL statement.
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. |
Plan/Pgm | The DBRM name. |
Stmt# | The precompiler statement number. This is the statement number assigned by the precompiler to the SQL request. When the statement number is zero, it indicates that the SQL statement was not produced by the DB2® precompiler or the SQL preprocessor, but was generated by some other means. For example, JDBC SQL statements have statement numbers that are zero. |
SQL Function | The SQL function. The is the name of the SQL function, SELECT, FETCH, UPDATE, etc. Nbr of Calls The number of SQL calls counted for this SQL statement. |
Nbr of Calls | The number of SQL calls counted for this SQL statement. |
CPU Time: Total | The total CPU time for all SQL calls counted for this statement. |
CPU Time: Mean | The mean CPU time per SQL call. |
CPU time: Pct | The percent of total CPU time this statement used. |
Svc Time: Total | The total service time for all SQL calls for this statement. |
Svc Time: Mean | The mean service time per SQL call. |
Svc time: Pct | The percent of total service time this statement used. |
This is the 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.
[ Top of Page | Previous Page | Next Page | Contents | Index ]