Informix - Problem description
Problem IT32490 | Status: Closed |
DISTRIBUTIONS ARE NOT CREATED FOR FIRST COLUMN OF TEMP TABLE WHEN RUNNING UPDATE STATISTICS HIGH OR MEDIUM | |
product: | |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 | |
Problem description: | |
If you run update statistics commands like below for table, distributions will not be created for the first column in temptab1. update statistics high for table temptab1 force; update statistics medium for table temptab1 force; The other columns will have their distributions created. Attempting to work around this problem by running update statistics on the lead column or a list of columns including the first column does not create distributions for the first column either. The command reports that update statistics was successful but there are no distributions for the first column in any of these cases. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix 11.70.xC8 and earlier versions. * **************************************************************** * PROBLEM DESCRIPTION: * * If you run update statistics commands like below for table, * * distributions will not be created * * for the first column in temptab1. * * * * update statistics high for table temptab1 force; * * update statistics medium for table temptab1 force; * * * * The other columns will have their distributions created. * * * * Attempting to work around this problem by running update * * statistics on the lead column or * * a list of columns including the first column does not create * * distributions for the first column either. * * * * The command reports that update statistics was successful * * but * * there are no distributions for the first column * * in any of these cases. * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 07.04.2020 24.08.2020 31.08.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |