dbccdb Maintenance Tasks

You may occasionally need to perform maintenance tasks on dbccdb.

Reevaluate and update the configuration using:
- sp_dbcc_evaluatedb – recommends values for configuration parameters using the results of previous dbcc checkstorage operations.
- sp_dbcc_updateconfig – updates the configuration parameters for the specified database.
Clean up obsolete data:
- sp_dbcc_deletedb – deletes all the information on the specified database from dbccdb.
- sp_dbcc_deletehistory – deletes the results of the dbcc checkstorage operations on the specified database from dbccdb.
Remove unnecessary workspaces.
Perform consistency checks on dbccdb itself.

Reevaluating and Updating the dbccdb Configuration
If the characteristics of user databases change, use sp_dbcc_evaluatedb to reevaluate the current dbccdb configuration and recommend more suitable values.
Cleaning Up dbccdb
SAP ASE stores data generated by dbcc checkstorage in dbccdb. Periodically clean up dbccdb by using sp_dbcc_deletehistory to delete data from a database. You must have created the database before the date specified.
Performing Consistency Checks on dbccdb
Limited update activity in the dbccdb tables should make corruption infrequent; however, severe corruption might cause dbcc checkstorage to fail.

Parent topic: Checking Database Consistency