PH10560: OBJECT COMPARE DDL HISTORY TABLES FIELDPROC ADB1664E ADB2REG.COL_PROC INTERR00000003FL.TB ADB7382S

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A compare of DDL between two temporal or history tables with
  FIELDPROC definitions may result in an error such as the
  following:
  ADB1664E An internal error occurred. Diagnostic
  text=ADB2REG.COL_PROC
  (8187):INTERR00000003FL.TB XXXX.XXXX_HIS
  ADB7382S Severe error while generating DDL for TB
  XXXX.XXXX_HIS. Please confirm the DDL is valid.
  ADB7380E Module ADB2CMP - Severe error Compare has been stopped.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: User of Db2 Object Comparison Tool for Z/OS  *
  *                 who compare temporal/history tables that     *
  *                 contain field procedures.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Compare of temporal/history tables      *
  *                      that contain field procedures may       *
  *                      result in error messages ADB1664E,      *
  *                      ADB7382S, and ADB7380E.                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  During the compare process, column information is copied from
  the temporal table to the history table. A column may contain a
  field procedure which is stored as an 'FL' row in the version
  file. This row information is not included when copying over the
  column information. This causes a DDL mismatch, since the
  temporal and history tables must have identical column
  definitions and the field procedure information is missing. The
  result may be the following error messages:
  
  ADB1664E An internal error occurred. Diagnostic
  text=ADB2REG.COL_PROC
  (8187):INTERR00000003FL.TB XXXX.XXXX_HIS
  ADB7382S Severe error while generating DDL for TB
  XXXX.XXXX_HIS. Please confirm the DDL is valid.
  ADB7380E Module ADB2CMP - Severe error Compare
  has been stopped.
  

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:

  UI63599

Modules/Macros

•    ADB2CMR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI63599

     UP19/06/14 P F906

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.