PI54445: OBJECT COMPARE - ADD CAPABILITY TO IGNORE LIMITKEY CHANGES AT AN OBJECT NAME LEVEL.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• OBJECT COMPARE - Add capability to ignore limitkey changes at an
  object name level.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS and DB2 Object Comparison Tool for      *
  *                 z/OS who need to ignore fields for a         *
  *                 subset of objects during a compare.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: Users want the ability to ignore        *
  *                      fields for a subset of objects during   *
  *                      a Compare. They need to be able to      *
  *                      add specific object names to field      *
  *                      names or GENERIC groups using           *
  *                      the same tools that are currently       *
  *                      available.                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Users currently do not have the ability to ignore fields by
  specifying a field name or by specifying the GENERIC name of
  a group of fields that are related using ignore panels GOCCI
  'Specify Ignore Fields: Objects' and GOCCIF 'Select Ignore
  Fields for..'.
  

Problem conclusion

Temporary fix

Comments

• The following enhancements are delivered:
  
  1 - The 'Qualifier' and 'Name' fields have been added to ignore
  panels GOCCI 'Specify Ignore Fields: Objects' and GOCCIF
  'Select Ignore Fields for..'. so that the qualifier/schema and
  name of an object can be associated to a field name or the
  GENERIC name of a group of fields.  If the object name is
  added to an ignore file, the object name can be appended
  to the field or GENERIC record by adding '(qualifier.name)'.
  
  For example:
  
  SYSTABLEPART:LIMITKEY(QUALIFIER.NAME) or
  PARTITIONING(QUALIFIER.NAME).
  
  2 - A new line command is added to panel GOCCIF.  It is
  'R -- Repeat Row'.  When 'R' is set in the select column,
  the row is repeated.  Any part of the new line can be
  altered including a new object name to have the field
  ignored by a different object:
  
  GOCCIF --------- Select Ignore Fields for  -------------------
  
  Valid line commands are:
  S - Select (add) field  U - Un-select  R - Repeat row
  
  3 - Help panel GOCCIF 'HELP: Specify Ignore Fields for object'
  has been modified to add the new 'Qualifier' and 'Name' fields,
  as well as the 'R - Repeat Row' line command:
  
  GOCCIFH ----- HELP: Specify Ignore Fields for object ------
  
  Panel explanation:
  
  This panel shows you ignores fields that currently are
  specified for the object
  
  The columns are:
  
  Fields        Name of the DB2 catalog table field that should
                be ignored during Compare.
  
  Action        The action you performed on this line
  
  Qualifier     The qualifier of the specific object(s) to be
                ignored.
  
  Name          The object name of the specific object(s) to be
                ignored.
  
  
  Use the S (add) line command to add this field to the list of
  ignore fields and the U (un-select) to remove it from the list.
  Use the R (repeat) line command to repeat the row specified.
  
  4 - Help panel GOCCIH 'HELP: Specify Ignore Fields: Objects'
  have been modified to add the new 'Qualifier' and 'Name'
  fields:
  
  GOCCIH ------- HELP: Specify Ignore Fields: Objects ------------
  Command ===>
  
  Panel explanation:
  
  This panel displays the ignores fields that are currently
  specified for the selected ignore. Use the U line command to
  change the fields that are specified.
  
  The panel columns are:
   Select         Input field where you can enter the listed
                  line command
   Object         Name of the DB2 catalog table that describes
                  (part of) the object
   Ignore fields  The fields to ignore for this DB2 table
   Qualifier      The qualifier of the specific object(s) to be
                  ignored
   Name           The object name of the specific object(s) to
                  be ignored
  

APAR Information

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

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

  UI34310

Modules/Macros

•    GOCCI    GOCCIF   GOCCIFH  GOCCIH   GOCCIS
  GOC4
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• RB20 PSY UI34310

     UP16/01/08 P F601

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.