Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
JDBC Drivers - DB2 z/OS JDBC Driver
|
|
Vendor: IBM
Website: http://www.ibm.com/software/data/db2/zos/
Database Product: DB2 for z/OS
Description: High-performance database for availability, scalability and reliability - optimized for SOA, CRM and data warehousing.
Note: JDBC Driver db2jcc_license_cisuz.jar (provided with DB2 Connect and DB2 Enterprise Server Edition) must be downloaded from vendor and is not bundled within ADS. Copy the driver into the Aqua Data Studio/lib/drivers folder.
Note for OS X users: For OS X, jdbc drivers should be placed within the "Aqua Data Studio.app"/Contents/Resources/Java/drivers directory. You can access this directory through the OS X Finder by right clicking on the application "Aqua Data Studio.app" and selecting "Show Package Contents."
Navigate within the package contents to /Contents/Resources/Java/drivers and add the drivers to this directory.
Then, still within the "Aqua Data Studio.app" package contents, edit the /Contents/Info.plist and add these drivers to the class path where you see the other jdbc drivers listed, such as <STRING> $JAVAROOT/drivers/mysql.jar </STRING>.
For each .jar file you added, create a new <STRING> $JAVAROOT/drivers/</STRING> line in /Contents/Info.plist, so that it contains a path to each new .jar file.
Once you've added the paths to Info.plist, restart Aqua Data Studio.
C:\Program Files\Aqua Data Studio 11.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 11.0 - 64bit\lib\drivers
04/09/2012 04:07 PM <DIR> .
04/09/2012 04:07 PM <DIR> ..
04/08/2012 04:03 PM 1,146,367 db2java.jar
12/07/2008 01:08 PM 3,059,973 db2jcc.jar
12/07/2008 01:08 PM 2,068 db2jcc_license_cisuz.jar
12/07/2008 01:08 PM 1,015 db2jcc_license_cu.jar
04/08/2012 04:03 PM 2,446,767 derby.jar
04/08/2012 04:03 PM 514,328 derbyclient.jar
04/08/2012 04:03 PM 229,921 derbynet.jar
04/08/2012 04:03 PM 812,386 ifxjdbc.jar
04/08/2012 04:03 PM 562,289 jconnect60.jar
04/08/2012 04:03 PM 4,485,843 jt400.jar
04/08/2012 04:03 PM 320,846 jtds-src.jar
04/08/2012 04:03 PM 324,727 jtds.jar
04/08/2012 04:03 PM 651,205 mysql-src.jar
04/08/2012 04:03 PM 745,416 mysql.jar
04/08/2012 04:03 PM 445,188 ncluster.jar
04/08/2012 04:03 PM 1,646,178 nlscharset12.jar
08/23/2010 11:07 AM 339,634 nzjdbc.jar
04/08/2012 04:03 PM 1,555,682 oracle.jar
04/08/2012 04:03 PM 346,944 paraccel-jdbc.jar
04/08/2012 04:03 PM 475,580 postgresql.jar
06/20/2008 01:41 PM 1,711 tdgssconfig.jar
05/08/2009 09:12 AM 855,053 terajdbc4.jar
04/08/2012 04:03 PM 286,773 util400.jar
04/08/2012 04:03 PM 139,148 xdb.jar
04/08/2012 04:03 PM 839,982 xmlparserv2.jar
25 File(s) 22,235,024 bytes
2 Dir(s) 113,013,755,904 bytes free
C:\Program Files\Aqua Data Studio 11.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 11.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=-Xmx512M 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 11.0 - 64bit> C:\Program Files\Aqua Data Studio 11.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\stringtemplate.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-ant.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-ant-commons-net.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-ant-jsch.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-ant-launcher.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-ant-nodeps.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-batik.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-fop.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-log4j.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-poi.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-poi-contrib.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-poi-ooxml.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-poi-ooxml-schemas.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-poi-scratchpad.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-serializer.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-xalan.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-beanutils.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-codec.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-collections.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-compress.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-configuration.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-dbcp.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-dbutils.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-email.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-httpclient.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-io.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-lang.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-logging.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-logging-adapters.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-logging-api.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-math.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-net.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-net-ftp.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-primitives.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-transaction.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-validator.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-vfs.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-xmlgraphics.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\dom4j.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\hadoop-core.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\jakarta-oro.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\jcraft-jsch.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\tidy.jar SET ADS_PATH=%ADS_PATH%;.\lib\apple\aqua2.jar SET ADS_PATH=%ADS_PATH%;.\lib\aquafold\geo.jar SET ADS_PATH=%ADS_PATH%;.\lib\aspose\aspc.jar SET ADS_PATH=%ADS_PATH%;.\lib\aspose\jsr173-api.jar SET ADS_PATH=%ADS_PATH%;.\lib\aspose\stax2-api.jar SET ADS_PATH=%ADS_PATH%;.\lib\aspose\woodstox-core-asl.jar SET ADS_PATH=%ADS_PATH%;.\lib\dnsjava\dnsjava.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\db2java.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\db2jcc.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\db2jcc_license_cisuz.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\db2jcc_license_cu.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\derby.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\derbyclient.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\derbynet.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\ifxjdbc.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\jconnect55.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\jconnect60.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\jt400.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\jtds.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\mysql.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\ncluster.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\nlscharset12.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\nzjdbc.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\oracle.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\paraccel-jdbc.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\postgresql.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\tdgssconfig.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\terajdbc4.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\util400.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\xdb.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\xmlparserv2.jar SET ADS_PATH=%ADS_PATH%;.\lib\icepdf\icepdf-core.jar SET ADS_PATH=%ADS_PATH%;.\lib\icepdf\icepdf-viewer.jar SET ADS_PATH=%ADS_PATH%;.\lib\infragistics\infragistics.jar SET ADS_PATH=%ADS_PATH%;.\lib\itext\itext.jar SET ADS_PATH=%ADS_PATH%;.\lib\java\activation.jar SET ADS_PATH=%ADS_PATH%;.\lib\java\mail.jar SET ADS_PATH=%ADS_PATH%;.\lib\java\servlet-api.jar SET ADS_PATH=%ADS_PATH%;.\lib\java\tools.jar SET ADS_PATH=%ADS_PATH%;.\lib\jgoodies\looks.jar SET ADS_PATH=%ADS_PATH%;.\lib\jgraph\jgraph.jar SET ADS_PATH=%ADS_PATH%;.\lib\jgraph\jgraphlayout.jar SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-action.jar SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-beaninfo.jar SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-common.jar SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-components.jar SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-dialogs.jar SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-dock.jar SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-grids.jar SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-pivot.jar SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-shortcut.jar SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-properties.jar SET ADS_PATH=%ADS_PATH%;.\lib\jinterop\jcifs.jar SET ADS_PATH=%ADS_PATH%;.\lib\jinterop\j-interop.jar SET ADS_PATH=%ADS_PATH%;.\lib\jinterop\j-interopdeps.jar SET ADS_PATH=%ADS_PATH%;.\lib\jna\jna.jar SET ADS_PATH=%ADS_PATH%;.\lib\jna\platform.jar SET ADS_PATH=%ADS_PATH%;.\lib\jogl\jogl.jar SET ADS_PATH=%ADS_PATH%;.\lib\jogl\gluegen-rt.jar SET ADS_PATH=%ADS_PATH%;.\lib\perforce\p4java.jar SET ADS_PATH=%ADS_PATH%;.\lib\quartz\quartz.jar SET ADS_PATH=%ADS_PATH%;.\lib\snmp4j\snmp4j.jar SET ADS_PATH=%ADS_PATH%;.\lib\ssh2\ssh2.jar SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\lib.core.jar SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\lib.htmlcss.jar SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\lib.java.jar SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\lib.javascript.jar SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\lib.terminal.jar SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\lib.xml.jar SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\standalone-htmlcss.jar SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\standalone-java.jar SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\standalone-javascript.jar SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\standalone-core.jar SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\standalone-xml.jar SET ADS_PATH=%ADS_PATH%;.\lib\svnkit\svnkit-cli.jar SET ADS_PATH=%ADS_PATH%;.\lib\svnkit\svnkit-javahl.jar SET ADS_PATH=%ADS_PATH%;.\lib\svnkit\svnkit.jar ECHO ON java -Xmx512M -XX:MaxPermSize=192m -cp "%ADS_PATH%" com.aquafold.datastudio.Data Studio C:\Program Files\Aqua Data Studio 11.0 - 64bit>