PH65331: SUPPORT IDAA7.5 FEATURE OF SKIPPING REMOVE TABLE FOR DROPPED DB2 TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Internal APAR for Support IDAA7.5 feature of skipping REMOVE
  table for dropped Db2 table
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 who use IBM Db2 Analytics Accelerator (IDAA) *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR provides support for the IDAA *
  *                      7.5 feature of skipping REMOVE table    *
  *                      for dropped Db2 tables.                 *
  ****************************************************************
  In IDAA 7.5, when an accelerator shadow table that meets both of
  the following criteria is dropped from Db2, that table is
  automatically dropped from the accelerator:
  - The table is part of an Integrated-Synchronization-enabled
  replication accelerator and enabled for replication.
  - The table is loaded (load status is "ReplicationInProgress")
  The user does not have to explicitly delete the table (using
  the SYSPROC.ACCEL_REMOVE_TABLE stored procedure).
  For dropped tables satisfying this criteria for automatic delete
  eligibility, Db2 Admin Tool skips the process of explicitly
  deleting the table from the accelerator and displays the
  following new message:
  ADB5283I The table to be dropped is associated with IBM
  Integrated Synchronization replication that supports automatic
  removal of the table from the accelerator. The REMOVE operation
  will be skipped for table <tbname> on accelerator <accel name>.
  

Problem conclusion

• The enhancement have been delivered.
  

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:

  UO02250

Modules/Macros

• ADB2CMP  ADB5000  ADBASP   ADBDAT   ADBDCAC  ADBTEP2  ADBXCAC
  ADBXGTI
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UO02250

     UP25/02/27 P F502

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.