DB2 must off-load audit data to a separate log management facility; this must be continuous and in near real time for systems with a network connection to the storage facility and weekly or more often for stand-alone systems.
Overview
Finding ID
Version
Rule ID
IA Controls
Severity
V-213762
DB2X-00-012600
SV-213762r879886_rule
Medium
Description
Information stored in one location is vulnerable to accidental or incidental deletion or alteration.
Off-loading is a common process in information systems with limited audit storage capacity.
The DBMS may write audit records to database tables, to files in the file system, to other kinds of local repository, or directly to a centralized log management system. Whatever the method used, it must be compatible with off-loading the records to the centralized system.
Run the following command to find the value of “Audit Data Path” and “Audit Archive Path”
$db2audit describe
DB2 can asynchronously extract the audit records in comma delimited format from “Audit Archive Path”.
If a separate log management facility approved by the organization exists and is configured to absorb the comma delimited audit log files, this is not a finding.
If a separate log management facility is not configured to absorb the extracted log data, this is a finding.
Fix Text (F-14981r295336_fix)
Configure the separate log management facility to absorb audit logs data from comma delimited files produced by extracting the audit data from archived audit logs.