APAR status
Closed as program error.
Error description
The optimizer will choose a sequential scan for a query containing an LVARCHAR data type. The optimizer chooses an index path for the same query with a VARCHAR data type.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All 11.70 users. * **************************************************************** * PROBLEM DESCRIPTION: * * A query may have sub-optimal query plan under the following * * conditions: * * - query has an equality predicate on LVARCHAR column, e.g. * * col1 = "abcd" where col1 is defined as LVARCHAR * * - there exists an index with col1 as the leading index * * column * * - update statistics has been run on the table * **************************************************************** * RECOMMENDATION: * * Update to IDS-11.70.xC9 * ****************************************************************
Problem conclusion
Problem Fixed In IDS-11.70.xC9
Temporary fix
Comments
APAR Information
APAR number
IC98433
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
B70
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2013-12-19
Closed date
2017-06-09
Last modified date
2024-09-24
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
INFORMIX SERVER
Fixed component ID
5725A3900
Applicable component levels
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B70","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
24 September 2024