Latest versionsfixlist
11.1.0.6 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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26
Question in the chat LiveZilla Live Help

DB2 - Problem description

Problem IC66267 Status: Closed

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

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
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
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users of version 9.5 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.5 FixPak 6 or higher levels.    * 
****************************************************************
Local Fix:
disable intra_parallel db config parameter (which will have 
performance implications).
available fix packs:
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Solution
First fixed in DB2 UDB Version 9.5 FixPak 6.
Workaround
disable intra_parallel db config parameter (which will have 
performance implications).
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
11.02.2010
25.05.2010
25.05.2010
Problem solved at the following versions (IBM BugInfos)
9.5.
Problem solved according to the fixlist(s) of the following version(s)
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.