Enter the SETUP primary command to select options for this report.
The following window is displayed:
+-------------------------------------------------------------+
| Options for DB2 SQL CPU/Svc Time by Stmt |
| |
| Enter "/" to select an option |
| / Show SQL statements with a positive SQLCODE |
| (these are successful calls). |
| |
| / Show SQL statements with a negative SQLCODE |
| (these are failed calls). |
| |
| / Show SQL statements by statement number and |
| ignore differences in SQL text. |
| |
| /Display Percent used in place of Mean fields |
| |
+-------------------------------------------------------------+
- Show SQL statements with positive SQLCODE
- This shows SQL statements that end successfully with a zero
or positive SQLCODE. When selected, successful SQL statements are
included in the report.
- Show SQL statements with negative SQLCODE
- This shows SQL statements that are unsuccessful; that is, with
a negative SQLCODE. When selected, unsuccessful SQL statements are
included in the report.
- Show SQL statements by statement number
- This displays dynamic SQL statements consolidated by statement
number and ignores differences in the SQL text. When selected, only
one line is displayed per statement number regardless of the contents
of the SQL text. The detail window for each statement number displays
the SQL information for the first call from this statement.
- Display Percent used in place of Mean fields
- When selected, this displays the percent of total CPU and total
service time used by each SQL statement, rather than the mean time.
[ Top of Page | Previous Page | Next Page | Contents | Index ]