PM44943: COMPARE FAILS RC08 WHEN SEGSIZE AND MEMBER CLUSTER ARE USED MSGGOC2CMP - ERROR(S) FOUND. PLEASE REVIEW OUTPUT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Object Compare Tool for z/OS will not permit SEGSIZE and
  MEMBER CLUSTER to co-exist on CREATE TABLESPACE statement in
  DB2 v9 and above, but error message:
    GOC2CMP - Error(s) found. Please review output
  does not provide adequate documentation of what the error is.
  Problem appears when reporting options specify only report on
  changed objects.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 z/OS who run Compare with 'Only changed      *
  *                 objects' set to 'YES' on panel GOC5RO        *
  *                 'Specify Compare Reporting Options'.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Object Comparison Tool for z/OS *
  *                      will not permit SEGSIZE and MEMBER      *
  *                      CLUSTER to coexist in a CREATE          *
  *                      TABLESPACE statement in DB2 9 and above *
  *                      according to the rule of DB2.  Compare  *
  *                      will fail with a RC=8 and the change    *
  *                      is ignored when such error is detected. *
  *                      The error message                       *
  *                                                              *
  *                      '(E)MEMBER CLUSTER is not               *
  *                      allowed with SEGSIZE option'            *
  *                                                              *
  *                      is displayed. However, when the         *
  *                      option 'Only changed objects' is        *
  *                      set to 'YES' on panel GOC5RO, this      *
  *                      error message is hidden since           *
  *                      unchanged objects should not be         *
  *                      reported. Compare only shows error      *
  *                      message:                                *
  *                                                              *
  *                      'GOC2CMP -                              *
  *                      Error(s) found. Please review           *
  *                      output'                                 *
  *                                                              *
  *                      which does not provide adequate         *
  *                      information.                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Object Comparison Tool for z/OS will not permit SEGSIZE
  and MEMBER CLUSTER to coexist in a CREATE TABLESPACE statement
  in DB2 9 and above according to the rule of DB2.  Compare will
  fail with a RC=8 and the change is ignored when such error is
  detected. The error message
  
  '(E)MEMBER CLUSTER is not allowed with SEGSIZE option'
  
  is displayed. However, when the option 'Only changed objects' is
  set to 'YES' on panel GOC5RO, this error message is hidden since
  unchanged objects should not be reported. Compare only shows
  error message:
  
  'GOC2CMP - Error(s) found. Please review output'
  
  which does not provide adequate information.
  

Problem conclusion

• Problem has been resolved.  When changes to an object leads to
  an error and DB2 Object Comparison Tool does not implement the
  changes, an error message will be displayed regardless of the
  setting of the 'Only changed objects' report option.
  

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:

  UK73289

Modules/Macros

•    ADB2CMF  ADB2CMR  ADB2CMS  ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK73289

     UP11/10/29 P F110

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.