PH11551: MERGE ERROR FOR ALTER TABLE STATEMENT.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Merge fails ALTER TABLE ADD COLUMN ... CONSTRAINT ... CHECK
  due to wrongly created delta VF.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS or Db2 Object Comparison Tool for       *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1.Analyzing a change results in         *
  *                      unexpected catalog error when the       *
  *                      change was generated by comparing       *
  *                      indexes that one has PARTITIONED and    *
  *                      PARTITION clauses while the other       *
  *                      only has PARTITIONED clause.            *
  *                                                              *
  *                      2.When analyzing a change of            *
  *                      ALTER TABLE ... CONSTRAINT ... CHECK    *
  *                      statement, Merge process terminates     *
  *                      with an error.                          *
  *                                                              *
  *                      3. Some packages remain invalidated     *
  *                      after applying a change.                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Compare index source(index_name) and target(index_name)
    (A)Number of partitions change from 6 to 12 for
       partitioned index
    Ignored fields will get values from target
    partition 1
  
  ADBC024E - Unexpected catalog row on target file.
  Expected:IP found:YX
  
  Rowtypes from source file :
    IX TS DB KY CO KY CO IP IP TP TP LK LK IP IP TP TP LK LK IP
    IP TP TP LK LK IP IP TP TP LK LK IP IP TP TP LK LK IP IP TP
    TP LK LK
  Rowtypes from target file :
    IX TS DB KY CO KY CO IP TP LK IP TP LK IP TP LK IP TP LK IP
    TP LK IP TP LK
  
  1.Analyzing a change results in unexpected catalog error when
  the change was generated by comparing indexes that one has
  PARTITION clause while the other only has PARTITIONED clause.
  Object Compare expects the same catalog row structure for an
  index 1- with PARTITIONED and PARTITIONED clauses, 2- and
  without PARTIION clause but only has PARTITIONED clause.
  
  ADB7380E Module ADB2CMP - Severe error Compare has been
  stopped.
  
  2.DDL reader generates wrong information in one of
  header fields of the version file when processing
  ALTER TABLE ... CONSTRAINT ... CHECK statement. The
  wrongly generated version file leads to an error in
  the proceeding Merge process of analyzing a change.
  
  ADB8007E An attempt was made to create a table that
  already exists.
  
  3 ADBTEP2 fails to identify packages to be rebound due to a
  foreign key change. After applying a change, some packages
  are remain invalidated.
  

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:

  UI62949

Modules/Macros

•    ADBCDTS  ADBTEPR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI62949

     UP19/05/15 P F905

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.