Troubleshooting
Problem
After migrating to DB2 V9.7, Java UDF hangs.
Symptom
2012-01-13-12.09.14.303475-300 I3017A451 LEVEL: Severe
PID : 13462 TID : 583 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-43711 APPID: X.X.X.X.37317.120112223
AUTHID : db2inst1
EDUID : 583 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerMasterThreadReq,
probe:10
RETCODE : ZRC=0xFFFFFBEE=-1042
2012-01-13-12.09.14.303904-300 E3469A3363 LEVEL: Severe
PID : 13462 TID : 583 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-43711 APPID: X.X.X.X.37317.120112223
AUTHID : db2inst1
EDUID : 583 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerMasterThreadReq, probe:910
DATA #1 : String, 58 bytes
marking fmp as unstable after new thread creation failure:
DATA #2 : String, 8 bytes
Fmp TID:
DATA #3 : Hexdump, 4 bytes
0x0000000200DBF6F0 : 0000 0000 ....
DATA #4 : String, 8 bytes
Fmp Row:
DATA #5 : sqlerFmpRow, PD_SQLER_TYPE_FMP_ROW, 496 bytes
fmpPid: 20062
fmpPoolList Ptr: 0x0000000000000000 fmpForcedList Ptr: 0x0000000000000000
nextFmpCB Ptr: 0x0000000200e3d7e0 prevFmpCB Ptr: 0x0000000000000000
fmpIPCList Ptr: 0x0000000200fbff00
stateFlags: 0x00000013 numFmp32Attaches: 0
numActiveThreads: 0 numPoolThreads: 0
fmpCodePage: 819 fmpRowUseCount: 3
active: 0x01 rowLoaderValidate: 0x00
ipcLatch:
0x0000000200EEFC64 : FFCC 01AD ....
rowLatch:
0x0000000200EEFC68 : FFCC 01AE ....
fmpAgentList:
PID : 13462 TID : 583 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-43711 APPID: X.X.X.X.37317.120112223
AUTHID : db2inst1
EDUID : 583 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerMasterThreadReq,
probe:10
RETCODE : ZRC=0xFFFFFBEE=-1042
2012-01-13-12.09.14.303904-300 E3469A3363 LEVEL: Severe
PID : 13462 TID : 583 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-43711 APPID: X.X.X.X.37317.120112223
AUTHID : db2inst1
EDUID : 583 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerMasterThreadReq, probe:910
DATA #1 : String, 58 bytes
marking fmp as unstable after new thread creation failure:
DATA #2 : String, 8 bytes
Fmp TID:
DATA #3 : Hexdump, 4 bytes
0x0000000200DBF6F0 : 0000 0000 ....
DATA #4 : String, 8 bytes
Fmp Row:
DATA #5 : sqlerFmpRow, PD_SQLER_TYPE_FMP_ROW, 496 bytes
fmpPid: 20062
fmpPoolList Ptr: 0x0000000000000000 fmpForcedList Ptr: 0x0000000000000000
nextFmpCB Ptr: 0x0000000200e3d7e0 prevFmpCB Ptr: 0x0000000000000000
fmpIPCList Ptr: 0x0000000200fbff00
stateFlags: 0x00000013 numFmp32Attaches: 0
numActiveThreads: 0 numPoolThreads: 0
fmpCodePage: 819 fmpRowUseCount: 3
active: 0x01 rowLoaderValidate: 0x00
ipcLatch:
0x0000000200EEFC64 : FFCC 01AD ....
rowLatch:
0x0000000200EEFC68 : FFCC 01AE ....
fmpAgentList:
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Routines (SP \u0026 UDF) - Java","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"9.7;9.5;9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
To view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use the link to actual document below to access the full document. You will be asked to log on if you are not already logged in. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
More support for:
Db2 for Linux, UNIX and Windows
Software version:
9.7, 9.5, 9.1
Operating system(s):
AIX, HP-UX, Linux, Solaris
Document number:
199141
Modified date:
30 April 2025
UID
swg21580141
Manage My Notification Subscriptions