IBM Support

PH63909: TABLE DDL PREVIOUSLY RESTRICTED CHANGES TO THE DB OR TS NAME, PREVENTING USERS FROM MOVING TABLES TO A NEW DB OR TS.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Enhanced restrictions on renaming tables, disallowing
    modifications to the table name, schema name, database, and
    tablespace. We have now updated the logic to permit
    modifications to the Database or Tablespace name when the
    Instance and Application Subsystem differ. The specified
    Database or Tablespace must exist in the Instance and the Source
    and Target Subsystems
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of the Db2 DevOps Experience for z/OS  *
    ****************************************************************
    * PROBLEM DESCRIPTION: Unable to move tables to new database   *
    ****************************************************************
    UMS has been updated to permit modifications to the Database or
    Tablespace name when the Instance and Application Subsystem
    differ. The specified Database or Tablespace must exist in the
    Instance and the Source and Target Subsystems.
    

Problem conclusion

  • Apply the PTF provided by this APAR
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH63909

  • Reported component name

    UNIFIED MGMT SV

  • Reported component ID

    5698UM100

  • Reported release

    120

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2024-10-28

  • Closed date

    2024-11-12

  • Last modified date

    2024-12-03

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

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

Modules/Macros

  • IZP2IFIP IZPD2A   IZPD2R   IZPD2T   IZPD2VA  IZPD2VR  IZPD2VT
    IZPD3T   IZPD3VT  IZPDAJP  IZPDATPP IZPDISCP IZPHLVP  IZPJOBSP
    IZPMNFST IZPSERVE IZPUI    IZPUSCP
    

Fix information

  • Fixed component name

    UNIFIED MGMT SV

  • Fixed component ID

    5698UM100

Applicable component levels

  • R120 PSY UI99021

       UP24/11/20 P F411

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":"BU011","label":"Systems - zSystems software"},"Product":{"code":"SG19M"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"120"}]

Document Information

Modified date:
03 December 2024