IC93789: DB2 ABEND IN FAST INTEGER SORT FUNCTIONS LIKE SQLSFASTINTDISTCOUNTSORT IF SORT MEMORY EXCEEDS 2GB

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error 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
    ...
    

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
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Problem Description above.                               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 10.1 Fix Pack 3.                      *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 Version 10.1 Fix Pack 3.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC93789

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-06-28

  • Closed date

    2013-10-07

  • Last modified date

    2013-10-07

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC95515

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RA10 PSN

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

10.1

Reference #:

IC93789

Modified date:

2013-10-07

Translate my page

Machine Translation

Content navigation