Administering databases

The system uses database DIPs to communicate with databases (one DIP per database). These DIPs need to be supplied with information regarding where and how to access the databases. The DIP configuration is managed entirely from the Web Administration interface.

You can have call information alternatively stored in a Call Data Handler (CDH) flat file where it can either be read directly or uploaded into a database. The upload to a database can be done at a convenient (low traffic) time using a cron job.

Configuring a database DIP

1. Choose Configuration Management > JDBC Administration from the main menu.

The browser displays the JDBC Administration - Main screen.

2. To configure a DIP:
1. Select the hyperlink corresponding to the DIP in the Dipid column.

The browser displays the JDBC Administration - Edit screen for the DIP you chose.

2. Fill in the fields and click Save.
3. To activate a DIP:
1. Select the radio button beside the name of the DIP in the Dipid column of the JDBC Administration - Main screen.
2. Click Start.

The browser displays the DIP Start Status screen, which shows whether or not the DIP has started.

4. To deactivate a DIP:
1. Select the radio button beside the name of the DIP in the Dipid column.
2. Click Stop.

The browser displays the DIP Stop Status screen, which shows whether or not the DIP has stopped.

Configuring CDH

If a flat file is always used, the flat file needs to be configured:

1. Select the File CDH hyperlink in the Dipid column of the JDBC Administration - Main screen.

The browser displays the JDBC Administration - Edit screen.

2. Select the database DIP that is used to upload the flat file to a database.
3. Enter the path to the flat file. Include the file name.
4. Click Save.

If you enable File CDH, the information saved in the flat file is always stored in the database accessed by the database DIP you chose.

Note:
Since enabling File CDH results in heavy LAN traffic, Avaya does not recommend doing this in most cases.

To enable File CDH:

1. From the JDBC Administration - Main screen, select the radio button beside File CDH in the Dipid column.
2. Click Start.

The browser displays the DIP Start Status screen, which notifies you if the DIP has successfully started.

To disable File CDH:

1. From the JDBC Administration - Main screen, select the radio button beside File CDH in the Dipid column.
2. Click Stop.

The browser displays the DIP Stop Status screen, which notifies you if the DIP has successfully stopped.

In some cases, you may want to create your own customized database DIP to run with a database. This DIP would use the CDH flat file as its source of call data.

To configure the DIP:

1. From the JDBC Administration - Main screen, click on the Database CDH hyperlink in the Dipid column.

The browser displays the Database DIP Configuration - Edit screen.

2. Fill in the fields and click Save.

To activate the DIP:

1. From the JDBC Administration - Main screen, select the radio button beside the name of the DIP in the Dipid column.
2. Click Start.

The browser displays the DIP Start Status screen, which notifies you if the DIP has successfully started.

To deactivate a DIP:

1. From the JDBC Administration - Main screen, select the radio button beside the name of the DIP in the Dipid column.
2. Click Stop.

The browser displays the DIP Stop Status screen, which notifies you if the DIP has successfully stopped.

� 2002 Avaya Inc. All Rights Reserved.