HP R4.2 Changing the Data Storage Number of Days, Note:, cdhdel, ccadel, croncdh, croncdh, croncdh, 5 Database Administration

5 Database Administration Decreasing the Database Storage Size

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 cleanup 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

UCS 1000 R4.2 Administration 585-313-507 Issue 3 April 2000 222