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

Clear

Db2 for z/OS

Showing 1067

Add and drop include columns to/from unique index as a pending change

To accomplish high availability for schema changes in a 24/7 environment, an addition of an Include Column to a unique index should be implemented as a pending change that is materialized by an online REORG. Dropping an include column from a uniqu...
over 10 years ago in Db2 for z/OS 0 Future consideration

SQLCODE -180 (invalid date/time) - add identifier for hostvariable.

When it comes to SQLCODE -180 (invalid value for date/time/timestamp) due to wrong data in an input-hostvarible currently DB2 issues following SQLCODE: SELECT * FROM SYSIBM.SYSTABLES WHERE CREATEDTS = ? Hostvariable holds 'SCHUBIDU' DSNT408I SQLCO...
about 8 years ago in Db2 for z/OS 0 Not under consideration

Allow for clear text NEWAUTHID in SYSIBM.USERNAMES

We use SYSPROC.DSNLEUSR to encrypt usernames and passwords that are stored in the DSNLEUSR table, The procedure encrypts both NEWAUTHID and PASSWORD. It becomes difficult to manage the SYSIBM.USERNAMES table as we cannot see the NEWAUTHID in clear...
6 months ago in Db2 for z/OS 1 Not under consideration

extend MERGE syntax to allow Common Table Expressions (CTE)

The MERGE SQL statement is a new favourite SQL statement. But I also like to use Common Table Expressions (CTE). CTE can be used in other type of SQL (mostly SELECT) but CTE is not allowed with MERGE What is my idea? Allow MERGE to use CTE. I...
about 6 years ago in Db2 for z/OS 5 Not under consideration

SQLCODE IFI

The IFI interface is very useful for Performance analysis. But for RAS work it would be even better if any unusual SQL code was externalized in a new IFI record.
almost 10 years ago in Db2 for z/OS 2 Not under consideration

Drop STP SQL with dependency of other STP SQL type NATIVE

We have a general purpose StoredProcedure (STPX1) that is called by other native StoredProcedures (STPA1, STPA2, STPA3, etc) that have CALL statements to STPX1, If I need DROP the STP STPX1 (for recreate later) I receive the error -478 for depende...
about 5 years ago in Db2 for z/OS 0 Not under consideration

DB2 should provide a built-in stored procedure for sending emails

Other DBRMs including DB2 LUW provide built-in options to send an email by calling a stored procedure. DB2 for zOS doesn't support that.
about 6 years ago in Db2 for z/OS 4 Future consideration

Reduce restrictions of ADD PARTITION

“ALTER TABLE ADD PARTITION” is not available when target table holds uncommitted(not materialized) definition change. In most cases “MAXVALUE” is selected as limit key value because Partitioned-Table of TABLE-CONTROL cannot hold data exceeded the ...
6 months ago in Db2 for z/OS 2 Not under consideration

Improve the flexibility of changing PARTITION key

When to change PARITITION keys in multiple PARTITIOIN, a validation routine to check the data consistency runs every time ALTER command (ALTER TABLE ALTER PARTITION) is executed. In most cases we change the key value for multiple PARTITION keys an...
6 months ago in Db2 for z/OS 1 Under review

Preventing DBD Lock when changing PARTITION key

There’s a possibility that status becomes AREOR when PARTITION key in PBR is changed by “ALTER TABLE ALTER PARTITION”. We strongly request you to revise the function NOT to set DBD Lock at this moment. It’s hard to say that changing PARTITION key ...
6 months ago in Db2 for z/OS 0 Future consideration