IBM Support

PH48246: ABSTRACT: OBJECT COMPARE - ACCELERATED TABLES REPLICATION AND ACCELERATION STATUS ARE OVERRIDDEN INSTEAD OF RESTORED

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • ABSTRACT:  Object Compare - Accelerated tables replication and
    acceleration status are overridden instead of restored
    
    
    
    
    DESCRIPTION:  An alter to an accelerated table does not maintain
    the original replication and acceleration status when it is
    added back to the accelerator. The common options 'restore
    replication of tables' and restore acceleration of tables' do
    not maintain the original acceleration and replication status
    when set to YES. Instead they will override those statuses to
    true no matter what. To check the replication and acceleration
    status of the accelerated table use the KEYS line command from
    panel ADBPZAT.
    

Local fix

  • na
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Administration Tool for         *
    *                 z/OS who also use IDAA                       *
    ****************************************************************
    * PROBLEM DESCRIPTION: Altering an accelerated table does not  *
    *                      maintain the original replication and   *
    *                      acceleration status when it is added    *
    *                      back to the accelerator.                *
    ****************************************************************
    The common options 'restore replication of tables' and 'restore
    acceleration of tables' do not maintain the original
    acceleration and replication status when set to YES. When an
    accelerated table is altered, it has to be disabled and deleted
    from the accelerator prior to the alter operation. After the
    table is altered, its replication status was not enabled, and
    acceleration was enabled unconditionally.
    

Problem conclusion

  • The problem has been resolved.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH48246

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2022-07-26

  • Closed date

    2022-10-21

  • Last modified date

    2022-11-01

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

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

    UI82973 UI82974

Modules/Macros

  • ADBDAT   ADBTEP2
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RC10 PSY UI82973

       UP22/10/26 P F210

  • RD10 PSY UI82974

       UP22/10/26 P F210

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.

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.1.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
01 November 2022