PI52695: ALLOW CONTROL OVER WHETHER IDAA DATA GETS RELOADED AS A RESULT OF A CHANGE.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Allow control over whether IDAA data gets reloaded as a result
  of a change.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who make changes to the             *
  *                 table definitions that are accelerated.      *
  ****************************************************************
  * PROBLEM DESCRIPTION: This new function will allow the user   *
  *                      to have control over whether IBM        *
  *                      DB2  Analytics Accelerator for IBM      *
  *                      z/OS  (IDAA) data gets reloaded as      *
  *                      a result of a change.                   *
  ****************************************************************
  * 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, added back and the data
  is reloaded.
  
  The option used on panel ADB2PCO 'Options for Change
  Functions ' to accomplish this was:
  
  Reload accelerated tables .. YES (Yes/No. Default is Yes.)
  
  With this APAR, there is more granularity added for taking care
  of the tables on the accelerator side.
  
  Here are the new options and explanation of what each can do:
  
  1 - The following option can determine whether to recreate the
  accelerated tables:
  
  Recreate accelerated tables  . . . YES (Yes/No. Default is Yes)
  
  2- The following option will allow control over whether IDAA
  data gets reloaded when a table is dropped and recreated:
  
  Reload accelerated tables  . . . . YES (Yes/No. Default is Yes)
  
  3- The following option helps in removing the table from the
  accelerator when a table is dropped from DB2 side:
  
  Remove deleted accelerated tables. YES (Yes/No. Default is Yes)
  

Problem conclusion

Temporary fix

Comments

• Enhancement delivered.
  

APAR Information

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

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

Modules/Macros

•    ADBASW   ADBCCM   ADBCCMM  ADBCDTS  ADBCEST
  ADBCMPDB ADBCNBVF ADBCRCR  ADBCSPG  ADBDAT   ADBDK    ADBEALT
  ADBHPCO  ADBLI    ADBNSPB  ADBPA    ADBPA1   ADBSALT  ADBSPCO
  ADBTEPI  ADBTEPR  ADBTEPU  ADBTEP2  ADBV99   ADB2CID  ADB2CME
  ADB2CMF  ADB2CMO  ADB2CMP  ADB2CMR  ADB2CMS  ADB2CMT  ADB2CMU
  ADB2CM1  ADB2CM2  ADB2CM3  ADB2C11A ADB2FMT  ADB2MSK  ADB2MSQ
  ADB2PA   ADB2PA3  ADB2PA4  ADB2PA5  ADB2PA6  ADB2PA7  ADB2PCO
  ADB2REG  ADB2REH  ADB2WCL  ADB2WVL  ADB27AC  ADB28MC  ADB5000
  ADB7000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI33960

     UP15/12/23 P F512

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.