PH40662: GEN/DDL NOT FORMATTING LARGE CHECK CONSTRAINTS CORRECTLY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Depending on the format specified, Db2 terminates each line of
  an SQL statement with a line feed character (x'25').  In the
  context of table constraints, GEN or DDL does not process this
  character to break up lines, causing large check constraints to
  print in one continuous line.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS Reverse Engineering (GEN) function      *
  ****************************************************************
  * PROBLEM DESCRIPTION: GEN does not process character x'25'    *
  *                      in SYSIBM.SYSCHECKS, resulting in       *
  *                      poorly formatted table constraint DDL.  *
  ****************************************************************
  When a table is created with format SQLPL, Db2 terminates each
  line of an SQL statement with line feed character x'25'.
  
  When generating constraints, GEN does not process this
  character, resulting in poorly formatted table constraint DDL.
  
  Example:
  
  Partial statement sent to Db2:
  CONSTRAINT NOLC
          CHECK (
  TABLE_COLUMN_TEST NOT LIKE '%r%' AND
  TABLE_COLUMN_TEST NOT LIKE '%s%' AND
  TABLE_COLUMN_TEST NOT LIKE '%t% ' AND
  TABLE_COLUMN_TEST NOT LIKE '%u%' AND
  TABLE_COLUMN_TEST NOT LIKE '%v%' AND
  TABLE_COLUMN_TEST NOT LIKE '%w%' AND
  TABLE_COLUMN_TEST NOT LIKE '%x%' AND
  TABLE_COLUMN_TEST NOT LIKE '%y%' AND
  TABLE_COLUMN_TEST NOT LIKE '%z%' )
  
  Generated DDL:      CONSTRAINT NOLC
          CHECK (TABLE_COLUMN_TEST NOT LIKE '%r%' AND
  TABLE_COLUMN_TEST
  NOT LIKE '%s%' AND TABLE_COLUMN_TEST NOT LIKE '%t% ' AND
  TABLE_COLUMN_TEST
  NOT LIKE '%u%' AND TABLE_COLUMN_TEST NOT LIKE '%v%' AND
  TABLE_COLUMN_TE
  ST NOT LIKE '%w%' AND TABLE_COLUMN_TEST NOT LIKE '%x%' AND
  TABLE_COLUMN_
  TEST NOT LIKE '%y%' AND TABLE_COLUMN_TEST NOT LIKE '%z%' )
  

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:

  UI77493

Modules/Macros

• ADB2REG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI77493

     UP21/10/12 P F110

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.