|
Problem IT34912
|
Status: Closed |
NEW OPTION FOR DB2LOOK -M NOT TO GENERATE RESET INDEX AND COLUMNSTATS IN THE OUTPUT VIA NEW ENVIRONMENT VARIABLE
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
APAR IT17532 introduced reset of index and column stats updates
in db2look -m output.
This APAR is introducing a new environment variable which when
set, will prevent generation of index and column reset stats
updates in db2look -m output.
To set environment variable to skip stats reset update
statements on new version of db2look after APAR fix is applied.
export DB2LOOK_SKIP_MIMIC_RESET=Y |
| 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 available *
**************************************************************** |
| Local Fix: |
Manually remove index and column reset stats updates when not
needed. |
| 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 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) |
