IBM Support

PM49908: NFDB210 DB2 OBJECT COMPARISON TOOL FOR Z/OS VERSION 10 ENHANCEMENTS.

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as new function.

Error description

  • NFDB210 DB2 OBJECT COMPARISON TOOL FOR Z/OS VERSION 10
    ENHANCEMENTS.
    

Local fix

  • APPLY PTF.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
    *                 z/OS.                                        *
    ****************************************************************
    * PROBLEM DESCRIPTION: The following enhancements are          *
    *                      delivered:                              *
    *                                                              *
    *                      - FLASHCOPY is now an available option  *
    *                      on the LOAD utility                     *
    *                      - Control of ENFORCE on LOAD            *
    *                      - A batch interface to change           *
    *                      management (CM batch)                   *
    *                      - A new option 'Mask ignored fields'    *
    *                      has been introduced on panel GOC5       *
    *                      'Generate Compare Jobs' to give the     *
    *                      user the option to choose if original   *
    *                      or mask values will be applied to       *
    *                      ignored fields from new objects.        *
    *                      - A new option has been introduced      *
    *                      to panel GOC5 called SEQUENCE           *
    *                      RESTART VALUE                           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The following enhancements are provided with this APAR:
    
    - FLASHCOPY is now an available option on the LOAD utility
      where LOAD utility options are used. FLASHCOPY will force
      the use of templates and will use templates specified in the
      following order:
    
      1- User-defined templates
      2- FLASHCOPY template contained in ADB2UCUS
      3- ZPARM FLASHCOPY template if present
      4- Default template name
    
    - Control of ENFORCE on LOAD is now available. If utility
      options are specified, ENFORCE can now be set to YES
      which will enforce constraints on LOAD. Keep in mind that
      sequence of LOADs becomes important and you may discard
      rows if tables are loaded out of sequence. If utility options
      are NOT specified or if they are specified but ENFORCE is not
      entered, ENFORCE NO will be the default used everywhere
      but in a stand-alone LOAD such as the 'UT-Utility selections'
      option.
    
    - A batch interface to Change Management (CM batch) has been
      added.  This allows a change to be imported, analyzed, run,
      and recovered without using the CM panels.
    
      In Chapter 20 'Managing changes to DB2 objects' of the DB2
      Administration Tool for z/OS User's Guide, a new section
      titled 'Making changes using Change Management batch
      interface' has been added to describe this new CM batch
      interface.
    
      In Chapter 2 'Activating DB2 Admin' of the DB2 Administration
      Tool for z/OS User's Guide, the 'Step 3. Set up to use Change
      Management' section has been updated to describe the set up
      for CM batch.
    
    - A new option called 'Mask ignored field' has been introduced
      on panel GOC5 to give the user the option to choose if the
      original or mask values will be applied to ignored fields
      from new objects.  The default value will be the original
      value (current behavior).  The new option is not applicable
      to ignore files provided in the Change Management Register
      options panel ADB2CRO 'Register Options'.  Some object
      attributes, like SYSPACKAGE.COLLID, are set by DB2.
      The new option does not impact the value for this
      attribute since DB2, not DB2 Object Compare,
      controls the value
    
    - For the recovery of a sequence restart value, a new
      option has been introduced to panel GOC5 called
      SEQUENCE RESTART VALUE which will allow the user two
      choices:
    
      'O' for Original and 'C' for Computed.
      Original will recover the RESTART value for a
      sequence back to its original value, and Computed
      will use the DB2 catalog values to set RESTART to
      the next sequence value not cached.  A new column
      in the ADBCHG table called SEQSVLR will be used to
      hold this option's value.
    

Problem conclusion

Temporary fix

  • *********
    * HIPER *
    *********
    

Comments

  • Enhancements are delivered.
    

APAR Information

  • APAR number

    PM49908

  • Reported component name

    DB2 OBJECT COMP

  • Reported component ID

    5697G6400

  • Reported release

    A10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-10-12

  • Closed date

    2012-03-10

  • Last modified date

    2012-04-03

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

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

    UK76861

Modules/Macros

  •    GOCCCM   GOCCI    GOCCIF   GOCCM    GOCCMP
    GOCCM2   GOCGCMP  GOC2CMP  GOC5     GOC5H    H25GA10J
    

Fix information

  • Fixed component name

    DB2 OBJECT COMP

  • Fixed component ID

    5697G6400

Applicable component levels

  • RA10 PSY UK76861

       UP12/03/15 P F203

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.



Document information

More support for: DB2 Tools for z/OS
DB2 Object Comparison Tool

Software version: 10.1.0

Reference #: PM49908

Modified date: 03 April 2012


Translate this page: