Data360 Analyze

Hi Adrian, further to the query I raised in respect of connecting Dataverse to an Iseries DB2 I database we subsequently re-installed the driver in the directory advised -  

/opt/dataverse-3.2.0/Dataverse/site-7731/lib/java/db/DB2i

I have the other settings as follows:

DB URL jdbc:as400://MDSDB2T2.mstest.loc/;prompt=false;translate binary=true

DB Driver as  com.ibm.as400.access.AS400JDBCDriver

and have set the DB DriverClassPath as per the driver location above.

Thanks in anticipation

Support tickets # 23699 has been opened to track this issue.

Here is an update on this issue for anyone using the JTOpen driver to connect to DB2.

The JTOpen driver can be downloaded from the JTOpen page on sourceforge.net as a zip file. The 'lib' folder contains a file named jt400.jar. However, do not use this file. Instead, navigate to the 'lib/java8' folder and use the jt400.jar file located in that folder as this file is compiled for use with Java 8 - which is used by the Dataverse application.

Additional comments:

The DbUrl property value should be of the form:

jdbc:as400://<host>:<port>/<dbname>

Driver options can be included in the DbUrl connection string as shown in the original post. Alternatively, options can be specified in the node's DbOptions property as a comma-separated list of key=value pairs.

The prompt=false option will prevent the driver attempting to open a pop-up sign-in window when the user credentials are not specified on the node. On certain Linux systems, if prompt=false is not set the credentials problem can manifest itself as an error relating to X11.

When using the jt400.jar driver discussed above, the DbDriverClassproperty needs to be configured to identify the path to the jt400.jar file. 

Note: When working with modern versions of ibm i the jcc driver can be used instead of the jt400 driver. The jcc driver for the DB2 database is now shipped with the product as from v.3.4.3 on the LTS release track and v.3.5.1 on the Feature release track. The driver can be selected from the list of databases in the DbType property. See the Help documentation for further details.