Purge data in existing audit data areas

Database Administration

Protecting Your Data : Auditing : Reconfiguring audit areas : Purge data in existing audit data areas

Suppose that you want to purge your database of all auditing data and restart recording audited events in the area you are currently using. Use the following steps as a guide:

To reconfigure your audit data area:

1. Archive any existing audit data with PROUTIL AUDITARCHIVE.

The syntax is:

proutil db-name -C auditarchive

If you archive the data with no parameters, the data in your audit tables is deleted after it is archived. See PROUTILAUDITARCHIVE qualifier for the complete syntax.

2. Reconfigure your existing audit data area.

Use the following syntax (suppose the existing audit data area is named "Audit Data"):

proutil db-name -C auditreconfig tablearea "Audit Data"

3. PROUTIL AUDITRECONFIG prompts you to confirm your data is archived.

The prompt appears as follows:

The operation will delete all auditing data records.
You must archive auditing data first.
Have you archived the data already and do you want to continue? (Y/N)
(16987)

4. Enter Y to proceed with the reconfiguration.

Successful completion of the reconfiguration produces the following messages:

Auditreconfig started. (16973)
Reconfiguring tables ... (16979)
Auditreconfig completed. (16975)

See PROUTILAUDITRECONFIG qualifier for the complete syntax.