Installing JDBC Drivers for Non-Sybase Replicate Databases

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 Sybase Control Center 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 2005 JDBC Driver 1.2 (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 driver in:
    • Windows – %SYBASE%\SCC-3_1\plugins\RMAP\lib
    • UNIX – $SYBASE/SCC-3_1/plugins/RMAP/lib
  3. If Sybase Control Center is running, restart the server.