Thanks for the response will try that out.


Sorry, i don't have any experience with DB2, but i guess you can try the latest version of sqoop (1.4.5).
Another thing is you can pass the --verbose flag to get more details.


On Mon, Sep 15, 2014 at 3:01 PM, Ajit Koti <> wrote:

I am using db2jcc4.jar , sqoop 1.4.2, 
When sqoop tries to close the connection, it throws the below warning, 

14/09/15 16:30:39 INFO mapreduce.ImportJobBase: Transferred 24.4863 KB in 14.0591 seconds (1.7417 KB/sec)
14/09/15 16:30:39 INFO mapreduce.ImportJobBase: Retrieved 578 records.
14/09/15 16:30:39 INFO util.AppendUtils: Appending to directory test
14/09/15 16:30:39 INFO util.AppendUtils: Using found partition 36
14/09/15 16:30:39 INFO tool.ImportTool: Saving incremental import state to the metastore
14/09/15 16:30:39 INFO tool.ImportTool: Updated data for job: db2_test_fetch44

14/09/15 16:30:39 WARN tool.BaseSqoopTool: Error while closing connection: [jcc][t4][10251][10308][4.14.119] java.sql.Connection.close() requested while a transaction is in progress on the connection.
The transaction remains active, and the connection cannot be closed. ERRORCODE=-4471, SQLSTATE=null

Has anyone faced it before , any workarounds and any suggestion would be helpful.