User's routine was terminated abnormally when the system
routines in the library db2dbroutext were run. The library was
loaded into the db2fmp process.
Typically, the health monitor may run the routine internally.
In the db2diag.log, we would see SQL1224N(0xFFFFFB38) and
SQL1131N(0xFFFFFB95), and the messages like this.
2011-07-01-07.15.31.863793+540 I119867E509 LEVEL: Error
PID : 21361 TID : 46912812083520PROC :
db2sysc
INSTANCE: db2inst1 NODE : 000 DB : TESTDB
APPHDL : 0-15872 APPID:
xxx.xxx.xx.x.xxxxx.xxxxxxxxxxxx
AUTHID : db2inst1
EDUID : 69 EDUNAME: db2agent (TESTDB)
FUNCTION: DB2 UDB, routine_infrastructure,
sqlerInvokeFencedRoutine, probe:40
DATA #1 : Hex integer, 4 bytes
0x8136001C
DATA #2 : Hex integer, 4 bytes
0xFFFFFB38
2011-07-01-07.15.31.864001+540 I120377E509 LEVEL: Error
PID : 21361 TID : 46912812083520PROC :
db2sysc
INSTANCE: db2inst1 NODE : 000 DB : TESTDB
APPHDL : 0-15872 APPID:
xxx.xxx.xx.x.xxxxx.xxxxxxxxxxxx
AUTHID : db2inst1
EDUID : 69 EDUNAME: db2agent (TESTDB)
FUNCTION: DB2 UDB, routine_infrastructure,
sqlerInvokeFencedRoutine, probe:45
DATA #1 : Hex integer, 4 bytes
0x8136001C
DATA #2 : Hex integer, 4 bytes
0xFFFFFB95
2011-07-01-07.15.32.167129+540 E132474E393 LEVEL: Error
PID : 21359 TID : 46912698837312PROC :
db2wdog
INSTANCE: db2inst1 NODE : 000
EDUID : 2 EDUNAME: db2wdog
FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashHandler,
probe:15
DATA #1 : <preformatted>
A non-EDU child crashed. Process id: 31059, OSS term code:
0x102, signal: 9
2011-07-01-07.15.32.167620+540 E132868E3477 LEVEL: Severe
PID : 21361 TID : 46912812083520PROC :
db2sysc
INSTANCE: db2inst1 NODE : 000 DB : TESTDB
APPHDL : 0-15872 APPID:
xxx.xxx.xx.x.xxxxx.xxxxxxxxxxxx
AUTHID : db2inst1
EDUID : 69 EDUNAME: db2agent (TESTDB)
FUNCTION: DB2 UDB, routine_infrastructure, sqlerReturnFmpToPool,
probe:900
DATA #1 : String, 50 bytes
Marking fmp as unstable, fmp is forced or aborted:
....... |
