PI97637: DB2 ADMIN TOOL - CHANGE MANAGEMENT ANALYZE JOB FAILS WITH ERROR ADB7380E OR ADB7184E

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Change Management ANALYZE job fails with the below errors:
  ADB7380E Module ADB2CMP - Severe error Compare has been stopped
  
  (or)
  
  ADB7184E A duplicate record was detected for object <objctname1>
           The error is probably caused by masking table from
           <objctname2> to <objctname3>. Run will terminate.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for         *
  *                 z/OS CM Batch facility and DB2 Object        *
  *                 Comparison Tool for z/OS who include         *
  *                 view aliases in compare process.             *
  ****************************************************************
  * PROBLEM DESCRIPTION: CM Batch ANALYZE JOB fails with error   *
  *                      message ADB7380E or, if masking is      *
  *                      involved, with error ADB7184E.          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When database containing views and view aliases is explicitly
  dropped, CM Batch ANALYZE Job fails with error message:
  
  ADB7380E Module ADB2CMP - Severe error Compare has been stopped.
  
  If masking is included in the run ANALYZE Job fails with error
  message:  ADB7184E A duplicate record was detected for object
  view_schema.view_name. The error is probably caused by masking
  table from table_schema.table_name to table_schema.table_name.
  Run will terminate.
  

Problem conclusion

• The issue has been resolved. Aliases on views will be left on
  target unchanged (DB2 behavior).
  

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:

  UI57124 UI57125

Modules/Macros

•    ADBCCMM  ADB2CMF  ADB2CMO  ADB2CMR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI57124

     UP18/07/13 P F807

• RC10 PSY UI57125

     UP18/07/13 P F807

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.