Start of change

Collecting DB2 resources in your CICS region

You must edit the JCL to conform with your own system conventions.

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 will improve 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 General Options panel for that region. See Specifying region-specific options: general for details.

To collect DB2 data:

  1. Review the following members in hlq.SCIUSMP2.OUT:
    • CIUDBCT
    • CIUDBNT
  2. Review the associate SQL members for the above jobs. They can be found in hlq.SCIUSQL.OUT.
  3. Run hlq.SCIUSMP2.OUT(CIUDBCT) to create indexes for SYSIBM.
  4. Run hlq.SCIUSMP2.OUT(CIUDBNT) to bind the programs that update DB2 tables.
End of change