How to connect to DB2 on the mainframe - z/Os

RazorSQL can connect to DB2 on z/Os via either JDBC or ODBC. ODBC connections are available on Windows machines only. Below is information on how to get connected to DB2 on z/Os using the DB2 JDBC driver.

RazorSQL ships with the IBM DB2 UDB JDBC Universal driver. This driver does support access to DB2 running on z/OS. However, to connect to DB2 z/OS, a special license file is needed. The license file is contained in the DB2 Connect software installation. Here is the name of the license file:

db2jcc_license_cisuz.jar

The information below outlines how to get connected to DB2 UDB for z/OS version 8 using the Universal Driver.

Once the license file is obtained, to connect to DB2 on z/OS, you can go to the Connections -> Add Connection Profile, select DB2 as the database type, JDBC as the connection type, and enter the paths to the db2jcc_license_cisuz.jar and the db2jcc.jar file that ships with RazorSQL in the driver location field. Those two paths should be separated by a semi-colon.

For a JDBC type 4 connection, the JDBC URL format would be the following:

jdbc:db2://<server hostname or IP address>:<DB2 UDB Instance port number>/

For example,

jdbc:db2//127.0.0.1:50000/SAMPLE

For a JDBC type 2 connection, (you would actually be connecting via DB2 Connect, so DB2 Connect needs to be installed and configured on your machine), the JDBC URL format would be the following:

jdbc:db2:<dbname>

For example,

jdbc:db2:SAMPLE

The driver class for all of the above examples is the following:

com.ibm.db2.jcc.DB2Driver

For more information on connecting to DB2 version 8 via JDBC, please see the following:

http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0401chong/