PK98414: IGNORE PARTITIONING DOES NOT PREVENT DROP AND CREATE OF TABLE WITH MESSAGE (D)NUMBER OF PARTITIONS REDUCED BY N PARTITION(S)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Object Comparison Tool for z/OS' IGNORE feature did
  not prevent a table being dropped and created when a difference
  in the number of partitions was present and the GENERIC IGNORE
  PARTITIONING was used.
  This resulted in a message:
   Tables have identical column lists
   (D)Number of partitions reduced by 100 partition(s)
   Table aaa.aaa will be dropped
   Table will be recreated
   Table data will not be converted
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Comparison               *
  *                 Tool for z/OS who use the ignore             *
  *                 partitioning option and/or table             *
  *                 columns with NOT NULL WITH                   *
  *                 DEFAULT constant.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: The compare of the table did            *
  *                      not fully ignore partitioning.          *
  *                      Modifications to column                 *
  *                      NOT NULL WITH DEFAULT                   *
  *                      constants were not                      *
  *                      implemented correctly.                  *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  DB2 Object Compare reported changes in table
  partitioning which resulted in a DROP/CREATE of
  the table.  Modifications to column NOT NULL WITH
  DEFAULT constants were implemented with
  DROP/CREATE.
  

Problem conclusion

• DB2 Object Compare is changed to correctly handle
  this situation.  Changes were also made to support
  the smart alter of columns NOT NULL WITH
  DEFAULT constant.
  

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  GOC2CMT
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R720 PSY UK56303

     UP10/04/28 P F004

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.