DB2 - Problembeschreibung
Problem IC70240 | Status: Geschlossen |
AN OPERATION REQUIRING A SORT THAT EXPERIENCES INSUFFICIENT MEMORY SCENARIO MAY TRAP. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
When Sort is using INCREMENTAL memory allocation (this is default for most sorts), and sort is not able to allocate enough memory for binsort structures to perform binsort on all records that were cached before spilling, then sort will perform the binsort on smaller chunks of records. In this scenario, sort will also check if each of the sorted chunks is already is sorted order. The method used to perform this check may cause a trap. We believe the problem is not pervasive. Symptom of this trap may differ slightly at the top of the stack, but will always contain sqlsBinSortIncremental()->sqlsCheckFSEQAcrossSpills()->sqlsInser tCompare(). sqlv_bin_ncmp sqlsInsertCompare sqlsCheckFSEQAcrossSpills sqlsBinSortIncremental sqlsBuildRow sqlsinsr sqldReorgSortRow sqldEvalDataPred sqldReadNorm sqldFetchNext sqldFetchNext sqldfrd sqldReorgTableScanSort | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * DB2 UDB Version 9.5 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error description field for more information. * **************************************************************** * RECOMMENDATION: * * Upgrade to Version 9.5 FixPack 7. * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in DB2 UDB Version 9.5 FixPack 7. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC70525 IC71276 IC71464 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 27.07.2010 11.01.2011 11.01.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP7 | |
Problem behoben lt. FixList in der Version | |
9.1.0.7 | |
9.5.0.7 |