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.