Informix - Problem description
Problem IT11956 | Status: Closed |
QUERYING DATA COMPLETELY CACHED HAVING A LARGE NUMBER OF ITEMS IN AN "IN" CLAUSE CAN CAUSE SQLEXEC THREAD TO YIELD IMPROPERLY | |
product: | |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 | |
Problem description: | |
A query in question had > 10,000 host variable values for a column IN filter and was doing a sequential scan on a large table. So when looking at rows to try and qualify for the result set, much of the data in the table did not satisfy the IN condition, and evaluating the expressions to determine the row that didn't qualify was taking a lot of cpu time and so the thread was not yielding frequently enough, which can negatively impact the server. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * users having large host variables or constant values in a * * query as "IN" clause. * **************************************************************** * 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 : | 23.10.2015 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) |