5 Database Administration

Database Interface Process

the machine not operating, the machine operating slowly, an application query of a large non-indexed table, network congestion, and so on.

While the DIP is waiting for a response from the machine, the message queue of the DIP may back up. A full message queue (the current maximum is 255) may result in performance problems for the voice system.

To prevent this, the DIP is equipped with a timeout mechanism. By default, the DIP times out every 45 seconds while waiting for a response. After the timeout, the DIP deletes the messages currently queued and continues to wait for a response from the database. The DIP continues to time out every 45 seconds and to empty the message queue. After the default of 300 seconds, the DIP automatically respawns and reinitializes.

The 45-second and 300-second timeout values can be altered in /vs/data/ldbdip.rc file. This file is included with the generic package and contains the following default values:

FIRST_TMOUT=45

SECOND_TMOUT=300

You can change these default values to any number that is appropriate for your database and applications. If the ldbdip.rc file is missing, the DIP uses the default timeout values of 45 seconds and 300 seconds.

!CAUTION:

Always stop the voice system before shutting down the remote database machine to avoid an unexpected interruption of service.

UCS 1000 R4.2 Administration 585-313-507

Issue 3 April 2000 214