PH35222: DB2 ADMIN : COMPARE REPORTS DIFFERENCE IN HISTORY TABLE DEFAULT VALUE WHEN SOURCE AND TARGET ARE IDENTICAL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Db2 Admin : Compare reports difference in history table default
  value when source and target are identical
  
  For example
  
  If the base table has a column defined like:
  
  
  END_D                DATE NOT NULL WITH DEFAULT '9999-12-30'
  
  and it's History table
  
  END_D                DATE NOT NULL
  
  The base and history table are identical on the source
  and target.
  
  Compare reports a difference which does not exist:
  
  Compare table source( < base table name>  and
  target( < base table name> )
  
     No changes to Table
  
  Compare table source( <history table name>  and
  target( <history table name> )
  
     Column END_D
       (A)Default value changed from 9999-12-30 to
     Tables have identical column lists
     Table will be altered
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Object Comparison Tool for      *
  *                 z/OS                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: Compare might report a difference in a  *
  *                      history table column default value      *
  *                      when none exists.                       *
  ****************************************************************
  Compare does not restore the history table column default value
  and uses the same value as the temporal table column default
  value. Compare then reports a difference in default value for
  the history table column when one does not exist.
  
  For example,
  
  Both the source and target have END_D defined as
  Base table:
  END_D DATE NOT NULL WITH DEFAULT '9999-12-30'
  History table:
  END_D DATE NOT NULL
  
  Compare reports this difference:
  
  Compare table source(A.TABLE1_HST) and target(B.TABLE1_HST)
  Column END_D
  (A)Default value changed from 9999-12-30 to
  Tables have identical column lists
  Table will be altered
  

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:

  010PC2Ÿ UI75086

Modules/Macros

• ADB2CMR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI75086

     UP21/05/03 P F104

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.