IBM DB2 Everyplace Sync Server Administration Guide Version 7 Release 2 Modification 1


Supported JDBC databases

There are two types of subscriptions that can connect to JDBC compliant databases.

For more information about upload subscriptions and JDBC subscriptions, see Creating a JDBC subscription and Creating an upload subscription.

Using local and remote configurations

For local configurations, the mirror and source databases are located on the same server. You can use the following data sources for JDBC subscriptions:

For remote configurations, the source database and mirror database are located on different servers. For JDBC subscriptions, use the data sources described in Table 1.

Table 1. Remote configurations

Source database Mirror database Driver
DB2 Universal database, Version 7.2 for Windows 2000 DB2 Universal Database, Version 7.2 IBM DB2 UDB local
DB2 Universal database, Version 7.1.0 for z/OS DB2 Universal Database, Version 7.2 IBM DB2 UDB local
Oracle 8i DB2 Universal Database, Version 7.2 Oracle Thin drivers 8.1.5 classes111.zip
DB2 iSeries Version, 5R1 for OS/400 DB2 Universal Database V7.2 IBM DB2 UDB local
Microsoft SQL Server, Version 7.0 for Windows NT DB2 Universal Database, Version 7.2 NetDirect JSQL 2.25 driver
Sybase Adaptive Server Enterprise, Version 11.93 DB2 Universal Database, Version 7.2 Sybase J-Connect 4.2 driver
Informix Server, Version 9 DB2 Universal Database, Version 7.2 Informix JDBC driver 1.5

NetDirect JSQL is a third-party driver. Microsoft does not provide a JDBC driver for SQL Server.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]