DB2X-00-007700 - DB2 must provide an immediate real-time alert to appropriate support staff of all audit failure events requiring alerts

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'

See Also

https://iasecontent.disa.mil/stigs/zip/U_IBM_DB2_V10-5_LUW_V1R3_STIG.zip

Item Details

References: CAT|II, CCI|CCI-001858, Rule-ID|SV-89247r1_rule, STIG-ID|DB2X-00-007700, Vuln-ID|V-74573

Plugin: Unix

Control ID: f499c759a85503cfc5c341ae23bb45d6af923fd9e1e27561d214871521742eaf