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 | |
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 |