Configuring DA to Use the IBM DB2 UDB JDBC Driver

To use an IBM DB2 UDB database in a comparison, configure the DA server and the DA agent to use the db2jcc4.jar file.

1. Download the db2jcc4.jar JDBC driver for your database version from the IBM Web site.
2. Copy the db2jcc4.jar file into the DA library folder:
   • On Windows – %SYBASE%\DA-15_5\server\lib\drivers\db2jcc4.jar
   • On UNIX – $SYBASE/DA-15_5/server/lib/drivers/db2jcc4.jar

   where %SYBASE% (Windows) or $SYBASE (UNIX) is the directory in which you installed the Data Assurance Option, and lib is the library folder of your DA server instance.
3. Open the RUN start-up script file:
   • On Windows 32-bit:

     %SYBASE%\DA-15_5\server\instance\RUN_instance_32.bat

   • On Windows 64-bit:

     %SYBASE%\DA-15_5\server\instance\RUN_instance_64.bat

   • On UNIX:

     $SYBASE/DA-15_5/server/instance/RUN_instance_64.sh

   where instance is the name of your DA server instance.

4. Add the location of the IBM DB2 UDB JDBC driver JAR file to the DA server CLASSPATH.
   On Windows:

   set CLASSPATH=%CLASSPATH%;%DA_LIB%\drivers\db2jcc4.jar

   On UNIX:

   set CP=$CP:$DA_LIB/drivers/db2jcc4.jar

5. Save the RUN start-up script file.
6. Restart the DA server for the settings to take effect.

   Follow the same steps to configure a DA agent to use the IBM DB2 UDB JDBC driver JAR file.