Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    15

    Unanswered: Turning on SQL logging

    Hello all,

    Is there way in DB2 to turn on logging of all SQL that gets executed against a particlular database/table? In Oracle it's called 'auditing', I believe.

    Thanks a lot
    James

  2. #2
    Join Date
    Nov 2004
    Posts
    374

    audit

    this is also called audit in DB2 - although this generates lot of data
    monitor statement can be activated to capture dynamic statements
    or see how index advisor collects workload...
    or use query patroller... many possibilities todo the same..
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

  3. #3
    Join Date
    Oct 2003
    Posts
    15
    Thanks very much! Very helpful

    Best,
    James

Posting Permissions

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