IBM Support

PH65260: DB2SCHEMA-UPDATE COMMAND IGNORES OBJECTS WITH OWNER THAT MATCHESA SOURCE MASK

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 does not generate
    DROP and CREATE statements for objects with an owner that
    matches one of the source masks and a schema that does not match
    any source mask.
    

Local fix

  • Manually drop and re-create the affected objects.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Cloning Tool for z/OS           *
    ****************************************************************
    * PROBLEM DESCRIPTION: The subsystem cloning DB2SCHEMA-UPDATE  *
    *                      command does not generate DROP and      *
    *                      CREATE statements for objects with an   *
    *                      owner that matches one of the source    *
    *                      masks and a schema that does not match  *
    *                      any source mask.                        *
    ****************************************************************
    * RECOMMENDATION: Apply the PTF                                *
    ****************************************************************
    The subsystem cloning DB2SCHEMA-UPDATE command does not generate
    DROP and CREATE statements for objects with an owner that
    matches one of the source masks and a schema that does not match
    any source mask.
    

Problem conclusion

  • Apply the PTF
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH65260

  • 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

    2025-02-13

  • Closed date

    2025-03-04

  • Last modified date

    2025-04-02

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

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

    UO02320

Modules/Macros

  • CKZ00249 CKZ00992 CKZ00993 CKZCAL9C CKZCALNC CKZCAQ1C CKZCAQNC
    CKZCAT01 CKZCATM  CKZCATMO CKZCCT9C CKZCCTNC CKZCDB9C CKZCDPNC
    CKZCDT0C CKZCDT1C CKZCDT9C CKZCDTNC CKZCFN0C CKZCFN9C CKZCFNNC
    CKZCHECK CKZCIX0C CKZCIX2C CKZCIX9C CKZCIXNC CKZCMT0C CKZCMTNC
    CKZCPK0C CKZCPK1C CKZCPK9C CKZCPKNC CKZCPL0C CKZCPL1C CKZCPL9C
    CKZCPLNC CKZCRL2C CKZCRL9C CKZCRO9C CKZCRTNC CKZCSG9C CKZCSN9C
    CKZCSNNC CKZCSP9C CKZCSPNC CKZCSQ1C CKZCSQ9C CKZCSQNC CKZCTB0C
    CKZCTB1C CKZCTB2C CKZCTB9C CKZCTBNC CKZCTC0C CKZCTR0C CKZCTR2C
    CKZCTR9C CKZCTRNC CKZCTS0C CKZCTS2C CKZCTS9C CKZCTSNC CKZCVA1C
    CKZCVANC CKZCVT0C CKZCVT9C CKZCVTNC CKZCXANC CKZCXT9C CKZDOCID
    CKZF2STR CKZFATTR CKZFBASE CKZFCD02 CKZFCEXP CKZFCFTC CKZFGNAL
    CKZFGNAQ CKZFGNCL CKZFGNCT CKZFGNDB CKZFGNDT CKZFGNIX CKZFGNPK
    CKZFGNPL CKZFGNRL CKZFGNRO CKZFGNRT CKZFGNSG CKZFGNSN CKZFGNSQ
    CKZFGNTB CKZFGNTC CKZFGNTR CKZFGNTS CKZFGNVA CKZFGNVT CKZFGNXT
    CKZFNORM CKZFOBJT CKZFOBJZ CKZFPDBG CKZFRTSM CKZFRTST CKZINCID
    

Fix information

  • Fixed component name

    DB2 CLONING TOO

  • Fixed component ID

    5655N1000

Applicable component levels

  • R320 PSY UO02320

       UP25/03/06 P F503

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:
02 April 2025