PI14464: MSG ADB5185E SQLCODE -650 FOR ALTER DEFAULT ON COLUMN TABLE WITH VIEW

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS issues SQLCODEN650 (-650) and
  message ADB5185E " The run is ending due to errors. " when
  Altering a column with a View and the column is  SET WITH
  DEFAULT.
  ( SQLCODEN625  SQLCODE = -650  SQLCODE -650 )
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 z/OS who alter the default value of a        *
  *                 column in a table referenced by a VIEW.      *
  ****************************************************************
  * PROBLEM DESCRIPTION: When altering the default value of a    *
  *                      column in a table referenced by a       *
  *                      VIEW, only the ALTER TABLE SET          *
  *                      DEFAULT statement was generated         *
  *                      in the CHANGE file.  The APPLY job      *
  *                      failed with a Return Code 8 / RC = 8    *
  *                      and a SQLCODE = -650 /                  *
  *                      SQLCODEN650 in the job log:             *
  *                                                              *
  *                      DSNT408I SQLCODE = -650, ERROR:         *
  *                               THE ALTER STATEMENT CANNOT     *
  *                               BE EXECUTED,                   *
  *                               REASON 22                      *
  *                      DSNT418I SQLSTATE   = 56090             *
  *                      SQLSTATE RETURN CODE                    *
  *                                                              *
  *                      ADB5185E The run is ending due to       *
  *                      errors.                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  If a table is referenced by a VIEW, the ALTER TABLE SET DEFAULT
  statement can not be executed to alter the default value of the
  column in the table. The referenced objects need to be dropped,
  followed by an ALTER statement, and the recreation of the
  referenced objects.
  

Problem conclusion

• 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:

Modules/Macros

•    ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI19337

     UP14/07/08 P F407

• RB10 PSY UI19338

     UP14/07/08 P F407

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.