Cisco Cisco Customer Voice Portal 8.0(1)

Best Practices for Purge

•

 - The CVP Reporting database houses records of calls handled by Cisco

Unified Voice call servers. The amount of data captured for each call is managed by filters

specified in the Operations Console. The granularity of data captured depends on these

settings.

•

 - As there is limited space available to capture this data, the purge mechanism

uses retention settings to govern how long data is retained.

If there is insufficient space to retain data for the desired time frame, the oldest data is pur

ged

in one-day increments until there is sufficient space for the reporting server to remain

operational.

If more data is captured on a daily basis than can be stored, the purge mechanism will be

unable to remove data because it can only operate on a daily basis. If this is the case, consider

installing a larger reporting server.

•

 cannot run at the same time. Purge should be scheduled at

least 3 hours before a backup. These jobs, as well as on-demand backup, should be run at

low call and reporting volume times. From the perspective of Unified CVP, database backups

are optional, data purges are mandatory. However, from the perspective of the user, database

backups should not be considered optional.

•

 - During a database purge operation, the reporting server disconnects from

the database (though for no more than 10 minutes) and starts buffering messages in memory

until the purge is done. The same memory limitations as described in the section 

 apply.

•

 may be disconnected from the database if they are holding locks that contend

with purge. Notify reporting users not to run reports at this time.

•

 - Turn off scheduled purge before performing an upgrade.

•

- The database backup and purge maintenance tasks are created

as Windows Scheduled Tasks, and can be viewed in the Scheduled Tasks window (Start >

Programs > Accessories > System Tools > Scheduled Tasks). Periodically, you should check

the Scheduled Tasks to ensure the Last Run Time was as expected and there are no status

messages.

Database Backup

Unified CVP allows users to turn the scheduling of data backups on or off, as well as to run

backups on-demand. Backups are made to the reporting servers' local file system. By default,

scheduled backups are turned off.

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