|
Problem IC93789
|
Status: Geschlossen |
DB2 ABEND IN FAST INTEGER SORT FUNCTIONS LIKE SQLSFASTINTDISTCOUNTSORT IF SORT MEMORY EXCEEDS 2GB |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problembeschreibung: |
A Fast Integer Sort is a DB2 internal operation for sorting
integer data. If sort heap memory in use for the fast integer
sort operation exceeds 2GB then a trap (SEGV) in the fast
integer
sort related functions is possible.
Exact details of traps may vary depending on the memory layout.
An example stack trace might show the following functions:
...
<signal delivery>
sqlsFastIntDistCountSort
sqlsFastIntCountSort
sqlsSortInts
sqlrifisBuffDoSort
sqlrsopen
sqlrifis
sqlriSectInvoke
... |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Problem Description above. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.1 Fix Pack 3. *
**************************************************************** |
| Local-Fix: |
Configure SORTHEAP memory to max. 2GB (i.e. 524288 pages)
OR
disable FIS (Fast Integer Sort):
db2stop force;
export DB2STDIO=true ;
db2set DB2_TCG_DEFAULT_OPTIONS="set num_page_fast_int_sort 0"
db2start |
| verfügbare FixPacks: |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Lösung |
First fixed in DB2 Version 10.1 Fix Pack 3. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC95515
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 28.06.2013
07.10.2013
07.10.2013 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
