|
Problem IT23812
|
Status: Closed |
INSTANCE TRAP IS POSSIBLE WHEN QUERY AGAINST COLUMN ORGANIZED TABLES WITH OLAP SPECIFICATION IS RUN |
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
IF QUERY WITH OLAP SPECIFICATION IS RUN AGAINST COLUMN ORGANIZED
TABLES INSTANCE COULD TRAP WITH THE FOLLOWING STACK:
sqloEDUCodeTrapHandler
__intel_ssse3_rep_memcpy
ibm_cde8services20SpillableWriteCursor10writeChunk
ibm_cde5query14SpillableDequeINS0_8WorkUnit
ibm_cde5query13OlapEvaluator24manageWorkUnitPoolMemory
ibm_cde5query27LookaheadEvaluatorBaseClassINS_5types7DecimalES3_
S3_S3_Lb0EE13mainOperation
ibm_cde5query13OlapEvaluator26processInputsSynchronously
ibm_cde5query9Evaluator8evaluateEbbRNS1_21EvaluatorRestartStateE
PNS0_19OptPredicateTracker
ibm_cde5query17EvaluationRoutine8evaluateEjP15sql_static_data
ibm_cde5query9Scheduler13evaluateChainEPNS0_17EvaluationRoutine
ibm_cde5query9Scheduler15runWorkerThread |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Columnar organized tables and OLAP specifications *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description. *
****************************************************************
* RECOMMENDATION: *
* Please, install this fix. *
**************************************************************** |
| Local Fix: |
turn off OLAP in COLUMNAR ORGANIZED logic:
db2set DB2_REDUCED_OPTIMIZATION=COL_NO_OLAP
The pans will move OLAP logic above CTQ lolepop. |
| available fix packs: |
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 |
See Error Description. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 23.01.2018
19.03.2018
19.03.2018 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
