PK66668: MERGE TO AVOID FR RECORDS BEING WRITTEN OUT WHEN COMPARE IS DONE AT TABLE LEVEL WITH REFERENCES CLAUSE (FK) CONTAINING NO COLUMN

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Merge to avoid FR records being written out when compare is done
  at table level with references clause (FK) containing no column
  list.
  

Local fix

• APPLY PTF.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Admin & Compare who use Compare     *
  *                 and/or Change Management.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: FR records are being written out when   *
  *                      compare  is done at table  level with   *
  *                      references clause (FK)  containing no   *
  *                      column list.                            *
  *                      This results in the following Analyze   *
  *                      or Compare failure:                     *
  *                       GOCC023E - Unknown catalog record      *
  *                                  type: FR.                   *
  *                       GOCC002E - Severe error. Compare       *
  *                                  terminates.                 *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  FR records are being written out when compare is done at table
  level with references clause (FK) containing no column list.
  This results in the following Analyze or Compare failure:
    GOCC023E - Unknown catalog record type: FR
    GOCC002E - Severe error. Compare terminates
  

Problem conclusion

• Resolved. Merge will avoid FR records being written out when
  compare is  done at table level with  references clause (FK)
  containing no column list.
  

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:

  UK43239

Modules/Macros

•    ADBCCMM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK43239

     UP09/01/24 P F901

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.