DB2 FOR LUW / DB2FORLUW / 970 - DB2

When an XML index is initially created by default or with the 
"compress no" clause, and if an alter index statement is run to 
update a XML index with clause "compress yes",  this alter 
command completes, but it does not actually change the 
compression attribute to "yes" for physical XML index. 
 
For example, 
CREATE TABLE T2 (  ID INTEGER, XMLDOC XML); 
create index xix_d1_t2 on T2 (XMLDOC) GENERATE KEY USING 
XMLPATTERN '/a/b' as SQL DOUBLE; 
By default,  XML index xix_d1_t2  has compression NO when 
checking SYSCAT.INDEXES table. 
SELECT INDNAME, COMPRESSION, PCTPAGESSAVED 
FROM  SYSCAT.INDEXESWHERE TABNAME = 'T2' ORDER BY INDNAME; 
 
After ALTER statement "alter index xix_d1_t2 compress yes;" 
completes,  the compression attribute of XML logic index shows 
"Y",  but its physical index's compression attribute still 
shows"N".

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users who uses ALTER INDEX to change XML index's compression * 
* attribute.                                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* "ALTER INDEX" compress yes/no doesn't work on XML type       * 
* index.                                                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to V97FP1.                                           * 
****************************************************************

create table with XML columns using "compress yes" 
or 
create XML index using "compress yes".

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

Support "ALTER INDEX" for XML type index to update compress 
attribute.

keiner bekannt / siehe Local-Fix

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

09.09.2009
25.01.2010
25.01.2010

9.7.FP1