IBM Support

IT32049: DB2 MAY TRAP DURING A COLUMN ORGANIZED SORT OF A VERY LARGE (4 BILLION+ ROW) TABLE.

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • DB2 may trap during a column organized sort of a very large (4
    billion+ row) table.
    
    The trap file produced in an FODC_Trap folder can have a stack
    that looks like this:
    
    0        void
    ibm_cde::query::NativeSortCB::getAndTransformKeyData<ibm_cde::ty
    pes::VarLenString>
    1        ibm_cde::query::NativeSortCB::buildLocalHistogram
    2        ibm_cde::query::NativeSortCB::paradisSort
    3        ibm_cde::query::NativeSortCB::sort
    4        ibm_cde::query::SortEvaluator::sortPartition
    5
    ibm_cde::query::SortEvaluator::processInputsSynchronously
    6        ibm_cde::query::Evaluator::evaluate
    7        ibm_cde::query::EvaluationRoutine::evaluate
    8        ibm_cde::query::Scheduler::evaluateChain
    9        ibm_cde::query::Scheduler::runWorkerThread
    10       ibm_cde::query::cdeEntryPointImpl
    11       cdeInterface::startCdeSubagent
    12       sqlriInvokeCde
    13       sqlriSectInvoke
    14       sqlrr_smp_router
    15       sqlrr_subagent_router
    16       IPRA.
    17       sqleProcessSubRequest
    18       sqeAgent::RunEDU
    19       sqzEDUObj::EDUDriver
    20       sqloEDUEntry
    

Local fix

  • One option is to convert column organized sort to rowstore sort
    by using this optimization guideline:
    
    /* <OPTGUIDELINES> <REGISTRY> <OPTION
    NAME='DB2_COMPILER_CDE_OVERRIDES' VALUE='000000000001'/>
    </REGISTRY> </OPTGUIDELINES> */
    
    Or using this parameter (but it is instance wide, and requires a
    db2stop/db2start):
    db2set DB2_COMPILER_CDE_OVERRIDES=000000000001
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * CDE SORT                                                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * See Error Description                                        *
    ****************************************************************
    

Problem conclusion

  • See Error Description
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT32049

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-03-02

  • Closed date

    2021-03-19

  • Last modified date

    2021-03-19

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

  • 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

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
20 March 2021