PH20512: ACCELERATED TABLE NOT GETTING ENABLED FOR REPLICATION AFTER RECREATE 20/01/07 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When a table that is enabled for replication, is dropped and
  recreated by the Admin Tool, the Enable replication fails
  with the following messages.
  
  
  ADB5031W No tables matching 'creator.tablename' were found on
  the accelerator 'accel_name' that are eligible for
  replication operation.
  
  ADB5270I Accelerated tables have been successfully enabled for
  replication.
  
  IBM Data Studio shows table is Disabled for Replication
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool who     *
  *                 also use IDAA                                *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1) When a table is re-created on an     *
  *                      accelerator, replication and            *
  *                      acceleration status are not correctly   *
  *                      preserved.                              *
  *                                                              *
  *                      2) With PROMPT ON, a prompt is          *
  *                      displayed to drop table                 *
  *                      SESSION.ADBPZAK when exiting panel      *
  *                      ADBPZAK0.                               *
  ****************************************************************
  1) When a table is re-created on the accelerator, replication
  status was not enabled, and acceleration was enabled
  unconditionally.
  
  2) When Admin Tool prompt options are turned on (either by using
  the PROPMT ON command or setting the options on panel ADBHPRMT),
  you are prompted to drop table SESSION.ADBPZAK when exiting
  panel ADBPZAK0.
  

Problem conclusion

• The issues are 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:

  UI68435

Modules/Macros

• ADBASP   ADBDAT   ADBEAA   ADBEZED  ADBHPCO  ADBP1AR0 ADBPZADS
  ADBPZAK0 ADBPZAT  ADBPZRE0 ADBTEP2
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI68435

     UP20/03/21 P F003 {

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.