SETUP options

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.