Collecting DB2 commands

You can collect data about the DB2® commands and resources that are used by your transaction and program in a CICS® region with the CICS IA dependency collector.

To obtain the resource name, for example a table name that is used in an EXEC SQL SELECT command, you need to access the SYSIBM.SYSPACKSTMT and the SYSIBM.SYSSTMT tables. To improve the performance of this access, CICS IA supplies you with some DB2 indexes for these tables. It is recommended that you create these indexes. Consult with your DB2 Administrator. Some locations are reluctant to create indexes on these tables. In this case it is recommended that you use the CICS IA option, Collect resource name, to remove access to these tables. For more information, see Specifying which dependency-related CICSPlex SM, DB2, IMS, and MQ commands are to be monitored.

To enable the collection of DB2 data, you must provide some DB2 options to the configuration exec. Consult with your DB2 Administrator to obtain these values. If you choose to enable DB2 collection in your CICS region, CICS IA defines DB2ENTRY and DB2TRAN resource definitions. A DB2CONN definition is not supplied.
Note: The DB2 subsystem that is connected to your CICS system and accessed by your applications can be different from the DB2 subsystem where you created the CICS IA database.