DB2 - Problem description
Problem IT06203 | Status: Closed |
Problem fixed via IT00786 can still occur for other routine types. | |
product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problem description: | |
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" | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 10.1 fp5 * **************************************************************** | |
Local Fix: | |
Solution | |
Fixed in 10.1 fp5 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 22.12.2014 13.07.2015 13.07.2015 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.1.0.5 |