A fix is available
APAR status
Closed as program error.
Error description
DB2 generates an incorrect compound filter factor in IMFF for a query with an IN list predicate despite having multi cardinality and multi frequency entries in SYSCOLDIST. Keywords: SQLPERFORMANCE SQLACCESSPATH FILTERFACTOR
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: DB2 for z/OS users collecting multi-column * * frequencies or multi-column histograms. * **************************************************************** * PROBLEM DESCRIPTION: DB2 may compute an incorrect filter * * factor for a set of predicates * * containing an IN list predicate if * * multi-column frequency or multi-column * * histogram statistics exist. * **************************************************************** * RECOMMENDATION: * **************************************************************** DB2 may compute an inaccurate compound filter factor. This problem can occur if all of the following conditions are met. * An IN list predicate is coded in the query. * Additional predicates are coded against the same table as the IN list predicate. * Multi-column frequency or multi-column histogram statistics exist for all or some of the columns referenced by the predicates against the table. This problem can result in selection of an inefficient access path leading to poor query performance. Additional Keywords: SQLPERFORMANCE SQLACCESSPATH SQLSTATS SQLIN
Problem conclusion
DB2 code has been corrected to accurately estimate the compound filter factor in the described scenario.
Temporary fix
Comments
APAR Information
APAR number
PI43645
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2015-06-24
Closed date
2015-11-12
Last modified date
2015-12-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI32905 UI32906
Modules/Macros
DSNXOGNC
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
02 December 2015