PH50892: ACCELERATION OF A TABLE IS NOT RESTORED AFTER THE TABLE IS ALTERED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Acceleration of a table is not restored after the table space is
  converted from a segmented table space to a PBG table space.
  
  
  The following message can be found in the job log.
  
  
  ADB5031W The following list of < x > table(s) were not enabled
  for acceleration on the accelerator < accelerator name > prior
  to the recreate operation.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for         *
  *                 z/OS who also use IDAA                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: When altering an accelerated table, the *
  *                      table might not retain the original     *
  *                      replication and acceleration status     *
  *                      after the table space is converted from *
  *                      a segmented table space to a            *
  *                      partition-by-growth (PBG) table space.  *
  ****************************************************************
  Setting the common options 'restore replication of tables' and
  'restore acceleration of tables' to YES (on panel ADB2PCO) might
  not retain the original acceleration and replication status.
  After a table space that contains an accelerated table is
  altered, the ADMIN ACCELERATOR RECREATE TABLES statement
  retrieves table information to restore the table's acceleration
  and replication status. If an alter operation that converts a
  segmented table space to a PBG table space changes the
  acceleration or replication status of the table, its
  acceleration and replication status might be not restored.
  
  
  
  This APAR introduces a new ADMIN ACCELERATOR GET TABLE INFO
  statement that is issued before the conversion of the table
  space. This statement retrieves accelerated table information
  that is used to restore its acceleration and replication status.
  

Problem conclusion

• The problem has been resolved.
  

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:

  UI90197 UI90198

Modules/Macros

• ADB27AC  ADB28MC  ADB2CID  ADB2CM3  ADB2CME  ADB2CMF  ADB2CMO
  ADB2CMP  ADB2CMR  ADB2CMS  ADB2CMT  ADB2CMU  ADB2FMT  ADB2MSK
  ADB2MSQ  ADB2PA   ADB2PA3  ADB2PA4  ADB2PA5  ADB2PA6  ADB2PA7
  ADB2REG  ADB2REH  ADB2WCL  ADB2WIN  ADB2WVL  ADB5000  ADBASW
  ADBCCM   ADBCCMM  ADBCDTS  ADBCEST  ADBCHST  ADBCRCR  ADBCSPG
  ADBDAT   ADBDK    ADBLI    ADBNSPB  ADBPA    ADBPA1   ADBTEP2
  ADBTEPI  ADBTEPR  ADBTEPU  ADBV99
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI90197

     UP23/01/24 P F301

• RD10 PSY UI90198

     UP23/01/24 P F301

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.