IBM Support

IT25732: DB2 IN DPF MAY HANG DURING IMPLICIT INDEX REBUILD ON COLUMNAR TABLE IF MORE THAN ONE INDEX IS RECREATED

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2 configured in DPF may hang during implicit index rebuild on
    a columnar table if the table has more than one index to be
    rebuilt
    
    the follow stacks may indicate a hang described by this APAR if
    they are both present:
    
    semtimedop
    sqloWaitEDUWaitPost
    ibm_cde::services::EventWaitPost::wait
    ibm_cde::query::Scheduler::runCompositeQueryAsync
    cdeInterface::initializeData
    cdeInterface::openTableScan
    sqlriCdeOpen
    sqlriCdeQuery
    sqlriSectInvoke
    sqlra_internal_sql
    sqldSerialIndex
    sqldCreateIndex
    sqldIndexCreate
    sqlrlRecreateSingleIndex
    sqlrlRecreateIndexObject
    sqlrlRecreateIndexes
    sqlrlrci
    sqldHandleInxCrRqst
    sqleIndCoordProcessRequest
    sqeAgent::RunEDU
    sqzEDUObj::EDUDriver
    sqloEDUEntry
    start_thread
    clone
    
    AND
    
    semtimedop
    sqloWaitEDUWaitPost
    sqkfChannel::WaitRecvReady
    sqkfChannel::ReceiveAnyBuffer
    sqlkqrcv
    ibm_cde::query::TableQueueBuffer::receiveBuffer
    ibm_cde::query::TableQueueReader::receiveFromAnyConnection
    ibm_cde::query::TableQueueReadEvaluator::getNextWU
    ibm_cde::query::TableQueueReadEvaluator::processInputsSynchronou
    sly
    ibm_cde::query::Evaluator::evaluate
    ibm_cde::query::EvaluationRoutine::evaluate
    ibm_cde::query::Scheduler::evaluateChain
    ibm_cde::query::Scheduler::runWorkerThread
    ibm_cde::query::cdeEntryPointImpl
    cdeInterface::startCdeSubagent
    sqlriInvokeCde
    sqlriSectInvoke
    sqlrr_subagent_router
    sqleSubRequestRouter
    sqleProcessSubRequest
    sqeAgent::RunEDU
    sqzEDUObj::EDUDriver
    sqloEDUEntry
    start_thread
    clone
    

Local fix

  • interrupt the query and manually drop and recreate the indexes
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 4 Fixpack 4 or higher                *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 4 Fixpack 4
    

Temporary fix

  • interrupt the query and manually drop and recreate the indexes
    

Comments

APAR Information

  • APAR number

    IT25732

  • 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

    2018-07-18

  • Closed date

    2018-11-27

  • Last modified date

    2018-11-27

  • 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

  • RB10 PSN

       UP

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

Document Information

Modified date:
27 November 2018