PM03277: MSG (D)NUMBER OF PARTITIONING KEY COLUMNS HAVE CHANGED FROM 0 TO 2

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Object Compare Tool the Object Comparison Report section
  of the compare joblog incorrectly reports that the partitioning
  key columns have changed when they have not. What was changed
  was the index partitioning in the target table was changed to
  table partitioning by the source table. The partitioning key
  columns were the same in source and target objects.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Comparison               *
  *                 Tool for z/OS who convert table              *
  *                 partitioning from index-controlled           *
  *                 to table-controlled.                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: In the DB2 Object Comparison            *
  *                      Tool, the Object Comparison             *
  *                      Report incorrectly states that          *
  *                      the partitioning key columns            *
  *                      had changed when they had               *
  *                      not. The table had changed              *
  *                      from index-controlled                   *
  *                      partitioning to table-controlled        *
  *                      partitioning.                           *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  DB2 Object Compare was unable to determine which of
  the customers five indexes was the clustering index.
  Customers with a single index will not encounter
  this problem.
  

Problem conclusion

• DB2 Object Compare is changed to correctly determine
  the clustering index.
  

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

•    GOC2CMF  GOC2CMP
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R720 PSY UK54758

     UP10/03/04 P F003

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.