|
Problem IT34911
|
Status: Closed |
APAR IT17532 INTRODUCED RESET OF COLUMN STATS IN DB2LOOK MIMIC OUTPUT, CAUSING LOCKING BEHAVIOUR WITH ONLINE RUNNING APPS.
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
APAR IT17532 introduced reset of column stats in
db2look output, which when updating stats on production causes
locking behaviour with online transactions.
This APAR will change the reset of column stats to be done per
column and not for all columns at once which will alleviate the
locking
issue. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All Users on DB2 v111m4FP5 and earlier *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 v111m4FP6 or apply Local Fix if available *
**************************************************************** |
| Local Fix: |
Manually remove reset stats updates when updating stats on
production. |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* All Users on DB2 v111m4FP5 and earlier *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 v111m4FP6 or apply Local Fix if available *
**************************************************************** |
| Comment |
First Fixed in DB2 v111m4FP6 |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 12.11.2020
15.03.2021
15.03.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
