DB2 FOR LUW / DB2FORLUW / A50 - DB2

The issue only occurs in the following conditions: 
 
The query involves: 
- a column oriented table 
- a CASE expression where the search condition is evaluated on 
results of a GROUP BY expression. 
- errors or warnings are produced from the CASE expression. 
 
In such a case, the query may fail with a -901 sqlcode: 
 
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -901   sqlerrml: 48 
 sqlerrmc: unexpected error at SQLErrorsAndWarnings.cpp:344 
 sqlerrp : SQLCT001 
 sqlerrd : (1) 0x00000000      (2) 0x00000000      (3) 
0x00000000 
           (4) 0x00000000      (5) 0xFFFFFEA8      (6) 
0x00000000 
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6) 
 
           (7)      (8)      (9)      (10)        (11) 
 sqlstate: 
 
A typical stack will look like so (including the 
mergeSQLErrorsAndWarnings and evaluateCaseSearchedWhenClause() 
in the stack: 
 
  [3] 0x090000001338BC94 
constructAndThrow__Q3_7ibm_cde8services24AssertionFailedExceptio 
nFCQ3_7ibm_cde8services11ComponentIDCPCcCUlN22RCQ3_7ibm_cde8ser 
+ 0x7C 
  [4] 0x0900000011DBBDC4 
mergeSQLErrorsAndWarnings__Q3_7ibm_cde8services20SQLErrorsAndWar 
ningsFPQ3_7ibm_cde8services20SQLErrorsAndWarningsRCQ3_7ibm_cde5 
+ 0x464 
  [5] 0x09000000151D18B8 
evaluateCaseSearchedWhenClause__Q3_7ibm_cde5query13NaryEvaluator 
HQ3_7ibm_cde5types7Decimal_v_v + 0x6F0 
  [6] 0x09000000152638C8 
processInputsSynchronously__Q3_7ibm_cde5query13NaryEvaluatorFv + 
0x158C 
  [7] 0x0900000013B32A1C 
evaluate__Q3_7ibm_cde5query9EvaluatorFbT1RQ4_7ibm_cde5query9Eval 
uator21EvaluatorRestartStatePQ3_7ibm_cde5query19OptPredicateTra 
+ 0xCDC 
  [8] 0x0900000013B32FD8 
evaluate__Q3_7ibm_cde5query17EvaluationRoutineFUiP15sql_static_d 
ata + 0xA4 
  [9] 0x0900000013B3544C 
runThreadTask__Q3_7ibm_cde5query9SchedulerFPvPi + 0xA8 
  [10] 0x0900000015492698 
cdeEntryPointImpl__Q2_7ibm_cde5queryFP8sqeAgentPvT2 + 0xC0 
  [11] 0x0900000015C3647C 
startCdeSubagent__12cdeInterfaceFP8sqeAgent + 0x1E4 
  [12] 0x0900000008BF3598 sqlriInvokeCde__FP8sqlrr_cb + 0x9C 
  [13] 0x09000000092A7F9C 
sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x74 
  [14] 0x090000000A379E40 
sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0x5670

**************************************************************** 
* USERS AFFECTED:                                              * 
* Column-organized tables - queries with errors or warnings    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to DB2 V10.5 fixpack 5                               * 
****************************************************************

if possibe rewrite query to avoid the case expression or to 
avoid the errors/warnings

Fixed in DB2 V10.5 fixpack 5

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

17.11.2014
15.12.2014
15.12.2014