PM22057: *.DDL.CREATE MISSING ) ON ALTER TABLE XXX.XXXXX ADD CONSTRAINT FFA10 PM27695.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Object Comparison Tool for z/OS, comparison of
  constraint can result in missing ) <right parenthesis> in
  file *.DDL.CREATE.
  .
  When APPLY job is performed, rc=8 on step CREATE.
  Message:
  ADB5044I *** INPUT STATEMENT:
     ALTER TABLE xxx.xxxxxxxx
       ADD CONSTRAINT xxxxxxxxxxxxxxxxx
  CHECK (xxx (xxxx ) <missing right parenthesis>;
  DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL
  "<END-OF-STATEMENT>". SOME
           SYMBOLS THAT MIGHT BE LEGAL ARE: OR ) AND
  .
  Additional Symptoms: rc8 sqlcoden104
  

Local fix

• Append missing ) <right parenthesis> on file *.DDL.CREATE
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison           *
  *                 Tool for z/OS who change the check           *
  *                 constraints on tables.                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Object Comparison               *
  *                      Tool for z/OS creates an ALTER          *
  *                      TABLE ADD CONSTRAINT CHECK              *
  *                      (constraint) syntax with a missing      *
  *                      closing right parenthesis.              *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The DB2 Object Comparison Tool for z/OS adds the
  closing right parenthesis without checking the remaining
  space at the end of the constraint body. If the constraint
  body fills the complete record, the closing parenthesis
  is lost.
  

Problem conclusion

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

Modules/Macros

•    GOC2CMT
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R720 PSY UK62281

     UP10/11/23 P F011

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.