8.3 Remove unused schemas

Information

A schema is a logical grouping of database objects. It is recommended that unused schemas be removed from the database.

Unused schemas can be left unmonitored and may be subjected to abuse, so they should be removed.

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

Solution

Perform the following commands to remove unused schemas:
1. Connect to the DB2 instance.
db2 => connect to $DB2DATABASE user $USERNAME using $PASSWORD
2. Run the following command from the DB2 command window:
db2 => drop scheme restrict
3. Remove the unused schemas.

See Also

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