Skip to Main Content
IBM Data and AI Ideas Portal for Customers


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


Status Planned for future release
Created by Guest
Created on Apr 5, 2023

Indication of the reason for conversion by drop/create

In our environment, we try to execute all changes to DB2 tables online via Alter commands if possible. However, there are a lot of reasons why in some cases the Alter is not possible and as a consequence Admintool correctly chooses the conversion via Unload/Drop/Create Load/. However, in our environment these are often unintentional small things, which are sometimes also easy to correct. (e.g. new column not null must get a default, the new column is accidentally not added at the end etc.).
Therefore it would be very helpful for us if AdminTool always writes out the reason for the change via drop/create in a message. Then the executing DBA can evaluate the reason and decide whether a change of the input DDL or database model is possible or whether the WSL is executed as it is. 
Often the reason is obvious, but often it is also - especially for inexperienced DBAs - difficult to find out the cause.

Needed By Quarter
  • Admin
    Chris Pomasl
    Reply
    |
    Oct 22, 2024

    Phase II is complete and is delivered via APAR PH63723

    This phase covers:

    • None of the columns match, source vs target

    • The columns match but are in differing orders, source vs target

    • The columns are a combination of reordered, and added and/or deleted, source vs target

  • Admin
    Chris Pomasl
    Reply
    |
    Jun 21, 2024

    This will be implemented in a phased approach.

    Phase I is complete and is delivered via APAR PH61897

    This phase covers:

    • Inserting a column into the middle of a table

    • Appending a column without default



  • Admin
    Chris Pomasl
    Reply
    |
    Dec 14, 2023

    This request is being planned with a tentative target of 2Q2024

  • Admin
    Chris Pomasl
    Reply
    |
    Sep 26, 2023

    Thank you for the idea. We are still processing the details/impact for this idea, and it is taking longer than expected. Please know that we have not forgotten you.

    Db2 Administration Tool for z/OS team.