DB2 - Problem description
Problem IC95515 | Status: Closed |
DB2 ABEND IN FAST INTEGER SORT FUNCTIONS LIKE SQLSFASTINTDISTCOUNTSORT IF SORT MEMORY EXCEEDS 2GB | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
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 Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to 10.5.0.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 | |
available fix packs: | |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows | |
Solution | |
Problem Fixed In 10.5.0.3 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 27.08.2013 04.03.2014 04.03.2014 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.5.0.3 | |
10.5.0.3 |