Cisco Cisco Unified Customer Voice Portal 11.0(1)

For each aspect of the password, the Reporting password must meet the requirement of the more
restrictive policy.

Joining Data with an ICM HDS Database

Joining Unified CVP and Unified ICME data can be a very expensive operation on the Unified
ICME system. To minimize performance impacts on an HDS system, use one of the following
strategies:

•

Dedicate an HDS for these reports

•

Query an HDS when Unified ICME reporting users are not running reports

Joining Unified CVP and SQL Server Data

To join data from a SQL Server Database and an Informix Database one must use a reporting
tool that supports the ability to join data from two heterogeneous databases.

Reporting Isolation Level

Reporting clients should never run with an isolation level of repeatable read as this could hold
locks and prevent updates to the data.

Database Retention Settings

Ensure that the database is sized conservatively so that it never needs to emergency purge.

Purge and Backup Database Maintenance Tasks

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). These jobs log in as SYSTEM.

If the CVPDBNightlyPurge and CVPDBMidDayPurge tasks do not run, then the database will
not be purged and will eventually become full, resulting in data loss.

If the CVPDBBackup task does not run the database will not be backed up.

Periodically, you should check the Scheduled Tasks to ensure that the 'Last Run Time' was as
expected and there are no status messages.

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