Symptom
After upgrading to Db2 11.5.4 you encounter crashes with SQL901N error outputted to the db2diag.log
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:300
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 52
sqlerrmc: Non-SYSTEM tenant for 3rd part name is not supported
Generated FODC will also contain the following stacktrace entries:
<StackTrace>
-------Frame------ ------Function + Offset------
0x09000000122623A4 policyAllowsTable__12JitsServicesFCUiUlT2 + 0x1B4
0x0900000012706794 sqlno_int_stats_scan__FP13sqlno_globals13SQLNN_BOOLEANl + 0xA64
0x09000000126BDD44 sqlno_jits_sa__FP13sqlno_globals + 0x1E4
0x09000000126BB11C sqlno_exe__FP9sqlnq_qur + 0x115C
0x09000000106D6A00 sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sqlrr_cmpl_enviT7PP9sqlnq_qur + 0x56F0
0x09000000106D1298 sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sqlrr_cmpl_env + 0x28
0x090000001067FD38 sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P14SQLP_LOCK_INFOP16sqlra_cached_varPiT11_Pb + 0xC08
0x090000001208D6E8
...
</StackTrace>
Issue can also be reported with:
- SQL0901N Reason "SYSSEQUENCES is missing row for identity column"
- SQL1224 and a trap file from JITS where the top of the stack shows:
_ZN12JitsServices17policyAllowsTableEjmm (demangled: JitsServices::policyAllowsTable)
Read more...
Keywords
KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview