Database Administration for Specific Platforms › UNIX/Oracle Routine Procedures › Cleaning Up Your Database › Models Remaining in Database Until Cleanup Is Run

Models Remaining in Database Until Cleanup Is Run

Unusable models also remain from any delete model operations. Your database can become fragmented over time from several delete model operations, or from performing delete model operations on large models. Deleted models remain in the database until a cleanup procedure is run.

The cleanup program provided with CSE deletes rows associated with unusable models from the encyclopedia. Use the following steps to clean up your database.

1. Back up your database.
2. cleanup -u <userid>

   where: <userid> is the CSE ID of an Encyclopedia Administrator.

   For example:

   cleanup -u daacmno
   

Note: The servers must be running when cleanup is performed. As with all command line commands, the optional parameters can be determined by typing only the command and pressing enter. Required and optional parameters used with that command will be displayed. For information on setting parameters, see Configure a CSE Server Environment in the CA Gen Client Server Encyclopedia User Guide.