Using the Product in a DB2 Environment › Analyze DB2 Data › Command Descriptions for the DB2View Panel

Command Descriptions for the DB2View Panel

The commands available on the DB2View panel are described next.

ADDHelp

Invokes the content-sensitive Help application to update or create a help entry for the selected content.

SQL all/sampled

Switches between sample-based statements (which CA Mainframe Application Tuner measured), or intercept-based data (all statements that executed). The current display mode is indicated by SQL: field

SEQuence

Switches between how the data is sorted (by measured activity or sequence of EXECUTION) and is shown in the Sort: field.

Select (S)

Is the SQL Statements panel, which shows the full text of the selected SQL statement.

Show Declare (SD)

Is the DECLARE Statement panel, which show the DECLARE statement coded by the application programmer for this DB2 verb.

This line command is valid for OPEN, FETCH, and CLOSE statements and UPDATE/DELETE statements that contain the clause WHERE CURRENT OF <cursor_name>. This command is not valid when DB2NOCAT=YES is specified. Customization for the Explain function must be completed.

Explain (E)

Interacts with the Explain panel for the SQL statement. Customization for the Explain function must have been completed.

Code Details (C)

Displays the CodeView Detail panel. The CodeView Detail panel reports the activity of each Module and CSECT that is associated with the selected DB2 plan/package name and statement number (as active and wait percentages of all samples in the monitor data set).

From the Code Detail panel, you can create a Histogram showing the locations within a CSECT where delays occurred, or you can list the types of delay found within a CSECT.

Explain Information (I)

Displays the messages that are generated based on the results of the DB2 EXPLAIN command. For more information, see Displaying Messages.

If the statement has an associated DECLARE CURSOR indicated by a number in the Declare Stmt column, the Explain data will be from the DECLARE CURSOR and not from the statement itself.

Statement Detail (D)

Displays the contents of the row in tabular format in the DB2 Statement Detail panel. Each field name and its value are shown. Zero , blank, and N/A entries are skipped.

If a long name value exists, you can then use line command N from the DB2 Statement Detail panel to display the complete long name.