IBM Support

PH66799: INCORRECT DROP RESTRICT ON DROP IS GENERATED IN MIG

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When MIG is run with the option 'DROP on target before CREATE'
    and masking is used, the generated ALTER TABLE DROP RESTRICT ON
    DROP statement is generated with the wrong table name.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
    *                                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION: The MIG function generates an incorrect *
    *                      ALTER TABLE DROP RESTRICT ON DROP       *
    *                      statement when masking is used.         *
    ****************************************************************
    When MIG is run with the option 'DROP on target before CREATE'
    and masking is used, the generated ALTER TABLE DROP RESTRICT ON
    DROP statement has the wrong table name.
    

Problem conclusion

  • The problem has been resolved.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH66799

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    D10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2025-05-30

  • Closed date

    2025-08-13

  • Last modified date

    2025-08-31

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

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

    UO04460

Modules/Macros

  •    ADB28M
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RD10 PSY UO04460

       UP25/08/31 P F508

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":"D10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
31 August 2025