PI50807: IBM NEW FUNCTION APAR FOR AOC 11.2 - ALTERING TABLESPACES OR INDEXES SHOULD NOT MAKE CHANGES BASED ON 'COMPARE' METHODOLOGY.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• IBM NEW FUNCTION APAR FOR AOC 11.2 - Altering Tablespaces or
  Indexes should not make changes based on 'compare' methodology.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS and DB2 Object Comparison Tool for      *
  *                 z/OS who use the Change Management (CM)      *
  *                 function.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: If a change to an object is registered  *
  *                      in the CM database and the object is    *
  *                      later updated outside CM, the new       *
  *                      difference is included during analyze   *
  *                      and run of the registered change.       *
  *                      However, the user's intention is to     *
  *                      update the object with the original     *
  *                      change only.                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  If a change to an object is registered in the CM database
  and the object is later updated outside CM, the new difference
  is included during analyze and run of the registered change.
  However, the user's intention is to update the object with the
  original change only.
  

Problem conclusion

Temporary fix

Comments

• The following enhancement is delivered:
  
  Instead of ADMIN DROP and CREATE, the new ADMIN ALTER
  statements will be generated and stored in the
  CM path which reflect the intended change. This APAR
  supports only changes to table spaces and indexes.  In
  most cases we are moving away from DROP/CREATE but there
  are some exceptions, for example, changes related to
  partitioning.
  
  For example,
  A table space has the encoding scheme changed from
  EBCDIC to UNICODE and the change is registered in
  the CM database as ADMIN DROP TABLESPACE and
  CREATE TABLESPACE statements.  The CREATE TABLESPACE
  statement contains the table space definition from the
  time the change was registered with the desired encoding
  scheme update:
  
  CREATE TABLESPACE tsname
    IN dbname
    USING STOGROUP SYSDEFLT
    PRIQTY -1 SECQTY -1
    ERASE  NO
    FREEPAGE 0 PCTFREE 5
    GBPCACHE CHANGED
    TRACKMOD YES
    LOGGED
    SEGSIZE 32
    BUFFERPOOL BP1
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    CLOSE YES
    COMPRESS NO
    CCSID      UNICODE
    DEFINE YES
    MAXROWS 255;
  
  Then the bufferpool for the table space is changed from
  BP1 to BP0 outside of the Change Management functions
  control, i.e., without registering the change in the CM
  database.  When analyze is run both changes are processed,
  reported, and the following SQL statement generated:
  
  CREATE TABLESPACE tsname
    IN dbname
    USING STOGROUP SYSDEFLT
    PRIQTY -1 SECQTY -1
    ERASE  NO
    FREEPAGE 0 PCTFREE 5
    GBPCACHE CHANGED
    TRACKMOD YES
    LOGGED
    SEGSIZE 32
    BUFFERPOOL BP0
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    CLOSE YES
    COMPRESS NO
    CCSID      UNICODE
    DEFINE YES
    MAXROWS 255;
  
  With this APAR the registered change will be an ADMIN
  ALTER statement containing only the desired update:
  ADMIN ALTER TABLESPACE ENCODING SCHEME UNICODE.
  When performing an Analyze, the SQL statement will
  include the registered change only:
  
  CREATE TABLESPACE tsname
    IN dbname
    USING STOGROUP SYSDEFLT
    PRIQTY -1 SECQTY -1
    ERASE  NO
    FREEPAGE 0 PCTFREE 5
    GBPCACHE CHANGED
    TRACKMOD YES
    LOGGED
    SEGSIZE 32
    BUFFERPOOL BP0
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    CLOSE YES
    COMPRESS NO
    CCSID      UNICODE
    DEFINE YES
    MAXROWS 255;
  
  If a change needs to be imported to a different
  DB2 system it will include only the original
  intended update i.e., the CCSID change to UNICODE.
  ×**** PE15/12/18 PTF IN ERROR. SEE APAR PI53615  FOR DESCRIPTION
  ×**** PE16/01/21 PTF IN ERROR. SEE APAR PI55567  FOR DESCRIPTION
  

APAR Information

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

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

  UI33220

Modules/Macros

•    ADBCCMM  ADBCDTS  ADB2CME  ADB2CMF  ADB2CMO
  ADB2CMP  ADB2CMR  ADB2CMS  ADB2CMT  ADB2CMU  ADB2CM1  ADB2CM2
  ADB2CM3  ADB2PA   ADB2PA5  ADB2PA6
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI33220

     UP15/11/26 P F511

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.