Trying to connect to DB2 using Sqoop Generates Map Tasks Raising: "Error: com.ibm.db2.jcc.am.lm.isClosed()Z" on the BDA (Doc ID 1956451.1)

Last updated on JUNE 16, 2017

Applies to:

Big Data Appliance Integrated Software - Version 3.0.1 and later
x86_64

Symptoms

While trying to connect to DB2 using Sqoop, map tasks raising the error "Error: com.ibm.db2.jcc.am.lm.isClosed()Z" on the BDA.

Running the sqoop job with "-verbose" shows map tasks failing with:

...
14/12/15 11:26:39 INFO mapreduce.Job: Task Id : attempt_1417824162389_3059_m_000000_0, Status : FAILED
Error: com.ibm.db2.jcc.am.lm.isClosed()Z
14/12/15 11:26:39 INFO mapreduce.Job: Task Id : attempt_1417824162389_3059_m_000000_1, Status : FAILED
Error: com.ibm.db2.jcc.am.lm.isClosed()Z
14/12/15 11:26:39 INFO mapreduce.Job: Task Id : attempt_1417824162389_3059_m_000000_2, Status : FAILED
Error: com.ibm.db2.jcc.am.lm.isClosed()Z
14/12/15 11:26:39 INFO mapreduce.Job: Task Id : attempt_1417824162389_3059_m_000000_3, Status : FAILED
Error: com.ibm.db2.jcc.am.lm.isClosed()Z
14/12/15 11:26:39 INFO mapreduce.Job: Job job_1417824162389_3059 failed with state FAILED due to:
...
14/12/15 11:26:39 INFO mapreduce.ImportJobBase: The MapReduce job has already been retired. Performance
14/12/15 11:26:39 INFO mapreduce.ImportJobBase: counters are unavailable. To get this information,
14/12/15 11:26:39 INFO mapreduce.ImportJobBase: you will need to enable the completed job store on
14/12/15 11:26:39 INFO mapreduce.ImportJobBase: the jobtracker with:
14/12/15 11:26:39 INFO mapreduce.ImportJobBase: mapreduce.jobtracker.persist.jobstatus.active = true
14/12/15 11:26:39 INFO mapreduce.ImportJobBase: mapreduce.jobtracker.persist.jobstatus.hours = 1
14/12/15 11:26:39 INFO mapreduce.ImportJobBase: A jobtracker restart is required for these settings
14/12/15 11:26:39 INFO mapreduce.ImportJobBase: to take effect.
14/12/15 11:26:39 DEBUG util.ClassLoaderStack: Restoring classloader: sun.misc.Launcher$AppClassLoader@1a722ef
14/12/15 11:26:39 ERROR tool.ImportTool: Error during import: Import job failed!

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms