Using the Product in a DB2 Environment › Analyze DB2 Data › Describe Differences between the DB2 Statements and DB2View Panels

Describe Differences between the DB2 Statements and DB2View Panels

You can access DB2 Statements panels from three different options:

• From Option 2, DelayView, by looking for Major Category Data Delay with Minor Category DB2 Statement, then putting the cursor in the LC (line command) column and simply pressing Enter.
• From Option 5, DataView, by looking for .DB2 in the DD Name column and DB2 Statement delay in the Dataset Name column, then entering S on the LC column.
• From Option 6, TranView, for getting to DB2 statements for CICS monitors by determining which transaction you are interested in and then, using line command D - Delay Details simply putting the cursor at the line command and pressing Enter. This action takes you to DelayView for that transaction and from there you follow the same path described above.

  Also from TranView you can select N - Data Details, which brings you to DataView for that transaction and then you can follow the same path for DataView described above.

  The displays from TranView are different than those from DelayView and DataView because they are intended to be specific to the transaction and they are based on sample data only.

When you access Option 10, DB2View, the DB2 statements in this view are intercepted by the DB2 Harvester and are displayed in order of occurrence.

The DB2 Statements displays from DataView and DelayView emphasize sampled data and the initial columns are presented accordingly. Sample-based percentages are shown first and the display is sorted based on Total%. DB2View data emphasizes data intercepted by the DB2 Harvester and the initial columns are presented accordingly with the intercepted data shown first.

The DB2 Statement displays from Options 2, 5 and 10 can all alternate between showing sampled data only or all data (both sampled and intercepted by the Harvester) by using the SQL command previously described.

These displays are designed to provide a basic subset of data on initial entry then allow you to drill down through the detailed data offered by available command options. If you prefer to see different or more data on the initial screen, use the CUST command to include or exclude, order, or sort the fields available for the display. The panel presented for CUST has a HELP option; simply put H in the Line Command column next to the field you want to review and a description of the field is shown.