PM89658: DB2 ADMINISTRATION TOOL FOR Z/OS DOES NOT PROCESS CHANGE WITH FOREIGN KEY CORRECTLY AFTER USING (DELTA) CHANGE IN COMPARE JOB

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS does not process change with
  foreign key correctly after using (Delta) Change in COMPARE job
  

Local fix

Problem summary

•   USERS AFFECTED: Users of the DB2 Administration Tool for
                    z/OS who use the Change Management function
                    to analyze a change.
  
    PROBLEM DESCRIPTION: When analyzing a change in which there
                         is a column that will be dropped, the
                         column is defined as the primary key,
                         and the primary key is the parent of
                         a referential constraint, the Analyze
                         job failed with Return Code 12 /
                         RC = 12 and an error message
                         ADBC002E / msgadbc002e is issued in
                         the job log:
  
                         ADBCCME - Error(s  found.
                                   Please review output
                         Added foreign key fk_name
                         for table tb_name already exists
                         ADBC002E - Severe error.
                                    Merge terminates
  
    RECOMMENDATION:
  
  When dropping a column which is defined as the primary key,
  the primary key is the parent of a foreign key, the primary
  key needs to be dropped and recreated, then the foreign key
  will be dropped by dropping the primary key.
  

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:

  UK95185 UK95186

Modules/Macros

• ADBCCMM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK95185

     UP13/06/19 P F306

• RA20 PSY UK95186

     UP13/06/19 P F306

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.