Fixes are available
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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 May 2022