5 Database Administration

Call Data Tables

Resizing Call Data Tables

The sizes of the call data handling tables are defined in the /oracle/dist/cdh/sql file. Although the sizes are carefully engineered, it is possible that one or more of the tables should be increased to accommodate the heavier traffic on your system or the greater number of events defined in your applications. The most likely candidates for resizing are the EVENTS, SERVICE, and CALL tables, and their index tables.

To increase the size of a call data table:

1At the Console Login: prompt, enter root The system prompts you for a password.

2Enter your root password.

The system displays the system prompt #.

3Enter cd /oracle/dist

The system changes to the oracle/dist directory.

4Enter cp cdh.sql o.cdh.sql

The system saves the original copy of the cdh.sql file to a file named o.cdh.sql.

5Enter dbused

The system displays the number of megabytes used by the table.

UCS 1000 R4.2 Administration 585-313-507

Issue 3 April 2000 206