PM78306: SUPPORT ADDED FOR TEMPORAL TABLE DDL

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• DDL support for temporal data is now available.
  DDL added as follows...
  DDL additions...
  CREATE TABLE: PERIOD SYSTEM_TIME
  BUSINESS_TIME
  ( start-column-name , end-column-name )
  CREATE TABLE ... LIKE to gen history table for system time
  UNIQUE CONSTRAINT... BUSINESS_TIME WITHOUT OVERLAPS
  BUSINESS and SYSTEM TIME column definitions
  CREATE INDEX... BUSINESS_TIME WITHOUT OVERLAPS
  GENERATED ALWAYS AS ROW BEGIN [and END]
  new column defaults
  etc.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Cloning Tool.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: DDL support for temporal data is now    *
  *                      available.                              *
  *                      DDL added as follows...                 *
  *                      DDL additions...                        *
  *                      CREATE TABLE: PERIOD SYSTEM_TIME        *
  *                      BUSINESS_TIME                           *
  *                      ( start-column-name , end-column-name ) *
  *                      CREATE TABLE ... LIKE to gen history    *
  *                      table for system time                   *
  *                      UNIQUE CONSTRAINT... BUSINESS_TIME      *
  *                      WITHOUT OVERLAPS BUSINESS and SYSTEM    *
  *                      TIME column definitions                 *
  *                      CREATE INDEX... BUSINESS_TIME WITHOUT   *
  *                      OVERLAPS GENERATED ALWAYS AS ROW BEGIN  *
  *                       and END  new column defaults etc.      *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

Temporary fix

Comments

• APPLY the PTF.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

•    CKZ00633
  

Fix information

• Fixed component name

  DB2 CLONING TOO

• Fixed component ID

  5655N1000

Applicable component levels

• R310 PSY UK90532

     UP13/01/03 P F301

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.