Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2013
    Posts
    23

    Unanswered: How to capture the SQL query statistics in runtime

    Hi all,
    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.

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    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

  3. #3
    Join Date
    Nov 2013
    Posts
    23
    I work on db2 v9.7 on linux and use the clp commands...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •