|
Problem IT09366
|
Status: Closed |
HANG DUE TO INPLACE REORG FAILING TO UNLATCH A PAGE |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
When inplace reorg moves an overflow record and the overflow is
already on the target page, an attempt may be made to create or
recreate a page dictionary on the target page. If the dictionary
creation or recreation does not free up any additional space on
the page, inplace reorg could fail to unlatch the page. Any
other application attempting to latch the page will wait on the
page latch indefinitely. The instance will need to be restarted. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Inplace reorg *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to the latest fix pack *
**************************************************************** |
| Local Fix: |
Disable adaptive compression before running inplace reorg. |
| Solution |
Problem was first fixed in DB2 UDB Version 10.5 fix pack 7 |
| Workaround |
Disable adaptive compression before running inplace reorg |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 09.06.2015
19.01.2016
29.04.2016 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.7
|
 |
