Lucent Technologies Intuity CONVERSANT System Version 7.0 Guide

6  
Database Administration  Call Data Tables
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 347
SERVICE Table
The SERVICE table contains the following information:•
CID — Numeric field that specifies a non-unique identification number 
that joins multiple SERVICE.CID to one CALL.CID.
Each call creates one or more SERVICE records, depending on the 
number of services used to handle the call. All SERVICE records 
associated with a call have the same SERVICE.CID as...

6  
Database Administration  Call Data Tables
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 348
CDHSUM Table
The CDHSUM table contains the following information:•
SUMID — Numeric field that specifies a unique identification number 
which joins CDHSUM.SUMID to EVSUM.SUMID. 
•
SERVICE— Variable length character field that specifies the service 
(application) name. This field can be up to 16 characters in length.
•
START_TIME — Date field that specifies the start...

6  
Database Administration  Call Data Tables
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 349
EVENTS Table
The EVENTS table contains the following information:•
SID — Numeric field that specifies a non unique identification number. 
Note:Each service run during a call creates a certain number of event 
records, depending on the number of events defined. All events 
records associated with this call have the same SID number as 
the SID field of the...

6  
Database Administration  Call Data Tables
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 350
EVSUM Table
The EVSUM table contains the following information:•
SUMID — Numeric field that specifies a unique identification number.
Note:The values in this field are related to the SUMID values in the 
CDHSUM table. 
•
EVENT_NUMBER — Numeric field that specifies the internal mapping 
between the event and an internal number. 
•
SUM_TOT — Numeric field that indicates...

6  
Database Administration  Call Data Tables
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 351
TRASUM Table
The TRASUM table contains the following information:•
START_TIME — Date field that specifies the start of hour (for example 
10:00:00).
•
CHANNEL — Numeric field that indicates the channel number. This field 
can be up to 3 digits in length.
•
CALL_TOT — Numeric field that specifies the total number of calls.
•
DUR_TOT — Numeric field that specifies the...

6  
Database Administration  Call Data Tables
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 352
•
Each record in the CALL table is linked to one or more records in the 
SERVICE table.
•
Each record in the SERVICE table is linked to zero or more records in the 
EVENTS table.
Figure 164. Relationship of CALL, SERVICE and EVENTS Tables   

6  
Database Administration  Call Data Tables
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 353
Resize Call Data Tables
The sizes of the call data handling tables are defined in
 /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 
the system or the greater number of events defined in your applications. The 
most likely candidates for...

6  
Database Administration  Call Data Tables
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 354
6  
Write down this number.
7  
Use the UNIX vi editor 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...

6  
Database Administration  Call Data Tables
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 355
9  
Enter systblsav
 file
 
The system saves the table storage information, where 
file
 is a UNIX file 
or a device name where the data will be saved (such as, /dev/rmt/c0s0).
10  
Enter sqlplus \@ /oracle/dist/cdh.sql 
The system reinitializes the table(s).
11  
Enter systblres
 file
 
The system restores the table storage information from the UNIX file or 
device...

6  
Database Administration  Call Data Tables
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 356
Verify Call Data Tables
Periodically, the field definitions of a table need to be reviewed for accuracy, 
or to assist with troubleshooting.
Use the following procedure to verify the field definitions of a table (such as, 
the CCA table):1  
At the 
Console Login:
 prompt, enter root
The system prompts you for a password.
2  
Enter your root password.
The system...