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 PROUTIL ENABLEAUDITING qualifier.