IBM Support

DB2 JDBC driver is not licensed for connectivity by file db2jcc_license_cisuz.jar ERRORCODE=-4472 SQLSTATE=42968

Technote (troubleshooting)


Problem(Abstract)

I'm trying to connect to a mainframe. I am new to JDBC connections. My java application fails with the following message. How do you locate or obtain the license jar file?

"[jcc][t4][10109][10354][4.7.85] The version of the IBM Universal JDBC driver in use is not licensed for connectivity to xxx databases. To connect to this server, please obtain a licensed copy of the IBM DB2 Universal Driver for JDBC and SQLJ.
An appropriate license file db2jcc_license_*.jar for this target platform must be installed to the application class path.
Connectivity to xxx databases is enabled by any of the following files: [db2jcc_license_cisuz.jar]. ERRORCODE=-4472, SQLSTATE=42968".
 

Cause

The JDBC connection checks to see if it is licensed to connect to the server by checking the CLASSPATH environment variable for db2jcc_license_cisuz.jar. If the correct license file is not listed in the CLASSPATH then the error is returned.
 

Resolving the problem

To resolve the error you must add the appropriate DB2 JDBC license file to the applications CLASSPATH environment variable. If you are connecting to a host (z/OS or iSeries) then you need to add the db2jcc_license_cisuz.jar file.

Where do I find the license file?

The db2jcc_license_cisuz.jar file is included in all DB2 Connect server editions including DB2 Connect Personal Edition. The license is also part the IBM Database Enterprise Developer Edition. If you already have one of these products, then please use the license file from the DB2 Connect Activation CD. If you have a Passport Advantage account, then remember to download the activation key from Passport Advantage for the DB2 Connect edition that you have purchased.

The db2jcc_license_cisuz.jar file is located in the /db2/license directory of the activation CD or activation file downloaded from Passport Advantage.

The license files for DB2 Connect products are not shipped with fix packs. Fix packs only contain a 90 day trial license for DB2 Connect and do not contain the license for the JDBC driver. Only the purchased product delivered on physical media (CD or DVD) or delivered from Passport Advantage contains the JDBC license that allows you to connect to a mainframe.

I don't have a DB2 Connect product. Now what do I do?
If you do not have the file, then you must purchase a DB2 Connect product so that you may license the JDBC driver to connect to a mainframe.

Note: If the Java application is being ran as a deployed JAR file, the error can also be encountered if the Class-Path header field in the manifest file, MANIFEST.MF, does not include the path of db2jcc_license_cisuz.jar



https://www.ibm.com/developerworks/community/forums/html/topic?id=3dfe2446-ba9d-40d3-b519-3dc12f6da4b1


Related information

Common licensing questions when migrating to DB2 Versio
Installing the JDBC driver
Knowledge Collection: JDBC driver issues

Cross reference information
Segment Product Component Platform Version Edition
Information Management DB2 for Linux- UNIX and Windows DB2 Programming Interfaces - JDBC AIX, Linux, Solaris, Windows 9.5
Information Management IBM Data Server Client Packages AIX, HP-UX, Linux, Solaris, Windows 9.5 All Editions

Document information

More support for: DB2 Connect

Software version: 9.5, 9.7, 10.1, 10.5

Operating system(s): AIX, Linux, Solaris, Windows

Software edition: Enterprise, Personal

Reference #: 1413734

Modified date: 20 May 2010


Translate this page: