Use these configuration parameters to manage the auditing process:
auditing enables or disables auditing for the whole Adaptive Server. The parameter takes effect immediately upon execution of sp_configure. Auditing occurs only when this parameter is enabled.
audit queue size establishes the size of the audit queue. Because the parameter affects memory allocation, the parameter does not take effect until Adaptive Server is restarted.
suspend audit when device full controls the behavior of the audit process when an audit device becomes full. The parameter takes effect immediately upon execution of sp_configure.
current audit table sets the current audit table. The parameter takes effect immediately upon execution of sp_configure.