DB2 Universal Database for Linux, UNIX, and Windows database connections
Use the New Database Connection wizard or the Database Connection page to create a JDBC connection to DB2 Universal Database for Linux, UNIX, and Windows.
The following JDBC drivers are supported for DB2 Universal Database for Linux, UNIX, and Windows. The available drivers might vary depending on the edition and version that you are connecting to.
- DB2 Application Driver
- DB2 Universal Driver
- DataDirect SequeLink Driver
- DB2 JDBC Drivers
You can download the DB2 JDBC drivers at www.ibm.com/software/data/db2/.
The DB2 Application Driver is included with the DB2 Runtime Application Client and the DB2 Application Development Client. The DB2 Application Driver is a Type 2 JDBC driver. You can use this JDBC driver only to connect to databases that are cataloged on your local computer. The DB2 Application Driver uses native DB2 CLI libraries to retrieve metadata.
The DB2 Universal Driver is included with the DB2 Application Development Client. This driver is a two tier pure Java JDBC driver that allows a Java client to communicate directly with DB2 UDB servers through the DRDA protocol. This driver supports both Type 2 connections (to databases that are cataloged on your local computer) and Type 4 connections (using a host, database name, and port). This driver is designed to replace the Type 3 Net driver.
To establish a cross-platform connection to a DB2 Universal Database system, you should configure a local database alias by using DB2 Connect or the Client Configuration Assistant from the locally installed DB2 UDB system and then use the DB2 Application Driver.
Note: The DB2 Net Driver is no longer supported in the workbench.
- DataDirect SequeLink Driver
The DataDirect SequeLink Driver server code must be installed on the remote computer. You can either use the JDBC driver that is shipped with this product, or you can download this JDBC driver at www.datadirect-technologies.com.
Related tasks
Troubleshooting database connection problems
Related reference
Supported database types
License requirements for all DB2 Universal Database database connections
DB2 Universal Database for iSeries database connections
DB2 Universal Database for z/OS and OS/390 database connections