IBM Data and AI Ideas Portal for Customers
Hide about this portal


This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).


Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:


Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,


Post your ideas

Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the IBM team to refine your idea


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

IBM Employees should enter Ideas at https://ideas.ibm.com


Add a new idea Subscribe
Status Planned for future release
Workspace Db2 for z/OS
Created by Guest
Created on Mar 11, 2019

RELATED IDEAS

Drop partition in UTS PBR RPN tablespaces

See this idea on ideas.ibm.com

Dropping partitions in a tablespaces can only be done by dropping and re-creating the entire tablespace

In earlier versions of DB2 for z/OS you could not add partition to an existing tablespace. Consequently we created about 60 tablespaces with 254 partitions each. We thought we would need them in a few years. We use only about 30 of the partitions now (13 years later). The administration and maintenance of these redundant partitions take a lot of time and effort and more datasets than actually needed has to stay allocated.

We need the ability to drop the redundant partitions by an ALTER statement. In our current case the redundant partitions are at the end of the tablespaces and no adding or rotating of partitions has been conducted, so dropping partitions at the end of the tablespace is our primary requirement. In the future we probably will need this functionality to be enhanced to any partition in the tablespace and regardless of previous rotations and additions of partitions. This may be the case if we in our Data Warehouse decide to keep less history data.

  • Admin
    Janet Figone
    Reply
    |     Mar 27, 2025

    Status correction applied, as the full solution is not yet delivered.

  • Guest
    Reply
    |     Mar 26, 2025

    I see that this idea to add the capability to drop a partition has been closed as "Delivered".   What APAR/PTF delivers this capability?  

  • Guest
    Reply
    |     Aug 15, 2022

    We also have the need to be able to drop a partition from a range-partitioned tablespace. When we try to rotate partitions of an archive-enabled PBR tablespace Db2 requires us to disable archiving before the rotate then re-enable archiving after the rotate. However, when we re-enable archiving we cause a deadlock with CICS and the online transaction fails. In order to prevent the deadlock we have stopped rotating partitions and are just adding a new partition at the end of each month and emptying out the oldest one. Since we cannot drop the old partition we will end up with many empty datasets from the partitions that we should have been able to rotate out.

  • Guest
    Reply
    |     Dec 13, 2021

    To have that option (to delete limits of partitions in PBR tables) available, is very important to us.

    Presently, customer we support have 300+ PBR tables, the partition key is the MVS ID, and from time to time (1 to 2 years) customer delete LPARs, coalesce others, and divide some of them in two.

    For the new LPARs we are able to add the partition limits, but what about the deleted ones?

    We are in a situation where more partitions exists on the tables, than LPARs exists

    Until now we faced no problems with that, but in the future? Who knows...

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.