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 IC66268 Status: Geschlossen

IN RARE TIMING SCENARIOS WHEN INTRA_PARALLEL ENABLED, A SORT OPERATION
THAT SPILLS MAY FAIL WITH SQLSMERGEREC, PROBE:2050.

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
When the intra_parallel db config parameter is enabled, in some 
rare race-condition timing scenarios a sort operation that 
spills to a temp table may fail with the following db2diag.log 
entry: 
 
2009-11-11-11.01.15.322651+480 I84870761A521      LEVEL: Severe 
PID     : 2478472              TID  : 1           PROC : 
db2agntp (FJDWDB) 32 
INSTANCE: fjdwinst             NODE : 032 
APPHDL  : 1-456                APPID: O68150A7.M30A.027703061026 
AUTHID  : MK 
FUNCTION: DB2 UDB, sort/list services, sqlsmergerec, probe:2050 
MESSAGE : Creating Temporary Table for sort spill, but one 
already exists. 
          Aborting sort operation. Contact IBM Support. 
slestatus = 870c40, 
          poolID = 1, objectID = 26
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users of version on Linux, Unix and Windows platforms.   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* When the intra_parallel db config parameter is enabled,      * 
* insome rare race-condition timing scenarios a sort           * 
* operationthat spills to a temp table may fail with the       * 
* followingdb2diag.log entry:2009-11-11-11.01.15.322651+480    * 
* I84870761A521      LEVEL:SeverePID     : 2478472             * 
*  TID  : 1           PROC :db2agntp (FJDWDB) 32INSTANCE:      * 
* fjdwinst             NODE : 032APPHDL  : 1-456               * 
*  APPID:O68150A7.M30A.027703061026AUTHID  : MKFUNCTION: DB2   * 
* UDB, sort/list services, sqlsmergerec,probe:2050MESSAGE :    * 
* Creating Temporary Table for sort spill, but onealready      * 
* exists.Aborting sort operation. Contact IBM                  * 
* Support.slestatus = 870c40,poolID = 1, objectID = 26         * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 UDB Version 9.7 FixPak 2 or higher levels.    * 
****************************************************************
Local-Fix:
disable intra_parallel db config parameter (which will have 
performance implications).
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
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 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
First fixed in DB2 UDB Version 9.7 FixPak 2.
Workaround
disable intra_parallel db config parameter (which will have 
performance implications).
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
11.02.2010
25.05.2010
25.05.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.
Problem behoben lt. FixList in der Version
9.7.0.2 FixList