SAP Knowledge Base Article - Preview

3781910 - SQL901N Errors and crashes after upgrading to Db2 V11.5.4

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.