DB2 FOR LUW / DB2FORLUW / A50 - DB2

Fenced wrapper may get hang sporadically after a -1131 error in 
db2diag.log. For this problem, only the specific query hang and 
anything else ran fine on the server at the same time. 
 
You will see following error messages from db2diag.log: 
 
2012-09-29-02.44.53.139002-240 I1951E322           LEVEL: Severe 
PID     : 19415                TID  : 139708008859408PROC : 
db2fmp ( 
INSTANCE: db2inst1              NODE : 000 
APPID   : 9.26.121.169.48208.120929064451 
FUNCTION: DB2 UDB, routine_infrastructure, sqlerFedFmpListener, 
probe:20 
RETCODE : ZRC=0xFFFFFB95=-1131 
 
2012-09-29-02.44.53.139333-240 I2274E454           LEVEL: 
Warning 
PID     : 19415                TID  : 139708008859408PROC : 
db2fmp ( 
INSTANCE: db2inst1              NODE : 000 
APPID   : 9.26.121.169.48208.120929064451 
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary 
logging func, probe:0 
MESSAGE : Thread of db2fmp terminated with nonzero rc 
DATA #1 : Hexdump, 4 bytes 
0x00007F104E3D7E84 : 95FB FFFF 
.... 
 
2012-09-29-02.44.53.170265-240 I2729E373           LEVEL: Error 
PID     : 19415                TID  : 139708008859408PROC : 
db2fmp ( 
INSTANCE: db2inst1              NODE : 000 
FUNCTION: DB2 UDB, drda wrapper, 
FencedDRDA_Server::get_diagnostic, probe:10 
MESSAGE : DiagRec han_type 
DATA #1 : Hexdump, 2 bytes 
0x00007F104E3D7158 : 0300 
.. 
 
The problem was introduced in v97 fix pack 5 by APAR IC76273, so 
you should not have this problem in v97 fix pack 4 or earlier.

**************************************************************** 
* USERS AFFECTED:                                              * 
* The users are running fenced wrappers.                       * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Federation Server V10.5FP3.                       * 
****************************************************************

Set ASLHEAPSZ to a value no less than 17 and recycle db2 server.

DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

The problem is firstly fixed in Federation Server V10.5FP3.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

03.10.2013
27.02.2014
27.02.2014