Unanswered: How to get SQLs for static SQL using event monitor?
using DB2 ESE v8.2 fp11 on Linux I have created event monitor for statements with the following two commands:
CREATE EVENT MONITOR event_mon_SQL FOR STATEMENTS WRITE TO TABLE MANUALSTART
SET EVENT MONITOR event_mon_SQL STATE=1
I see EVENT_MONITOR_SQL table has been created and there are SQLs that was executed on database. When using dynamic SQL there is SQL statement in column STMT_TEXT displaying the actual executed statement. So far so good. But when using static SQL (CICS application using static SQL) there is no info in STMT_TEXT. I can see package name in PACKAGE_NAME column and I can also get statements from SYSCAT.STATEMENTS table. But there are 10 or more SQL statements by package. But in table EVENT_MONITOR_SQL there is only one record by package not by statement. Is there any way to get info about how long was execution time for a particular statement inside package?