DB2 FOR LUW / DB2FORLUW / 970 - DB2

The db2look with -m option can generate the same predicates like 
as below against different indexes on the same table. 
 
WHERE COLNAMES = ' ' 
AND TABNAME = '<tabname>' AND TABSCHEMA = '<schema>'; 
 
COLNAMES is valid only if each column name is less than 30 bytes 
and if there are fewer than 16 columns in the index. Otherwise, 
the value can be blank. 
As the db2look uses COLNAMES to mimic index stats against 
primary key index and indexes for unique constraint. 
So db2look generates an invalid update statements to mimic index 
stats if a table has more than one indexes meet above 
conditions.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users who use db2look to mimic statistics for unique         * 
* indexes.                                                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to V9.7 FixPack 9 or later.                   * 
****************************************************************

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
 

This problem was first fixed in DB2 V9.7 FixPack 9.

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC97128 IC97132 
follow-up : 

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

12.07.2013
17.12.2013
17.12.2013

9.7.FP9