Hitachi

Hitachi Advanced Database Setup and Operation Guide


6.15 Estimating the size of the audit trail directory

This section describes how to determine the size of the audit trail directory. You must determine the size of the audit trail directory before using the audit trail facility.

Note

The audit trail directory is the directory specified for the adb_audit_log_path operand in the server definition.

Use the following formula to determine the size of the audit trail directory (AUDFILE).

Formula (megabytes)

AUDFILE = aud_log_max_size × aud_log_max_num

Explanation of variables

aud_log_max_size

Value specified for the adb_audit_log_max_size operand in the server definition

For details about the adb_audit_log_max_size operand, see 7.2.9 Operands related to audit trail facility (set format).

aud_log_max_num

Value specified for the adb_audit_log_max_num operand in the server definition

For details about the adb_audit_log_max_num operand, see 7.2.9 Operands related to audit trail facility (set format).

If 0 is specified for the adb_audit_log_max_num operand, there is no limit to the number of audit trail files that can be created. For this reason, you cannot determine a value for the variable AUDFILE. When specifying 0 for the adb_audit_log_max_num operand, determine the size of the audit trail directory by considering the following aspects of audit trail facility operation:

  • The size of the output audit trail data and the number of audit trail files that will be created

  • How often audit trail files are moved from the audit trail directory to the audit trail storage directory

For details about the operation of the audit trail facility, see 12. Audit Trail Facility Operations.