PH49639: CHANGE REORG SHRLEVEL DEFAULT TO CHANGE

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Change REORG SHRLEVEL default to CHANGE
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and Db2 Object Comparison Tool for z/OS      *
  *                 who use Compare or Change Management         *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using Change Management (CM) or    *
  *                      CM batch, if you do not specify a       *
  *                      value for the SHRLEVEL option of the    *
  *                      REORG TABLESPACE utility, SHRLEVEL NONE *
  *                      is used as the default. As a result,    *
  *                      any pending changes are not             *
  *                      materialized. In  these cases, REORG    *
  *                      should use SHRLEVEL CHANGE or SHRLEVEL  *
  *                      REFERENCE.                              *
  ****************************************************************
  In CM, the default value SHRLEVEL NONE is used for REORG
  TABLESPACE in either of the following situations:
  
  When the SHRLEVEL value is not explicitly specified
  When you specify that custom utility options are not to be
  used (CM batch parameter USE_UTILITY_OPTIONS='NO' or the panel
  option 'Review/change options' or 'List/Customize DB2 Utility
  options' is set to 'NO').
  Because SHRLEVEL NONE is used, any table spaces with pending
  changes are left in a pending state. (REORG can materialize
  pending changes only if SHRLEVEL is set to CHANGE or REFERENCE.)
  
  This APAR changes CM and Compare so that SHRLEVEL NONE is no
  longer used as the default for REORG. Instead, to ensure that
  any pending changes are materialized successfully, either
  SHRLEVEL CHANGE or SHRLEVEL REFERENCE will be used; Db2 Admin
  Tool determines the best value (CHANGE or REFERENCE) depending
  on the circumstance.
  
  Additionally, a message will be issued in these situations to
  state that CM has changed the SHRLEVEL value from NONE to
  CHANGE or REFERENCE.
  

Problem conclusion

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:

  UI82568 UI82573

Modules/Macros

• ADBA01   ADBB20   ADBGAJOB ADBTREO
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI82573

     UP22/09/29 P F209

• RD10 PSY UI82568

     UP22/09/29 P F209

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.