Reducing database size

There are several other ways you can reduce the size of your database. These activities do not need to be performed on a regular basis. They can be performed on an as-needed basis. Here are some suggestions.

Procedure

  1. Keep your user lists up-to-date.

    When people leave the company, remove their userid and role definitions. Also, delete working and checkpoint objects belonging to those users. The Save Offline and Delete (SOAD) tool provides a scope for this purpose called All non-static projects and products for a specified user.

  2. Keep release information up-to-date.
    When releases are completed or abandoned, mark them as inactive. You can delete old baselines and old prep hierarchies using the following SOAD scopes:
    • Non released baselines for specified release older than specified date
    • Integration Testing prep projects and products for a specified release
  3. Clean up Rational® License Server TL log files.

    See the IBM® Rational License Server TL Guide for instructions on checking the Rational License Server TL log files.


Feedback