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
Содержание R4.2
Страница 1: ...UCS 1000 R4 2...
Страница 2: ...Copyright 2000 by Lucent Technologies All rights reserved...
Страница 21: ...vusage 618 wl_copy 619 wl_edit 620 wl_gen 622 wl_init 624 wl_install 625 Glossary 627 Index 699...
Страница 192: ...4 Switch Interface Administration Digital Interfaces Figure 89 Assign Card T1 A B Robbed bit E M Window...
Страница 313: ...6 Peripheral Administration Modem Administration 10 Select ModemMon add to one add port services...
Страница 665: ...A Summary of Commands wl_install Example wl_install See Also wl_copy wl_gen...