JR65163: MIRROR BULK APPLY CAN FAIL WITH A CLOSEEXCEPTION IF ATTEMPT DELETE ON EMPTY TABLE AND TIMING CIRCUMSTANCES ARE UNFORTUNATE

APAR status

• Closed as program error.

Error description

• CDC Db2 LUW fails with the following error:
  652742 2022-09-01 08:28:02.522 PARMDB_C Db2 Target Bulk
  Apply:0{226}
  com.datamirror.ts.target.apply.bulkapply.TargetBulkApplyJob
  handleException() java.nio.channels.AsynchronousCloseException
  | at java.nio.channels.spi.AbstractInterruptibleChannel.end(Abs
  tractInterruptibleChannel.java:223)|at sun.nio.ch.FileChannelImp
  at com.datamirror.ts.util.SpoolFile.write(SpoolFile.java:457)|
  at com.datamirror.ts.util.SpoolFile.write(SpoolFile.java:447)|
  at com.datamirror.ts.target.apply.bulkapply.TargetBulkApplyJob.
  sendDataToSpoolFile(TargetBulkApplyJob.java:1184)|at ...
  

Local fix

• Disable Adaptive Apply.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue might affect you if you are using IDR             *
  * 11.4.0.4-5656 or older for Db2 LUW as a target datastore.    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Not available                                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDR 11.4.0.4-5659 or newer for Db2 LUW.           *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR 11.4.0.4-5659 or newer 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