Informix - Problem description
Problem IT15627 | Status: Closed |
OPTIMIZER NEEDS A LOT OF SHARED MEMORY | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
Optimizing a query needs much more shared memory in 12.10.FC6 compared to 12.10.FC5. After running a query (with AVOID_EXECUTE) a lot of shared memory segments were allocated. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of 12.10.xC6 through 12.10.xC12 (inclusive). * **************************************************************** * PROBLEM DESCRIPTION: * * Optimizing a query needs much more shared memory in * * 12.10.xC6 - 12.10.xC12 compared to 12.10.FC5. * * * * After running a query a lot of shared memory segments were * * allocated. * **************************************************************** * RECOMMENDATION: * * Upgrade to IDS 12.10.xC13+. * **************************************************************** The fix can be disabled by setting OPT_ANSIJOIN_P1PRUNE to a big number like 100: onmode -wm OPT_ANSIJOIN_P1PRUNE=100 | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 07.06.2016 31.10.2019 31.10.2019 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC13, 12.10.xC8 | |
Problem solved according to the fixlist(s) of the following version(s) |