home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT05613 Status: Geschlossen

SQL0901 ERROR (UNEXPECTED ERROR AT SQLERRORSANDWARNINGS.CPP) FROM
COLUMN-ORGANIZED TABLE WITH CASE STATEMENT

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
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
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Column-organized tables - queries with errors or warnings    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to DB2 V10.5 fixpack 5                               * 
****************************************************************
Local-Fix:
if possibe rewrite query to avoid the case expression or to 
avoid the errors/warnings
Lösung
Fixed in DB2 V10.5 fixpack 5
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
17.11.2014
15.12.2014
15.12.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.5 FixList