PH36794: MASKED STOGROUP ANALYZE/COMPARE PROCESSING ERROR ADB7184E ADB7955E

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An analyze/compare step fails with error messages ADB7184E and
  ADB7955E if the tablespace involved has a different storage
  group than enforced by the masking parameter for storage groups.
  

Local fix

• BYPASS/CIRCUMVENTION:
  The customer can workaround this by changing their mask to be
  more specific. Instead of using SGNAME they can use TSSGNAME
  and/or IXSGNAME and make those masks object specific.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and Db2 Object Comparison Tool for z/OS      *
  *                                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: Using a generic mask on a storage group *
  *                      (stogroup) might result in a duplicate  *
  *                      masking error during a compare.         *
  ****************************************************************
  A compare that involves two objects with different stogroups and
  a stogroup mask that uses a wildcard character might result in
  the following errors:
  
  ADB7184E A duplicate record was detected for object >stogroup<.
           The error is probably caused by masking
           storage group from . to >stogroup<. Run will terminate.
  
  ADB7955E ADBC024E - Unexpected catalog row on source file.
  Expected:RA found:SG
  
  ADB7955E Rowtypes from source file :
  ADB7955E SG SG VO VO VO
  
  ADB7955E Rowtypes from target file :
  ADB7955E SG VO
  ADB7380E Module ADB2CMP - Severe error Compare has been
           stopped.
  
  Keywords: msgadb7184e; msgadb7955e
  

Problem conclusion

• The problem has been resolved.
  

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:

  UI78186

Modules/Macros

• ADBCVOC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI78186

     UP21/11/23 P F111

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.