sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chalcy <cha...@gmail.com>
Subject DB2 sqoop activate license error
Date Thu, 09 Apr 2015 16:48:25 GMT
Hi All,

I am trying to connect to db2 and copied all the jars to /var/lib/sqoop and
I am getting error as below.

Can anyone help me with what is missing?

Thanks,
Chalcy

Error: java.lang.RuntimeException: java.lang.RuntimeException:
com.ibm.db2.jcc.am.SqlSyntaxErrorException:
[jcc][t4][10509][13454][4.14.137] Connection to the data server failed. 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. ERRORCODE=-4230,
SQLSTATE=42968

        at
org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:167)

        at
org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:73)

        at
org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:133)

        at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:726)

        at org.apache.hadoop.mapred.MapTask.run(MapTask.java:340)

        at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:167)

        at java.security.AccessController.doPrivileged(Native Method)

        at javax.security.auth.Subject.doAs(Subject.java:415)

        at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1554)

        at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:162)

Caused by: java.lang.RuntimeException:
com.ibm.db2.jcc.am.SqlSyntaxErrorException:
[jcc][t4][10509][13454][4.14.137] Connection to the data server failed. The
IBM Data Server for JDBC and SQLJ license was invalid

Mime
View raw message