Informix - Problem description
Problem IT11480 | Status: Closed |
UPDATE STATISTICS LOW FOR TABLE MAY BLOCK OTHER THREAD ACTIVITY | |
product: | |
INFORMIX SERVER / 5725A3900 / B50 - IDS 11.50 | |
Problem description: | |
When running the SQL statement UPDATE STATISTICS LOW FOR TABLE on a table with indexes it is possible the activity to scan index leaf pages can run without yielding if all required pages are present in the buffer pool. The impact of this will vary depending on what other threads need to run on the same VP. For example if a listener thread is ready to run then new connections to the database server may be delayed. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Any * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 11.50.xC10 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 28.09.2015 15.06.2017 15.06.2017 |
Problem solved at the following versions (IBM BugInfos) | |
11.50.xC10 | |
Problem solved according to the fixlist(s) of the following version(s) |