PH18447: CM BATCH OBJECT COMPARE ALTER MULTIPLE ADD COLUMN CLAUSES MISSING ALTER STATEMENTS FOR SOME COLUMNS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A CM Batch or Object Compare Analyze that includes an
  ALTER TABLE ADD COLUMN statement followed by an ALTER TABLE
  ADD COLUMN statement with multiple ADD COLUMN
  clauses may not add all of the columns specified.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS and Db2 Object Comparison Tool for      *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Analyzing a change fails to add all of  *
  *                      the columns specified when a change     *
  *                      contains an ALTER TABLE ADD COLUMN      *
  *                      statement followed by an ALTER          *
  *                      TABLE ...ADD COLUMN ... statement       *
  *                      containing multiple ADD COLUMN clauses  *
  *                      in one statement.                       *
  ****************************************************************
  Analyzing a change fails to add all of the columns specified
  when a change contains an ALTER TABLE ADD COLUMN
  statement followed by an ALTER TABLE ADD COLUMN ...
  statement with multiple ADD COLUMN clauses.
  
  An example is shown below:
  
  ALTER TABLE ADD COL1;
  
  ALTER TABLE ADD COL2 ADD COL3 ADD COL4 ADD COL5;
  
  ALTER TABLE ADD COL6;
  
  The resulting Compare recognizes to add only COL1, COL2, COL3.
  The remaining columns are missing.
  

Problem conclusion

• The 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:

  010PC2Ÿ UI67593 010PC2Ÿ 010PC2Ÿ

Modules/Macros

• ADBCCMM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI67593

     UP20/01/30 P F001

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.