PH70819: OBJECT COMPARE PROCESS HANGS WHEN RENAMING TABLES THAT HAVE CONSTRAINTS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When analyzing a change in Change Management that has rename
  masks, the job can enter an unresponsive state and never
  complete if the renamed tables contained primary keys, unique
  constraints, or foreign keys.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and Db2 Object Comparison Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: An analyze job in Change Management     *
  *                      hangs when processing tables with       *
  *                      name masks if those tables have         *
  *                      primary keys, unique constraints, or    *
  *                      foreign keys.                           *
  ****************************************************************
  When analyzing a change in Change Management where
  name masks are defined for tables that contain primary keys,
  unique constraints, or foreign keys, the compare job might
  become unresponsive and fail to complete. This situation
  requires the job to be manually cancelled.
  

Problem conclusion

• The problem has been fixed.
  

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:

  UO08503

Modules/Macros

• ADB2CM3  ADB2CMU
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UO08503

     UP26/07/08 I 1000

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.