Unanswered: capturing sql execution times within stored procedures
DB2 UDB 8.1 on AIX
We are executing a db2 sql stored procedure which is invoked from a java client.
The stored procedure contains few select, insert and update statements.
Using the DB2 snapshot and event monitor we are able to find the time taken for the stored procedure execution.
We want to find what is the execution time for each select,insert,update statement within the stored procedure? We were not able to find a way to do the same? Any ideas on this will be very helpful