PM15669: MESSAGE NULLS/DEFAULT CHANGED FROM IDENTITY GENERATED BY DEFAULT TO IDENTITY GENERATED ALWAYS YET DDL HAS GENERATED BY DEFAULT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Object Comparison Tool for z/OS issues a message:
  Column aaaaaaaaaaaaaa
      (D)Nulls/default changed from IDENTITY GENERATED BY DEFAULT
                                 to IDENTITY GENERATED ALWAYS
    Tables have identical column lists
    Table aaaaaaa.aaaaaaa will be dropped
  yet the CREATE DDL generated has GENERATED BY DEFAULT again.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users Of DB2 Object Comparison               *
  *                 Tool for z/OS who alter the                  *
  *                 GENERATED clause on an identity              *
  *                 column.                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 Object Comparison Tool              *
  *                      reported a change to an identity        *
  *                      column from GENERATED BY                *
  *                      DEFAULT to GENERATED                    *
  *                      ALWAYS, but generated the               *
  *                      column with the GENERATED BY            *
  *                      DEFAULT clause.                         *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  DB2 Object Comparison Tool reported a change to
  an identity column from GENERATED BY
  DEFAULT to GENERATED ALWAYS, but
  generated the column with the GENERATED BY
  DEFAULT clause.
  

Problem conclusion

• DB2 Object Comparison Tool has been updated to
  recreate the identity column with the GENERATED
  ALWAYS clause and generate the IDENTITYOVERRIDE
  option in the LOAD utility to allow unloaded data to
  be reloaded correctly.
  

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:

  UK60011

Modules/Macros

•    ADB2RE   ADB2REE  ADB2REG  ADB2REM  ADB2REU
  ADB2REZ
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK60011

     UP10/08/31 P F008

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.