DB2 FOR LUW / DB2FORLUW / 970 - DB2

For queries containing a group-by clause, if a SORT operation is 
not required, as determined by the DB2 Optimizer, you might 
encounter the following error in the db2diag.log if the 
intra-partition parallelism feature is used: 
 
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary 
logging fu, probe:0 
MESSAGE : Sort reclen limit exceeded 
DATA #1 : String, 157 bytes 
Sort.  In function sqlsTableInfoSetup( ) Line 800 
Record length exceeds <k> -- the maximum allowed for this 
temporary tablespace. 
Sort record length <m> 
 
where <k> and <m> are integer values, with <m> greater in value 
than <k>. 
 
You can verify the access plan chosen by the optimizer might 
result in this error by collecting an EXPLAIN of the query and 
checking for a SORT operator between two GRPBY operators, with 
cardinality and cost values set to the maximum float value, such 
as in the following example: 
 
      124177 
      GRPBY 
      (   5) 
        INF 
    3.40282e+38 
        | 
    3.40282e+38 
      TBSCAN 
      (   6) 
    3.40282e+38 
    3.40282e+38 
        | 
    3.40282e+38 
      SORT 
      (   7) 
    3.40282e+38 
    3.40282e+38 
        | 
      124177 
      GRPBY 
      (   8) 
      45239.9 
       16870 
 
It is also possible that the instance could crash as a result of 
the above error.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Intra-partition parallelism environment                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to version 9.7 Fix Pack 7                            * 
****************************************************************

Avoid this problem by setting the current degree special 
register to 1 prior to compiling the affected statement(s) or 
turn off the intra_parallel database configuration.

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
 

This problem is first fixed in DB2 Version 9.7 Fix Pack 7

See Local Fix

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

01.06.2012
20.10.2012
20.10.2012

9.7.FP7