8.4 Review system tablespaces for user data

Information

System tablespaces store all system object data within that database. It is recommended that system tablespaces are used to store system data only and not user data.

Do not install any user data in the following system tablespaces: SYSCATSPACE and SYSTOOLSPACE.

NOTE: Nessus has provided the target output to assist in reviewing the benchmark to ensure target compliance.

Solution

Drop, migrate, or otherwise remove all user data objects (tables, schemas, etc.) from within the system tablespaces. Also, revoke write access for the system tablespaces for all users. Note that these actions may cause loss of data and functionality for users.
1. Connect to the DB2 database.
db2 => connect to $DB2DATABASE user $USERNAME using $PASSWORD
2. Review unused users and user objects that are stored in the system tablespaces. Perform the appropriate actions to remediate the identified issues.

See Also

https://workbench.cisecurity.org/files/1654

Item Details

Category: CONFIGURATION MANAGEMENT

References: 800-53|CM-6b.

Plugin: IBM_DB2DB

Control ID: 474483b7e9eb7d886d9e70d98196e8a57ce40b5c40bfc1b1be08e4319a3eb1d3