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.