PH23813: DUPLICATE DROP VERSIONING STATEMENT WHEN DROPPING VERSIONING AND DROPPING COLUMNS FROM A TEMPORAL HISTORY TABLE PAIR.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When comparing tables with
  system-period data versioning on the
  target only, Object Compare generates
  a duplicate statement to drop
  versioning in the resulting CHG and WSL.
  When trying to run the WSL, it fails
  with SQL -20525.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Object Comparison Tool for z/OS *
  *                 who compare tables with system-period data   *
  *                 versioning (temporal tables and history      *
  *                 tables).                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: When comparing tables with              *
  *                      system-period data versioning on the    *
  *                      target only, Object Compare generates   *
  *                      a duplicate statement to drop           *
  *                      versioning.                             *
  ****************************************************************
  When comparing tables with system-period data versioning
  (temporal tables and history tables) on the target but not on
  the source, any additional change to the objects causes a
  duplicate ALTER TABLE DROP VERSIONING statement to be generated
  in the change file and the WSL. When trying to run the WSL, it
  fails with SQL -20525.
  

Problem conclusion

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

  UI69462

Modules/Macros

• ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI69462

     UP20/06/01 P F005

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.