PI88251: CM BATCH ANALYZE PHASE OF CHANGE ENDS WITH RC=12 AND MESSAGES No sysindexpart row found for Create index, ADB7380E, andADBC026

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• If a change is created to add a new column to a table, and to
  add that column to the primary key, the analyze phase of change
  processing ends with RC=12 and the following messages:
  No sysindexpart row found for Create index
  ADB7380E Module ADB2CMP - Severe error Compare  has been
  stopped.
  ADBC026E Severe Error when generating DDL
  

Local fix

• Remove the DDL for the primary key CREATE INDEX from the source
  DDL, or add the new key column at the end of the source Create
  Index DDL.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:  Users of DB2 Administration Tool for        *
  *                  z/OS and Object Comparison Tool for         *
  *                  z/OS who use the ANALYZE function to        *
  *                  analyze a change.                           *
  ****************************************************************
  * PROBLEM DESCRIPTION: When analyzing a change that has an     *
  *                      ADMIN ALTER INDEX REPLACE COLUMN        *
  *                      statement, the analyze process results  *
  *                      in RC=12 with a message:                *
  *                                                              *
  *                      "ADBC026E Severe Error when generating  *
  *                       DDL".                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When analyzing a change that has an ADMIN ALTER
  INDEX REPLACE COLUMN statement on an index, a
  merge process will generate the wrong sequence number
  for internal object record in an intermediate file for
  the post merge process. The wrongly generated sequence
  number leads to an error in the subsequent process. The
  analyze process of a change ends with RC=12 with the
  following message:
  
   "ADBC026E Severe Error when generating DDL".
  

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:

Modules/Macros

•    ADBCCMM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI52201

     UP17/11/30 P F711

• RC10 PSY UI52202

     UP17/11/30 P F711

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.