Information
DB2 can be configured to use an audit buffer. It is recommended that the audit buffer size be set to at least 1000.
Increasing the audit buffer size to greater than 0 will allocate space for the audit records generated by the audit facility. At scheduled intervals, or when the audit buffer is full, the db2auditd audit daemon empties the audit buffer to disk, writing the audit records asynchronously.
Solution
Perform the following to establish an audit buffer:
1. Attach to the DB2 instance:
db2 => attach to $DB2INSTANCE
2. Run the following command from the DB2 command window:
db2 => update database manager configuration using audit_buf_sz 1000
Default Value:
The default value for audit_buz_sz is zero (0).