PH49601: IGNORING CHANGES BETWEEN V12 AND MIGRATED PRE V12 OBJECTS

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Ignoring changes between v12 and migrated pre v12 objects.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and Db2 Object Comparison Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR ensures that Object           *
  *                      Comparison Tool does not generate       *
  *                      unnecessary changes for the following   *
  *                      new Db2 12 table space and index        *
  *                      attributes, when comparing source Db2   *
  *                      12 DDL/catalog with the target catalog  *
  *                      migrated from version 11                *
  *                      (created prior to Db2 12) and the       *
  *                      first partition                         *
  *                      values on the target are the same as    *
  *                      the source table space/index-level      *
  *                      attributes.                             *
  *                                                              *
  *                      1) Table space attributes               *
  *                      (in SYSIBM.SYSTABLESPACE):              *
  *                      PQTY, SECQTYI, STORTYPE, STORNAME,      *
  *                      VCATNAME,PCTFREE,PCTFREE_UPD, FREEPAGE, *
  *                      COMPRESS,GBPCACHE and TRACKMOD          *
  *                      2) Index attributes                     *
  *                      (in SYSIBM.SYSINDEXES):                 *
  *                      PQTY, SECQTYI, STORTYPE, STORNAME,      *
  *                      VCATNAME, FREEPAGE, PCTFREE and         *
  *                      GBPCACHE                                *
  ****************************************************************
  The following components are enhanced to support these new
  attributes:
  
  1.DDL reader:
  
  The DDL reader sets the specific values for the attributes
  with null values for table spaces and indexes for Object
  Compare.
  
  2.GEN:
  GEN does not generate the attributes with null values for
  partitioned table spaces or indexes.
  
  3.Object Compare:
  
  If a table space was created prior to Db2 12, certain
  table space attributes that are new in version 12 might
  be set to NULL in the Db2 catalog for that table space.
  If you use Db2 Object Comparison Tool to compare one of
  these table spaces in the catalog (the target) with
  DDL that was created in Db2 12 or later (the source),
  and the first partition values on target are the same
  as source table space-level attributes, no ALTER statements
  should be generated for these attributes.
  
  This APAR ensures that Object Comparison Tool does not
  generate unnecessary changes for the following attributes
  when comparing table spaces and the target is a table space
  in the catalog that was created prior to Db2 12:
  
      PQTY
      SECQTYI
      STORTYPE
      STORNAME
      VCATNAME
      PCTFREE
      PCTFREE_UPD
      TRACKMOD
      COMPRESS
      FREEPAGE
      GBPCACHE
  
  A similar situation exists for indexes that were created prior
  to Db2 12.  This APAR also ensures that Object Comparison Tool
  does not generate unnecessary changes for the following index
  attributes when comparing indexes and the target is an index in
  the catalog that was created prior to Db2 12:
  
      PQTY
      SECQTYI
      STORTYPE
      STORNAME
      VCATNAME
      FREEPAGE
      PCTFREE
      GBPCCAHE
  

Problem conclusion

Temporary fix

Comments

• ×**** PE22/12/13 FIX IN ERROR. SEE APAR PH51453  FOR DESCRIPTION
  ×**** PE22/12/13 FIX IN ERROR. SEE APAR PH51453  FOR DESCRIPTION
  ×**** PE22/12/13 FIX IN ERROR. SEE APAR PH51453  FOR DESCRIPTION
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• ADB2CME  ADB2REG  ADBCDTS
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI83087

     UP22/11/04 P F211

• RD10 PSY UI83088

     UP22/11/04 P F211

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.