Informix - Problem description
Problem IT14444 | Status: Closed |
A QUERY USING XPS API AND INDEX ACCESS CAN RETURN INCOMPLETE RESULTS IF THE INDEX IS UPDATED BY A CONCURRENT THREAD | |
product: | |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 | |
Problem description: | |
If you have the BATCHEDREAD_TABLE set to 1 and you run a query using an index access path (with dirty read or committed read isolation level set) and there are concurrent updates against the column on which the index is build, the query can end prematurely, not returning all expected rows. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of BATCHREAD_INDEX when an update to the index occurs. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 11.70.xC9 * **************************************************************** | |
Local Fix: | |
Set BATCHEDREAD_TABLE onconfig parameter to 0, either in the file directly (requires instance restart), or via 'onmode -wf'. | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 23.03.2016 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) |