Unified CCE Database Administration
When you install a new Logger, you create its central database. Create an HDS database on a real-time Administration & Data Server. When you create a database, you specify the size of its data or log files. The data files must be sufficient for all the data that you expect the database to hold. The size of the central and HDS databases depend on your call center traffic and your data retention requirements.
The local database (awdb) contains configuration and real-time data, if the Administration & Data Server role includes a real-time server. Because the real-time data in the local database (awdb) are constantly overwritten by new data, the database size remains fairly constant.
Over time, the size of your enterprise or your call volumes can change significantly. Therefore, you might need to resize the central and HDS databases to meet new requirements. You normally do not need to resize the local database (awdb). To resize the local database (awdb), use the ICM Database Administration (ICMDBA) tool.
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 Unified ICM configuration; for example, how many services, skill groups, routes, and trunk groups are configured.
- Call rate; that is, how many calls per day the system 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. The system software generates a new historical record every half hour for each service, skill group, route, trunk group, and so on, that is configured in the Unified ICM system.
You size and create the central and HDS databases after installing the system software. Use the Database Sizing Estimator applet for estimating the size of these databases, based on the expected usage.
If your configuration expands significantly or if you change the retention times for historical data, you might have to increase the size of the database. This increase might involve adding more disks to the system.