1. Jdbc Driver Download
2. Ibm Db2 Jdbc Driver

The DB2 Universal JDBC Driver for DB2 UDB for OS/390® and z/OS Version 7, as documented in APAR PQ80841. This version supports both driver Types 2 and 4. The DB2 Universal JDBC Driver with the feature z/OS Application Connectivity to DB2 for z/OS, which provides Type 4 connectivity only. IIRC, all available DB2 JDBC drivers should be already in the /java or /jdbc folder of the DB2 installation folder. Ask your DB admin to have a copy of them if you don't have direct access to the machine where DB2 runs. DB2 UDB provides for JDBC connectivity through a number of Java classes and interfaces that implement the JDBC specification. The implementation is known as a JDBC driver. DB2 currently offers JDBC drivers known as legacy/CLI drivers and the universal JDBC driver. Updating your DB2 JDBC driver to the version which you are using is always a good idea. The DB2 Server installation provides JDBC drivers for the version and fixpack in use. You may copy the provided JDBC driver and overwrite the driver provided by ADS. The DB2 Data Server Client allows you to connect to a DB2 database on z/OS using JDBC without requiring DB2 Connect in between. However, you will still need a DB2 Connect license, contained in the db2jcc_license_cisuz.jar file that comes with any DB2 Connect product.

Am evaluating options other than either Sybase's DirectConnect or IBM's DB2Connect to connect to DB2 running on z/OS. From what our findings have shown us so far, we need to connect and also do format translation from ASCII to EBCDIC and vice versa. We are currently seeking an open source (not necessarily community edition) to help us achieve this. Any thoughts will always help.

1 Answer

The DB2 Data Server Client allows you to connect to a DB2 database on z/OS using JDBC without requiring DB2 Connect in between. However, you will still need a DB2 Connect license, contained in the db2jcc_license_cisuz.jar file that comes with any DB2 Connect product.

Not the answer you're looking for? Browse other questions tagged jdbcdb2asciitranslationebcdic or ask your own question.

Where do I download JDBC drivers for DB2 that are compatible with JDK 1.5? They seem to be very elusive and I hit many dead-ends at IBM's website. I managed to find versions of the driver bundled with some tools such as IBM Data Studio. Unfortunately, these versions either target a JVM too modern (JDK 1.6, leading to class version errors) or too ancient (JDK 1.2, leading to known bugs when run on JDK 1.5).

4 Answers

I know its late but i recently ran into this situation. After wasting entire day I finally found the solution. I am suprised that I got this info on oracle's website whereas this seems nowhere to be found on IBM's website.

If you want to use JDBC drivers for DB2 that are compatible with JDK 1.5 or 1.4 , you need to use the jar db2jcc.jar, which is available in SQLLIB/java/ folder of your db2 installation.

Right here: http://jt400.sourceforge.net/

This is what I use for that exact purpose.

EDIT: Usage Examples (minus exceptions):

Hope that helps!

Jdbc Driver Download

you can download and install db2client and looking for - db2jcc.jar - db2jcc_license_cisuz.jar - db2jcc_license_cu.jar - and etc.at C:Program Files (x86)IBMSQLLIBjava

Gateway fx6800-01e drivers for mac. A smartly spruced-up case design and a forward-looking motherboard give this PC a decided edge over its competition. Gateway's FX6800-01e is the first mainstream PC we've seen with Intel's new Core i7 desktop processor, but that's far from the only exciting feature in this desktop.

Ibm Db2 Jdbc Driver

Not the answer you're looking for? Browse other questions tagged jdbcdb2 or ask your own question.