Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2011
    Location
    Delhi
    Posts
    24

    Unanswered: when sql statement was ran on database

    Hi,

    I am using DB2 V9.7 fp3 on linux box.
    Is there any way out to check the time when the sql statement ran on the database ?

    User connected to the database through Db2 client and ran some sql statements. I have those set of statements but wanna check that at which time those statement was ran. Is it possible to check it through any set of commands or utility ??

    Thanks in advance..!!

  2. #2
    Join Date
    Jan 2009
    Location
    United Kingdom
    Posts
    77
    Unless you had a trace , you might be out of luck , some suggestions
    1) Check the routine MONREPORT.PKGCACHE to generate the Package Cache report
    2) Check the application , and see if any logs appears, same for any audit tables

  3. #3
    Join Date
    Apr 2012
    Posts
    156
    Try using the admin view sysibmadm.snapstmt. There is a column with start_time and stop_Time.

    IBM DB2 9.7 for Linux, UNIX and Windows Information Center

Posting Permissions

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