DB2 FOR LUW / DB2FORLUW / A50 - DB2

A trap will be generated in sqlnq_handle_module_obj_ref when 
Create Procedure is run which contains a UDI statement for which 
an inlined trigger exists and the trigger, in turn, calls a 
module routine. The trigger needs to have been invalidated for 
the trap to occur e.g. by changing the data type of a column. 
 
Crash stack will look similar to: 
 
<StackTrace> 
sqlnq_handle_module_obj_ref 
sqlnq_call_stmt 
sqlnp_smactn 
sqlnp_parser 
sqlnp_main 
sqlnn_cmpl 
sqlnn_cmpl 
sqlra_compile_var 
sqlra_find_var 
sqlra_get_var 
sqlri_ddl_common 
sqlriddl 
sqlriSectInvoke 
sqlra_internal_sql 
sqlnn_regen_trigger 
sqlns_unpack_triggers 
sqlns_unpack_cstrnts 
sqlns_cmpl_cstrnts_main 
sqlns_exp_constraints 
sqlns_qgs 
sqlnn_cmpl 
sqlnn_cmpl 
sqlrr_cmpl 
sqlrr_compile 
psmPackageGenMaddStatement 
psmQdDueryStringLmakeSection 
psmPVMCodeGeneratorIgenerate 
psmPVMCodeGeneratorIgenerate 
psmPVMCodeGeneratorIgenerate 
psmPVMCodeGeneratorKgenProgram 
psm_ctrlQpsm_generate_PVM 
psm_gen_program 
sqlnq_create_proc_end 
sqlnq_proc_create_stmt 
sqlnp_smactn 
sqlnp_parser 
sqlnp_main 
sqlnn_cmpl 
sqlnn_cmpl 
sqlra_compile_var 
sqlra_find_var 
sqlra_get_var 
sqlri_ddl_common 
sqlriddl 
sqlriSectInvoke 
sqlrr_execute_immediate 
sqlrr_execimmd 
sqljs_ddm_excsqlimm 
sqljsParseRdbAccessed 
sqljsParse 
sqljsSetupDrdaAsForApp 
sqljsSetupDrdaAsForApp 
sqljsDrdaAsDriver 
sqljsDrdaAsDriver 
sqeAgentGRunEDU 
sqzEDUObjJEDUDriver 
sqloEDUEntry 
</StackTrace>

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 and Fix Pack 4                   * 
****************************************************************

Run 'call sysproc.admin_revalidate_db_objects' on the trigger to 
revalidate it prior to running the Create Procedure command.

DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

Problem was first fixed in DB2 Version 10.5 and Fix Pack 4

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

24.04.2014
08.09.2014
08.09.2014