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
