DB2 FOR LUW / DB2FORLUW / 970 - DB2

If db2look is executed with both -t and -l, for a range 
partitioned table, then the create tablespace DDLs are not 
generated for the partitioned indexes. 
 
For example, given the following table definition in database 
SAMPLE: 
 
CREATE TABLE "DB2INST1"."TEST"  ( 
    "COL1" INTEGER , 
    "COL2" INTEGER ) 
   PARTITION BY RANGE("COL1") 
   (PART "0" STARTING(0) ENDING(10) IN "USERSPACE1" INDEX IN 
"TESTSPACE"); 
 
db2look -d SAMPLE -t TEST -e -l will not generate the create 
tablespace DDL for TESTSPACE, even though it's a user-defined 
tablespace. 
 
 
However, if db2look is executed with -l and WITHOUT -t 
<tablename>, then the DDL for tablespaces of partitioned indexes 
will be generated. db2look should provide the partitioned index 
tablespace DDL when -t and -l are used together.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* If db2look is executed with both -t and -l, for a range      * 
* partitioned table, then the create tablespace DDLs are not   * 
* generated for the partitioned indexes.                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to Version 9.7 Fix Pack 5                             * 
****************************************************************

Run db2look with -l but without the -t <tablename> filter to get 
the tablespace DDL for the partitioned indexes

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
 

Problem was first fixed in Version 9.7 Fix Pack 5

keiner bekannt / siehe Local-Fix

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

18.02.2011
17.01.2012
17.01.2012

9.7.FP5