DB2 FOR LUW / DB2FORLUW / 970 - DB2

The problem occurs while running a delete on an MDC table that 
contains overflow records such that the pointer record being 
deleted is not the last record in the block, but the overflow 
record pointed to by that pointer record is the last record of a 
different block. 
 
Steps to reproduce this problem: 
#!/bin/ksh 
 
dbName="wsdb" 
export DB2OPTIONS="-ctv" 
 
db2start 
db2 "create db $dbName" 
db2 "connect to $dbName" 
db2 "create tablespace ts1 extentsize 2" 
db2 "create table t1 (i1 int, i2 int, c3 char(250), c4 
char(250), c5 char(250), 
v6 varchar(250)) organize by (i1) in ts1" 
 
dataFile="data.del" 
rm -f $dataFile 
typeset -i i=0 
while [ $i -lt 10 ] 
do 
  echo "0,$i,$i,$i,$i,$i" >> $dataFile 
  i=$i+1 
done 
 
db2 "import from $dataFile of del insert into t1" 
rm -f $dataFile 
db2 "update t1 set 
v6='012345678901234567890123456789012345678901234567890123456789 
0123456789012345678901234567890123456789012345678901234567890123 
4567890123456789012345678901234567890123456789012345678901234567 
890123456789' 
where i2=0" 
db2 "delete from t1 where i2 >= 0" 
db2 "select count(*) from t1 where i2 >= 0" 
db2 "drop table t1" 
db2 "drop tablespace ts1" 
db2 "terminate" 
db2stop 
 
There is no workaround for this problem. 
 
Note: this problem does NOT exist in 9.5 and earlier releases.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See error description.                                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 UDB Version 9.7 fix pack 2.                   * 
****************************************************************

There is no workaround for this problem.

DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

The problem was first fixed in DB2 UDB Version 9.7 fix pack 2.

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC66836 
follow-up : 

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

16.02.2010
30.06.2010
30.06.2010

9.7.FP2