Results 1 to 2 of 2

Thread: Sql End Time

  1. #1
    Join Date
    Sep 2004

    Thumbs up Unanswered: Sql End Time


    Is there any way to track the SQL end time.
    I would like to automate in the script to track the SQL start time and end time.

    We have adhoc query environment and needs SQL tracking.
    Some SQL we have static which executes weekly, monthly -- We need to track the end time for these SQL.

    We can capture start time by using list applications command.

    Please help. If any one has script that capture SQL end time that will be helpful.


  2. #2
    Join Date
    Jan 2007
    Jena, Germany
    Do you want to capture the execution times of SQL statements or the duration SQL sessions (connections)?

    I would probably do this in the application: take the current timestamp before the statement/session is initiated and take the current timestamp at the end. But I don't know exactly what you are after and which options you have in your environment.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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