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 IC66228 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 / 910 - 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 9.1 on Linux, Unix and Windows          * 
* platforms.                                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* 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                                    * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 UDB Version 9.1 FixPak 10 or higher levels.   * 
****************************************************************
Local-Fix:
disable intra_parallel db config parameter (which will have 
performance implications).
verfügbare FixPacks:
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

Lösung
First fixed in DB2 UDB Version 9.1 FixPak 10.
Workaround
disable intra_parallel db config parameter (which will have 
performance implications).
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC66267 IC66268 IC72099 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
11.02.2010
20.06.2011
20.06.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.1.
Problem behoben lt. FixList in der Version
9.1.0.10 FixList