| Latest versions | fixlist |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IC96601 | Status: Closed |
FENCED WRAPPER GETS HANG SPORADICALLY AFTER -1131 ERROR | |
| product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
| Problem description: | |
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. | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * The users are running fenced wrappers. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Federation Server V10.5FP3. * **************************************************************** | |
| Local Fix: | |
Set ASLHEAPSZ to a value no less than 17 and recycle db2 server. | |
| available fix packs: | |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows | |
| Solution | |
The problem is firstly fixed in Federation Server V10.5FP3. | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 03.10.2013 27.02.2014 27.02.2014 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 10.5.0.3 |
|
| 10.5.0.3 |
|