DB2 LUW 8.1 and DB2 UDB 8.2 (Revision #0)

The DB2 JDBC drivers included with ADS work across all 8.x versions of DB2. There is no need to change or update this driver.

Contents

• Driver Location
• Updating Driver Contents for use with DB2 8.1

Driver Location

You may locate the latest DB2 8.1 JDBC drivers at the following location ...

Vendor: IBM (JDBC Type 4 Driver)
Driver URL: http://www.ibm.com/support/us/

Database Product: DB2 8.1

You may locate the JDBC drivers for your installed version of DB2 in the DB2 server or DB2 client installations. Below is a directory listing of the driver files in the [DB2_INSTALL]\java directory. The db2java.zip file is the DB2 JDBC driver required by ADS. This is the file you need to copy and whose extension you need to rename to .jar and use to overwrite the db2java.jar file.

C:\Program Files\IBM\SQLLIB\java>dir
 Volume in drive C is Local Disk
 Volume Serial Number is 5C1C-7C82

 Directory of C:\Program Files\IBM\SQLLIB\java

08/03/2004  12:07a      DIR          .
08/03/2004  12:07a      DIR          ..
08/15/2004  08:48p           2,212,612 Common.jar
08/15/2004  08:48p             237,008 db2fs.jar
08/15/2004  08:48p           1,232,035 db2java.zip
08/15/2004  08:48p           1,075,286 db2jcc.jar
08/15/2004  08:48p              23,709 db2jcc_javax.jar
08/15/2004  08:48p               1,013 db2jcc_license_cu.jar
08/15/2004  08:48p             118,928 db2policy.jar
08/15/2004  08:48p             161,393 db2qgjava.jar
08/03/2004  12:02a      DIR          images
08/03/2004  12:03a      DIR          jdk
08/15/2004  08:48p           1,512,886 sqlj.zip
               9 File(s)      6,574,870 bytes
               4 Dir(s)   1,808,121,856 bytes free

C:\Program Files\IBM\SQLLIB\java>
        

Updating Driver Contents for use DB2 8.1

To update the Aqua Data Studio JDBC drivers for DB2 8.1 you need to overwrite the Aqua Data Studio db2jcc.jar and db2jcc_license_cu.jar files. Below is a listing of the Aqua Data Studio library directory [ADS_INSTALL]\lib\drivers\ ...

Windows

[ADS_INSTALL]\lib\drivers\db2java.jar
[ADS_INSTALL]\lib\drivers\db2jcc.jar
[ADS_INSTALL]\lib\drivers\db2jcc_license_cu.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

11/23/2012  08:58 AM    <DIR>          .
11/23/2012  08:58 AM    <DIR>          ..
11/22/2012  11:13 AM            35,701 cassandra-clientutil.jar
11/22/2012  11:13 AM            64,465 cassandra-jdbc.jar
11/22/2012  11:13 AM           948,351 cassandra-thrift.jar
11/22/2012  11:13 AM         1,146,367 db2java.jar
11/22/2012  11:13 AM         3,348,681 db2jcc.jar
11/22/2012  11:13 AM             1,015 db2jcc_license_cu.jar
11/22/2012  11:13 AM         2,703,892 derby.jar
11/22/2012  11:13 AM           535,985 derbyclient.jar
11/22/2012  11:13 AM           242,891 derbynet.jar
11/22/2012  11:13 AM           812,386 ifxjdbc.jar
11/22/2012  11:13 AM         1,660,765 jconnect70.jar
11/22/2012  11:13 AM           141,648 jsqlparser-src.zip
11/22/2012  11:13 AM           142,861 jsqlparser.jar
11/22/2012  11:13 AM         4,581,825 jt400.jar
11/22/2012  11:13 AM           350,273 jtds-src.jar
11/22/2012  11:13 AM           329,228 jtds.jar
11/22/2012  11:13 AM           291,946 mongo.jar
11/22/2012  11:13 AM           651,205 mysql-src.jar
11/22/2012  11:13 AM           745,416 mysql.jar
11/22/2012  11:13 AM           445,188 ncluster.jar
11/22/2012  11:13 AM         2,714,189 ojdbc6.jar
11/22/2012  11:13 AM         1,656,248 orai18n.jar
11/22/2012  11:13 AM           346,944 paraccel-jdbc.jar
11/22/2012  11:13 AM           561,969 postgresql.jar
11/22/2012  11:13 AM         3,516,830 sqlite-jdbc.jar
11/22/2012  11:13 AM           286,773 util400.jar
11/22/2012  11:13 AM           262,740 xdb6.jar
11/22/2012  11:13 AM           839,982 xmlparserv2.jar
              28 File(s)     29,365,764 bytes
               2 Dir(s)  88,341,790,720 bytes free

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

Linux

[ADS_INSTALL]/lib/drivers/db2java.jar
[ADS_INSTALL]/lib/drivers/db2jcc.jar
[ADS_INSTALL]/lib/drivers/db2jcc_license_cu.jar

OSX

Aqua Data Studio.app/Contents/Java/drivers/db2java.jar
Aqua Data Studio.app/Contents/Java/drivers/db2jcc.jar
Aqua Data Studio.app/Contents/Java/drivers/db2jcc_license_cu.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.