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 Under review
Workspace Db2 for z/OS
Created by Guest
Created on May 16, 2025

RELATED IDEAS

Support REORG for DEFINE NO

See this idea on ideas.ibm.com

I have heard, in various IBM presentations (Haakon at IDUG Valencia, John Lyle at CCDB2) talking about Db2 Vnext, the statement "no migration to vnext if you have 6 byte RBA/LRSN or non-UTS tablespaces". This if fine unless you happen to have old DEFINE NO objects. You cannot REORG these to action the ALTER command as reorg is disallowed on DEFINE NO. We cannot simply INSERT a row into every DEFINE NO as this creates possibly 100's of objects which, by definition, are not really in use (Yes they can be SELECTed from !!), Reverse engineer the DDL, DROP and reCREATE, reGRANT and BIND is just a crazy amount of effort.

My idea is simply to allow REORG on DEFINE NO objects which would just set the correct bits in the catalog so that when it *would* be created it would then create a UTS space with MAXPARTITIONS 1 DSSIZE 64GB which is 100% ok, especially for a DEFINE NO dataset.

Needed By Month
  • Guest
    May 28, 2025

    Alternatively, ALTERs that would normally be deferred could be made immediate for DEFINE NO objects as the only changes are in the Db2 Catalog.

    Reply
  • Guest
    May 28, 2025

    Jorn found out that you can ALTER a DEFINE NO non UTS if it has one table within otherwise it fails (as to be expected!) it would be very very good if these "hidden ALTERs" were all documented in the SQL Guide like the BRF/RRF one already is. I have not personally tested a SIMPLE space or a Classic/Index based non-UTS Partitioned tablespace to see if this ALTER works without going into advisory REORG...

    Reply
  • Guest
    May 21, 2025

    This is already supported by IBM for BRF/RRF so I hope it is an easy change:

    • REORG TABLESPACE (One exception is if ROWFORMAT RRF is specified in the REORG statement and the specified target is an undefined table space in basic row format. In this case, REORG updates the row format definition in the catalog and directory. No data sets are defined for the table space.)

    Reply

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.