home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC82435 Status: Geschlossen

OPTIMIZER NOT DETECTING THAT A TEMP TABLESPACE OF SUFFICIENT SIZE DOES NOT
EXIST WHEN RUNNING WITH INTRA_PARALLEL ON

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
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.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.5 Fix Pack 10                              * 
****************************************************************
Local-Fix:
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.
Lösung
First fixed in DB2 V9.5 Fix Pack 10
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC83906 IC87883 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
02.04.2012
17.12.2012
17.12.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP10
Problem behoben lt. FixList in der Version
9.5.0.10 FixList