Information
DB2X-00-007700 - DB2 must provide an immediate real-time alert to appropriate support staff of all audit failure events requiring real-time alerts.
It is critical for the appropriate personnel to be aware if a system is at risk of failing to process audit logs as required. Without a real-time alert, security personnel may be unaware of an impending failure of the audit capability, and system operation may be adversely affected.
The appropriate support staff include, at a minimum, the ISSO and the DBA/SA.
Alerts provide organizations with urgent messages. Real-time alerts provide these messages immediately (i.e., the time from event detection to alert occurs in seconds or less).
NOTE: Nessus has not performed this check. Please review the benchmark to ensure target compliance.
Run the following command to monitor the database diagnostic log file for audit failure errors:
$db2diag -g msg:='Write to audit log failed'
If the diagnostic log file is not being monitored for audit failure errors, this is a finding.
Solution
Run the following command to alter the audit policies and to set the ERRORTYPE to audit:
DB2>ALTER AUDIT POLICY <DB audit policy name> CATEGORIES AUDIT STATUS BOTH ERROR TYPE AUDIT
Monitor the diagnostic log file for audit failure error using the following command:
$db2diag -g msg:='Write to audit log failed'