IBM Support

IT27067: HANG MAY OCCUR WITH COLUMN ORGANIZED QUERY IN DPF ENVIRONMENT WHERE AGENT CANNOT BE FORCED

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

  • In a Column Organized DPF environment a query may hang which
    cannot then be forced off.
    The stack trace on for the hanging query on one of the data
    nodes will show the following:
    <StackTrace>
    -------Frame------ ------Function + Offset------
    0x0900000000113194 thread_wait + 0x94
    0x0900000034B91414 sqloWaitEDUWaitPost + 0x434
    0x090000003587C5C0 sqkfChannel::WaitRecvReady(int,int) + 0x1220
    0x090000003588EE20
    sqkfChannel::ReceiveAnyBuffer(sqkfBuffer**,int,int*) + 0x680
    0x0900000038CAF988 sqlkq_process_ctl_msg(SQLKQ_CB*,int,unsigned
    int) + 0x788
    0x0900000049753074
    sqlkq_process_stopwrite(sqeAgent*,SQLKQ_CB*,int) + 0x2B4
    0x0900000049752124 ibm_cde::query::TableQueueWriter::send(bool)
    + 0x484
    0x0900000049752870
    ibm_cde::query::TableQueueWriter::sendWU(bool) + 0xC0
    0x09000000496AE6C8
    ibm_cde::query::TableQueueWriteEvaluator::createAndWriteMiniWU(u
    nsigned
    long,std::vector<ibm_cde::services::CountedPtrWithCopy<const
    ibm_cde::types::VectorBase<0,0>,2,1>,ibm_cde::services::Allocato
    r<ibm_cde::services::CountedPtrWithCopy<const
    ibm_cde::types::VectorBase<0,0>,2,1> > >&,unsigned
    long,ibm_cde::query::TableQueueWriter*,short,unsigned int&) +
    0x3D8
    0x09000000496D6AE4
    ibm_cde::query::TableQueueWriteScatterEvaluator::processInputsSy
    nchronously() + 0x6A4
    0x090000004794EB70
    ibm_cde::query::Evaluator::evaluate(bool,bool,ibm_cde::query::Ev
    aluator::EvaluatorRestartState&,ibm_cde::query::OptPredicateTrac
    ker*) + 0x1040
    0x0900000047CD6ECC
    ibm_cde::query::EvaluationRoutine::evaluate(unsigned
    int,sql_static_data*) + 0x3DC
    0x0900000049436350
    ibm_cde::query::Scheduler::evaluateChain(ibm_cde::query::Evaluat
    ionRoutine*,unsigned long&) + 0x370
    0x0900000049433248
    ibm_cde::query::Scheduler::runWorkerThread(void*,int*) + 0x318
    0x090000004943E8B0
    ibm_cde::query::cdeEntryPointImpl(sqeAgent*,void*,void*) + 0xA0
    0x090000004C8274C4 cdeInterface::startCdeSubagent(sqeAgent*) +
    0xB4
    0x0900000037CB3408 sqlriInvokeCde(sqlrr_cb*) + 0x48
    0x0900000037CD8998 sqlriSectInvoke(sqlrr_cb*,sqlri_opparm*) +
    0x618
    0x0900000039E75A08 sqlrr_smp_router(sqlrr_cb*) + 0x188
    0x0900000039E71EC8
    sqlrr_subagent_router(sqeAgent*,SQLE_DB2RA_T*) + 0xFC8
    0x0900000039E54020 IPRA.$sqleSubRequestRouter(sqeAgent*,unsigned
    int*,unsigned long*) + 0x7C0
    0x0900000039E4E0C8 sqleProcessSubRequest(sqeAgent*) + 0x2C28
    0x0900000034BAABCC sqeAgent::RunEDU() + 0x9EC
    0x0900000034B8D7C0 sqzEDUObj::EDUDriver() + 0x300
    0x0900000034A7C714 sqloEDUEntry + 0x374
    </StackTrace>
    
    An instance restart will be required to clear the hanging agent.
    

Local fix

Problem summary

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

Problem conclusion

  • First fixed in Db2 11.1 Mod 4 Fixpack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT27067

  • 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-11-22

  • Closed date

    2020-01-16

  • Last modified date

    2020-01-16

  • 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":"BU048","label":"IBM Software"},"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:
16 January 2020