home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC71276 Status: Geschlossen

AN OPERATION REQUIRING A SORT THAT EXPERIENCES INSUFFICIENT MEMORY SCENARIO
MAY TRAP.

Produkt:
DB2 FOR LUW / DB2FORLUW / 910 - 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:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* 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()->sqlsIns 
* tCompare().                                                  * 
*                                                              * 
*                                                              * 
*                                                              * 
*   sqlv_bin_ncmp                                              * 
*                                                              * 
*   sqlsInsertCompare                                          * 
*                                                              * 
*   sqlsCheckFSEQAcrossSpills                                  * 
*                                                              * 
*   sqlsBinSortIncremental                                     * 
*                                                              * 
*   sqlsBuildRow                                               * 
*                                                              * 
*   sqlsinsr                                                   * 
*                                                              * 
*   sqldReorgSortRow                                           * 
*                                                              * 
*   sqldEvalDataPred                                           * 
*                                                              * 
*   sqldReadNorm                                               * 
*                                                              * 
*   sqldFetchNext                                              * 
*                                                              * 
*   sqldFetchNext                                              * 
*                                                              * 
*   sqldfrd                                                    * 
*                                                              * 
*   sqldReorgTableScanSort                                     * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to V9.1 FP10                                         * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
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

Lösung
First fixed in V9.1 FP10
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
17.09.2010
10.06.2011
10.06.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.1.FP10
Problem behoben lt. FixList in der Version
9.1.0.10 FixList