Fixes are available
APAR status
Closed as program error.
Error description
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:
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 3 Fix Pack 3 or higher * ****************************************************************
Problem conclusion
First fixed in Db2 11.1 Mod 3 Fix Pack 3
Temporary fix
Comments
APAR Information
APAR number
IT22175
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-08-28
Closed date
2018-03-19
Last modified date
2018-03-19
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 FOR LUW
Fixed component ID
DB2FORLUW
Applicable component levels
RB10 PSN
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
19 March 2018