PH28182: INDEX LOOK ASIDE SUPPORT WHEN INDEX FAST TRAVERSE BLOCK(FTB) IS IN USE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When In-memory index optimization function (Index Fast Traverse
  Block-FTB) is enabled, index look aside is not set up properly.
  The index look aside information can be used to avoid extra
  get page calls when the same index leaf page is used by two
  index manager calls doing index insert , delete or index fetch.
  This APAR will allow the index look aside function to be used
  when the index leaf page is returned by FTB and will reduce the
  number of index get page calls during insert, delete or index
  access query workloads.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS users with                               *
  * in-memory index optimization function                        *
  * (Index Fast Traverse Block-FTB)                              *
  * enabled.                                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When in-memory index optimization                            *
  * function (Index Fast Traverse                                *
  * Block-FTB) is enabled, index look                            *
  * aside is not used. This will cause                           *
  * extra index get page requests during                         *
  * SQL INSERT and DELETE workload.                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  When in-memory index optimization function (Index Fast Traverse
  Block-FTB) is enabled, index look aside is not used.
  The index look aside information can be used to avoid extra
  get page calls when the same index leaf page is used by two
  index manager calls doing index insert or delete processing.
  

Problem conclusion

• Db2 code has been modified to allow the index look aside
  function to be used when the index leaf page is returned by
  FTB. This change will reduce the number of index get page
  requests during SQL INSERT and DELETE workload.
  Additional keyword : DB2FTB/K
  

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:

  UI71784

Modules/Macros

• DSNKINSL DSNKTRAV DSNKDLE
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI71784

     UP20/10/03 P F010

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.