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

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

Istikhar, thanks for providing a follow-up on this one ?

Are you using this one currently in your shop ?

Sathyaram

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

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

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

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.