PK33848: GOC DROPS RECREATES TABLESPACE THAT HAD NUMPARTS CHANGED WHEN IT SHOULD HAVE DONE A SMART ALTER

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Customer changes the numparts of a tablespace and when using
  Object Compare R710 it drops and recreates the tablespace
  instead of doing a smart alter . GOC output shows:
  Compare tablespace source(xxx.yyyy) and
  target(xxx.yyy)
      (D)Field NUMPARTS changed from 5 to 4
      Tablespace DB35298.S60A0100 will be dropped
      Tablespace will be recreated
  Compare table source(DB35298.S60A0100) and
  target(DB35298.S60A0100)
    Source and/or target tablespaces use table-controlled
        partitioning DB35298.S60A0100 will be dropped
    Comparison results may not reflect actual object differences
    Tables have identical column lists
    (D)Number of partitions reduced by 1 partition(s)
    Table DB35298.S60A0100 will be dropped by dropping the
       tablespace
    Table will be recreated
  

Local fix

• Please apply PTF when available.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Object Compare 7.1                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: Customer adds one partition to the      *
  *                      tablespace. GOC 7.1. gets rc=0 but      *
  *                      tablespace is dropped and recreated     *
  *                      instead of 'Smart alter                 *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Drop/Create is created instead of "smart" alter when partition
  added to the table (table based partitioning).  Note: "smart"
  alter will be created only if the target is a catalog and pqty,
  seqty and storname in the "added" partitions are defaults.
  

Problem conclusion

• The problem is fixed in DB2 Object Compare V7.2 and V7.1
  

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
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R710 PSY UK29839

     UP07/10/18 P F710

• R720 PSY UK29840

     UP07/10/18 P F710

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.