Installing the IBM DB2 JDBC driver

To integrate the Avaya IR system with an IBM DB2 database, you must install the JDBC driver for DB2.

To install the DB2 JDBC driver:

1. Locate the driver file (db2jcc.jar) on the server on which DB2 is installed.

   For Microsoft Windows installations, the driver file is usually in the directory HD:\Program Files\IBM\SQLLIB\java where HD is the hard disk drive containing the DB2 software.

   For Solaris installations, enter find / –name db2jcc.jar –print to locate the file on the DB2 server.

2. Transfer the file (using the ftp command or some other method) to the /vs/java/jdbc/lib directory on the Avaya IR system.
3. Log on to the Avaya IR system as root.
4. Enter /etc/init.d/tomcat stop

   The system displays messages indicating that the Tomcat engine is stopped.

5. Enter /etc/init.d/tomcat start

   The system displays messages indicating that the Tomcat engine is started.

6. Configure and test the database DIP using the JDBC Administration - Edit (Custom) screen in Web administration. Click the Help link to see individual field descriptions.
7. Use the following settings:
   • The Database type is Custom
   • The Classname is com.ibm.db2.jcc.DB2Driver
   • The Database URL is jdbc:db2://server.domain_name:50000/database_name

     where 50000 is the port number. For example, jdbc:db2://dataserver.company.com:50000/IR_database

   • The Database subtype is IBM DB2

© 2006 Avaya Inc. All Rights Reserved.