PI94840: CM BATCH JOB RENAME TABLE AND CREATE ALIAS WITH ORIGINAL TABLE NAME ERROR MESSAGE ADB7184E DUPLICATE RECORD DETECTED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A CM Batch job which renames a table and then creates an alias
  using the original name of the table may result in error
  message ADB7184E / msgadb7184e:
  ADB7184E A duplicate record was detected for object
  schema.tablename. The error is probably caused by
  masking table from schema.tablename to schema.tablename. Run
  will terminate.
  The message can appear even though object has not been masked.
  

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 rename          *
  *                 tables.                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Analyzing a change which renames        *
  *                      a table and creates a new alias with    *
  *                      the old table name may fail with error  *
  *                      ADB7184E / msgadb7184e.                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Analyzing a change which renames a table and creates
  a new alias with the old table name may fail with the following
  error message:
  
  ADB7184E A duplicate record was detected for object
  obj_name. The error is probably caused by masking table
  from obj_name to obj_name. Run will terminate.
  

Problem conclusion

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

Modules/Macros

•    ADBCDTS  ADB2CMR  ADB7000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI56654

     UP18/06/22 P F806

• RC10 PSY UI56655

     UP18/06/22 P F806

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.