It is related. I believe some db2 and sqoop guru can help. Someone would have had this error before.
Thanks, Chalcy On Thu, Apr 9, 2015 at 1:32 PM, SHANKAR REDDY <[email protected]> wrote: > Nothing related to SQOOP on this error you have I believe. > > > -Shan > > > On Thursday, April 9, 2015, Chalcy <[email protected]> wrote: > >> 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 >> > > > -- > Regards, > Sankara Reddy Telukutla >
