suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT22780 Status: Closed

CRASH MAY OCCUR DURING CDE JOIN WHEN PROCESSING A LARGE AMOUNT OF DATA

product:
DB2 FOR LUW / DB2FORLUW / B10 - DB2
Problem description:
Crash may occur during CDE Join when processing a large amount 
of data. 
Crash stack will show similar to the following: 
<StackTrace> 
__intel_avx_rep_memset + 0x01b1 
_ZNK7ibm_cde5query10ColumnDesc10extractColILb0ELb1EEEvPvPKlRmRj 
+ 0x0063 
_ZN7ibm_cde5query16ExtractEvaluatorILb1EE7processINS_5types7Inte 
gerIaLb0EEENS4_12VarLenStringELb0ELb1EEEvv + 0x0570 
_ZN7ibm_cde5query16ExtractEvaluatorILb1EE26processInputsSynchron 
ouslyEv + 0x02b4 
_ZN7ibm_cde5query9Evaluator8evaluateEbbRNS1_21EvaluatorRestartSt 
ateEPNS0_19OptPredicateTrackerE + 0x03a9 
_ZN7ibm_cde5query17EvaluationRoutine8evaluateEjP15sql_static_dat 
a + 0x030c 
_ZN7ibm_cde5query9Scheduler13evaluateChainEPNS0_17EvaluationRout 
ineERm + 0x0284 
_ZN7ibm_cde5query9Scheduler15runWorkerThreadEPvPi + 0x0363 
... 
 
 
Cleaned up stack shows as: 
<StackTrace> 
memset + 0x01b1 
ibm_cde::query::ColumnDesc::extractCol<false, true>(void*, long 
const*, unsigned long&, unsigned int&) const + 0x0063 
ibm_cde::query::ExtractEvaluator<true>::process<ibm_cde::types:: 
Integer<signed char, false>, ibm_cde::types::VarLenString,false, 
true>() + 0x0570 
ibm_cde::query::ExtractEvaluator<true>::processInputsSynchronous 
ly() + 0x02b4 
ibm_cde::query::Evaluator::evaluate(bool, bool, 
ibm_cde::query::Evaluator::EvaluatorRestartState&, 
ibm_cde::query::OptPredicateTracker*) + 0x03a9 
ibm_cde::query::EvaluationRoutine::evaluate(unsigned 
int,sql_static_data*) + 0x030c 
ibm_cde::query::Scheduler::evaluateChain(ibm_cde::query::Evaluat 
ionRoutine*, unsigned long&) + 0x0284 
ibm_cde::query::Scheduler::runWorkerThread(void*, int*) + 0x0363 
...
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All Db2 Column Organized Users                               * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Db2 11.1.3.3 or later.                            * 
****************************************************************
Local Fix:
available fix packs:
Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows

Solution
First fixed in Db2 11.1.3.3.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
13.10.2017
15.03.2018
15.03.2018
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)