PH30978: SUBSYSTEM PARAMETER TO ENABLE INDEX IN-MEMORY OPTIMIZATION (FTB) FOR NON-UNIQUE INDEXES

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Subsystem parameter to enable index in-memory optimization
  (FTB) for non-unique indexes - DB2FTB/K
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS users.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * This APAR adds a new Db2 subsystem                           *
  * parameter in DSN6SPRM called                                 *
  * FTB_NON_UNIQUE_INDEX that specifies                          *
  * whether fast index traversal for                             *
  * non-unique indexes is enabled.                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This PTF adds a new Db2 subsystem parameter in DSN6SPRM
  called FTB_NON_UNIQUE_INDEX that specifies whether fast index
  traversal for non-unique indexes is enabled.
  Valid options are:
  - NO  : Fast index traversal for non-unique
          indexes is disabled.
          ====> This is the default setting
  - YES : Fast index traversal for non-unique
          indexes is enabled.
  

Problem conclusion

Temporary fix

Comments

• This PTF adds a new Db2 subsystem parameter in DSN6SPRM
  called FTB_NON_UNIQUE_INDEX that specifies whether fast index
  traversal for non-unique indexes is enabled.
  Valid options are:
  - NO  : Fast index traversal for non-unique
          indexes is disabled.
          ====> This is the default setting
  - YES : Fast index traversal for non-unique
          indexes is enabled.
  

APAR Information

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

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

  UI75643

Modules/Macros

• DSNTINMF DSNDQWPZ DSNTIP71 DSNWZIFC DSNTIDXA DSNTIVMD DSNTIJUZ
  DSNTINST DSNTIDXC DSNTIWIA DSNTIDXB DSNTIVIA DSNTIWMD DSNTIWIE
  DSNTIVIE DSN@XAZP DSN6SPRM DSNTXAZP DSNTIWPC DSNDSPRM DSN6SPRC
  DSNTIVMN DSNTIWMN DSNTIVAF DSNTIVIN DSNTIWMS DSNTIVMS DSNTIWAF
  DSNTIWIN
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI75643

     UP21/06/09 P F106

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.