PH60828: INTERNAL APAR TO NON-DISRUPTIVE ADD COLUMN NOT NULL WITH NO DEFAULT

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Internal APAR to Non-disruptive add column not null with no
  default
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and Db2 Object Comparison Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR adds an enhancement to        *
  *                      support a non-disruptive change         *
  *                      when a NOT NULL column with no          *
  *                      default is appended to a table.         *
  ****************************************************************
  When you compare objects with Object Comparison Tool, and the
  resulting changes to the target include appending a column that
  is NOT NULL with no default, that change is no longer
  disruptive. Previously, such a change was made by dropping and
  recreating the table. Now, this change is accomplished by
  altering the table as follows:
  
  ALTER TABLE table ADD COL NOT NULL WITH DEFAULT
  REORG TABLESPACE table_space
  ALTER TABLE table ALTER COL DROP DEFAULT
  
  Note that a REORG operation is needed in this case to clear the
  restrictive state. Therefore, set the Run REORG/REBUILD option
  on the Generate Compare Jobs (GOC5) panel to M or A. Or, if you
  are using CM batch, set the RUN_REORG_REBUILD parameter to M or
  A.
  
  Restrictions:
  This ALTER operation will not be used in the following
  situations:
  * For tables with DATA CAPTURE CHANGES
  * For base tables with materialized query tables
  * If the appended column is part of a check constraint
    or a business period
  

Problem conclusion

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:

  UI96566

Modules/Macros

• ADB2CMR  ADB2CMT  ADB2CMU
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UI96566

     UP24/04/23 P F404  

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.