DB2 Version 9.7 for Linux, UNIX, and Windows
DB2 Version 9.7 for Linux, UNIX, and Windows
This parameter specifies the size of the buffer used when you audit the database.
If you set the value of audit_buf_sz configuration parameter to zero (0), the audit buffer is not used. If you set the value greater than zero (0), space is allocated for the audit buffer where the audit records are placed when they are generated by the audit facility. The amount of space allocated for the audit buffer is the value of audit_buf_sz times the page size of 4KB. At regular time intervals, or when the audit buffer is full, the db2auditd audit daemon process flushes the audit buffer to disk.
The audit buffer cannot be allocated dynamically. You must restart the DB2 instance before the new value for this parameter takes effect.
If you change audit_buf_sz configuration parameter to a value larger than zero (0), the audit facility writes records to disk asynchronously compared to the execution of the statements generating the audit records, which improves the performance of the DB2 instance. The value of zero (0) means the audit facility writes records to disk synchronously with the execution of the statements generating the audit records. The synchronous operation during auditing decreases the performance of applications running in DB2.