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.

When you delete a database, you should also delete from dbccdb all configuration information and dbcc checkstorage results related to that database. Use sp_dbcc_deletedb to delete all database information from dbccdb.

To remove unnecessary workspaces, in dbccdb, issue:
drop table workspace_name