DB2 - Problem description
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) |