If you want to collect DB2® resource
information in your target CICS® region
follow these steps.
About this task
Before collecting DB2 resource
information in your CICS region,
it is highly recommended that you create an new index against your
SYSIBM.SYSPACKSTMT and SYSIBM.SYSSTMT tables. This improves performance
of the online collection. If you choose not to create these indexes,
switch off the DB2 query in
the SYSIBM tables by entering N in the Inquire
for DB2 Resources field in the
CINT DB2/MQ/IMS panel for that region. For more information see, Specifying which dependency-related DB2, IMS, MQ commands and TRUEs are to be monitored.
To collect DB2 data:
- Review the following members in hlq.SCIUSAMP.CICS:
- Review the associate SQL members for the above jobs. They can
be found in hlq.SCIUSQL.CICS.
- Run hlq.SCIUSAMP.CICS(CIUDBCT) to create indexes for the SYSIBM.SYSPACKSTMT
and the SYSIBM.SYSSTMT tables.
- Run hlq.SCIUSAMP.DB2(CIUDBNT) to bind the CIUCINB2 program to CICS.
Note: You must have defined the CICS resources
for DB2TRAN and DB2ENTRY. For more information, see
Defining CICS resources.
Note: On any region
where you want to collect DB2 data,
ensure that the user ID, under which CICS IA
runs, has GRANT permission to the batch plan created in the sample
job SCIUSAMP.DB2(CIUDBNT). This enables the background transaction
CINB to access the SYSIBM.SYSPACKSTMT and SYSIBM.SYSSTMT DB2 tables.