Cisco Cisco Unified Customer Voice Portal 11.0(1)

Informix, Operating System Time, and Local Time

Informix only displays a datetime that corresponds to the same time zone as the Informix serv

er

operating system's time zone. As a result, two items must be kept in mind:

• If you wish a datetime to be displayed for a time zone other than that of the Informix server

operating system, you must use reporting tools or SQL tools (for example, those available
with Crystal Reports or Java) to do this.

• If, in your system, you are using more than one Informix server for Unified CVP reporting,

it is best if all such server OSs are set to the same time zone. This helps avoid confusion.

Assuring Accurate Time Stamps for Reporting and Logging

Unified CVP components do not themselves synchronize machine times. However, customers
must provide a cross-component time synchronization mechanism, such as NTP, to ensure
accurate time stamps for reporting and logging.

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 Guide for Cisco Unified Customer Voice Portal Release 7.0(2)