The DB2 JDBC drivers included with ADS work across all 8.x, 9.x ,10.x and 11.x versions of DB2. There is no need to change or update this driver.
Contents
Driver Location
You may locate the latest DB2 9.x/10.x/11.x JDBC drivers at the following location ...
Vendor: IBM (JDBC Type 4 Driver)
Driver URL: http://www.ibm.com/support/us/
Database Product: DB2 9.x/10.x/11.x
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 has no label.
Volume Serial Number is 18E3-967F
Directory of C:\Program Files\IBM\SQLLIB\java
04/09/2007 08:19a DIR .
04/09/2007 08:19a DIR ..
07/11/2006 01:06a 2,227,922 Common.jar
07/11/2006 01:05a 47,649 db2dbgm.jar
07/11/2006 01:05a 869,388 db2java.zip
07/11/2006 01:05a 1,973,658 db2jcc.jar
07/11/2006 01:05a 23,709 db2jcc_javax.jar
07/11/2006 01:05a 1,015 db2jcc_license_cu.jar
07/11/2006 01:06a 120,951 db2policy.jar
07/11/2006 01:05a 170,472 db2qgjava.jar
07/11/2006 01:05a 9,095 db2umplugin.jar
04/09/2007 08:19a DIR images
04/09/2007 08:18a DIR jdk
07/11/2006 01:05a 1,515,827 sqlj.zip
10 File(s) 6,959,686 bytes
4 Dir(s) 26,645,422,080 bytes free
C:\Program Files\IBM\SQLLIB\java>
Updating Driver Contents for use DB2 9.x/10.x/11.x
To update the ADS JDBC drivers you need to overwrite the ADS db2java.jar (for DB2 7.2) and/or db2jcc.jar and db2jcc_license_cu.jar (for DB2 8.1) 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
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/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.