PM15735: ++HOLD MISSING FOR MESSAGE ADB559G YES IS NOT ALLOWED WHEN MOVING TO PARTITIONED-BY-GROWTH TABLE SPACE. FFA10 PM24212.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS delivered code which
  closed a restriction in the ALC function and added a message:
  ADB559G YES is not allowed when moving to Partitioned-by-Growth
  table space (PBG)
  Message ADB559G is specific to panel  ADB21SAR (Redefine Table
  Space) and is issued when attempting to redefine a Table Space
  to Partitioned-by-Growth or Partitioned-by-Range with the MEMBER
  CLUSTER input field set to YES.
  Note:
  This is a DB2 V9 restriction.
  System action:
  Processing stops.
  User response:
  Specify NO to the Member Cluster input field when attempting to
  redefine a Table Space to Partitioned-by-Growth or
  Partitioned-by-Range.
  

Local fix

• Specify NO to the Member Cluster input field when attempting to
  redefine a Table Space to Partitioned-by-Growth or
  Partitioned-by-Range.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who use the ALC (Alter              *
  *                 Table) function.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: There is a DB2 V9 restriction which     *
  *                      prevents redefining a Table Space       *
  *                      to Partitioned-by-Growth (PBG) or       *
  *                      Partitioned-by-Range (PBR) with the     *
  *                      MEMBER CLUSTER input field              *
  *                      set to YES.                             *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  Message ADB559G
    'YES is not allowed when moving to a
     Partitioned-by-Growth table space.'
  
  is specific to panel ADB21SAR Redefine Table Space'
  and is issued when attempting to redefine a table space
  to Partitioned-by-Growth or Partitioned-by-Range with the
  MEMBER CLUSTER input field set to YES.  This is a DB2
  V9 restriction.
  
  System action:
  Processing stops.
  
  User response:
  Specify NO to the Member Cluster input field
  when attempting to redefine a Table Space to
  Partitioned-by-Growth or Partitioned-by-Range.
  

Problem conclusion

• Specify NO to the Member Cluster input field when
  attempting to redefine a table space to
  Partitioned-by-Growth or Partitioned-by-Range.
  Message ADB559G was added to the DB2
  Administration Tool for z/OS Users Guide, and the Help
  panel ADBH1SAR has been updated to include a
  warning that MEMEBER CLUSTER = YES is not
  allowed when moving to a Partitioned-by-Growth
  or Partitioned-by-Range table space.
  

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:

  UK62273

Modules/Macros

•    ADBH1SAR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK62273

     UP10/11/23 P F011

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.