|
Problem IT09620
|
Status: Closed |
HASH JOIN ON A COMPLEX QUERY CAN YIELD TO MASSIVE PERFORMANCE PROBLEMS OR BLOCK THE ENGINE |
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
When running a dss query which is doing some complex aggregate
functions, the sqlexec thread does not yield often
enough. This can lead to massive performance issues or block the
engine.
How massive the issue is depends on where the sqlexec thread is
running. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users having DSS queries without PDQ and aggregate *
* operations. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 12.10.xC6 *
**************************************************************** |
| Local Fix: |
|
| Solution |
Problem Fixed In IBM Informix Server 12.10.xC6 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 23.06.2015
30.12.2015
30.12.2015 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 12.10.xC6
|
 |
