DB2 FOR LUW / DB2FORLUW / A10 - DB2

You might encounter an SQL0901 error with reason "Descriptor row 
length exceeds maximum allowed." and producing the following 
stack trace 
 
sqldCompleteTCBforDAT 
sqldCreateDAT 
sqldInternalCreateTable 
sqldTableCreateTemp 
sqlriCreateIndexedTempTable 
sqlritib 
sqlriExecThread 
sqlriZZOpenDims 
sqlriZZInit 
sqlriZigZagJoin 
sqlriExecThread 
sqlriSectInvoke 
 
when executing an SQL statement that fits the required criteria 
for a zigzag join and the combined size of the columns retrieved 
from any of the dimension tables is too large to fit in any 
temporary tablespace available. You can refer to the topic 
"Ensuring that queries fit the required criteria for the zigzag 
join" in the DB2 InfoCenter for details about the required 
criteria.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Db2 Version 10.1 Fix Pack 3                       * 
****************************************************************

db2set DB2_REDUCED_OPTIMIZATION="ZZJN OFF" 
OR 
Use optimization level 0

DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

Problem first fixed in DB2 Version 10.1 Fix Pack 3

See Local Fix

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

30.04.2013
27.09.2013
27.09.2013