ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

How to view SQL History in IDB2?


Article ID: 141344


Updated On:


SYSVIEW Performance Management Option for DB2 for z/OS Database Management for DB2 for z/OS - Performance Suite Database Management for DB2 for z/OS - SQL Performance Suite Insight Performance Monitor for DB2 UDB for z/OS


How to determine what  SQL statements were issued by  a user  at  certain time of the day? Is there any IDB2 report  showing such information ?



Release : 19.0

Component : CA Insight Database Performance Monitor for DB for z/OS


1-Dynamic SQL statistics collection was not enabled during the selected history interval. To enable include IFCID 316 in the
HIST-STATS-RECS data collector SYSPARM parameter.
2. There were no dynamic SQL statements within the cache executed during the selected history interval.
3. The data is only available for DB2 10 or higher.