DB2 JDBC License Error

Owned by Former user (Deleted)
Last updated: Jan 25, 2023 by Stonebranch (Deactivated)
1 min read

Problem

A SQL or Stored Procedure task using a DB2 Database Connection may fail with the following error message:

The IBM Data Server for JDBC and SQLJ license was invalid or was not activated for the DB2 for z/OS subsystem. If you are connecting 
directly to the data server and using DB2 Connect Unlimited Edition for System z, perform the activation step by running the activation 
program in the license activation kit. If you are using any other edition of DB2 Connect, obtain the license file, db2jcc_license_cisuz.jar, 
from the license activation kit, and follow the installation directions to include the license file in the class path.

Solution

The db2jcc_license_cisuz.jar file needs to be included in the classpath for Universal Controller.
 

Step 1

Copy the db2jcc_license_cisuz.jar file to the following directory:
 
Windows
[tomcat-install]\webapps\uc\WEB-INF\lib
 
UNIX
[tomcat-install]/webapps/uc/WEB-INF/lib

Step 2

Restart Universal Controller.