IBM Support

PH49137: DB2SCHEMA-UPDATE COMMAND FAILS WITH MESSAGE CKZ28128E

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The subsystem cloning DB2SCHEMA-UPDATE command might fail with
    message CKZ28128E when a target schema matches a user ID or role
    that issued GRANT statements for packages or plans, or was a
    grantee in those statements.
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Cloning Tool for z/OS           *
    ****************************************************************
    * PROBLEM DESCRIPTION: The subsystem cloning DB2SCHEMA-UPDATE  *
    *                      command might fail with message         *
    *                      CKZ28128E when a target schema          *
    *                      matches a user ID or role that issued   *
    *                      GRANT statements for packages or plans, *
    *                      or that was a grantee in those          *
    *                      statements                              *
    ****************************************************************
    * RECOMMENDATION: Apply the PTF                                *
    ****************************************************************
    The subsystem cloning DB2SCHEMA-UPDATE command might fail with
    message CKZ28128E when a target schema matches a user ID
    or role that issued GRANT statements for packages or plans, or
    that was a grantee in those statements
    

Problem conclusion

  • Apply the PTF
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH49137

  • Reported component name

    DB2 CLONING TOO

  • Reported component ID

    5655N1000

  • Reported release

    320

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2022-08-30

  • Closed date

    2022-10-07

  • 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:

    UI82757

Modules/Macros

  • CKZ00281 CKZ00600 CKZ00709 CKZ00710 CKZ00992
    

Fix information

  • Fixed component name

    DB2 CLONING TOO

  • Fixed component ID

    5655N1000

Applicable component levels

  • R320 PSY UI82757

       UP22/10/11 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":"3.2.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
01 November 2022