PH30862: OBJECT COMPARE MAY REPORT UNNECESSARY CHANGE IF DEFAULT VALUE FOR COLUMN IS SESSION_USER

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When the default value for a column is SESSION_USER, Object
  Compare does the comparison based on the actual SESSION_USER
  at the time the table was created.  This is what is stored in
  the SYSCOLUMNS.DEFAULTVALUE column.  This is not an issue for
  tables created by the same user, but can otherwise result in
  an unnecessary reported change, such as the drop/create of a
  view. This is especially true if either source or target is DDL,
  since there is no user at the time of the extract.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Object Comparison Tool for      *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Object Compare reports an unnecessary   *
  *                      change on a column with default value   *
  *                      SESSION_USER.                           *
  *                                                              *
  ****************************************************************
  When a table column has the default SESSION_USER, the value
  stored in SYSIBM.SYSCOLUMNS DEFAULTVALUE might differ,
  depending on whether the column was
  defined with a CREATE TABLE or ALTER TABLE ADD COLUMN statement.
  Because of this variation, Compare might report a change to
  the default value.
  In this case, no action is performed on the table, but
  views on the table are dropped and recreated unnecessarily.
  
  The same issue is possible if the column default is
  CURRENT SQLID.
  

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:

  UI73706

Modules/Macros

• ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI73706

     UP21/02/02 P F102

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.