IBM Support

Issue with DB2 LOAD utility can cause data loss in Q Replication

Flash (Alert)


A DB2 for Linux, UNIX, and Windows problem can cause data loss in Q replication when the LOAD utility is used to load target tables with data from the source. No error is logged by either replication or DB2.


In DB2 Versions 9.8 Fix Pack 3 and newer, the problem can occur if one of the following LOAD options are used:

  • Remote fetch (a load from a cursor where the cursor is declared using the DATABASE keyword)

For replication, the problem can occur in Version 9.7 Fix Pack 4 and newer.

To resolve the problem, you can apply any of the following DB2 APARs, depending on your version:
  • V97 N/A
  • V98FP6 APAR IC95124
  • V10.1 APAR IC95010
  • V10.5 APAR IC95146

Document information

More support for: InfoSphere Replication Server
Q Apply

Software version: 9.7.4, 9.7.5, 10.1, 10.2, 10.5

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Reference #: 1651771

Modified date: 28 May 2016

Translate this page: