PH65683: ADDING NOT NULL COLUMN WITHOUT DEFAULT FAILS WITH SQLCODE -650

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When a new NOT NULL column without default is added to the table
  by ALTER statements, it is done by ADD statement with default
  and then default is dropped by ALTER COLUMN statement. But if a
  view exists on the table, ALTER COLUMN fails with SQLCODE -650.
  View must be drop/created to apply this change.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and Db2 Object Comparison Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: An apply job fails with SQLCODE = -650  *
  *                      when a NOT NULL column without a        *
  *                      default is added to the table.          *
  ****************************************************************
  When Object Compare processes a change to add a NOT NULL column
  without a default, it generates an ALTER TABLE ADD COLUMN
  statement with a default followed by a ALTER TABLE DROP DEFAULT
  statement. But if a view exists on the table, DROP DEFAULT fails
  with SQLCODE = -650.
  

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:

  UO03142

Modules/Macros

• ADB2CMO  ADB2CMP  ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UO03145

     UP25/05/14 I 1000

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.