PI92373: DB2 ADMIN TOOL - ADB1664E AN INTERNAL ERROR OCCURRED. / ADB7382S SEVERE ERROR WHILE GENERATING DDL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Analyze a CM - Changes which should create a base table and the
  HISTORY TABLE. The job ends with:
  
  Table <table_name> not found on target
  New Table <tale_name> will be added
  New history Table <tale_name_HIST> be added
  ADB1664E An internal error occurred. Diagnostic
           text=ADB2REG.COL_PROC
           (7735):INTERR00000003SQ.TB <tale_name_HIST>
  
  ADB7382S Severe error while generating DDL for TB
           <tale_name_HIST>.
  Please confirm the DDL is valid.
  
  ADB7380E Module ADB2CMP - Severe error Compare has been stopped.
  
  Summary of Issue:
  Customer is analyzing change which contains new temporal table
  with identity column and new history table with identity column
  which leads to failure with error message ADB1664E . However the
  same error can be reproduced if both tables are added as new
  objects via regular compare.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Comparison Tool for      *
  *                 z/OS who use Change Management.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: Analyzing a change fails with an error  *
  *                      message but the message does not        *
  *                      specify detailed reason of the error.   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Analyzing a change which creates temporal and history tables
  with an identity column correctly fails with an error message:
  
  ADB1664E An internal error occurred. Diagnostic
           text=ADB2REG.COL_PROC (7735):INTERR00000003SQ.TB
           DBA.CS0_MAIN
  
  ADB7382S Severe error while generating DDL for TB DBA.CS0_MAIN.
           Please confirm the DDL is valid.
  
  ADB7380E Module ADB2CMP - Severe error Compare has been stopped.
  
  Although the message suggests that DDL may not be valid, it
  does not provide further details.
  

Problem conclusion

• The problem has been resolved. A new error message will be
  generated if provided history table contains identity column:
  
  ADB7194S Table tbqual.tbname cannot include an identity
           column because it is a history table. Correct the
           definition for column col_name.
  

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  ADB7000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI55058

     UP18/04/10 P F804

• RC10 PSY UI55059

     UP18/04/10 P F804

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.