|
Problem IT36266
|
Status: Closed |
INSPECT DATABASE COMMAND SLOW BECAUSE OF EXCESSIVE SLEEP WHILE CHECKING OVERFLOW RECORDS
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
While checking overflow records, INSPECT may sleep while waiting
on latches. This sleep is longer than necessary leading to poor
performance.
Identifying and reorganizing the tables with the most overflows
will alleviate, but not resolve the problem.
Identify the tables with the most overflow accesses :
SELECT varchar(tabschema,20) as tabschema,
varchar(tabname,20) as tabname,
OVERFLOW_ACCESSES
FROM TABLE(MON_GET_TABLE('','',-2)) AS t
ORDER BY OVERFLOW_ACCESSES DESC;
and then reorg the tables at the top of the list.
reorg table . inplace cleanup overflows; |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All Federated Users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Apply DB2 11.5 Mod 4 Fix Pack 6 *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* All Federated Users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Apply DB2 11.5 Mod 4 Fix Pack 6 *
**************************************************************** |
| Comment |
Problem fixed in DB2 11.5 Mod 4 Fix Pack 6 |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.03.2021
11.06.2021
11.06.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
