DB2 - Problem description
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 | |
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 |