DB2 FOR LUW / DB2FORLUW / 980 - DB2

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

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users of version 9.8 on Linux, Unix and                  * 
* Windowsplatforms.                                            * 
**************************************************************** 
* 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.8 FixPak 3 or higher levels.    * 
****************************************************************

disable intra_parallel db config parameter (which will have 
performance implications).

DB2 Version 9.8 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.8 Fix Pack 4 for AIX and Linux
 DB2 Version 9.8 Fix Pack 5 for AIX and Linux
 

First fixed in DB2 UDB Version 9.8 FixPak 3.

disable intra_parallel db config parameter (which will have 
performance implications).

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

21.10.2010
10.01.2011
10.01.2011

9.8.