DB2 for z/OS and OS/390 database connections

Use the New Database Connection wizard or pages that are embedded in other wizards to create a JDBC connection to DB2® for z/OS® or DB2 for z/OS and OS/390®.

The DB2 Universal Driver is supported for DB2 for z/OS.

DB2 JDBC Drivers

You can download the DB2 JDBC drivers at www.ibm.com/software/data/db2/.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.

The DB2 Universal Driver is included with this product, in the com.ibm.datatools.db2 plug-in.

Note: Due to a JDBC limitation, when connecting to DB2 for OS/390 (CP930), some double-byte character set (DBCS) data gets truncated based on the data length of UTF-8 encoding. 10 single-byte character set (SBCS) Katakana characters can be received as three Katakana characters by a "SELECT" statement. The actual data stored in a table in OS/390 is '8182838485868788898A' in hexadecimal which is 10 Japanese Katakana characters (1 byte for 1 character). However, when using the JDBC driver with the default setting, the received query data shows only three characters ('efbdb1efbdb2efbdb3') as the valid nine bytes string in UTF-8, which would be cut off from 'efbdb1efbdb2efbdb3efbdb4efbdb5efbdb6efbdb7efbdb8efbdb9efbdba' in the JDBC driver.
Related concepts
Overview of database connections
Related tasks
Connecting to a database by using a wizard
Related reference
Connection Parameters page
Filter page
New or Existing Connection page

Feedback