PH06885: DB2 ADMIN TOOL - SQLCODE -650 REASON 22 WHEN ALTERING A TABLE WITH VIEW TO SET DEFAULT VALUE ON DECIMAL COLUMN

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When a table has a column default value changed which will be
  achieved through ALTER TABLE/ALTER COLUMN and table has views,
  the ALTER fails with SQLCODE -650 / SQLCODEN650 REASON 22. This
  is because the views need to be dropped before the ALTER
  statement can be executed, then create views back.
  
  For a Compare, when views are included in the source DDL, the
  tool knows it has to drop them first in order to perform ALTER
  on the table, then recreates them.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS or Db2 Object Comparison Tool for       *
  *                 z/OS who use views.                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: A compare whose target is a table with  *
  *                      dependent views, which is automatically *
  *                      extracted from the catalog, may not     *
  *                      drop the necessary views to allow       *
  *                      the altering of its column's default    *
  *                      value and results in SQLCODE -650 /     *
  *                      SQLCODEN650.                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  A table which has column default value changed , the change
  will be achieved with an Alter table. When the table has
  views on the target and the source DDL does not include the
  views, the views are not dropped. In order for the ALTER
  TABLE to be successful, the views need to be dropped and
  recreated after the alter or the change will fail with
  SQLCODE=-650. When the views are included in the source DDL
  the tool knows it has to drop them first and no error.
  

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:

  UI62302

Modules/Macros

•    ADB2CME  ADB2CMO  ADB2CMP  ADB2CMR  ADB2CMS
  ADB2CMT  ADB2CMU  ADB2CM3
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI62302

     UP19/04/05 P F904

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.