DB2 FOR LUW / DB2FORLUW / 970 - DB2

db2 create nickname SECNICK for secd2.sahanant.tab2; 
 
db2 CREATE SUMMARY TABLE mqt (col2) as (select * from secnick) 
DATA INITIALLY DEFERRED REFRESH DEFERRED; 
 
db2 create index idx on mqt(col2); 
 
Here the index 'idx' is created on MQT defined on nickname 
 
When you run db2look -d <dbname> -e you will find the index 
statement missing in the db2look output 
 
 
------------------------------------------------ 
-- DDL Statements for table "DBGUEST3"."MQT" 
------------------------------------------------ 
 SET CURRENT SCHEMA = "DBGUEST3"; 
SET CURRENT PATH = 
"SYSIBM","SYSFUN","SYSPROC","SYSIBMADM","DBGUEST3"; 
CREATE SUMMARY TABLE mqt (col2) as (select * from secnick) DATA 
INITIALLY 
DEFERRED REFRESH DEFERRED; 
REFRESH TABLE "DBGUEST3"."MQT"; 
 
CONNECT RESET; 
 
TERMINATE;

**************************************************************** 
* USERS AFFECTED:                                              * 
* Software                                                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* DB2LOOK FAILS TO GENERATE INDEX DDL FOR THE MQTS DEFINED ON  * 
* NICKNAME                                                     * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* move to v97 fp2                                              * 
****************************************************************

No local fix

fixed in v97 fp2

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

17.09.2009
26.03.2010
26.03.2010

9.7.FP2