DB2 - Problem description
Problem IT22673 | Status: Closed |
DB2 MAY RETURN SQL0901N DURING UPDATE/DELETE/INSERT (UDI) ON TABLE CONTAINING INLINE TRIGGER | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
DB2 may return SQL0901N: "Can not find marked Qun in upperQtb." during a UDI statement. The following criteria must be true about the table the UDI statement is targeting: - The table has an inline trigger defined on it. - The trigger contains a UDI statement that contains correlation from the table. - The table the trigger UDI statement is targeting has FGAC masks and are enabled. The call stack for this error will look similar to the one below: ------Function------ pthread_kill ossPthreadKill__FCUiT1 sqloDumpEDU sqldDumpContext__FP9sqeBsuEduiN42PCcPvT2 sqlrr_dump_ffdc__FP8sqlrr_cbiT2 sqlzeDumpFFDC__FP8sqeAgentUiP5sqlcai sqlzeSqlCode__FP8sqeAgentUiUlT2P5sqlcaiUsPc sqlnn_erds__FiN41e sqlns_find_topsubgraph_from_lower2upper__FP9sqlnq_qtbT1RP9sqlnq_ qun sqlns_determine_sibling_order__FP9sqlnq_qunN31iRiRP9sqlnq_qunN26 sqlns_resolve_rw_conflict_pair__FP9sqlnq_qunN21P9sqlnq_quriT5RP1 8sqlnq_corrPartListRiT8 sqlns_resolve_rw_conflict__FP9sqlnq_qunT1P9sqlnq_quriRP18sqlnq_c orrPartList sqlns_build_conflict_set__FP9sqlnq_qunRP18sqlnq_corrPartList sqlns_force_reevaluation__FP9sqlnq_qur sqlns_qgs__FP9sqlnq_qur17sqlnq_requestTypePc sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq lrr_cmpl_enviT7PP9sqlnq_qur sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq lrr_cmpl_env sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P14SQLP_ LOCK_INFOP16sqlra_cached_varPiT11_Pb sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUi T4PUcT4UsUcP14sqlra_cmpl_env15sqlra_fill_modePiiT12_N313_T12_P14 SQLP_LOCK_INFOPP16sqlra_cached_varT12_bT19_Pb sqlra_get_var__FP8sqlrr_cbiT2bPbT5 sqlrr_execute_immediate__FP8sqlrr_cbi sqlrr_execimmd__FP14db2UCinterfaceP16db2UCprepareInfo sqljs_ddm_excsqlimm__FP14db2UCinterfaceP13sqljDDMObject sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC interface sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T RunEDU__8sqeAgentFv EDUDriver__9sqzEDUObjFv sqlzRunEDU__FPcUi sqloEDUEntry | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * See Local Fix * **************************************************************** | |
Local Fix: | |
To avoid the SQL0901N error in a non-partitioned database environment, use a compiled trigger instead (i.e. remove the ATOMIC keyword). | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : follow-up : IT22718 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 04.10.2017 30.01.2020 30.01.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |