Cisco Cisco Customer Voice Portal 8.0(1)

Database Purge

This section explains how to schedule purges, the difference between midday and nightly purges,

and how to run emergency purges.

To allow for rapid space management, all Unified CVP Reporting Server data is kept in

date-specific fragments. On a daily basis, new day fragments are created for incoming data.

This allows the Unified CVP Reporting Server to quickly drop old data by dropping the disk

fragment in which that data resides.

This means that new fragments must be created on a regular basis to ensure that they can be

rapidly disposed of when their retention period expires. All of this is handled by the purge.

In a quiet environment, the purge can execute in under one second. In a busy environment, the

purge might take considerably longer (15-20 minutes) while the purge navigates around running

processes.

To allow for situations where the purge may be unable to execute, space is allocated two days

before it is needed. This allocation occurs by the first purge to run after a date boundary has

been crossed.

If the nightly purge is scheduled to run at 1:00 AM, it will typically perform this task. If the

nightly purge is scheduled to run at 11:00 PM, then the next day will not occur until 11:00 AM

the next morning, which may not be an optimal time to execute the process.

For this reason, schedule the nightly purge to occur after midnight.

Scheduling Purges

Database purge is run from the Operations Console as follows:

1. Select Device Management > CVP Reporting Server.

2. Select a reporting server by clicking on the link in its name field or by clicking the radio

button preceding it and then clicking Edit.

3. At the Edit Reporting Server Configuration window, select the Database Administration

menu in the toolbar, then select Data Delete.

4. On the Reporting Server - Data Delete page, change the data retention time for each

category of data.

5. Select the hours and minutes to run the purge each day.

This defines the time for the primary (Nightly) purge and sets the Midday purge to run 12

hours later.

6. Enter your Informix Password and click Save & Deploy.

Reporting Guide for Cisco Unified Customer Voice Portal Release 8.0(1)