5 Database Administration

Decreasing the Database Storage Size

Decreasing the Database Storage Size

To minimize database storage and access problems, the voice system provides two ways to minimize the storage space required for call data:

Reduce the amount of call data stored.

Reduce the number of days for which data is stored.

Reducing the Amount of Call Data Stored

You can decrease the amount of database space needed by reducing the number of stored call data events. This reduction must be accomplished at the application design level. Unlike the technique to reduce the number of days data is stored, there are no system variables to modify. This minimization technique involves modifying every application that stores call data events to store fewer of them.

Reducing the Number of Days Data is Stored

Another way to minimize the amount of storage required for call classification and call data detail information is to store fewer than 7 days worth of data. The voice system knows how many days worth of data to archive by reading the contents of the croncdh file in the /vs/bin/util directory.

UCS 1000 R4.2 Administration 585-313-507

Issue 3 April 2000 220