Issue with DB2 LOAD utility can cause data loss in Q Replication
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
More support for:
InfoSphere Replication Server
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: 02 October 2013