Start of change

Collecting DB2 resources in your CICS region

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:

  1. Review the following members in hlq.SCIUSAMP.CICS:
    • CIUDBCT
    • CIUDBNT
  2. Review the associate SQL members for the above jobs. They can be found in hlq.SCIUSQL.CICS.
  3. Run hlq.SCIUSAMP.CICS(CIUDBCT) to create indexes for the SYSIBM.SYSPACKSTMT and the SYSIBM.SYSSTMT tables.
  4. 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.

Task Task

Feedback


Timestamp icon Last updated: Friday, 8 February 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic//ciuugc0023a.html
End of change