DB2 query may hit 901 or trap if the following conditions are
met:
a. The query has multiple common sub expressions
b. The available memory is not enough to form matches for common
sub expressions
Similar error message may be seen in db2diag.log
2016-04-08-17.33.57.812757+480 E3602678A1906 LEVEL: Info
(Origin)
PID : 11993178 TID : 33612 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000 DB : ***
APPHDL : 0-44802 APPID:
21.2.6.135.64874.160401024526
AUTHID : ***
EDUID : 33612 EDUNAME: db2agent (***) 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
false
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: 30
sqlerrmc: Memory pool should be provided
sqlerrp : SQLNQ12F
sqlerrd : (1) 0x801A006D (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFFC19 (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, 615 bytes
Compiler error stack for rc = -2144272209:
sqlnn_cmpl[370]
sqlnr_exe[1200]
sqlnr_rcc[100]
sqlnr_seq[100]
sqlnr_comp[110]
sqlnr_optprep_action[100]
sqlnr_optprep[10]
sqlnr_form_common_subexprs[1500]
sqlnr_cleanup_qur_matching[100]
sqlnr_cleanup_opr_matching[200]
sqlnq_mch::drop[100]
sqlnq_mch::drop_comp[150]
sqlnq_qun::drop[180]
sqlnq_qun::destroy[999]
sqlnr_matchmaker::form_mat[800]
sqlnr_subsume_match[300]
sqlnr_subsume_derived_matc[1300]
sqlnr_subsume_prds[100]
sqlnr_subsume_prds_sel_sel[100]
sqlnr_match_prd[100]
sqlnr_trans_pid[110]
sqlnr_trans_pid[220]
sqlnq_pid::new[110]
sqlnq_memMgr::newEntry_new[140]
-----------
stack trace in FODC_AppErr directory generated:
-------Frame------ ------Function + Offset------
0x0900000000C760D4 pthread_kill + 0xD4
0x09000000140B6EE8 sqloDumpEDU + 0x34
0x090000001675FF90 sqldDumpContext__FP9sqeBsuEduiN42PCcPvT2 +
0xC4
0x09000000142AD5CC
sqldDumpContext__FP9sqeBsuEduiN42PCcPvT2@glue5B1 + 0x98
0x0900000014600AD8 sqlrr_dump_ffdc__FP8sqlrr_cbiT2 + 0x388
0x0900000014EDFCD4 sqlzeDumpFFDC__FP8sqeAgentUiP5sqlcai + 0x28
0x0900000014EE0690 sqlzeSqlCode__FP8sqeAgentUiUlT2P5sqlcaiUsPc +
0x140
0x0900000014EE04A4 sqlnn_erds__FiN41e + 0x150
0x0900000016447BC8 sqlnn_erds__FiN41e@glue72A + 0xC0
0x09000000148BB024 destroy__9sqlnq_qunFP13sqlnq_memPool + 0x460
0x0900000014CE259C drop__9sqlnq_qunFP13sqlnq_memPool + 0x4CC
0x09000000180D45E4 drop_comp__9sqlnq_mchFv + 0x1AC
0x09000000180D4380 drop__9sqlnq_mchFiT1P13sqlnq_memPool + 0x138
0x0900000016916044
sqlnr_cleanup_opr_matching_info__FP9sqlnq_oprCP13sqlnq_memPool +
0x100
0x09000000180DFBD8 sqlnr_cleanup_qur_matching_info__FP9sqlnq_qur
+ 0xD4
0x09000000181183E8 sqlnr_form_common_subexprs__FP9sqlnq_quriRi +
0x33C
0x0900000016423550 sqlnr_optprep__FP9sqlnq_qur + 0xC8C
0x0900000014BA52DC
sqlnr_optprep_action__FP10sqlnr_qrwaPiP14sqlnr_progress + 0x1C
0x0900000014BA513C
sqlnr_comp__FPiiP16sqlnr_rule_stateP10sqlnr_qrwaP14sqlnr_progres
s@AF324_232 + 0x194
0x0900000014BA4D34
sqlnr_seq__FPiP10sqlnr_qrwaP14sqlnr_progressP12sqlnr_rclass +
0xEC
0x0900000014BA4BCC sqlnr_rcc__FiP10sqlnr_qrwaPiP14sqlnr_progress
+ 0x80
0x0900000014BA3EC4 sqlnr_exe__FP9sqlnq_qur + 0x614
0x0900000014BA3334 sqlnr_exe__FP9sqlnq_qur@glue15F9 + 0x74
0x0900000014BAA5F0
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
lrr_cmpl_enviT7PP9sqlnq_qur + 0x2F4
0x0900000014E8745C
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
lrr_cmpl_env + 0x40
0x0900000014FAADC8
sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P14SQLP_
LOCK_INFOP16sqlra_cached_varPiPUl + 0x84C
0x0900000014FA8990
sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUi
T4PUcT4UsUcP14sqlra_cmpl_env15sqlra_fill_modePiiT12
_N313_T12_P14SQLP_LOCK_INFOPP16sqlra_cached_varT12_PUlb + 0x664
0x0900000014FA9498 sqlra_get_var__FP8sqlrr_cbiT2bPbT5 + 0x604
0x090000001569F518
sqlrr_prepare__FP14db2UCinterfaceP16db2UCprepareInfo + 0xC8
0x0900000017A4DFF0
sqljs_ddm_prpsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0xC74
0x0900000014B41E3C
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface + 0x228
0x0900000014E1FDE4
.sqljsParse.fdpr.clone.120__FP13sqljsDrdaAsCbP14db2UCinterfaceP8
sqeAgentb + 0x268
0x0900000014E1EAA0 @63@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb
+ 0x290
0x0900000014F5E4D0
@63@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xEC
0x0900000014F5E2CC
@63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x270
0x0900000014F5DDA4 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
0xE4
0x0900000014C65AC8 RunEDU__8sqeAgentFv + 0x2F4
0x0900000014C6D114 EDUDriver__9sqzEDUObjFv + 0xDC
0x0900000014C8BD94 sqloEDUEntry + 0x250 |
