Maintenance Manual

Chapter 4 Database Administration
Retaining Historical Data
4-2
Cisco ICM Enterprise Edition Administrator Guide Release 6.0(0)
real-time database. If you do need to resize the Distributor AW database, you can
do so using the ICM Database Administration (ICMDBA) tool. The procedures
for using the ICMDBA tool are described later in this chapter.
The data in the central database and HDS database grow as they accumulate
historical data and call detail records. The growth is directly related to the
following factors:
• Size of the ICM configuration; for example, how many services, skill groups,
routes, and trunk groups are configured.
• Call rate; that is, how many calls per day ICM software is handling.
• How long historical data is kept in the database.
The amount of configuration data directly affects the amount of historical data
generated. ICM software generates a new historical record every half hour for
each service, skill group, route, trunk group, etc., configured in the ICM system.
You must size and create the central and HDS databases after installing the ICM
software. Use the ICM Database Administration (ICMDBA) tool for estimating
the size of these databases, based on the expected usage.
The database size remains adequate as long as your usage is consistent with the
values used to size the database. If your configuration expands significantly or if
you change the retention times for historical data, you may have to increase the
size of the database. This may involve adding additional disks to the system.
Normally, the central database transaction logs are sized to handle the processing
of historical data at a call rate of 35 calls per second.
Retaining Historical Data
ICM software initiates a purge process on the Logger and on each HDS AW
machine once every day. By default, the purge process runs each night at 12:30
A.M. The purge process deletes records that are older than a specified number of
days. When you configure the ICM databases you can specify the number of days
to keep data for each historical table.
Table 4-1 lists the default settings for retaining historical data.