Data360 Analyze

Hello,

We are getting the message, "Unable to load Driver Class: com.ibm.db2.jcc.DB2Driver".

There are the jar files we have installed: db2jcc4.jar, db2jcc_license_cisuz.jar, db2jcc_license_cu.jar

In this directory ../site-7731/lib/bd/db2

Do we have the correct jar files installed? I can connect to the DB2 in our installation of LAE6.1.4. But we can connect to the same DB2 in our newly installed Data3Sixty....

Thanks

Clarification, we can not connect to the same DB2 in out newly installed Data3Sixty.

Hi Brad,

If you are using a release on the Analyze Long Term Support track (3.4.x) you should consider upgrading to v.3.4.3 which ships with the DB2 JDBC driver pre-installed. We will also be shipping this driver in the next release on the Feature release track next month (v.3.5.1).

Both of these releases will use the jcc-11.5.0.0.jar

Note, Analyze uses Java 8 vs. LAE 6.1.4 which uses Java 7. There is a comment on this page that "JDK/JRE 1.8 support first included with JDBC drivers bundled with v10.5FP7" which, from the table, corresponds to v.4.19.49 for the db2jcc4.jar

https://render-prd-trops.events.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads

Hi Adrian,

Thanks. We are running D360 Analyze (3.4.2). I loaded jcc-11.5.0.0.jar and I'm still getting the same error.

We now have

I'm not sure why that last post was cut. The files are installed in ../site-7731/lib/db/db2. In addition to the new jar the other jar files installed are listed in my original post.

Thanks,

Brad

The jcc-11.5.0.0.jar is an alternative to using the db2jcc4.jar.  I think you should be using one or the other (set) but not both - the node may be picking up the class from the db2jcc4.jar.

Did you check the version number of the db2jcc4.jar you have installed to confirm whether it is one that is compatible with Java 8? 

If you are using the jcc-11.5.0.0.jar instead then it will still need to be licensed so you will still need the b2jcc_license_cisuz.jar (you may get an error indicating it is not licensed if the driver jar cannot find this file when it is run). If this is the case you should add the site-7731/lib/db/db2 directory to the JDBC node's DbDriverClasspath property.

Thanks, I should have remembered that. I removed the db2jcc4.jar, so it should only have access to jcc-11.5.0.0.jar. But, I'm getting the same error, "Unable to load driver class:...". Thoughts? Thanks, Brad

I believe the directory where the files are installed should be

 ../site-7731/lib/java/db/db2

We resolved this by adding the string below to the DbDriverClasspath of a JDBC node.

{{%ls.appdatadir%}}/lib/db/db2

I believe the variable is a system variable. The rest of it is the remaining portion of the path that points to the location of the required drivers. I think we only need this for JDBC nodes connecting to DB2 db's.

Thanks everyone! Brad