Informix - Problem description
Problem IT20247 | Status: Closed |
UPDATE STATISTICS LOW WITH PDQ ENABLED IS NOT ALWAYS DOING PARALLEL SCANS OF FRAGMENTED INDEXES | |
product: | |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 | |
Problem description: | |
There are a number of combinations that appear to be incorrectly preventing the parallel index fragment scans when using PDQ. They are as follows: 1) if AUTO_STAT_MODE is set to 0 in the $ONCONFIG 2) if AUTO_STAT_MODE is set to 1 and STATCHANGE is set to 0 3) when running any update statistics low command with the new FORCE keyword If any of the above conditions is met, but the table that update statistics low is being run against has a fragmented index, the server will not properly spawn multiple updstat threads to scan the fragments of the index at the same time. So the only condition where the server is properly doing this is if AUTO_STAT_MODE is set to 1 and STATCHANGE is > 0 and the force keyword is not used in the update statistics command. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 11.70.xC9 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 18.04.2017 09.06.2017 09.06.2017 |
Problem solved at the following versions (IBM BugInfos) | |
11.70.xC9 | |
Problem solved according to the fixlist(s) of the following version(s) |