I am still getting same error. sqoop list-tables --driver com.ibm.db2.jcc.DB2Driver --connect jdbc:db2:@XXXXX.com:455/USCTFN01DB2HD1 --username XXXXXX --password YYYYY
14/07/24 14:30:21 ERROR manager.SqlManager: Error reading database metadata: com.ibm.db2.jcc.am.SqlException: [jcc][10389][12245][3.65.110] Failure in loading native library db2jcct2, java.lang.UnsatisfiedLinkError: no db2jcct2 in java.library.path: ERRORCODE=-4472, SQLSTATE=null com.ibm.db2.jcc.am.SqlException: [jcc][10389][12245][3.65.110] Failure in loading native library db2jcct2, java.lang.UnsatisfiedLinkError: no db2jcct2 in java.library.path: ERRORCODE=-4472, SQLSTATE=null Any thoughts? Did I get the right JDBC jar? Regards, Venkat -----Original Message----- From: Gwen Shapira [mailto:[email protected]] Sent: Thursday, July 24, 2014 3:07 PM To: [email protected] Subject: Re: Sqoop Import Error from Mainframe DB2 Hi, Here's what I use: sqoop list-tables --driver com.ibm.db2.jcc.DB2Driver --connect jdbc:db2://example.com:50000/MYDB --username MY --password password I think the DBNAME is required. Gwen On Thu, Jul 24, 2014 at 1:04 PM, Venkat, Ankam <[email protected]> wrote: > I need to import data from Mainframe DB2 to Hadoop using Sqoop. I am > getting below errors. Any help on this highly appreciated. > > > > With command à sqoop list-databases --connect > jdbc:db2://xxxxxx.com:455/ --username XXXXX --password YYYYY > > Error: Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: > [jcc][10165][10047][4.14.111] Invalid database URL syntax: > jdbc:db2://d1vipa.corp.intranet:455/. ERRORCODE=-4461, SQLSTATE=42815 > > > > With command à sqoop list-databases --connect > jdbc:db2:@xxxxxx.com:455/ --username XXXXX --password YYYYY > > Error: Caused by: com.ibm.db2.jcc.am.SqlException: > [jcc][10389][12245][4.14.111] Failure in loading native library > db2jcct2, > java.lang.UnsatisfiedLinkError: no db2jcct2 in java.library.path: > ERRORCODE=-4472, SQLSTATE=null > > > > Downloaded DB2 Version 10.1 JDBC driver (both 3.0 and 4.0) and after > extracting I see two jar files (db2jcc4.jar and db2jcc.jar). > > > > I copied db2jcc4.jar to > /opt/cloudera/parcels/CDH-5.0.0-1.cdh5.0.0.p0.47/lib/sqoop/lib and > then tried above two commands. Tried with db2jcc.jar as well but > getting same errors. Tried copying these jars from both 3.0 and 4.0 > versions after deleting the earlier JDBC. > > > > Mainframe DB2 version is 10.1 and My Sqoop version is Sqoop 1.4.4-cdh5.0.0. > > > > Any quick help? > > > > Thanks in advance. > > > > Regards, > > Venkat Ankam
