DB2 - Problembeschreibung
Problem IC66358 | Status: Geschlossen |
DELETE NOT REMOVING DATA FROM MDC TABLE. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
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. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * See error description. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 UDB Version 9.7 fix pack 2. * **************************************************************** | |
Local-Fix: | |
There is no workaround for this problem. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
Lösung | |
The problem was first fixed in DB2 UDB Version 9.7 fix pack 2. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC66836 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 16.02.2010 30.06.2010 30.06.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP2 | |
Problem behoben lt. FixList in der Version | |
9.7.0.2 |