Installing JDBC Drivers for Non-Sybase Replicate Databases

(Optional, replication only) To use latency monitoring (rs_ticket) in a replication environment to measure latency to non-Sybase replicate databases, you must install JDBC™ drivers to enable Sybase Control Center for Replication to connect to those replicate databases.

You can install JDBC drivers at any time after installing Sybase Control Center, even if the Sybase Control Center server is already running.
  1. Download the JDBC drivers for your databases. Drivers are typically available with the database server or on the database vendor’s Web site.

    • Oracle 9i, 10g, 11g

      Driver – Oracle JDBC Thin Driver 11.1 for use with JDK 1.5 (ojdbc5.jar)

    • Microsoft SQL Server 2005 and 2008

      Driver – Microsoft SQL Server JDBC Driver 2.0 (sqljdbc.jar)

    • IBM DB2 UDB 8.22, 9.1, 9.5

      Driver – IBM DB2 for Unix, Linux, and Windows JDBC Driver 9 (db2jcc.jar and db2jcc_license_cu.jar)

  2. Place the drivers in:
    • Windows – %SYBASE%\SCC-3_2\plugins\RMAP\lib
    • UNIX – $SYBASE/SCC-3_2/plugins/RMAP/lib
  3. If Sybase Control Center is running, stop it and start it again.