Using the Product in a DB2 Environment › Analyze DB2 Data › CodeView Detail Panel for DB2

Previous Topic: Display the SQL Statements from the DB2 Statements Panel

Next Topic: Display the DB2View Panel from the Interactive Analysis Panel

CodeView Detail Panel for DB2

From the DB2View panel, you can display the program activity that is associated with an SQL statement from a specific DBRM/Package.

  1. From the DB2View panel, type C next to the desired DBRM/Package in the
    LC (line command) column, and press Enter.

    The CodeView Detail panel displays.

     CA MAT -------------------- CodeView Detail --------------- Row 1 to 13 of 20
 COMMAND ===>                                                  SCROLL ===> HALF

     Package/DBRM: D91PROG    Statement Number: 587           Profile: PROFT9
                                                              Options: NORMAL
                                                                 Mode: CSECT
 Primary commands: MOde Pseudo/Module/Csect/4GL,
                   PSEudo, REGister, ADDHelp

    Line commands: A - Associate     C - Callerid     D - Delays   N - Long Name
                   I - Info          L - Listing      S - Distribution
                   H - Histogram    NH - Normalized Histogram

 Extended Callerid:   CC - Current   CA - Application   CV - Via


 LC Module   Csect    Description             L C X Actv% Wait% Totl% Visual
    ________ ________ _______________________ _ _ _ _____ _____ _____ __________
 >------------------------------------------------------------------------------
 __ .DISPWT  DIA3DBM1 Waiting for the CPU           12.68  0.00 12.68 =========>
 __ .XMS0041 DIA3DBM1 Cross Memory Routine      Y    2.12  0.49  2.61 =>
 __ .NUCLEUS IWMW2ETM Workload manager        B      0.58  0.07  0.65
 __ .NUCLEUS IEAVEECT External flih           B      0.47  0.14  0.61
 __ DSNXGRDS DSNXROHB DB2 routine             A      0.11  0.41  0.52
 __ DSNIDM   DSNIRNXT DM-FETCH NEXT ROW       A      0.02  0.47  0.49
 __ DSNXGRDS DSNXERT  RDS-APPL CALL RTN       A      0.00  0.36  0.36
 __ DSNXGRDS DSNXERD  RDS-TOPMOST RDS CSECT   A      0.05  0.31  0.36
 __ .NUCLEUS IEAVTSFR SETFRR Service          B      0.25  0.05  0.31
 __ DSNXGRDS DSNXECP  RDS-COPY APPL STRUCTURE A      0.05  0.16  0.22
 __ DSNXEEZ  DSNXEEZ  RDS-DATABASE PGM REQUES A      0.00  0.20  0.20
 __ .NUCLEUS IRARMFIP System Resources Manage B      0.16  0.04  0.20
 __ DSN3EPX  DSNAPRHX SSS-PGM REQUEST NONDELE A Y    0.05  0.07  0.13

This panel identifies modules and CSECTs that delayed the SQL statement in the SQL: field for the specified DBRM/Package in the DBRM/Package: field. The commands you can issue and field headings are identical to the CodeView panel (see page 158 and page 159). All subsequent associated panels report information for the specified SQL statement from the specified DBRM/Package named.

The CodeView Detail panel reports both Active and Wait activity percentages for Analyze Normal mode, which accounts for all activity reported in DB2View.