IBM Support

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

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error 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()->sqlsInser
    tCompare().
    
      sqlv_bin_ncmp
      sqlsInsertCompare
      sqlsCheckFSEQAcrossSpills
      sqlsBinSortIncremental
      sqlsBuildRow
      sqlsinsr
      sqldReorgSortRow
      sqldEvalDataPred
      sqldReadNorm
      sqldFetchNext
      sqldFetchNext
      sqldfrd
      sqldReorgTableScanSort
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB2 UDB Version 9.7                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error description field for more information.            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Version 9.7 FixPack 4.                            *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 UDB Version 9.7 FixPack 4.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC70525

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-08-12

  • Closed date

    2011-05-03

  • Last modified date

    2011-05-03

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

    IC70240

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC70525

Modified date: 03 May 2011