PH13501: DB2 ADMINISTRATION TOOL - CMBATCH IMPORT IGNORES ALTER TABLE ADDCONSTRAINT FOREIGN KEY STATEMENTS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• CMBATCH Import ignores ALTER TABLE ADD CONSTRAINT FOREIGN KEY
  statements.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 Z/OS who explicitly drop objects.            *
  ****************************************************************
  * PROBLEM DESCRIPTION: Compare may not include the foreign key *
  *                      constraints in the WSL when adding a    *
  *                      table that was implicitly dropped from  *
  *                      an explicit drop of its tablespace.     *
  ****************************************************************
  Compare does not recognize the table being added is the same
  table as the one that was dropped from explicitly dropping its
  tablespace. As a result the referential constraints on that
  table are not included in the resulting WSL. In this case it is
  the foreign keys on the table that are not being generated.
  

Problem conclusion

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

  UI64888

Modules/Macros

• ADB2CMF  ADB2CMR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI64888

     UP19/08/23 P F908

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.