DB2 FOR LUW / DB2FORLUW / B10 - DB2

Complex query plan  with multiple joins with SUBSTR will cause 
query to fail with -901 
 
Messages in diag log 
 
AssertionFailedException: An assertion 'getBasicType() == 
TYPE_FIXED_STRING || getBasicType() == TYPE_VARIABLE_STRING || 
getBasicType() == TYPE_FIXED_BINARY || getBasicType() == 
TYPE_VARIABLE_BINARY' failed. Additional info: Not a string data 
typeT0 
Thrown at 
/view/db2_v111m1fp2_aix64_s1706091900/vbs/engn/cde/types/DataTyp 
eImpl.hpp : 325 
DATA #2 : Function name in Library, 40 bytes 
ibm_cde::types::DataType::isCU32() const 
 
<<< It is important to see isCU32() to know that this APAR 
applies 
 
further messages: 
APPHDL  : 0-54607              APPID: 
###.##.###.###.50992.170.##121058 
AUTHID  : XXXX                 HOSTNAME: xxxxxx 
EDUID   : 189891               EDUNAME: db2agnts (XXX) 0 
FUNCTION: DB2 UDB, CDE Trace, cdeDiagnosticsFacility, probe:325 
MESSAGE : SQL0901N  The SQL statement or command failed because 
of a database 
          system error. (Reason "".) 
DATA #1 : <preformatted> 
'getBasicType() == TYPE_FIXED_STRING || getBasicType() == 
TYPE_VARIABLE_STRING || getBasicType() == TYPE_FIXED_BINARY || 
getBasicType() == TYPE_VARIABLE_BINARY' failed. Info:Not 
a string data typeT0 
CALLSTCK: (Static functions may not be resolved correctly, as 
they are resolved to the nearest symbol) 
  [0] 0x090000004E8233A8 pdLogPrintf + 0x28 
  [1] 0x090000005F55147C 
done__Q3_7ibm_cde8services24AssertionFailedExceptionFv + 0x4DC 
  [2] 0x090000005F553780 
constructAndThrow__Q3_7ibm_cde8services24AssertionFailedExceptio 
nFCQ3_7ibm_cde8services11ComponentIDCPCcCUlN22RCQ3_7ibm_cde8ser 
+ 0x1B0 
  [3] 0x09000000631D83E8 
addCastOperators__Q3_7ibm_cde5query6ParserFPQ3_7ibm_cde5query10S 
yntaxTreeRCQ3_7ibm_cde5query14QueryResourcesRCQ3_7ibm_cde5query 
+ 0x2F28 
  [4] 0x09000000631B0F18 
prepare__Q3_7ibm_cde5query6ParserFPQ3_7ibm_cde5query10SyntaxTree 
bi + 0x2C8 
  [5] 0x09000000631B3F14 
prepareSingleTableQuery__Q3_7ibm_cde5query6ParserFPQ3_7ibm_cde5q 
uery10SyntaxTreeb + 0xE4 
  [6] 0x09000000631AF1A0 
parserWrapper__Q3_7ibm_cde5query6ParserFRCQ2_3std12basic_stringX 
TcTQ2_3std11char_traitsXTc_TQ3_7ibm_cde8services9AllocatorXTc__ 
+ 0xAC0 
  [7] 0x09000000631B35B4 
prepareNestedQuery__Q3_7ibm_cde5query6ParserFPQ3_7ibm_cde5query1 
0SyntaxTreeT1 + 0x284 
  [8] 0x09000000631AE9FC 
parserWrapper__Q3_7ibm_cde5query6ParserFRCQ2_3std12basic_stringX 
TcTQ2_3std11char_traitsXTc_TQ3_7ibm_cde8services9AllocatorXTc__ 
+ 0x31C 
  [9] 0x09000000631B35B4 
prepareNestedQuery__Q3_7ibm_cde5query6ParserFPQ3_7ibm_cde5query1 
0SyntaxTreeT1 + 0x284 
  [10] 0x09000000631AE9FC 
parserWrapper__Q3_7ibm_cde5query6ParserFRCQ2_3std12basic_stringX 
TcTQ2_3std11char_traitsXTc_TQ3_7ibm_cde8services9AllocatorXTc__ 
+ 0x31C 
  [11] 0x0900000064018C44 
initializeData__12cdeInterfaceFP8sqlrr_cbP17sqlriCdeStatement + 
0x22B4 
  [12] 0x0900000064.##7D0 
openTableScan__12cdeInterfaceFP8sqlrr_cbP17sqlriCdeStatement + 
0x90 
  [13] 0x09000000507B4D8C 
sqlriCdeSmpOpen__FP8sqlrr_cbP17sqlriCdeStatement + 0x5CC 
  [14] 0x09000000507B65A0 
sqlriCdeOpen__FP8sqlrr_cbP17sqlriCdeStatement + 0x120 
  [15] 0x09000000507B710C sqlriCdeQuery__FP8sqlrr_cb + 0x50C 
  .##] 0x09000000507D4898 
sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x618 
  [17] 0x090000005012EC08 sqlrr_smp_router__FP8sqlrr_cb + 0x188 
  [18] 0x090000005012B0C8 
sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0xFC8 
  [19] 0x0900000050110220 
IPRA.$sqleSubRequestRouter__FP8sqeAgentPUiPUl + 0x7C0 
  [20] 0x090000005010A2C8 sqleProcessSubRequest__FP8sqeAgent + 
0x2C28 
  [21] 0x090000004E9D902C RunEDU__8sqeAgentFv + 0x9EC 
  [22] 0x090000004E9BBD20 EDUDriver__9sqzEDUObjFv + 0x2E0 
  [23] 0x090000004E8AAC14 sqloEDUEntry + 0x374 
  [24] 0x0900000000567E10 _pthread_body + 0xF0 
  [25] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF 
 
..... 
 
2017-08.##-14.10.36.184440+120 I147337786A901       LEVEL: 
Severe 
PID     : .##0726              TID : 189891         PROC : 
db2sysc 0 
INSTANCE: xxxx                 NODE : 000           DB   : XXX 
APPHDL  : 0-54607              APPID: 
###.##.###.###.50992.170.##121058 
AUTHID  : XXXX                 HOSTNAME: xxxxxx 
EDUID   : 189891               EDUNAME: db2agnts (XXX) 0 
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, 
probe:250 
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes 
sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -901   sqlerrml: 40 
sqlerrmc: unexpected error at DataTypeImpl.hpp:325 
sqlerrp : SQLCT001 
sqlerrd : (1) 0x00000000      (2) 0x00000000      (3) 0x00000000 
           (4) 0x00000000      (5) 0xFFFFFEBB      (6) 
0x00000000 
sqlwarn : (1)      (2)      (3)      (4)        (5)       (6) 
           (7)      (8)      (9)      (10)        (11) 
sqlstate:

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Db2 11.1 Mod 3 Fix Pack 3 or higher               * 
****************************************************************

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
 

First fixed in Db2 11.1 Mod 3 Fix Pack 3

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

28.08.2017
19.03.2018
19.03.2018