DB2 FOR LUW / DB2FORLUW / 970 - DB2

db2look may generate wrong CREATE INDEX statement with the 
"PARTITIONED" clause even when the index was originally created 
with 
the "NON PARTITIONED" clause, for example: 
 
 
CREATE INDEX "FAP"."I03" ON 
"FAP"."T1" (STARTDATUM" ASC, "KUNDE" ASC) 
NOT PARTITIONED COMPRESS YES ALLOW REVERSE SCANS; 
 
db2look output: 
 
CREATE INDEX "FAP    "."I03" ON "FAP"."T1" 
  ("STARTDATUM" ASC, 
  "KUNDE" ASC) 
  PARTITIONED                  <<<< wrong 
  COMPRESS YES ALLOW REVERSE SCANS; 
 
This problem can only occur if you use the same index name in at 
least two different database schema's. And in one of these 
schema's the 
index was created as "PARTITIONED", where as in the other it was 
created 
as "NOT PARTITIONED". 
For this index db2look will generate a wrong index statement 
with 
the "PARTITIONED" clause.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Problem Description above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* pgrade to DB2 Version 9.7 Fix Pack 5.                        * 
****************************************************************

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 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
 

First fixed in Version 9.7 Fix Pack 5.

keiner bekannt / siehe Local-Fix

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

01.02.2011
20.12.2011
20.12.2011

9.7.FP5