APAR status
Closed as program error.
Error description
Affects 11.3.3 and 11.4, Db2 LUW LOBs that are stored inline by the database (whether explicitly defined as INLINE or stored inline because the data size is small) can be silently replicated to the target as empty.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * For IDR/CDC 11.4.x: * * This issue may affect you if you use IDR/CDC 11.4.0.1-5085 * * for all LUW engines or lower. * * * * For IDR/CDC 11.3.x: * * This issue may affect you if you use IDR/CDC 11.3.3.3-84 for * * all LUW engines or lower. * **************************************************************** * PROBLEM DESCRIPTION: * * When loading data from DB to memory, some of the records of * * BLOB field is empty. * * The BLOB field is empty when it shouldn't be empty. * * Other columns are correct. * * It is about 10 thousand over one millions records which * * cannot replicate BLOB field data. * * * * The issue only happens for inline LOB data. * **************************************************************** * RECOMMENDATION: * * Upgrade to IIDR 11.4.0.1-5086 for all LUW engines or later, * * OR 11.3.3.3-85 for all LUW engines or later * ****************************************************************
Problem conclusion
For IDR/CDC 11.4.x: Upgrading to IDR/CDC 11.4.0.1-5086 for all LUW engines or newer resolves the issue. For IDR/CDC 11.3.x: Upgrading to IDR/CDC 11.3.3.3-85 for all LUW engines or newer resolves the issue.
Temporary fix
Comments
APAR Information
APAR number
JR60275
Reported component name
IS CDC DB2 LUW
Reported component ID
5725E30DL
Reported release
B40
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-11-09
Closed date
2020-04-24
Last modified date
2020-04-24
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTRGZ","label":"InfoSphere Data Replication"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
25 April 2020