Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Location
    Thailand
    Posts
    42

    Question Unanswered: How can I know time executing each command

    I wanna know .How Can I know excute time each sql command .

  2. #2
    Join Date
    Oct 2001
    Location
    Bangalore
    Posts
    186
    Hi,

    You can use a event monitor for this purpose. Just create a event monitor for statements on the given database and in the log you will get the start and end time.

    If you want to know the cost of the query you can use the explain plan utility of DB2.

    Cheers,
    Prashant

  3. #3
    Join Date
    Jul 2002
    Location
    ATL
    Posts
    170
    Use db2batch

Posting Permissions

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