DB2 FOR LUW / DB2FORLUW / A50 - DB2

When explaining an SQL statement that accesses a 
column-organized table in "RECOMMEND INDEXES" explain mode, a 
SQL0901N error message with reason "Column number out of range" 
can be returned. Indexes are not supported on column-organized 
tables but a SQL0217W warning should be returned instead of the 
SQL0901N error along with no index recommendation. 
 
Example : 
 
db2 "CREATE TABLE CO (F1 INTEGER) ORGANIZE BY COLUMN" 
DB20000I  The SQL command completed successfully. 
 
$ db2 SET CURRENT EXPLAIN MODE RECOMMEND INDEXES 
DB20000I  The SQL command completed successfully. 
 
$  db2 "SELECT F1 FROM CO WHERE F1=1" 
 
SQL0901N  The SQL statement or command failed because of a 
database system 
error. (Reason "column number out of range".)  SQLSTATE=58004

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users executing the index advisor or using the RECOMMEND     * 
* INDEXES explain mode with column organized tables            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 Fix Pack 4                       * 
****************************************************************

Creation of indexes on column organized tables is not supported. 
A workaround is to avoid recommending indexes on queries 
accessing column organized tables until the DB2LUW instance can 
be upgraded to version 10.5 fixPack 3 where the fix for this 
APAR is provided.

DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

keiner bekannt / siehe Local-Fix

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

20.09.2013
19.09.2014
19.09.2014