|
Problem IC66228
|
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 / 910 - 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.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). |
| available fix packs: |
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
|
| Solution |
First fixed in DB2 UDB Version 9.1 FixPak 10. |
| Workaround |
disable intra_parallel db config parameter (which will have
performance implications). |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC66267 IC66268 IC72099
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 11.02.2010
20.06.2011
20.06.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.1.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.10
|
 |
