IBM Support

PH54480: SUPPORT DDL VS DDL COMPARE IN CMBATCH

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • Support DDL vs DDL compare in CMBatch
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
    *                 or Db2 Object Comparison Tool for z/OS       *
    ****************************************************************
    * PROBLEM DESCRIPTION: This APAR introduces an enhancement so  *
    *                      that users can use Change Management    *
    *                      (CM) batch to compare DDL to DDL. The   *
    *                      results of this comparison are shown in *
    *                      the REPORT data set.                    *
    ****************************************************************
    Users can use CM batch to compare DDL to DDL by using a new
    value for the existing CM batch parameter TARGET_TYPE. The new
    value is DDL:
    
    TARGET_TYPE
    
    Values:
    
    DDL
    
    The target is DDL. You can use the compare target input file
    (TGTIN DD) or the TARGET_DSN parameter to specify a data
    set that contains the DDL. If the TARGET_DSN parameter is
    not specified, the compare target input file (TGTIN DD) must
    be pre-allocated.
    
    Attention: If the target DDL that is specified does not match
    the DDL in the Db2 database, problems might occur when
    running the resultant change. Therefore, consider using
    this option only when comparing DDL to DDL
    (TARGET_TYPE='DDL' and SOURCE_TYPE='DDL').
    
    If the user specifies TARGET_TYPE = 'DDL' and SOURCE_TYPE
    as something other than 'DDL', the existing error message
    ADB9723E is issued, as the two parameter values are mutually
    exclusive.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH54480

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    C10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / New Function / Xsystem

  • Submitted date

    2023-05-11

  • Closed date

    2023-05-15

  • Last modified date

    2023-06-01

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

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

    UI91802 UI91803

Modules/Macros

  • ADB2000  ADBCCM
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RC10 PSY UI91802

       UP23/05/19 P F305  

  • RD10 PSY UI91803

       UP23/05/17 P F305  

[{"Business Unit":{"code":"BU011","label":"Systems - zSystems software"},"Product":{"code":"SG19O","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"12.1.0"}]

Document Information

Modified date:
01 June 2023