PI52710: OBJECT COMPARE - 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

• OBJECT COMPARE -  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:

  UI33962

Modules/Macros

•    GOCCMP   GOCGCMP
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• RB20 PSY UI33962

     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.