Certain queries might fail with SQL0901N and the following
error message:
SQL0901N The SQL statement or command failed because of a
database system
error. (Reason "Unsupported leaf node of the tree".)
SQLSTATE=58004
The db2diag.log will report the following message:
2019-03-08-16.08.31.205958+060 E191931A2426 LEVEL: Info (Origin)
PID : 53412178 TID : 73866 PROC : db2sysc 0
INSTANCE: db2jkl NODE : 000 DB : JKL
APPHDL : 0-44276 APPID: *LOCAL.hal9001.190308150637
AUTHID : DB2JKL HOSTNAME: hal9001
EDUID : 73866 EDUNAME: db2agent (JKL) 0
FUNCTION: DB2 UDB, SW- common services, sqlnn_cmpl, probe:650
MESSAGE : ZRC=0x803100AF=-2144272209=SQLNN_E_BADNEWS
"unexpected error but state is OK"
DATA #1 : String, 62 bytes
An unexpected error was detected during statement compilation.
DATA #2 : Boolean, 1 bytes
true
DATA #3 : Boolean, 1 bytes
false
DATA #4 : Boolean, 1 bytes
true
DATA #5 : Boolean, 1 bytes
false
DATA #6 : Hex integer, 4 bytes
0x00000000
DATA #7 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 33
sqlerrmc: Unsupported leaf node of the tree
sqlerrp : SQLNQ4A0
sqlerrd : (1) 0x801A006D (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFFE66 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
DATA #8 : Hex integer, 4 bytes
0x00000040
DATA #9 : String with size, 724 bytes
DATA #10: String, 332 bytes
Compiler error stack for rc = -2144272209:
with the following stack:
sqlnn_cmpl[370]
sqlnr_exe[1200]
sqlnr_rcc[100]
sqlnr_seq[100]
sqlnr_comp[110]
sqlnr_optprep_action[100]
sqlnr_optprep_chunk2[550]
sqlnr_generate_between4eao[520]
sqlnr_exists_augment[800]
sqlnq_hxp::sqlnq_hxp_pid[40]
sqlnq_qtb::add_head_exp[60]
sqlnq_fun_tres[140]
sqlnq_fun_res_walk[410] |
