DB2 - Problem description
Problem IT38046 | Status: Closed |
NNSTAT MIGHT FAIL TO UPDATE NUMERIC COLUMN STATS WITH SQL1227N RC=3 IF VACHAR2 COMPATIVILITY IS ENABLED. | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
The nnstat procedure (method 1) might return SQL20274W against some nicknames, and nnstat.log shows SQL1227N rc=3 HIGH2KEY to update column statistics. This problem can happen in case all the following conditions are met: - Varchar2 compatibility is enabled in both source and federated databases. - Numeric column has less cardinality than 4 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5 FP7 or later * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5 FP7 or later * **************************************************************** | |
Comment | |
Upgrade to 11.5 FP7 or later | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 17.08.2021 22.11.2021 22.11.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |