DB2 z OS JDBC Drivers

The DB2 z/OSJDBC Driver db2jcc_license_cisuz.jar (provided with DB2 Connect and DB2 Enterprise Server Edition) must be downloaded from vendor and is not bundled within Aqua Data Studio. Copy the driver into the Aqua Data Studio/lib/drivers folder.

Contents

• Driver Location
• Updating Driver Contents for use with DB2 z/OS

Driver Location

You may locate the latest DB2 z/OS JDBC drivers at the following location ...

Vendor: IBM (JDBC Type 4 Driver)
Driver URL: http://www.ibm.com/support/us/
Database Product: DB2 for z/OS
Description: High-performance database for availability, scalability and reliability - optimized for SOA, CRM and data warehousing.

Updating Driver Contents for use DB2 z/OS

To update the Aqua Data Studio JDBC drivers you need to overwrite the Aqua Data Studio db2java.jar (for DB2 7.2) and/or db2jcc.jar and db2jcc_license_cu.jar (for DB2 z/OS) files. Below is a listing of the Aqua Data Studio library directory [ADS_INSTALL]\lib\drivers\ ...

Windows

[ADS_INSTALL]\lib\drivers\db2jcc.jar

C:\Program Files\Aqua Data Studio 13.0 - 64bit\lib\drivers>dir
 Volume in drive C has no label.
 Volume Serial Number is 40F4-2392

 Directory of C:\Program Files\Aqua Data Studio 13.0 - 64bit\lib\drivers

12/26/2012  04:35 PM    <DIR>          .
12/26/2012  04:35 PM    <DIR>          ..
12/21/2012  10:24 AM            35,701 cassandra-clientutil.jar
12/21/2012  10:24 AM            64,465 cassandra-jdbc.jar
12/21/2012  10:24 AM           948,351 cassandra-thrift.jar
12/07/2008  12:08 PM         3,059,973 db2jcc.jar
12/07/2008  01:08 PM             2,068 db2jcc_license_cisuz.jar
12/07/2008  12:08 PM             1,015 db2jcc_license_cu.jar
12/21/2012  10:24 AM         2,703,892 derby.jar
12/21/2012  10:24 AM           535,985 derbyclient.jar
12/21/2012  10:24 AM           242,891 derbynet.jar
12/21/2012  10:24 AM           812,386 ifxjdbc.jar
12/21/2012  10:24 AM         1,660,765 jconnect70.jar
12/21/2012  10:24 AM           141,648 jsqlparser-src.zip
12/21/2012  10:24 AM           142,861 jsqlparser.jar
12/21/2012  10:24 AM         4,581,825 jt400.jar
12/21/2012  10:24 AM           349,542 jtds-src.jar
12/21/2012  10:24 AM           330,688 jtds.jar
12/21/2012  10:24 AM           388,540 mongo.jar
12/21/2012  10:24 AM           651,205 mysql-src.jar
12/21/2012  10:24 AM           745,416 mysql.jar
12/21/2012  10:24 AM           445,188 ncluster.jar
12/03/2012  02:56 PM           340,338 nzjdbc.jar
12/21/2012  10:24 AM         2,714,189 ojdbc6.jar
12/21/2012  10:24 AM         1,656,248 orai18n.jar
12/21/2012  10:24 AM           346,944 paraccel-jdbc.jar
12/21/2012  10:24 AM           561,969 postgresql.jar
12/21/2012  10:24 AM         3,516,830 sqlite-jdbc.jar
12/21/2012  10:24 AM           286,773 util400.jar
11/26/2012  01:47 PM           527,714 vertica.jar
12/21/2012  10:24 AM           262,740 xdb6.jar
12/21/2012  10:24 AM           839,982 xmlparserv2.jar
              30 File(s)     28,898,132 bytes
               2 Dir(s)  86,595,055,616 bytes free

C:\Program Files\Aqua Data Studio 13.0 - 64bit\lib\drivers>

Linux

[ADS_INSTALL]/lib/drivers/db2jcc.jar

OSX

Aqua Data Studio.app/Contents/Java/drivers/db2jcc.jar

The Java class path for the drivers are already configured for ADS in the datastudio.ini for launching ADS with datastudio.exe and in datastudio.bat/.sh and datastudio-bundled.bat/.sh for launching Aqua Data Studio from the command line.