PI16521: DB2 OBJECT COMPARISON TOOL FOR Z/OS ENDS WITH MESSAGE MSGADBC007E - INVALID FIELD NAME IN IGNORES FILE RECORD

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Object Comparison Tool for z/OS ends with message
  msgADBC007E - Invalid field name in IGNORES file record
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 z/OS who specify ignore fields settings      *
  *                 for SYSSEQUENCES.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: When specifying the Ignore fields       *
  *                      settings in DB2 11, SEQSCHEMA and       *
  *                      SEQNAME are available to be selected    *
  *                      for object SYSSEQUENCES on panel        *
  *                      GOCCIF 'Select Ignore Fields for        *
  *                      SYSSEQUENCES'.  When selecting these    *
  *                      two fields then running Compare,        *
  *                      Object Compare fails with error         *
  *                      message ADBC007E / msgadbc007e:         *
  *                                                              *
  *                      ADBC007E - Invalid field name in        *
  *                      IGNORES file record.                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In DB2 11, when specifying the Ignore fields settings,
  SEQSCHEMA and SEQNAME are available to be selected for
  object SYSSEQUENCES on panel GOCCIF 'Select Ignore Fields
  for SYSSEQUENCES'.  When selecting these two fields then
  running Compare, Object Compare fails with error message
  ADBC007E / msgadbc007e:
  
  ADBC007E - Invalid field name in IGNORES file record.
  

Problem conclusion

• Problem has been resolved. Fields SEQSCHEMA and SEQNAME have
  been removed from panel GOCCIF since currently Aliases on
  Sequence are not compared in Object Compare.
  
  The DB2 Administration Tool for z/OS, Version 11, Release 1
  User's Guide and Reference has been updated with the following
  message information:
  
  ADBC007E Invalid field name in the IGNORES file record.
  
  Explanation
  
  The IGNORES file contains invalid ignore field specifications
  which can not be processed.
  
  System action
  
  Processing stops.
  
  User response
  
  Review the ignore field specifications in the IGNORES file
  and make sure all the fields specified are listed as supported
  catalog table ignore fields (See the DB2 Administration Tool
  for z/OS User's Guide), or redefine the ignores by specifying
  the ignore fields on the Specify Ignore Fields panel.
  

Temporary fix

Comments

APAR Information

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

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

  UI18955

Modules/Macros

•    GOCCIF
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• RB10 PSY UI18955

     UP14/06/20 P F406

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.