PI87286: DB2 ADMINISTRATION TOOL - COMPARE STEP FAILED ADB1664E, NOT CLEAR WHAT THE PROBLEM WAS OR WHERE IT WAS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Compare failed with:
  ADB1664E An internal error occurred. Diagnostic
           text=ADB2REG.COL_PROC(19918):INT
  ADB7380E Module ADB2CMP - Severe error Compare has been stopped
  
  It was not clear what the problem was or where it was. APAR
  fix message(s) to provide more detail.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison           *
  *                 Tool for z/OS who use source DDL for         *
  *                 compare or parse generated ADMIN             *
  *                 CHECK DATA statements.                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1- A compare operation that uses        *
  *                      a source DDL may end with               *
  *                      ADB1664E and ADB7380E.                  *
  *                      msgADB1664E msgADB7380E                 *
  *                                                              *
  *                      2- Parsing of ADMIN CHECK               *
  *                      DATA fails with:                        *
  *                      ADB2PA: The following                   *
  *                      statement could not be                  *
  *                      completely parsed.                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  1- When Compare uses a source DDL that has an incorrect
  object definition, the operation may end with:
  
  ADB1664E An internal error occurred. Diagnostic
           text=ADB2REG.COL_PROC(19918):INT
  
  ADB7380E Module ADB2CMP - Severe error Compare
  has been stopped
  
  The information given does not indicate what the problem
  was or where it was. A message that provides more details
  is needed.
  
  2- The parser was recently changed to catch possible
  syntax errors and not allow partly parsed statements.
  However, the ADMIN CHECK DATA statement is still not
  completely parsed.
  

Problem conclusion

• 1- The problem is resolved by adding message ADB7382S
  to the Object Comparison Report following the ADB1664E
  message:
  
  ADB7382S Severe error while generating DDL for objtype
  objschema.objname. Please confirm the DDL is valid.
  
  2- Since the ADMIN CHECK DATA statement is generated
  internally we continue to allow it to be partly parsed.
  

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:

  UI52639 UI52640

Modules/Macros

•    ADB2CMR  ADB2CMT  ADB2CMU  ADB2PA   ADB7000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI52639

     UP17/12/14 P F712

• RC10 PSY UI52640

     UP17/12/14 P F712

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.