Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003

    Unanswered: active transaction

    how to find long running / active transaction.
    I mean which is not commited yet ? ( unix)

  2. #2
    Join Date
    May 2003
    First find the application id (db2 list applications show detail). Then do a snapshot of the application. It will show you the current status and the number of SQL statements.

    There is a freeware online monitor that will do the job nicely once you have the snapshot switches set on for the dbm configuration. The link for this program has been posted several times in this forum and you should be able to find it with a search, or you can try the Useful Stuff thread to see if you can find it.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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