5 Database Administration

Call Data Tables

6Write down this number.

7Use 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)8Enter 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.

UCS 1000 R4.2 Administration 585-313-507

Issue 3 April 2000 207