Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2005
    Posts
    1

    Question Unanswered: capturing sql execution times within stored procedures

    Env:
    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

  2. #2
    Join Date
    Apr 2005
    Posts
    41

Posting Permissions

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