Skip to Main Content
IBM Data Platform Ideas Portal for Customers


This portal is to open public enhancement requests against products and services offered by the IBM Data Platform 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

Search results: Db2 for z/OS

Showing 132 of 1093

Allow multiple ALTER PART nnn VALUES clauses in one ALTER TABLE stmt instead of SQLcode -637 error

Requirement to alter many partition limit key values for a PBR tablespace. New values come from external source so REORG REBALANCE is not suitable. With index-based partitioning it is possible to alter multiple partition limit keys in a single AL...
over 6 years ago in Db2 for z/OS 2 Delivered

Request to convert classic partitioned to UTS PBR by partition

Would like to see if it could be considered to perform an alter classic partitioned tablespace and then reorg by partition instead of the entire tablespace. While I agree it may be more housekeeping, some of the tablespaces we eventually will need...
almost 12 years ago in Db2 for z/OS 1 Not under consideration

CONCURRENTACCESSRESOLUTION (USECURRENTLYCOMMITTED) - missing UPDATE support

For a new application we decided to use BIND option "CONCURRENTACCESSRESOLUTION(USECURRENTLYCOMMITTED)". In this case we didn't expected to run into a timeout for a SELECT statement, but received the following error: DSNT408I SQLCODE = -911, ERROR...
over 10 years ago in Db2 for z/OS 1 Not under consideration

Include SYSPACKSTMT.STMT_ID in GET DIAGNOSTICS data

The SQL Standard for GET DIAGNOSTICS includes details about the actual statement being diagnosed - COMMAND_ FUNCTION / _CODE and DYNAMIC_FUNCTION / _CODE. The Db2 implementation includes none of these. Making it, effectively, impossible to identif...
over 3 years ago in Db2 for z/OS 0 Future consideration

RECOVER to A MIGRATED FLASHCOPY

We are in DB2 V10.We recovered a tablespace to a flashcopy. The flashcopy was migrated via HSM and the recover skipped to a previous copy (not migrated). The job returned return code = 04 with the message FLASHCOPY ....... FOR TABLESPACE DBHWCOPY....
over 9 years ago in Db2 for z/OS 1 Not under consideration

Temporal Join Capabilities

The table reference syntax for temporal joins needs to be expanded to include effective ways to find rows across the tables that share time affectivity.The FOR BUSINESS_TIME / FOR SYSTEM_TIME syntax does not allow for references to columns from th...
over 13 years ago in Db2 for z/OS 1 Not under consideration

Managing status of DB2 REST services

One of the really good things about the REST implementation is that it is based on static SQL. This makes it possible for us to get to know what services will be affected before we do some maintenance to one or more referenced tables. But, without...
over 8 years ago in Db2 for z/OS 0 Delivered

UNION should automatically be rewritten to "UNION ALL" when it is logically equivalent

In the following query, the developer coded "UNION". Because it is part of a "WHERE EXISTS" subselect, replacing the UNION with "UNION ALL" will perform much better and deliver the same results: SELECT * FROM PDBR111.VCLI095_SELECT V01WHERE V01.AR...
over 6 years ago in Db2 for z/OS 1 Not under consideration

DSNRXXXX tables userID case sensitive problem

Hello,This enhancement request is referenced to PMR 17878,001,862 . Please review PMR 17878,001,862 . We are using db2 10 for z/OS and external security -RACF- on this system . DB2 user's distributed connection type is JDBC / ODBC. They reach db2 ...
over 8 years ago in Db2 for z/OS 1 Not under consideration

PieceMeal Delete without coding application

During CERT (V12-CERT-2017) it was a desire amongst several customers to get a sort of imbedded COMMIT in the new piecemeal DELETE - when running from TSO attachment.-Alternatively to allow procedural language (SQL PL like) syntax in SPUFI/DSNTEP2...
over 8 years ago in Db2 for z/OS 1 Not under consideration