JR59346: THE NPE HAPPENS WHEN THE LOB RECORDS ARE COMING BEFORE THE DMS RECORDS.

APAR status

• Closed as program error.

Error description

• The NPE happens when the LOB records are coming before the DMS
  records. OP_NON_UPDATE_LOB is sent when some extended row data
  has been updated but update does not contain data that could be
  considered as extended row.
  Since the LOB record is coming before the DMS record, CDC is
  trying to get the next log entry from the txnq. But there are
  no more entries in this transaction hence it returns null.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * NONE                                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Stack:                                                       *
  * 2055130    2018-02-05 06:12:53.513    SHAREDSCRAPE LOG       *
  * PARSER{155589}    com.datamirror.ts.util.TsExceptionHandler  *
  * processUnhandledException()    An uncaught exception has     *
  * occurred: ?java.lang.NullPointerException |    at            *
  * com.datamirror.ts.scrapers.db2udbscraper.Db2udbLogParser.par *
  * seLocalCommittedTxn(Db2udbLogParser.java:498)|    at         *
  * com.datamirror.ts.scrapers.db2udbscraper.Db2udbLogParser.par *
  * seCommittedTxn(Db2udbLogParser.java:392)|    at              *
  * com.datamirror.ts.scrapers.cdc.LogParser.handleCommitEntry(L *
  * ogParser.java:2737)|    at                                   *
  * com.datamirror.ts.scrapers.cdc.LogParser.execute(LogParser.j *
  * ava:748)|    at                                              *
  * com.datamirror.ts.scrapers.cdc.LogParser$LogParserPipelineJo *
  * b.execute(LogParser.java:154)|    at                         *
  * com.datamirror.ts.engine.component.PipelineThread.runThread( *
  * PipelineThread.java:217)|    at                              *
  * com.datamirror.ts.util.TsThread.run(TsThread.java:130)       *
  *                                                              *
  * Cause:                                                       *
  * CDC encounters a NPE when parsing a OP_NON_UPDATE_LOB record *
  * and there are no more entries in the transaction queue       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IIDR 11.4.0.0-5059 for all LUW engines or later,  *
  * OR 11.3.3.3-81 for all LUW engines or later                  *
  ****************************************************************
  

Problem conclusion

• Upgrading to IIDR 11.4.0.0-5059 for all LUW engines or later, OR
  11.3.3.3-81 for all LUW engines or later will fix the issue
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  IS CDC DB2 LUW

• Fixed component ID

  5725E30DL

Applicable component levels

• RB33 PSY

     UP