PH56578: SQLCODE=-205 ERROR WHEN QUOTED COLUMN NAMES AND CHECK CONSTRAINT INCLUDED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SQLCODE=-205 error when quoted column names and CHECK
  constraint included
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and Db2 Object Comparison Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Object Compare incorrectly capitalizes  *
  *                      and omits quotation marks around        *
  *                      mixed-case column names in the CHECK    *
  *                      condition for a table or for ALTER      *
  *                      TABLE ADD VERSIONING.                   *
  ****************************************************************
  An SQLCODE = -205 is returned as the produced column name
  for the CHECK condition is no longer valid. An SQLCODE = -204
  is returned as the produced table name for ALTER TABLE ADD
  VERSIONING is no longer valid.
  

Problem conclusion

• The problem has been resolved. The scope of the fix is for
  tables that are on the source but not on the target.
  

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:

  UI94960 UI94961

Modules/Macros

• ADB2CMR  ADB2MSK  ADBCDTS
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI94960

     UP23/12/19 P F312

• RD10 PSY UI94961

     UP23/12/19 P F312

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.