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

Obtain the fix for this APAR.

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 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.