Users Guide

Database Cleanup | 89
19
Database Cleanup
The Database Cleanup feature facilitates removal of unused data history from
the OMPE database for improved performance.
OMPE maintains minute wise and hourly data in its database which is
summarized on a daily basis. This process of summarizing detailed data for
storage is called Roll-Up operation. Database roll-up reduces the number of
records in the database, hence, increasing OMPE system response.
By default, OMPE performs roll-up on a daily and monthly basis. It maintains
daily information for one year and monthly information permanently till you
delete it. Using Database Cleanup feature, you can perform database cleanup
immediately, or at a later time or on a monthly schedule.
To open the DB Cleanup Schedule window :
1. Launch the Dell OpenManage
TM
Printer Essentials.
2. In the navigation pane, click Settings Cleanup .
Cleaning the database once
You can perform database cleanup immediately, or at a later time using this
option.
CAUTION: During database cleanup, the audit and system logs are cleaned
up without maintaining their summaries.
1. From the action menu in the DB Cleanup Schedule window , click NEW .
The Cleanup widget is displayed.
2. Enter a name for the task in the Name field.
3. From the Schedule Task list, select Once .
4. To cleanup database immediately, select Run Now .
5. To cleanup database later, select Later .
6. From the Schedule to Run and Time drop-down lists, select schedule date
and time.
7. From the Delete items older than (in months) list, select the number of
months for which data has to be retained. Data older than the selected
number of months will be deleted.
8. Click Add .