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.