home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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 FixList