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
