DB2X-00-001600 - DB2 must produce audit records containing sufficient information to establish the outcome (success or failure) of the events

Information

Information system auditing capability is critical for accurate forensic analysis. Without information about the outcome of events, security personnel cannot make an accurate assessment as to whether an attack was successful or if changes were made to the security state of the system.

Event outcomes can include indicators of event success or failure and event-specific results (e.g., the security state of the information system after the event occurred). As such, they also provide a means to measure the impact of an event and help authorized personnel to determine the appropriate response.

Solution

Drop and recreate the policy with STATUS set to ''Both'' or use ALTER POLICY to set the STATUS='B'.

To drop and recreate a policy use following statements:
DB2> DROP AUDIT POLICY <audit1>
DB2> CREATE AUDIT POLICY <audit1>
CATEGORIES < audit categories > STATUS BOTH ERROR TYPE AUDIT

To alter the audit policy:
DB2> ALTER AUDIT POLICY <audit1>
CATEGORIES < audit categories > STATUS BOTH ERROR TYPE AUDIT

Notes: Each audit record has an Event Status represented by a SQLCODE where Successful event > = 0 Failed event < 0. To generate a record for both success and failed events, all the audit policies should be created with STATUS 'BOTH'.

CREATE AUDIT POLICY information:
http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.sql.ref.doc/doc/r0050607.html?lang=en

ALTER AUDIT POLICY information:
http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.sql.ref.doc/doc/r0050608.html?cp=SSEPGG_10.5.0%2F2-12-7-7&lang=en'

See Also

https://dl.dod.cyber.mil/wp-content/uploads/stigs/zip/U_IBM_DB2_V10-5_LUW_V2R1_STIG.zip

Item Details

Category: AUDIT AND ACCOUNTABILITY

References: 800-53|AU-3, CAT|II, CCI|CCI-000134, Rule-ID|SV-213679r879567_rule, STIG-ID|DB2X-00-001600, STIG-Legacy|SV-89121, STIG-Legacy|V-74447, Vuln-ID|V-213679

Plugin: IBM_DB2DB

Control ID: 005af3b04af3602ecf48aa774249c82c8f029e6b421338932d0e7eec78e57244