|
Problem IT25732
|
Status: Geschlossen |
DB2 IN DPF MAY HANG DURING IMPLICIT INDEX REBUILD ON COLUMNAR TABLE IF MORE THAN ONE INDEX IS RECREATED
|
| Produkt: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problembeschreibung: |
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 |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 11.1 Mod 4 Fixpack 4 or higher *
**************************************************************** |
| Local-Fix: |
interrupt the query and manually drop and recreate the indexes |
| Lösung |
|
| Workaround |
interrupt the query and manually drop and recreate the indexes |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 18.07.2018
27.11.2018
27.11.2018 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
