# RazorSQL

## Query, Edit, Browse, and Manage Databases

- razorsql.com
- Contact

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

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/