Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2006
    Posts
    19

    Question Unanswered: Audit Trail of DML statements

    First of All I would like to appreciate all of you, I realy wonder how the questions are answered at this forum. Thanks all to you

    What is the mechanism in DB2 8.2 to handle the Audit trail of DML Statements.

    I want to record all the changes in any table(Data Deletion, Insertion , and Updation).
    Is there need to create triggers on each table OR Is there any DB2 System lavel thing availabe to handle this requirement.

    Istikhar

  2. #2
    Join Date
    Sep 2006
    Posts
    19
    The article below provide a plenty of details to solve the AUDIT Trail ISSUE

    DB2 Tracking Database Changes
    By Marin Komadina at the URL http://www.databasejournal.com/featu...le.php/3438801


    Istikhar

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Istikhar, thanks for providing a follow-up on this one ?

    Are you using this one currently in your shop ?

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Sep 2006
    Posts
    19
    Sathyaram,

    We are looking for DB2 AUDIT Trail facility for our requirements(DML Statements).


    The following URLS provide some details

    http://publib.boulder.ibm.com/infoce...n/c0005483.htm

    http://publib.boulder.ibm.com/infoce...n/t0011540.htm

    http://publib.boulder.ibm.com/infoce...n/c0005686.htm

    Audit facility can control the following actions within the audit facility:

    Start recording auditable events within the DB2 UDB instance.
    Stop recording auditable events within the DB2 UDB instance.
    Configure the behavior of the audit facility, including selecting the categories of the auditable events to be recorded.
    Request a description of the current audit configuration.
    Flush any pending audit records from the instance and write them to the audit log.
    Extract audit records by formatting and copying them from the audit log to a flat file or ASCII delimited files. Extraction is done for one of two reasons: in preparation for analysis of log records or in preparation for pruning of log records.
    Prune audit records from the current audit log.

    How to get the Audit Trail of DML statements by going through the aforementioned details is an issue for us.

    Thanks for your comments.

    Istikhar

    istikhar@gmail.com

  5. #5
    Join Date
    Sep 2006
    Posts
    19
    List of possible CHECKING access attempted types
    available at this URL http://publib.boulder.ibm.com/infoce...n/r0005643.htm
    DML Statements Checking events are

    0x0000000000000004 DELETE
    Attempt to delete an object.
    0x0000000000000010 INSERT
    Attempt to insert into an object.
    0x0000000000000040 UPDATE
    Attempt to update data in an object.

    So the checking table will contain the aforementioned values for DML Statement.

    How to get which table was there under manipulation and how to track the record ?

    Thanks in advance.
    Istikhar

  6. #6
    Join Date
    Sep 2006
    Posts
    19
    Event Monitors Seems Intressting

    See the URL...

    http://publib.boulder.ibm.com/infoce...65%6e%74%22%20

    http://publib.boulder.ibm.com/infoce...65%6e%74%22%20

    The obove mentioned URL seams interesting for DML statements audit.
    I am going into details and will post if there any solution for DML statements auditing in DB2

    Istikhar

  7. #7
    Join Date
    Sep 2006
    Posts
    19
    SQL Replication OR Triggers are the only options to solve the issue of DML statemtents auditing.

    SQL Replication can be setup to capture all DML changes to
    a subscribed Table. SQL Replication is used amongst customers for audit reasons.


    Istikhar.

Posting Permissions

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