DB2 FOR LUW / DB2FORLUW / 970 - DB2

The db2IdentifyType1 tool may display the message: 
 
DBT3009I There are no indexes on the inspected tables. No index 
conversion is required. 
 
However, there might be system defined indexes.  The message 
indicates that there are no user-defined indexes on the 
inspected tables.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users using the db2IdentifyType1 tool                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* As described in the APAR description, users may receive a    * 
* message when running the db2IdentifyType1 tool saying there  * 
* are no indexes on the inspected tables although in reality   * 
* the tables might have system defined indexes.                * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* To avoid experiencing this issue users can upgrade to DB2    * 
* Version V9.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 DB2 Version 9.7 fix pack 5 
 
With the fix users will see a more accurate message.

keiner bekannt / siehe Local-Fix

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

20.10.2010
28.12.2011
28.12.2011

9.7.,
9.7.FP5