Unanswered: How to capture the SQL query statistics in runtime
I have used db2batch to find out the elapsed time for the given sql query statement...can anybody give their inputs on how to capture the SQL query statistics during the actual runtime of the application...becuase during the runtime the application takes longer time to load so i need to capture the same.
have a look at event monitor in infocenter
as no level/platform is provided - no link to infocenter is provided either
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be