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
.
