DB2 FOR LUW / DB2FORLUW / A50 - DB2

The nnstat with Catalog-based method (method 1) can drop the 
unique rule from existing index specifications. 
The Catalog-based method will drop all the existing index 
specifications on the nickname, then create index specifications 
as the same manner as the source object. 
However, nnstat fails to set unique rule when creating the index 
specifications. 
 
Please note that method 0 (try method 1 first, then run method 2 
if required) also hitting this problem.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users who use nnstat.                                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to DB2 V10.5 FixPack 7 or later.              * 
****************************************************************

Please use data-based method (method 2) to bypass this issue.

This problem was first fixed in DB2 V10.5 FixPack 7.

not known / see Local fix

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

29.07.2015
22.01.2016
22.01.2016