PM81295: CHOOSE BAD INDEX ACCESSING DUE TO CALCULATE PAGE LIST COST

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• N/A
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: For all DB2 10 for z/OS users who have       *
  *                 queries choosing range list access           *
  *                 (ACCESSTYPE='NR' in PLAN_TABLE output).      *
  ****************************************************************
  * PROBLEM DESCRIPTION: PM81295 corrects a problem related      *
  *                      to range-list access (ACCESSTYPE='NR'   *
  *                      in PLAN_TABLE output) that a range-list *
  *                      plan may not have the lowest cost of    *
  *                      any plan it beats.                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  PM81295 corrects a problem related to range-list access that a
  range-list plan may not be assigned the lowest cost of any plan
  it beats.  As a result, the query could have poor performance.
  
  
  Additional Keywords:
  SQLRANGELIST RANGELIST SQLOR SQLACCESSPATH
  

Problem conclusion

• The logic in the DB2 optimizer has been corrected to resolve
  the described problem related to range-list access that
  the range-list plan should carry the lowest cost of any plans
  it beats.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK92968

Modules/Macros

•    DSNXOCSC
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK92968

     UP13/04/12 P F304

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.