Try OpenEdge Now
skip to main content
Database Administration
Reference : PROUTIL Utility : PROUTIL AUDITRECONFIG qualifier
 

PROUTIL AUDITRECONFIG qualifier

Reconstructs the audit data and index areas of an audit-enabled database.

Syntax

proutil db-name -C auditreconfig [ tablearea table-area-name]
    [ indexarea index-area-name]
    [-userid username[-password passwd]]

Parameters

db-name
Specifies the database where you want to reconfigure your audit data and index areas.
tablearea table-area-name
Name of the Type II area where auditing data tables are to be located.
indexarea index-area-name
Name of the Type II area where auditing indexes are to be located.
userid username
Specifies the user name of the privileged user. If you are using the _User table, username must be defined there, and you must include the -userid parameter to identify the user. If you are not using the _User table, use of -userid is optional; in this scenario, username specifies a local operating system login ID. Regardless of the source, username must have the Audit Data Archiver privilege in order to run AUDITRECONFIG.
-password passwd
Specifies the password for username. If you are using the _User table, passwd is the password defined for the user there. The value of passwd can be clear text or encrypted. If you are not using the _User table and have specified a local operating system ID with -userid, passwd must be the encrypted value of the DB Pass key. See OpenEdge Getting Started: Core Business Services - Security and Auditing or the Data Administration online Help for information on the DB Pass Key. For information on encrypting a password, see the description of the genpassword utility in OpenEdge Getting Started: Installation and Configuration.
If you do not supply a password corresponding to username, the utility will prompt for it.
AUDITRECONFIG provides Audit Data Archivers the ability to reconfigure audit data and index areas while auditing is enabled. You can move the audit data tables and indexes to new areas, or you can purge and reuse your current areas.
When reconfiguring your audit data and index areas, you can:
*Split or combine index and data areas
*Set new records per block and blocks per cluster values in new areas
*Purge all data from existing audit areas by specifying the existing areas in the AUDITRECONFIG command
*Reclaim disk space by deleting your old audit data and or index areas after configuring new areas with PROSTRCT REMOVE.
If data exists in the audit data area it is destroyed by AUDITRECONFIG. You are prompted to acknowledge this fact before the reconfiguration executes.
See Reconfiguringaudit areas for examples.

Notes

*You must have Audit Archiver privilege to run AUDITRECONFIG.
*Your database must be offline to execute PROUTIL AUDITRECONFIG.
*If auditing is disabled, you can execute AUDITRECONFIG if the audit data tables are empty.
*AUDITRECONFIG destroys all data in your current audit data and index areas. Preserve your auditing data by archiving with PROUTIL AUDITARCHIVE prior to executing PROUTIL AUDITRECONFIG. See PROUTILAUDITARCHIVE qualifier for more information on archiving audit data.