DB2 FOR LUW / DB2FORLUW / 970 - DB2

If table for which index was created with 'GENERATE KEY USING 
XMLPATTERN ... AS ... REJECT INVALID VALUES' clause was moved 
with SYSPROC.ADMIN_MOVE_TABLE procedure, then recreated index 
will have wrong definition. 
REJECT INVALID VALUES clause will be changed to IGNORE INVALID 
VALUES clause. 
 
The issue can be observed with db2look utility: 
 
db2look -d sample -z db2inst1 -t tab1 -e 
 
        CREATE INDEX "DB2INST1"."IND1" ON "DB2INST1"."TAB1" 
                        ("C_XML" ASC) 
                        GENERATE KEY USING XMLPATTERN '/row/c1' 
                        AS SQL DOUBLE   REJECT INVALID VALUES 
<<<<< 
                        COMPRESS NO ALLOW REVERSE SCANS; 
 
db2 "CALL 
SYSPROC.ADMIN_MOVE_TABLE('DB2INST1','TAB1','','','','','','','', 
'','MOVE')" 
 
db2look -d sample -z db2inst1 -t tab1 -e 
 
        CREATE INDEX "DB2INST1"."IND1" ON "DB2INST1"."TAB1" 
                        ("C_XML" ASC) 
                        GENERATE KEY USING XMLPATTERN '/row/c3' 
                        AS SQL DOUBLE   IGNORE INVALID VALUES 
<<<<< 
                        COMPRESS NO ALLOW REVERSE SCANS;

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description.                                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 7.                       * 
****************************************************************

No local fix.

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 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem was first fixed in DB2 Version 9.7 Fix Pack 7.

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC87910 IC87919 IC88623 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

29.05.2012
20.10.2012
20.10.2012

9.7.FP7