PI53805: RECREATE ACCELERATED TABLE KEYS DURING COMPARE TABLE RECREATE PROCESS.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Recreate accelerated table keys during compare table recreate
  process.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration and Object   *
  *                 Comparison Tool for z/OS who use IBM  DB2    *
  *                 Analytics Accelerator for IBM z/OS  (IDAA)   *
  *                 for query enhancements and make changes to   *
  *                 the table definitions added to the           *
  *                 accelerator.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: This new function will add support to   *
  *                      recreate distribution and organizing    *
  *                      keys of the accelerated tables          *
  *                      whenever those tables are dropped       *
  *                      and recreated in DB2.                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Prior to this APAR, when the definition of a DB2 table is
  changed that involved dropping and recreating the table, the
  table on the accelerator is removed and added back, but without
  recreating any distribution or organizing keys specified for
  the accelerated tables. This enhancement will ensure that
  previously specified keys information is retained and added
  back to the accelerated table definition, during its recreate
  process.
  
  The option used on panel ADB2PCO 'Options for Change Functions'
  to accomplish this is:
  
  Recreate accelerated tables  . . . YES (Yes/No. Default is Yes)
  
  This option, if enabled, will ensure that accelerated tables
  are recreated along with any distribution or organizing keys.
  

Problem conclusion

Temporary fix

Comments

• Enhancement delivered.
  
  The DB2 Administration Tool for z/OS User's Guide
  and Reference has been updated:
  
  https://ibm.biz/BdH3b4
  

APAR Information

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

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

  UI35057

Modules/Macros

•    ADBASP   ADBDAT   ADBHZAK  ADBPZATA ADBXGTI
  H0IHB20J
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI35057

     UP16/02/05 P F602

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.