5
Database Administration
Decreasing the Database Storage Size
UCS 1000 R4.2 Administration 585-313-507
Issue 3 April 2000 222
Changing the Data Storage Number of Days
Currently, the only report produced for the call classification data is the Call
Classification Summary report. Therefore, saving zero days worth of call
classification data saves database space without affecting the reports
produced by the voice system. Storing zero days worth of data means that
only the call classification data for the current day is available until the clean-
up and summary programs run each night after midnight. The voice system
always maintains the current day’s data.
To change the number of data days, modify the following commands in the
croncdh file, where
x
is the number of days of data to store:
$VSUTIL/cdhdel -x
$VSUTIL/ccadel -x
Note:
If cdhdel and ccadel do not have any arguments, the default of 7
days is used, as illustrated in the sample croncdh file above.
To store 2 days worth of call detail data information, and 4 days of call
classification data, modify the croncdh file as follows:
# Start the ORACLE DBMS
VSUTIL=/vs/bin/util
ORACLE_SID=A;export ORACLE_SID
ORACLE_HOME=‘/usr/lbin/dbhome $ORACLE_SID‘;export
ORACLE_HOME
PATH=$PATH:$ORACLE_HOME/bin;export PATH
