DB2 report

The report lists all the DB2® commands that were collected by the Collector.

Figure 1 shows an example DB2 report.
Figure 1. Example DB2 report from the Dependency Reporter
2011/01/27 - CICS INTERDEPENDENCY ANALYZER (CIU) - Version 320  -  Page:  60                                       
                     DB2 RESOURCES REPORT FOR APPLID: IYCYZC3C                                                     
                                                                                                                   
 TRAN  PROGRAM  OFFSET    COMMAND               TYPE        RESOURCE                                 DB2ID PLAN    
-------------------------------------------------------------------------------------------------------------------
                           USAGE  FIRST RUN            LAST RUN             TERM    SECTION#  STATEMENT#   TCBMODE 
-------------------------------------------------------------------------------------------------------------------
 D8CS  DSN8CC0  000007E8  SELECT                TABLE       VCONA                                    DF2E  DSN8CC0 
                              25  2011-01-27 09.34.42  2011-01-27 09.35.58     Y           1         815        L8 
                                                                                                                   
       DSN8CC1  00002724  SELECT                TABLE       VCONA                                    DF2E  DSN8CC0 
                              25  2011-01-27 09.34.42  2011-01-27 09.35.58     Y           4         672        L8 
                                                                                                                   
                00002872  DELETE                TABLE       VCONA                                    DF2E  DSN8CC0 
                               4  2011-01-27 09.35.09  2011-01-27 09.36.10     Y           5         710        L8 
                                                                                                                   
                00002AEE  INSERT                TABLE       VCONA                                    DF2E  DSN8CC0 
                               4  2011-01-27 09.34.42  2011-01-27 09.35.58     Y           6         804        L8 
                                                                                                                   
                00002B98  UPDATE                TABLE       VCONA                                    DF2E  DSN8CC0 
                              17  2011-01-27 09.34.45  2011-01-27 09.35.40     Y           7         810        L8 
                                                                                                                   

The report fields contain the same information as the identically named fields on the CICS® report, with the following additions and deletions:
DB2ID
The identifier (ID) of the DB2 subsystem.
PLAN
The DB2 plan.
SECTION#
The section number in the source code of the CICS program at which the DB2 command is issued.
STATEMENT#
The statement number in the source code of the CICS program at which the DB2 command is issued.
TYPE
The type of resource against which the command was issued.
Sysid
Not reported on the DB2 report.

Concept Concept

Feedback


Timestamp icon Last updated: Friday, 7 February 2014


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic///ciuug5k.html