PM57001: ALLOW ALTER TABLESPACE MAXPARTITIONS TO A SMALLER SIZE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Users are unable to modify the number of partitions to a smaller
  value.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: DB2 9 and 10 for z/OS users of ALTER         *
  *                 TABLESPACE MAXPARTITIONS                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: Users experience storage management     *
  *                      issues due to partition-by-growth (PBG) *
  *                      table spaces defined with large         *
  *                      MAXPARTITIONS value.                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Users may experience difficulty with storage management because
  internal control blocks were taking up storage for PBG table
  spaces defined with large MAXPARTITIONS value.
  
  To provide some relief, DB2 for z/OS will now allow ALTER
  TABLESPACE MAXPARTITIONS to a lower number within the valid
  range of 1 to 4096, and the value must not be less than the
  number of physical partitions already allocated for the table
  space.
  

Problem conclusion

• DB2 will now allow ALTER TABLESPACE MAXPARTITIONS to a smaller
  value. Previously, SQLCODE -644 was issued to restrict this
  case altogether. Now DB2 allows the alter, but will still
  issue SQLCODE -644 if the MAXPARTITIONS value is altered to
  a number lower than the physical partitions allocated.
  
  For DB2 9 for z/OS, dependent plans defined with the ACQUIRE
  ALLOCATE option will be invalidated on ALTER TABLESPACE
  MAXPARTITIONS.
  
  Additional Keywords:
  SQLCODE644
  SQLPBG
  SQLALTER
  
  ++HOLD COMMENT FOR RELEASE 910, TYPE DOC:
  PM57001 introduces the following changes to externals and the
  approximate text will be added to the V9 DB2 SQL Reference.
  This text is subject to change.
  
  Changed option for ALTER TABLESPACE MAXPARTITIONS:
    Specifies that the table space is partition-by-growth. integer
    specifies the maximum number of partitions to which the table
  | space can grow or shrink. integer must be in the range of 1 to
    4096, depending on the value that is in effect for DSSIZE and
    the page size of the table space, and must not be less than
  | the number of physical partitions already allocated for the
    table space. See CREATE TABLESPACE for more information about
    how DSSIZE and the page size are related.
  
  New note added to ALTER TABLESPACE, Invalidation of plans and
  packages:
    Plans bound with the ACQUIRE ALLOCATE option that refer to the
    table space will be invalidated when the MAXPARTITIONS value
    is altered.
  
  Information about this changed option will be included in the
  Information Management Software for z/OS Solutions Information
  Center (http://publib.boulder.ibm.com/infocenter/imzic) at a
  later date.
  
  ++HOLD COMMENT FOR RELEASE A10, TYPE DOC:
  PM57001 introduces the following changes to externals and the
  approximate text will be added to the V10 DB2 SQL Reference.
  This text is subject to change.
  
  Changed option for ALTER TABLESPACE MAXPARTITIONS:
    Specifies that the table space is partition-by-growth. integer
    specifies the maximum number of partitions to which the table
  | space can grow or shrink. integer must be in the range of 1 to
    4096, depending on the value that is in effect for DSSIZE and
    the page size of the table space, and must not be less than
  | the number of physical partitions already allocated for the
    table space. See CREATE TABLESPACE for more information about
    how DSSIZE and the page size are related.
  
  Information about this changed option will be included in the
  Information Management Software for z/OS Solutions Information
  Center (http://publib.boulder.ibm.com/infocenter/imzic) at a
  later date.
  

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:

  UK78522 UK78523

Modules/Macros

•    DSNXIATS DSNXIDPM
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK78522

     UP12/05/22 P F205

• R910 PSY UK78523

     UP12/05/22 P F205

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.