5
Database Administration
Decreasing the Database Storage Size
UCS 1000 R4.2 Administration 585-313-507
Issue 3 April 2000 220
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.
