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 Not under consideration
Workspace Db2 for z/OS
Created by Guest
Created on Jul 22, 2021

Improve messaging surrounding the +20272 SQL warning in cases of a -904

A DBA was running an ALTER NOT CLUSTER. The ALTER should have converted the tablespace to table-controlled partitioning, but it encountered a -904. I have copied the output to "additional details".

In the SPUFI output, after the -904, the ALTER displayed DSNT404I with SQLCODE +20272, indicating that the tablespace was converted to Table-Controlled partitioning. However, this conversion was NOT done due to the -904.

We recently opened a ticket to address this. The programmer states that this is "working as designed" and insists that the +20272 was generated BEFORE the -904, despite the output from SPUFI showing it AFTER the -904. (I'm guessing this has to do with the way SPUFI is formatting the information?)

This is confusing, as the output of the +20272 after the -904 seems to suggest that conversion WAS completed, in SPITE of the -904. I think I see what the developer is saying, but I don't believe that +20272 should be set/returned to the user if the conversion fails, as the language/documentation implies a SUCCESSFUL conversion.

I am suggesting that Db2 do one of the following:

  • Not issue/set +20272 until any units of work that could affect the completion/rollback of the table-controlled partitioning complete successfully.

  • In the case of a -904 that causes a conversion to fail, provide some notification to the user (possibly in the ADDITIONAL INFORMATION area of the +20272??) that the conversion was rolled back, or replace the +20272 with another warning indicating conversion rollback.

  • Modify +20272 to indicate that conversion was attempted - the current syntax, "HAS BEEN CONVERTED" implies that the action was completed.

  • Modify documentation for +20272 to indicate that RESOURCE UNAVAILABLE conditions may cause a conversion to fail, despite the issue of this message/code.

Any of these solutions would likely be sufficient.

Needed By Not sure -- Just thought it was cool
  • Admin
    Janet Figone
    Reply
    |
    Apr 19, 2024

    Dear Mark, We are pleased to inform you that our IBM Documentation (general documentation) has been updated and can be seen here: https://www.ibm.com/docs/en/db2-for-zos/12?topic=codes-success-warning-sql

    Note, no changes were applied in the specific documentation for SQL codes +20272 or -904 because this situation where the error code is displayed first in SPUFI is not unique to those specific SQL codes.

    We appreciate your input to the Db2 for z/OS development team. And we hope that you will continue to submit enhancement suggestions for improvements as customer feedback is a key component to shaping the future direction of Db2 for z/OS.

    Sincerely,

    Db2 for z/OS Team


  • Admin
    Janet Figone
    Reply
    |
    Jan 5, 2022

    Dear Mark, Please be aware of an update from Db2 for z/OS development:

    We will update our SPUFI documentation to clearly point out the order of SQL conditions raised by an SQL statement. We do not want to change the order of how the SQL conditions are output to avoid incompatible changes. Therefore, we are not going to implement this idea, but instead, will be handle with a documentation update.

    Sincerely,

    The Db2 for z/OS Development Team

  • Admin
    Janet Figone
    Reply
    |
    Sep 29, 2021

    Dear Mark,

    Thank you for submitting this Aha! Idea. Db2 for z/OS development has reviewed it and decided to have the SPUFI documentation updated to clearly point out the order of SQL conditions raised by an SQL statement. This idea will be marked as delivered once our IBM Documentation web site is updated.

    Sincerely,

    The Db2 for z/OS Development team