PH15913: CM BATCH ANALYZE OBJECT COMPARE DROP CREATE TEMPORAL HISTORY TABLES MISSING ALTER TABLE ADD VERSIONING STATEMENTS IN WSL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• CM Batch Analyze or Object Compare involving DDL with explicit
  drop/create of three sets of temporal and history tables
  results in a WSL containing only one ALTER TABLE ADD VERSIONING
  statement instead of all three.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS and DB2 Object Comparison Tool for      *
  *                 z/OS who explicitly drop temporal and        *
  *                 history tablespaces.                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: When explicitly dropping temporal and   *
  *                      history tablespaces, and then creating  *
  *                      new temporal and history tablespaces,   *
  *                      analyze fails to re-add versioning when *
  *                      there is more than one set of temporal  *
  *                      and history table pairs.                *
  ****************************************************************
  When explicitly dropping temporal and history tablespaces and
  then creating new temporal and history tablespaces with
  versioning on the tables, analyze fails to add versioning when
  there is more than one set of temporal and history table pairs.
  

Problem conclusion

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

  UI66298

Modules/Macros

• ADB2CMR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI66298

     UP19/11/30 P F911

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.