SQL1042C running a fenced routine (stored procedure/UDF)

时间:2022-02-15 13:59:05

Relation to this link

http://www-01.ibm.com/support/docview.wss?uid=swg21399105

2015-01-11-13.38.19.538002+000 E263507727A548     LEVEL: Warning
PID     : 15139020             TID  : 13287       PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000         DB   : ICMNLSDB
APPHDL  : 0-17924              APPID: 146.89.240.23.61630.150111133822
AUTHID  : ICMADMIN
EDUID   : 13287                EDUNAME: db2agent (ICMNLSDB) 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerReturnFmpToPool, probe:2000
DATA #1 : String, 55 bytes
Sending a signal to clean up NOT THREADED FMP process:
DATA #2 : Process ID, 4 bytes
13303904

2015-01-11-13.38.19.554686+000 E263508276A1319    LEVEL: Severe
PID     : 15139020             TID  : 13287       PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000         DB   : ICMNLSDB
APPHDL  : 0-17924              APPID: 146.89.240.23.61630.150111133822
AUTHID  : ICMADMIN
EDUID   : 13287                EDUNAME: db2agent (ICMNLSDB) 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerSendFmpStart, probe:10
MESSAGE : ZRC=0xFFFFFBEE=-1042
DATA #1 : SQC RC type., PD_TYPE_SQC_RC, 4 bytes
54
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
  [0] 0x09000000128A2D78 pdLog + 0xE0

54
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
  [0] 0x09000000128A2D78 pdLog + 0xE0
  [1] 0x09000000127AE148 pdLog@glue41A + 0xAC
  [2] 0x0900000011B88D98 sqlerSendFmpStart__FP13sqlerFmpParmsP14sqlerFmpHandleP5sqlca + 0xE4
  [3] 0x09000000145C591C sqlerInvokeFencedRoutine__FP13sqlerFmpParms + 0x1244
  [4] 0x0900000012895188 sqlriInvokeInvoker__FP10sqlri_ufobb + 0x4D4
  [5] 0x09000000128944C8 sqlricall__FP8sqlrr_cb + 0x12C
  [6] 0x09000000129260A4 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x30
  [7] 0x09000000128DB7E4 sqlrr_process_execute_request__FP8sqlrr_cbib + 0xC40
  [8] 0x09000000128DBA80 sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo + 0xB8
  [9] 0x09000000128CAFFC .sqljs_ddm_excsqlstt.fdpr.clone.4__FP14db2UCinterfaceP13sqljDDMObject + 0x7A4

2015-01-11-13.38.19.554970+000 I263509596A451     LEVEL: Severe