IT00786 fixed an issue in which unnecessary db2diag.log entries
were being generated due to db2fmp processes being interrupted
unncessarily in a DPF environment. However even with the fix to
that APAR some routine types were not accounted for which could
still lead to a similar set of errors.
As an example the following messages might be seen in the
db2diag.log in a DPF environment:
2014-11-14-00.17.23.344953-300 I53517A496 LEVEL:
Severe
PID : 9896532 TID : 1 PROC :
db2fmp (C) 3
INSTANCE: db2inst1 NODE : 003
HOSTNAME: test.ibm.com
EDUID : 1 EDUNAME: db2fmp (C) 3
FUNCTION: DB2 UDB, routine_infrastructure,
sqlerMasterThreadListener, probe:400
RETCODE : ZRC=0xFFFFFB95=-1131
SQL1131N A stored procedure process has been
terminated abnormally.
Routine name: "". Specific name: "".
2014-11-14-00.17.23.348353-300 I54512A3444 LEVEL:
Severe
PID : 30540542 TID : 17912 PROC :
db2sysc 3
INSTANCE: db2inst1 NODE : 003 DB :
SAMPLE
APPHDL : 1-36736 APPID:
192.168.0.5.51733.141114051723
AUTHID : DB2USR1 HOSTNAME: test.ibm.com
EDUID : 17912 EDUNAME: db2agntp (AAAABBBB) 3
FUNCTION: DB2 UDB, routine_infrastructure, sqlerMasterThreadReq,
probe:100
RETCODE : ZRC=0x00000000=0=PSM_OK "Unknown"
DATA #1 : sqlerFmpRow, PD_SQLER_TYPE_FMP_ROW, 544 bytes
fmpPid: 9896532
fmpPoolList Ptr: 0x0000000000000000 fmpForcedList Ptr:
0x0000000000000000
nextFmpCB Ptr: 0x0780000000a8da00 prevFmpCB Ptr:
0x0000000000000000
fmpIPCList Ptr: 0x0780000000a8ffc0
stateFlags: 0x00000002 numFmp32Attaches: 0
numActiveThreads: 1 numPoolThreads: 0
fmpCodePage: 0 fmpRowUseCount: 1
active: 0x01 rowLoaderValidate: 0x00
2014-11-14-00.17.23.352712-300 I68150A982 LEVEL: Error
PID : 30540542 TID : 17912 PROC :
db2sysc 3
INSTANCE: db2inst1 NODE : 003 DB :
SAMPLE
APPHDL : 1-36736 APPID:
192.168.0.5.51733.141114051723
AUTHID : DB2USR1 HOSTNAME: test.ibm.com
EDUID : 17912 EDUNAME: db2agntp (AAAABBBB) 3
FUNCTION: DB2 UDB, routine_infrastructure,
sqlerInvokeFencedRoutine, probe:99
MESSAGE : ZRC=0xFFFFFBEC=-1044
SQL1044N Processing was cancelled due to an
interrupt.
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL10014
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0x00000000 (6)
0x00000003
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2014-11-14-00.17.23.353625-300 I69133A554 LEVEL: Error
PID : 30540542 TID : 17912 PROC :
db2sysc 3
INSTANCE: db2inst1 NODE : 003 DB :
SAMPLE
APPHDL : 1-36736 APPID: APPID:
192.168.0.5.51733.141114051723
AUTHID : DB2USR1 HOSTNAME: test.ibm.com
EDUID : 17912 EDUNAME: db2agntp (AAAABBBB) 3
FUNCTION: DB2 UDB, runtime interpreter, sqlri_close_udf_eos,
probe:202
RETCODE : ZRC=0x8012006D=-2146303891=SQLR_CA_BUILT
"SQLCA has already been built" |
