< Previous  | TOC | Index | Next  >

Pruning the database

You can prune or remove historical information from the database and reduce the database size. The pruning task allows you to remove the following objects from the database that were created within a specified time period:

• All cluster data management server objects
• All report outputs
• All log entries

The time period can be either the life of the database, or from the beginning through some number of years, months, weeks, or days ago.

 To prune the database

1. On the main tab bar, click the Administration tab.
2. On the details tab bar, click the Database tab
3. In the Operations task menu, click Prune the database.
4. In the Select the historical data to be removed dialog box, use the Type of Data drop-down menu to select the type of data you want to remove. The following types are available:
   • Cluster data

     This option specifies historical cluster data. Historical cluster data includes: (1) cluster and management server objects that have been deleted by the user, and (2) historical attribute and tag values. The current values of attributes and tags are not removed.

   • Report outputs only

     This option specifies report outputs, not the associated report jobs.

     See About reporting.

   • Log entries only

     This option specifies log entries only, but includes all entries and does not discriminate based upon the object or event that generated the entry.

5. Specify a time interval by selecting one of the two options under Starting with today, remove data older than and then click OK.

   To clear all historical cluster data, select the first option, which is labeled all data through today. To select a specific time interval, select the second option, which is set to 1 year by default. If desired, enter a different number in place of 1 and then select year, month, week, or day from the drop-down menu.

   Time intervals begin at the date when the oldest data was stored and end at a later date that is specified by the length of the interval. For example, assume that you enter the number 2 and select month. The database is pruned beginning with the oldest data and ending with data stored two months after the oldest data. If the oldest data was stored on January 1, and the most recent data was stored on May 1, the data stored between January 1 to March 1 is pruned.

6. When asked to confirm that you want to prune the database, click OK.

   When the pruning operation is finished, the management server updates the Status of current prune value in the Database Status table. This value also indicates whether the prune was successful and the number of records deleted.