PI07356: COMPARE GENERATES INCORRECT SYNTAX IN CHANGE FILE WHEN ALTERING TEMPORAL TABLE WITH IGNORE FILE KEYWORD PARTITIONING

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS Compare function generates
  incorrect syntax when altering a Temporal Table and the keyword
  Partitioning is specified in the Ignore file.
  

Local fix

• Remove Keyword Partitioning from Ignore File.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool      *
  *                 for z/OS who specify a compare source        *
  *                 which includes temporal tables with          *
  *                 TRANSACTION START ID columns and also        *
  *                 specify an ignore file containing the        *
  *                 generic ignore field PARTITIONING.           *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 Object Comparison Tool for       *
  *                      z/OS, if the generic ignore field       *
  *                      PARTITIONING is specified and there     *
  *                      is a temporal table with                *
  *                      TRANSACTION START ID columns in         *
  *                      the compare source, the wrong default   *
  *                      clause is generated for the             *
  *                      TRANSACTION START ID columns in the     *
  *                      CHANGE file. The column definition      *
  *                      shows as below:                         *
  *                                                              *
  *                      Column_name      TIMESTAMP (12)         *
  *                       WITHOUT TIME ZONE NOT NULL             *
  *                       WITH DEFAULT                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The default value of TRANSACTION START ID columns in temporal
  tables have nothing to do with the generic ignore field
  PARTITIONING, so the default clause of TRANSACTION START ID
  columns should be generated based on the definition in the
  source regardless of the generic ignore field PARTITIONING.
  

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

•    ADB2CMR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI14594

     UP14/01/30 P F401

• RB10 PSY UI14595

     UP14/01/30 P F401

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.