DB2 FOR LUW / DB2FORLUW / 980 - DB2

If a LOB field has been appended with an update command (e.g. 
using the || operator or the CONCAT scalar operator), it may 
become corrupted if either of the following scenarios occur: 
 
1. If a LOB is appended after a backup is taken, restoring from 
the backup and rolling forward such that the concatenation is 
replayed can corrupt the LOB. 
2. In HADR scenarios, a LOB concatenation operation on the 
primary can be incorrectly replayed on the secondary, corrupting 
the LOB. 
 
In both cases, the target LOB to be updated must contain the 
original version of itself as one of the concatenation 
arguments. The concatenation of other values written to the 
target LOB will not result in corruption. 
 
If corruption did occur, the LOB will appear to be truncated. 
Although the length as indicated by LENGTH(column) will report 
the non-corrupted size of the concatenated LOB, the actual LOB 
will appear to be shorter than what it should be.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Without this APAR, customer is exposed to the issue as       * 
* described in the "ERROR DESCRIPTION" section.                * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.8, Fixpack 5.                       * 
****************************************************************

N/A

First fixed in DB2 Version 9.8, Fixpack 5.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

14.05.2012
18.07.2012
18.07.2012

9.8.FP5