PH46522: PERIOD SYSTEM_TIME OR PERIOD BUSINESS_TIME CLAUSE MISSING FROM DDL WHEN USING THE GENERATE FUNCTION

APAR status

• Closed as program error.

Error description

• Prior APAR PH45401 disabled Optim's ability to properly provide
  the PERIOD SYSTEM_TIME or PERIOD BUSINESS_TIME clause when
  generating DDL with the object (table) GENERATE function
  for TEMPORAL tables.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Optim users utilizing the object (table) *
  *                 Create function involving TEMPORAL DB2       *
  *                 tables.                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: PERIOD SYSTEM_TIME or                   *
  *                      PERIOD BUSINESS_TIME clause may be      *
  *                      missing from DDL when creating TEMPORAL *
  *                      DB2 tables.                             *
  ****************************************************************
  Optim logic is incorrectly maintaining data structures related
  to PERIOD SYSTEM_TIME or PERIOD BUSINESS_TIME clause.
  

Problem conclusion

• Optim processing will be corrected.
  

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

• FOP0DAUE FOP9APIM FOPCFPMN FOPINS0  FOPMADDE FOPMAIN  FOPMARCN
  FOPMCMAI FOPMCOLA FOPMCOLP FOPMDBMN FOPMDDDL FOPMDPRC FOPMDXTR
  FOPMECMN FOPMIXMM FOPMMCMR FOPMMJBS FOPMMUNU FOPMMUTL FOPMUXIM
  FOPOMN   FOPUBMC  FOPUIAUL FOPUUNLD FOPZFMMN FOPZSUB
  

Fix information

• Fixed component name

  OPTIM MOVE FOR

• Fixed component ID

  5655V0700

Applicable component levels