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:
https://www.ibm.com/developerworks/data/library/techarticle/dm-0401chong/index.html
