5 Database Administration Call Data Tables
UCS 1000 R4.2 Administration 585-313-507 Issue 3 April 2000 206
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:
1 At the Console Login: prompt, enter root
The system prompts you for a password.
2 Enter your root password.
The system displays the system prompt
#.
3 Enter cd /oracle/dist
The system changes to the oracle/dist directory.
4 Enter cp cdh.sql o.cdh.sql
The system saves the original copy of the cdh.sql file to a file named
o.cdh.sql.
5 Enter dbused
The system displays the number of megabytes used by the table.
