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 IC88426 Status: Closed

ERROR RAISED INCORRECTLY FROM SQLEFEDFMPMANAGER::DISCONNECT UPON SUBAGENT
CLEANUP

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
When a subagent working on behalf of a coordinator agent is 
cleanup up, it may get sent an interrupt signal 
depending on the code currently executing in that subagent's 
code path. 
 
If the subagent is also associated with a db2fmp process 
executing federated code, then this may lead to the following 
sequence of errors in the db2diag.log : 
 
2012-08-17-02.49.02.110085+060 I4453399E448        LEVEL: Severe 
PID     : 14992                TID  : 46920542185792PROC : 
db2sysc 0 
INSTANCE: db2inst1             NODE : 000          DB   : SAMPLE 
APPHDL  : 0-58304              APPID: 
9.10.11.12.34514.120817014904 
AUTHID  : DB2INST1 
EDUID   : 49486                EDUNAME: db2agntp (SAMPLE) 0 
FUNCTION: DB2 UDB, base sys utilities, 
sqleFedFMPManager::disconnect, probe:30 
RETCODE : ZRC=0x00000048=72 
 
2012-08-17-02.49.02.110218+060 I4453848E451        LEVEL: Severe 
PID     : 14992                TID  : 46920542185792PROC : 
db2sysc 0 
INSTANCE: db2inst1             NODE : 000          DB   : SAMPLE 
APPHDL  : 0-58304              APPID: 
172.16.10.140.34514.120817014904 
AUTHID  : DB2INST1 
EDUID   : 49486                EDUNAME: db2agntp (SAMPLE) 0 
FUNCTION: DB2 UDB, base sys utilities, 
sqleFedFMPManager::disconnect, probe:30 
RETCODE : ZRC=0xFFFFFB95=-1131 
 
This marks db2fmp as unstable and can lead to error SQL20357N 
failing a commit statement.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* all                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade the database server to V9.7 Fix Pack 8               * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Solution
This problem has first been fixed in V9.7 Fix Pack 8
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC91455 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
20.11.2012
06.05.2013
06.05.2013
Problem solved at the following versions (IBM BugInfos)
9.7.FP8
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.8 FixList