DB2 FOR LUW / DB2FORLUW / 970 - 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 DRDA wrapper when ASLHEAPSZ is set to  * 
* a value less than 17.                                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 and Fix Pack 8.                   * 
****************************************************************

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

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
 

Problem was first fixed in DB2 Version 9.7 and Fix Pack 8.

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC89712 IC89884 
Nachfolger : 

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

29.09.2012
02.04.2013
02.04.2013

9.7.