Historical data is replicated from the Logger to the Historical Data Server (HDS). It is a client/server mechanism. A Replication Server process runs on an Cisco Intelligent Contact Management (ICM) Logger and a peer Replication Client process runs on an ICM HDS.
Upon the initial installation of an HDS, the Replication Server on the ICM Logger and the Replication Client on the HDS establishes a start point for all HDS table data. The start point depends on the registry settings on the HDS. This document describes the initial registry settings on the HDS.
For more information on document conventions, see the Cisco Technical Tips Conventions.
Readers of this document should be knowledgeable of the following:
Cisco ICM databases
Microsoft SQL Server database
The information in this document is based on the software and hardware versions below.
Cisco ICM 4.1.5 and later
Microsoft SQL Server version 6.5 and 7.0
The information presented in this document was created from devices in a specific lab environment. All of the devices used in this document started with a cleared (default) configuration. If you are working in a live network, ensure that you understand the potential impact of any command before using it.
It is necessary to size and create the HDS database when you build an HDS Admin Workstation (AW). The length of time the historical data is kept in the database affects the size of the HDS database. Retention time could be set by a table.
Cisco ICM software initiates a purge process on each HDS AW once a day. By default, the purge process runs each night at 12:30 a.m. The process deletes records older than a specified number of days. When you configure the Cisco ICM databases you can specify the number of days to keep data for each historical table. This table lists the default settings for historical data retention.
|Historical Tables||Default Retention Time|
|Application_Event, Config_Message_Log, Event||14 days|
|Admin, Recovery||30 days|
|All other historical tables||100 days|
Default retention time for all tables can be found under the following registry key:
Note: The above value is displayed over two lines due to space limitations.
Drill-down two levels, select the registry key for the specific table, double-click Days and change its value to a new retention time.Figure 1: Registry Editor
Once the HDS database is synchronized with the Logger database, data is replicated to each database table on the HDS from the Logger based on the ImageArgs registry key setting:
/db <HDS database name>/client/name <ICM Logger node name>/ replicationport40026/recoveryport40028/all
Note: The above keys are displayed over two lines due to space limitations.
The kind of data replicated from Logger to HDS is up to the setting of the /all node manager switch. If /all is set, the Logger replicates old historical tables to the HDS. If /all is not set, the Logger skips the old historical data and replicates the new data only from the time the service is turned on. To turn on the /all switch, double-click ImageArgs. The String Editor displays. Enter the /all switch at the end of the line and click OK.Figure 2: String Editor
Note: The /all switch only works when the HDS database is empty. This means the above registry must be set before the Cisco ICM processes start on the HDS for the first time. Otherwise, the HDS database must be rebuilt.Figure 3: Registry Editor
The Cisco Support Community is a forum for you to ask and answer questions, share suggestions, and collaborate with your peers.
Refer to Cisco Technical Tips Conventions for information on conventions used in this document.