3.8 DB2 LUW 8.1 and DB2 UDB 8.2 (Revision #1)

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 which you need to 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>