Return
-
Title
How to monitor Dynamic SQL Statements that are being submitted by the Users/Applications? -
Description
How can Dynamic SQL Statements that are being submitted by the Users/Applications against the DB2 Subsystem be monitored? Is it possible to view/monitor all SQL statements through Dynamic Statement cache?
-
Resolution
1. Open Object Explorer using View menu.
2. Select “Subsystem” category either via tabs, drop down or tree node.
3. Select subsystem name, right-click on it and select View Details.
4. Dynamic Statement Cache tab will show on the right-hand side showing cache tables and SQL statements.