4.1.8 Secure Permissions for the Log Mirror Location (MIRRORLOGPATH)

Information

The MIRRORLOGPATH parameter specifies the type of media and the location used to store the mirror copy of the logs. It is recommended that the directory used for the mirror copy of the logs be set to full access for Db2 administrator accounts and read and execute only for all other accounts.

Rationale:

A mirror log path should not be empty and it should be a valid path. The mirror log path stores a second copy of the active log files. Access to the directory pointed to by that path should be restricted through permissions to help ensure that the confidentiality, integrity, and availability of the mirror logs are protected.

Solution

For Windows and Linux:

Connect to the Db2 database

db2 => connect to <dbname>

Run the following command to change the mirror log directory, if necessary:

db2 => update database configuration using mirrorlogpath <valid directory>

Additional steps for Windows:

Connect to the Db2 host

Right-click on the mirror log directory

Choose Properties

Select the Security tab

Grant all Db2 administrator accounts the Full Control authority

Grant all other accounts read and execute privileges only (revoke all other privileges)

Additional steps for Linux:

Connect to the Db2 host

Change to the mirror log directory

Change the permissions for the directory

$ chmod -R 755

See Also

https://workbench.cisecurity.org/benchmarks/10752

Item Details

Category: ACCESS CONTROL, MEDIA PROTECTION

References: 800-53|AC-3, 800-53|AC-5, 800-53|AC-6, 800-53|MP-2, CSCv7|14.6

Plugin: Windows

Control ID: ef141b28f8d5d29dfcae43f60ca244b1b6389f54798d0ea04968a2ab679936a1