Db2® report
The report lists all the Db2® commands that were collected by the Collector.
Example Db2 report
from the Dependency Reporter shows an example Db2® report. Figure 1. Example Db2® report
from the Dependency Reporter
2023/12/18 - CICS INTERDEPENDENCY ANALYZER (CIU) - Version 610 - 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 2023-12-18 09.34.42 2023-12-18 09.35.58 Y 1 815 L8
DSN8CC1 00002724 SELECT TABLE VCONA DF2E DSN8CC0
25 2023-12-18 09.34.42 2023-12-18 09.35.58 Y 4 672 L8
00002872 DELETE TABLE VCONA DF2E DSN8CC0
4 2023-12-18 09.35.09 2023-12-18 09.36.10 Y 5 710 L8
00002AEE INSERT TABLE VCONA DF2E DSN8CC0
4 2023-12-18 09.34.42 2023-12-18 09.35.58 Y 6 804 L8
00002B98 UPDATE TABLE VCONA DF2E DSN8CC0
17 2023-12-18 09.34.45 2023-12-18 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.