DB2 LUW 8.1 and DB2 UDB 8.2

JDBC Drivers - DB2 8.1 & 8.2 JDBC Driver

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.

Driver Location (Windows/Linux):
[ADS_INSTALL]\lib\drivers\db2jcc.jar

Driver Location (OSX):
/Aqua Data Studio/Contents/Resources/Java/drivers/db2jcc.jar

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

Vendor: IBM (JDBC Type 4 Driver)

Driver URL: http://www.ibm.com/support/us/

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>
        

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

C:\Program Files\Aqua Data Studio 12.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 12.0 - 64bit\lib\drivers

07/26/2012  07:45 AM    <DIR>          .
07/26/2012  07:45 AM    <DIR>          ..
07/26/2012  06:33 AM         1,146,367 db2java.jar
07/26/2012  06:33 AM         3,348,681 db2jcc.jar
07/26/2012  06:33 AM             1,015 db2jcc_license_cu.jar
07/26/2012  06:33 AM         2,671,577 derby.jar
07/26/2012  06:33 AM           538,340 derbyclient.jar
07/26/2012  06:33 AM           239,546 derbynet.jar
07/26/2012  06:33 AM           812,386 ifxjdbc.jar
07/26/2012  06:33 AM         1,437,384 jconnect70.jar
07/26/2012  06:33 AM         4,581,825 jt400.jar
07/26/2012  06:33 AM           327,933 jtds-src.jar
07/26/2012  06:33 AM           327,974 jtds.jar
07/26/2012  06:33 AM           291,946 mongo.jar
07/26/2012  06:33 AM           651,205 mysql-src.jar
07/26/2012  06:33 AM           745,416 mysql.jar
07/26/2012  06:33 AM           445,188 ncluster.jar
07/26/2012  06:33 AM         2,714,189 ojdbc6.jar
07/26/2012  06:33 AM         1,656,248 orai18n.jar
07/26/2012  06:33 AM           346,944 paraccel-jdbc.jar
07/26/2012  06:33 AM           561,969 postgresql.jar
07/26/2012  06:33 AM         3,516,830 sqlite-jdbc.jar
07/26/2012  06:33 AM           286,773 util400.jar
07/26/2012  06:33 AM           262,740 xdb6.jar
07/26/2012  06:33 AM           839,982 xmlparserv2.jar
              23 File(s)     27,752,458 bytes
               2 Dir(s)  252,798,070,784 bytes free

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

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 ADS from the command line. The contents of the file are as follows ...

C:\Program Files\Aqua Data Studio 12.0 - 64bit>type datastudio.ini
working.directory=.

# JVM Properties
vm.location=.\jre\bin\server\jvm.dll

# Specify a proportion of the available physical memory to use (ie. relates to -
Xmx arg). For example, vm.heapsize.max.percent=75. Note that this will use the m
aximum memory possible.
#vm.heapsize.max.percent=

#Specify a proportion of the available physical memory to use as the minimum sta
rting heap size (ie. relates to -Xms arg).
#vm.heapsize.min.percent=

#Specify a preferred amount (in MB) for the heap size (ie. relates to -Xmx arg).
 If this amount is not available it will use the maximum amount possible given t
he physical memory available.
#vm.heapsize.preferred=

#Specifies that only one instance of the product should run at any given time
#single.instance=window
single.instance=dde
dde.enabled=true
dde.class=com.common.windows.noobfus.WinDDE
dde.server.name=datastudio

vmarg.1=-Dsun.swing.enableImprovedDragGesture
vmarg.2=-Xmx756M
vmarg.3=-XX:MaxPermSize=128m

classpath.1=.\lib\*.jar
classpath.2=.\lib\antlr\*.jar
classpath.3=.\lib\apache\*.jar
classpath.4=.\lib\apple\*.jar
classpath.5=.\lib\aquafold\*.jar
classpath.6=.\lib\aspose\*.jar
classpath.7=.\lib\dnsjava\*.jar
classpath.8=.\lib\drivers\*.jar
classpath.9=.\lib\icepdf\*.jar
classpath.10=.\lib\infragistics\*.jar
classpath.11=.\lib\itext\*.jar
classpath.12=.\lib\java\*.jar
classpath.13=.\lib\jgoodies\*.jar
classpath.14=.\lib\jgraph\*.jar
classpath.15=.\lib\jide\*.jar
classpath.16=.\lib\jinterop\*.jar
classpath.17=.\lib\jna\*.jar
classpath.18=.\lib\jogl\*.jar
classpath.19=.\lib\perforce\*.jar
classpath.20=.\lib\quartz\*.jar
classpath.21=.\lib\snmp4j\*.jar
classpath.22=.\lib\ssh2\*.jar
classpath.23=.\lib\stndeditor\*.jar
classpath.24=.\lib\svnkit\*.jar

main.class=com.aquafold.datastudio.DataStudio




C:\Program Files\Aqua Data Studio 12.0 - 64bit>



C:\Program Files\Aqua Data Studio 12.0 - 64bit>type datastudio.bat
ECHO OFF

SET ADS_PATH=
SET ADS_PATH=%ADS_PATH%;.\lib\ads.jar
SET ADS_PATH=%ADS_PATH%;.\lib\aqua-lib.jar
SET ADS_PATH=%ADS_PATH%;.\lib\antlr\*
SET ADS_PATH=%ADS_PATH%;.\lib\apache\*
SET ADS_PATH=%ADS_PATH%;.\lib\apple\*
SET ADS_PATH=%ADS_PATH%;.\lib\aquafold\*
SET ADS_PATH=%ADS_PATH%;.\lib\aspose\*
SET ADS_PATH=%ADS_PATH%;.\lib\dnsjava\*
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\*
SET ADS_PATH=%ADS_PATH%;.\lib\icepdf\*
SET ADS_PATH=%ADS_PATH%;.\lib\infragistics\*
SET ADS_PATH=%ADS_PATH%;.\lib\itext\*
SET ADS_PATH=%ADS_PATH%;.\lib\java\*
SET ADS_PATH=%ADS_PATH%;.\lib\jgoodies\*
SET ADS_PATH=%ADS_PATH%;.\lib\jgraph\*
SET ADS_PATH=%ADS_PATH%;.\lib\jide\*
SET ADS_PATH=%ADS_PATH%;.\lib\jinterop\*
SET ADS_PATH=%ADS_PATH%;.\lib\jna\*
SET ADS_PATH=%ADS_PATH%;.\lib\jogl\*
SET ADS_PATH=%ADS_PATH%;.\lib\perforce\*
SET ADS_PATH=%ADS_PATH%;.\lib\quartz\*
SET ADS_PATH=%ADS_PATH%;.\lib\snmp4j\*
SET ADS_PATH=%ADS_PATH%;.\lib\ssh2\*
SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\*
SET ADS_PATH=%ADS_PATH%;.\lib\svnkit\*

ECHO ON

java -Xmx756M -XX:MaxPermSize=192m -cp "%ADS_PATH%" com.aquafold.datastudio.DataStudio


C:\Program Files\Aqua Data Studio 12.0 - 64bit>