Re-enabling auditing from a deactivated state

Database Administration

Protecting Your Data : Auditing : Enabling and disabling auditing : Re-enabling auditing from a deactivated state

To re-enable a database for auditing from a deactivated state:

1. Ensure that your audit data tables are empty.

2. Enable your database with PROUTIL ENABLEAUDITING. The following command enables auditing for a database named sample-db, and places the auditing tables in an area named "Audit Area", the auditing indexes in an area named "Audit Indexes", and deactivates the non-primary indexes:

proutil sample-db -C enableauditing

Successfully enabling the database results in the following message:

Auditing has been activated

For a complete discussion of the PROUTIL ENABLEAUDITING syntax, see PROUTILENABLEAUDITING qualifier.