|
Problem IC80900
|
Status: Closed |
LATCH LEAKED MESSAGES IN THE LOGS DUE TO LATCH SQLO_LT_SQLE_FEDFMP_APP_CB__FMPAPPLATCH |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
DB2 agent holds latch of SQLO_LT_SQLE_FEDFMP_APP_CB__fmpAppLatch
when the corresponding application is in UOW-Waiting state.
Similar messages will be reported in the db2diag.log:
2012-01-12-17.38.53.158901-360 E9618409A422 LEVEL: Severe
PID : 1274692 TID : 5320 PROC : db2sysc
INSTANCE: xxxxxxx NODE : 000
EDUID : 5320 EDUNAME: db2agent (idle)
FUNCTION: DB2 UDB, oper system services,
sqloDumpLatchTableToLog, probe:10
DATA #1 : String, 92 bytes
Latch leaked on EDU termination: File sqle_fed_fmp.C : Line 487
(Identity: 278) HoldCount: 1
From the output of db2pd -stack for that agent, you can see
below latch holding message:
Holding Latch type: (SQLO_LT_SQLE_FEDFMP_APP_CB__fmpAppLatch) -
Address: (780000000bfe508), Line: 481, File: sqle_fed_fmp.C
HoldCount: 1
This can happen when a busy application is forced, or killed or
brought down by any other methods. This issue exists in the
version after DB2 V9.7. This is specific to federated. And the
error can happen when data source of Federation server is
non-DRDA. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Issue is specific to federated user. *
****************************************************************
* PROBLEM DESCRIPTION: *
* LATCH LEAKED MESSAGES IN THE DB2 LOGS DUE TO LATCH *
* SQLO_LT_SQLE_FEDFMP_APP_CB__FMPAPPLATCH. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 6. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
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 |
First fixed in DB2 Version 9.7 Fix pack 6. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC84326
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 19.01.2012
21.06.2012
21.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
