DB2 FOR LUW / DB2FORLUW / A10 - 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:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V10 Fix Pack 1                                * 
****************************************************************

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.

First Fixed in DB2 V10 Fix Pack 1

not known / see Local fix

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

04.11.2012
17.12.2012
17.12.2012