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.
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.