DB2 can be configured to use an audit buffer. It is recommended that the audit buffer size be set to at least 1000.
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