|
Problem IT33158
|
Status: Closed |
AUTO_REORG ENABLED DATABASES MAY PERFORM REORG EVALUATION OF TABLES USING THE ADMIN_GET_TAB_INFO() ROUTINE UNNECESSARILY.
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
For AUTO_REORG enabled databases with a mixture of row-based
tables along with either ITC or MDC or columnar tables,
evaluation of the row-based tables for reclaim extents may be
performed using ADMIN_GET_TAB_INFO() unnecessarily. Frequent
execution of ADMIN_GET_TAB_INFO() may cause some lock contention
with other applications, resulting in lock-wait or deadlock
conditions for the applications. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* databases with a mixture of row-based *
* tables along with either ITC or MDC or columnar tables *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.1.4.6 (mod 4 fix pack 6) *
**************************************************************** |
| Local Fix: |
Upgrade to fixpack inclusive of this APAR fix. |
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 11.06.2020
19.03.2021
19.03.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
