DB2 7.2 is the database which has the most connection issues. JDBC drivers for database version are not compatible, neither are they compatible across fixpacks. Updating your DB2 JDBC driver to the version which you are using is always a good idea. The DB2 Server installation provides JDBC drivers for the version and fixpack in use. You may copy the provided JDBC driver and overwrite the driver provided by ADS. You can copy the /sqllib/java/db2java.zip that comes with your installation and overwrite the /ADS_INSTALLATION/lib/db2java.jar file.

- NOTE: The DB2 7.2 JDBC driver does not connect directly to the DB2 Server, but to a proxy server which is installed with the DB2 Server. This proxy server can be started with the db2jstrt[.exe], which defaults to port 6789. The process is enabled by default in most installations.

Driver Location (Windows/Linux): [ADS_INSTALL]\lib\drivers\db2java.jar
Driver Location (OSX): /Aqua Data Studio/Contents/Resources/Java/drivers/db2java.jar

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

Vendor: IBM
Driver URL: DB2 Server Installation ([DB2 Install]\java\db2java.zip)

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\SQLLIB\java>dir
 Volume in drive C has no label.
 Volume Serial Number is 7C2B-F9B7

 Directory of C:\Program Files\SQLLIB\java

09/03/2002  12:39p      DIR          .
09/03/2002  12:39p      DIR          ..
06/17/2003  07:02p             554,911 cc_cmn.jar
06/17/2003  07:02p             266,631 cc_nav.jar
06/17/2003  06:58p             809,313 common.jar
03/07/2003  07:20p             234,244 databean.jar
06/27/2003  04:23p           1,146,367 db2java.zip
06/18/2003  04:37a               5,342 db2vcsql.jar
09/03/2002  11:21a      DIR          images
09/03/2002  11:19a      DIR          java12
09/03/2002  12:36p      DIR          jdk
06/17/2003  07:01p             239,966 jgraph.jar
09/03/2002  12:35p      DIR          jre
09/03/2002  12:40p      DIR          prime
06/17/2003  06:22p             338,990 runtime.zip
06/17/2003  06:58p           1,253,896 sqlasst.jar
06/17/2003  06:22p           1,671,552 sqlj.zip
06/17/2003  09:29p           2,458,220 swingall.jar
              11 File(s)      8,979,432 bytes
               7 Dir(s)   5,216,145,408 bytes free

C:\Program Files\SQLLIB\java>

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

C:\Program Files\Aqua Data Studio 7.0 - 32bit\lib\drivers>dir
 Volume in drive C has no label.
 Volume Serial Number is AC70-D62C

 Directory of C:\Program Files\Aqua Data Studio 7.0 - 32bit\lib\drivers

05/30/2008  08:48 AM    dir          .
05/30/2008  08:48 AM    dir          ..
03/20/2008  10:05 PM         1,146,367 db2java.jar
03/20/2008  10:05 PM         1,973,658 db2jcc.jar
03/20/2008  10:05 PM             1,015 db2jcc_license_cu.jar
03/20/2008  10:05 PM         2,343,388 derby.jar
03/20/2008  10:05 PM           489,802 derbyclient.jar
04/05/2008  01:15 PM           218,162 derbynet.jar
03/20/2008  10:05 PM           685,631 ifxjdbc.jar
03/20/2008  10:05 PM           529,560 jconnect60.jar
03/20/2008  10:05 PM         4,301,866 jt400.jar
03/20/2008  10:05 PM           554,589 jtds-src.jar
05/06/2008  09:46 PM           297,610 jtds.jar
03/20/2008  10:05 PM           655,034 mysql-src.jar
03/20/2008  10:05 PM           676,693 mysql.jar
04/16/2008  09:29 AM         1,645,114 nlscharset12.jar
04/16/2008  09:29 AM         1,545,954 oracle.jar
03/20/2008  10:05 PM           415,542 postgresql.jar
03/20/2008  10:05 PM           286,771 util400.jar
03/20/2008  10:05 PM           139,148 xdb.jar
03/20/2008  10:05 PM           839,982 xmlparserv2.jar
              19 File(s)     18,745,886 bytes
               2 Dir(s)  17,642,438,656 bytes free

The Java class path for the drivers are already configured for ADS in the datastudio.cfg 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 6.5>type datastudio.cfg

.

.\jre\bin\javaw.exe

-Dsun.swing.enableImprovedDragGesture -Xmx256M -cp ".\lib\ads.jar;
.\lib\aqua-lib.jar;
.\lib\aspc.jar;
.\lib\aqua2.jar;
.\lib\oracle.jar;
.\lib\nlscharset12.jar;
.\lib\jtds.jar;
.\lib\derby.jar;
.\lib\derbyclient.jar;
.\lib\mysql.jar;
.\lib\postgresql.jar;
.\lib\db2java.jar;
.\lib\db2jcc.jar;
.\lib\db2jcc_license_cu.jar;
.\lib\ifxjdbc.jar;
.\lib\jconnect55.jar;
.\lib\jconnect60.jar;
.\lib\xmlparserv2.jar;
.\lib\xdb.jar;
.\lib\activation.jar;
.\lib\jaxb1-impl.jar;
.\lib\jaxb-api.jar;
.\lib\jaxb-impl.jar;
.\lib\jaxb-xjc.jar;
.\lib\jsr173_1.0_api.jar;
.\lib\stringtemplate.jar;
.\lib\jide-action.jar;
.\lib\jide-beaninfo.jar;
.\lib\jide-common.jar;
.\lib\jide-components.jar;
.\lib\jide-dialogs.jar;
.\lib\jide-dock.jar;
.\lib\jide-grids.jar;
.\lib\jide-pivot.jar;
.\lib\jide-shortcut.jar" com.aquafold.datastudio.DataStudio

C:\Program Files\Aqua Data Studio 6.5>type datastudio.bat
SET ADS_PATH=
SET ADS_PATH=%ADS_PATH%;.\lib\oracle.jar
SET ADS_PATH=%ADS_PATH%;.\lib\nlscharset12.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jtds.jar
SET ADS_PATH=%ADS_PATH%;.\lib\derby.jar
SET ADS_PATH=%ADS_PATH%;.\lib\derbyclient.jar
SET ADS_PATH=%ADS_PATH%;.\lib\mysql.jar
SET ADS_PATH=%ADS_PATH%;.\lib\postgresql.jar
SET ADS_PATH=%ADS_PATH%;.\lib\db2jcc.jar
SET ADS_PATH=%ADS_PATH%;.\lib\db2jcc_license_cu.jar
SET ADS_PATH=%ADS_PATH%;.\lib\db2java.jar
SET ADS_PATH=%ADS_PATH%;.\lib\ifxjdbc.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jconnect55.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jconnect60.jar
SET ADS_PATH=%ADS_PATH%;.\lib\aqua-lib.jar
SET ADS_PATH=%ADS_PATH%;.\lib\aqua2.jar
SET ADS_PATH=%ADS_PATH%;.\lib\xmlparserv2.jar
SET ADS_PATH=%ADS_PATH%;.\lib\xdb.jar

SET ADS_PATH=%ADS_PATH%;.\lib\activation.jar
SET ADS_PATH=%ADS_PATH%;.\lib\aspc.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jaxb1-impl.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jaxb-api.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jaxb-impl.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jaxb-xjc.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jsr173_1.0_api.jar
SET ADS_PATH=%ADS_PATH%;.\lib\stringtemplate.jar

SET ADS_PATH=%ADS_PATH%;.\lib\jide-action.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide-beaninfo.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide-common.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide-components.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide-dialogs.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide-dock.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide-grids.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide-pivot.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide-shortcut.jar