5
Database Administration
Call Data Tables
UCS 1000 R4.2 Administration 585-313-507
Issue 3 April 2000 207
6
Write down this number.
7
Use the UNIX editor
vi
to modify the cdh.sql file as follows:
a
Find the
create table xxx
statement block, where
xxx
is the table
name (for example, CALL, SERVICE or EVENTS).
b
Modify the statement
storage (initial 999k)
to a bigger number,
where
999
is the current initial size for the table and
k
stands for
kilobytes (1024 bytes).
Note:
The new values specified should be at least twice as large as the
current table size you wrote down in
step 6
. You may use the
megabyte format,
99m
, where
m
is mbytes (1,000,000 bytes =
mbyte). For example, to make the table have an initial size of 3
mbytes, modify the storage statement to read:
storage (initial 3m)
8
Enter stop_vs
The systems stops the voice system. See
stop_vs
in
Appendix A,
Summary of Commands
for more information about the stop_vs
command.
Note:
If you do not want to preserve existing call data, skip
step 9
through
step 11
.
