APAR status
Closed as program error.
Error description
We observed that the exact same SQL statement will be executed with different query plans when it is run within a stored procedure compared to its direct execution with dbaccess. This can happen when the statement cache is disabled. This can result in a significant drop of execution performance.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC7 * ****************************************************************
Problem conclusion
Problem Fixed In IBM Informix Server 12.10.xC7
Temporary fix
Comments
APAR Information
APAR number
IT12507
Reported component name
IFMX ULT WHSE E
Reported component ID
IM0019BOS
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2015-12-01
Closed date
2016-06-28
Last modified date
2016-06-28
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
IFMX ULT WHSE E
Fixed component ID
IM0019BOS
Applicable component levels
RB70 PSN
UP
RB70 PSY
UP
RC10 PSN
UP
RC10 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSBJS3","label":"Informix Ultimate Warehouse Edition"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
28 June 2016