PI54444: 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

• 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 adifferent 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 ------
  
  Command ===>
  
  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:
                                                  More:     +
  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:

  UI34309

Modules/Macros

•    ADBCIMV  ADBM01   ADBSETUP ADB2CME  ADB2CMF
  ADB2CMO  ADB2CMP  ADB2CMR  ADB2CMS  ADB2CMT  ADB2CMU  ADB2CM1
  ADB2CM2  ADB2CM3  ADB2IGN
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI34309

     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.