PH57071: CHANGE READING FTB SYSIBM.SYSINDEXCONTROL TABLE FROM 10 MINUTES TO EVERY 2 MINUTES

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• After FTB rows are inserted into SYSIBM.SYSINDEXCONTROL Db2 will
  process the requested fast index traversal changes within 10
  minutes. This apar will change from 10 to every 2 minutes.
  
  Additional keyword: DB2FTB/K
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 V13 for z/OS users with in-memory                    *
  * index optimization function switched on                      *
  * (Index Fast Traverse Block - FTB).                           *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * After FTB rows are inserted into                             *
  * SYSIBM.SYSINDEXCONTROL Db2 will                              *
  * process the requested fast index                             *
  * traversal changes within 10 minutes.                         *
  * This apar will change it from 10 to                          *
  * every 2 minutes.                                             *
  * Additional keyword: DB2FTB/K                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  After FTB rows are inserted into SYSIBM.SYSINDEXCONTROL Db2
  will process the requested fast index traversal changes within
  ten minutes. This apar will change it from 10 to every 2
  minutes.
  Additional problem fixed:
  The number of index levels for the index in the message
  DSNT783I for DISPLAY STATS(Index Memory Usage) and in the
  message DSNT830I for DISPLAY STATS(Index Traverse Count) may be
  not correct on some data sharing members after index page
  splits.  The code has been modified to update this information,
  when it is possible, by sending a notify message - when a FTB
  exists on the member, where this information needs to be
  updated.
  Additional keyword: FTB, DB2FTB/K
  

Problem conclusion

Temporary fix

Comments

• More information can be found in the "IBM Knowledge Center"
  Additional key words:
  FTB, DB2FTB/K
  

APAR Information

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

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

  UI94095

Modules/Macros

• DSNKULTH DSNKFQPL DSNB1PPP DSNKUSET DSNKUNR2 DSNKDPG  DSNKFEXT
  DSNKINSL DSNB1SWD DSNTDSTE DSNKINSN DSNKMDEL DSNKISPL DSNKISPN
  DSNKTRAV DSNKFTOM DSNKIXDB DSNKFTIN DSNKLOD2 DSNKPLOK DSNK1CNE
  DSNKFTDL DSNKFTBU DSNKFTOB DSNB1CPP DSNKFLOK
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RD10 PSY UI94095

     UP23/10/27 P F310

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.