Using the Product in a DB2 Environment › Analyze DB2 Data › Display Statement Details and Long Names

Display Statement Details and Long Names

1. Type D in the LC field on either the DB2 Statements panel or the DB2View panel and press Enter.

   The DB2 Statement Detail panel displays.

    CA MAT ---------------- DB2 Statement Detail ----------- Row 3 to 24 of 38
    COMMAND ===>                                                  SCROLL ===> PAGE
   
      Primary Commands: SQL - Display SQL Text                   Profile: PROFT9
                                                                 Options: NORMAL
         Line Commands: N - Display Long Name                   DB2 SSID: DIA3
                                                                 DB2 Rel: 9.1.0
    LC Field Name       Field Value
       ________________ ___________________________________________________________
    -------------------------------------------------------------------------------
       Location         DIA
       Plan             D91PRG
    __ Collection       D91PROGZ_BIG_PACKAGE_LITTLE_PACKAGE_PACKAGE_LONGER_AND_LONG
       Package          D91PROG
       Section Number   2
       Stmnt Number     425
       Statement        OPEN
       SQL Type         Static
       Total Count      1
       Total CPU        15.123193
       CPU per Call     15.123193
       Total Resp Time  34.591737
       Avg Resp Time    34.591737
       Enclave CPU      15.124186
       Get Pages        69340
       Pages from DASD  47598
       From DASD%       68.64
       Pages from Pools 21742
       From Pools%      31.36
       Index Get Pages  2
       Sync Read I/0    1217
       Async Pages Read 46381
       SEQ Pre Fetch    2448
       Declare Stmnt    769
       Length           46
       Correlation      USRDB2T9
       OPER ID          USRMMM1
       Thread           1CEF5DB8
       Thread Count     7006
       Req Job Name     USRDB2T9
       Exec Job Name    USRDB2T9
       Cursor Name      BT_D91PROG_CURSOR_FOR_TESTING_LONG_NAMES
       Unique Samps     1
       Total Samps      358
       Max Conc Samps   1
       Active%          4.51
       Wait%            1.92
       Total%           6.44
    ********************************* End of Table ********************************
   

   This panel displays the contents of the row in tabular format. It shows each field name and its value. Zero, blank, and N/A entries are skipped.

   You can use the SQL command to view the full text of the selected SQL statement in the SQL Statements panel.

   If a long name value exists, you can use line command N to view the DB2 Long Name panel.

   CA MAT --------------------- DB2 Long Name -------------- Row 1 to 2 of 2
   COMMAND ===>                                                  SCROLL ===> PAGE
   
     Field Name: Collection                                     Profile: DB2STRP
                                                                Options: NORMAL
   
   -------------------------------------------------------------------------------
   D81PROGZ_BIG_PACKAGE_LITTLE_PACKAGE_PACKAGE_LONGER_AND_LONGER_AND_LONGER_AND
   _LONGER_AND_LONGER_AND_STILL_LONGER
   

   This panel shows the complete long name and the field name for the selected field.