HP R4.2 - Manual (Page 252)

5
Database Administration Database Interface Process
UCS 1000 R4.2 Administration 585-313-507 Issue 3 April 2000 213
5 Enter 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