PM57001: ALLOW ALTER TABLESPACE MAXPARTITIONS TO A SMALLER SIZE

A fix is available

Subscribe

You can track all active APARs for this component.

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 number

    PM57001

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-01-31

  • Closed date

    2012-05-04

  • Last modified date

    2012-06-03

  • 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.



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for z/OS

Software version:

910

Reference #:

PM57001

Modified date:

2012-06-03

Translate my page

Machine Translation

Content navigation