PH00293: DB2 ADMIN TOOL / OBJECT COMPARISON TOOL - CM BATCH INTERFACE ADB7382S SEVERE ERROR WHILE GENERATING DDL FOR IX

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• OCT CM Batch interface returns message:
  ADB7382S Severe error while generating DDL for IX <ixname>.
      Please confirm the DDL is valid.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for z/OS    *
  *                 who use the Change Management Batch facility *
  *                 and DB2 Object Comparison Tool for z/OS.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: Compare returned with RC=12 and reports *
  *                      the following errors:                   *
  *                                                              *
  *                       No sysindexpart row found for Create   *
  *                       index                                  *
  *                       ADB7382S Severe error while generating *
  *                                DDL for IX >ixname<. Please   *
  *                                confirm the DDL is valid.     *
  *                                                              *
  *                       ADB7380E Module ADB2CMP - Severe error *
  *                                Compare has been stopped.     *
  *                                                              *
  *                      May see an additional looping issue:    *
  *                                                              *
  *                      ADB7350E Module : ADB2CMP detected an   *
  *                               ONCODE condition 9999 in       *
  *                               ADB2DICT_FREE at 234           *
  *                      ADB7350E Module : ADB2CMP detected an   *
  *                               ONCODE condition 8094 in       *
  *                               ADB2DICT_FREE at 233           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When comparing source DDL and target objects with masks and
  ignores and there is one index changed, Compare returned with
  RC=12 and the following reporting errors:
  
  No sysindexpart row found for Create index
  ADB7382S Severe error while generating DDL for IX
      <ixname>. Please confirm the DDL is valid.
  ADB7380E Module ADB2CMP - Severe error Compare has been stopped.
  
   May see additional looping issue:
  
  ADB7350E Module : ADB2CMP detected an ONCODE condition 9999 in
  ADB2DICT_FREE at 234
  ADB7380E Module ADB2CMP - Severe error Compare has been stopped.
  ADB7350E Module : ADB2CMP detected an ONCODE condition 8094 in
  ADB2DICT_FREE at 233
  ADB7380E Module ADB2CMP - Severe error Compare has been stopped.
  

Problem conclusion

• Problems have 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:

  UI58573 UI58574

Modules/Macros

•    ADB2CM3
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI58573

     UP18/09/26 P F809

• RC10 PSY UI58574

     UP18/09/26 P F809

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.