The Access Audit Facility tracks changes made to DB2® data during an Access edit session.
The audit data is stored in DB2 to provide a secure, centralized location. This also ensures that data in the audit table is consistent with the changes made to the actual data since all ROLLBACK and COMMIT processing affects the audit as well as the data.
Only changes made to the DB2 data during an Access session are tracked by the Audit Facility. This does not include any activity that results from executing an embedded SQL statement, unless it is a SELECT statement that invokes an Access edit session.
The Access Audit Facility is available to users if:
You can determine whether the Audit Facility is available by displaying the Editor and Display Options panel from Option 0 on the Main Menu.
If Audit Mode is protected and set to ON, the facility is always active and you cannot deactivate it without proper authority. If Audit Mode is protected and set to OFF, the facility is not active and you cannot activate it without proper authority. If Audit Mode is unprotected, you can specify Yes to activate or No to deactivate the Audit Facility for your edit session. (See the Common Elements Manual, section for Editor and Display Options, for more information on Audit Mode.)