|
Problem IT35764
|
Status: Closed |
EXTENT MOVER CAN HANG WAITING FOR SQLO_LT_SQLB_POOL_CB__READLOTCH WHILE HOLDING SQLO_LT_SQLB_EXTENT_DESC__EXTENTLATCH
|
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
Note that in releases >= 11.1.4.4 the extentLatch was renamed to
extentLotch and this APAR is still applicable.
This is a 3-way dead latch between the Extent Mover (spawned by
running ALTER TABLESPACE .. [REDUCE MAX | LOWER HIGH WATER MARK
| REDUCE ]), a Page Cleaner, and a 3rd EDU (of any
description) that is requesting SQLO_LT_SQLB_POOL_CB__readLotch
in exclusive mode. The dead latch looks like the following:
1. Page Cleaner is holding SQLO_LT_SQLB_POOL_CB__readLotch in
shared mode and requesting SQLO_LT_SQLB_EXTENT_DESC__extentLatch
in shared mode with the following stack:
getConflict
sqlbFindAndLatchExtent (name changed to sqlbFindAndLotchExtent
in releases >= 11.1.4.4)
sqlbCommonWriteSetup
sqlbClnrAsyncWriteSetup
sqloDispatchNBlocks
sqlbClnrWriteSerializedPages
sqlbClnrWritePages
2. Extent Mover is holding SQLO_LT_SQLB_EXTENT_DESC__extentLatch
in exclusive mode and requesting SQLO_LT_SQLB_POOL_CB__readLotch
in shared mode with one of the following stacks:
getConflict
getLatchOnly
sqlbMoveHighestExtent
sqlbLockAndMoveExtents
sqlbExtentMovementEntryPoint
getConflict
getLatchOnly
sqlbCommonWriteSetup
sqlbWritePage
sqlbUnfixPage
sqlbMoveHighestExtent
sqlbLockAndMoveExtents
sqlbExtentMovementEntryPoint
getConflict
getLatchOnly
sqlbCommonWriteSetup
sqlbWritePage
sqlbUnfixPage
sqldUnFixFILE_INFO
sqldUpdateRow
sqldoupd
sqlbMoveHighestExtent
sqlbLockAndMoveExtents
sqlbExtentMovementEntryPoint
3. A 3rd EDU is requesting SQLO_LT_SQLB_POOL_CB__readLotch in
exclusive mode. For example BACKUP:
getConflict
getLatchOnly
sqlbLatchPoolForReadWrite
sqlbTestSetDatapoolState
sqlubBuildAppTbsp
sqlubcka
sqlubcka_route_in |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* N/A *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Fix target is 11.1.4.7, please request a special build *
**************************************************************** |
| Local Fix: |
Install latest fix pack. |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* N/A *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Fix target is 11.1.4.7, please request a special build *
**************************************************************** |
| Comment |
Fix target is 11.1.4.7, please request a special build |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 02.02.2021
26.10.2021
26.10.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
