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.