JR65193: TABLES WITH EXTENDED ROW DATA FAIL WITH NULLPOINTEREXCEPTION WHEN LOB DATA IS STORED IN A SEPARATE TABLESPACE

APAR status

• Closed as program error.

Error description

• The exception thrown in IDR CDC instance traces:
  
  SHAREDSCRAPE LOG PARSER
  com.datamirror.ts.scrapers.db2udbscraper.Db2udbLogParser
  handleDmlOperation()    java.lang.NullPointerException
  
     at com.datamirror.ts.scrapers.db2udbscraper.Db2udbLogParser.
  getExtendedRowInformation(Db2udbLogParser.java:1912)
     at com.datamirror.ts.scrapers.db2udbscraper.Db2udbLogParser.
  parseValueUncompressedImage(Db2udbLogParser.java:1713)
     at com.datamirror.ts.scrapers.db2udbscraper.Db2udbLogParser.
  parseImage(Db2udbLogParser.java:1465)
     at com.datamirror.ts.scrapers.db2udbscraper.Db2udbLogParser.
  handleDmlOperation(Db2udbLogParser.java:5125)
     at com.datamirror.ts.scrapers.db2udbscraper.Db2udbLogParser.
  parseLocalCommittedTxn(Db2udbLogParser.java:625)
     at com.datamirror.ts.scrapers.db2udbscraper.Db2udbLogParser.
  parseCommittedTxn(Db2udbLogParser.java:410)
     at com.datamirror.ts.scrapers.cdc.LogParser.handleCommitEntr
  y(LogParser.java:2928)
     at com.datamirror.ts.scrapers.cdc.LogParser.execute(LogParse
  r.java:784)
     at com.datamirror.ts.scrapers.cdc.LogParser$LogParserPipelin
  eJob.execute(LogParser.java:155)
     at com.datamirror.ts.engine.component.PipelineThread.runThre
  ad(PipelineThread.java:217)
     at com.datamirror.ts.util.TsThread.run(TsThread.java:130)
  

Local fix

• Alter table definition to have LOB data in the same tablespace
  as the table data.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue might affect you if you use IDR 11.4.0.4-5660 or  *
  * earlier for Db2 LUW                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Not available                                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDR 11.4.0.4-5661 or later for Db2 LUW.           *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR 11.4.0.4-5661 or later for Db2 LUW resolves 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