5 Database Administration

Database Interface Process

5Enter create index index_name on table_name (“FIELD2”); The system creates a non-unique index for FIELD2 in the table.

Database Interface Process

A voice system application accesses the database tables through a single database interface process (DIP). A DIP is a software program that connects to the database and provides the only interface between the application and the database.

Database DIP Timeout

The voice system and remote database ORACLE connection is established when the voice system starts. After the connection is established, the voice system does not keep track of status changes on the remote machine. The connection between it and the voice system is dropped if the remote machine is turned off or rebooted. If the remote machine is shut down and rebooted while the voice system is still active, the voice system detects this status change only when calls come in to the system that involve remote database access for call processing. The voice system attempts to reestablish the remote connection and is not able to process calls during this time.

In certain cases, the database DIP (oraldb) may not receive a timely response from the machine. This may be due to a variety of factors, such as

UCS 1000 R4.2 Administration 585-313-507

Issue 3 April 2000 213