PI50595: DB2 ADMIN NEW FUNCTION - ALTER TBLSPCS OR INDEXES SHOULD NOT MAKE CHANGES BASED ON A 'COMPARE' METHODOLOGY.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• DB2 ADMIN NEW FUNCTION TO ALTER TBLSPCS or INDEXES should not
  make changes based on a '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
  from EBCDIC to UNICODE and the change is registered
  changed 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 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
    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
    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.
  

APAR Information

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

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

  UI33167

Modules/Macros

•    ADBCCMM  ADBCDTS  ADB2CMF  ADB2CMP  ADB2CMR
  ADB2CMS  ADB2CMT  ADB2PA   ADB2PA5  ADB2PA6  ADB2REG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI33167

     UP15/11/25 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.