4.5.3 Review System Tablespaces

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. Only certain table spaces can be used to hold user tables.

Rationale:

Users should not have privileges to create user data objects within the system tablespaces. User data objects created within the system tablespaces should be removed.

Solution

Connect to the Db2 database.

db2 => connect to <dbname>

Review the system tablespaces to identify any user data objects within them.

Drop, migrate, or otherwise remove all user data objects (tables, schemas, etc.) from within the system tablespaces.

Revoke write access for the system tablespaces from all users.

See Also

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

Item Details

Category: CONFIGURATION MANAGEMENT

References: 800-53|CM-6b.

Plugin: IBM_DB2DB

Control ID: 3aa3b34ca2193648dfe6f1540a72cda5590ce42080700050fc11cc1b65071168