Connecting to DB2 using Sqoop Raises: ERROR "version of the IBM Universal JDBC driver in use is not licensed for connectivity to QDB2 databases" on the BDA (Doc ID 1956441.1)

Last updated on DECEMBER 24, 2014

Applies to:

Big Data Appliance Integrated Software - Version 3.0.1 and later
Linux x86-64

Symptoms

Trying to connect to DB2 using Sqoop Raises: ERROR "version of the IBM Universal JDBC driver in use is not licensed for connectivity to QDB2 databases".  The full error looks like:

ERROR manager.SqlManager: Error executing statement: com.ibm.db2.jcc.am.io: [jcc][t4][10109][10354][3.57.82] The version of the IBM Universal JDBC driver in use is not licensed for connectivity to QDB2 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 QDB2 databases is enabled by any of the following license files: [ db2jcc_license_cisuz.jar ]. ERRORCODE=-4472, SQLSTATE=42968
com.ibm.db2.jcc.am.io: [jcc][t4][10109][10354][3.57.82] The version of the IBM Universal JDBC driver in use is not licensed for connectivity to QDB2 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 QDB2 databases is enabled by any of the following license files: [ db2jcc_license_cisuz.jar ]. ERRORCODE=-4472, SQLSTATE=42968

Additional symptoms:

1. The Sqoop DB2 JDBC driver requires two files:

a) The DB2 driver /usr/lib/sqoop/db2/v9.7/java/db2jcc4.jar
b) The DB2 license file /usr/lib/sqoop/db2/v9.7/java/db2jcc_license_cisuz.jar

Both of these files are present in the required location /var/lib/sqoop:

2. Running the sqoop command with "-verbose" shows that both files are in the hadoop_classpath. 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms