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

Ideas

Compress statement text before insert in Dynamic Statement Cache

GGDB212006 'Compress' statement text of dynamic SQL statements by removing all unnecessary blanks before inserting in DSC. As a consequence statements have to be 'compressed' before comparing it to statements in DSC
almost 14 years ago in Db2 for z/OS 1 Not under consideration

Dynamic Plan Stability - Option to restabilize an invalidated query missing

We've got several SQL queries stabilized with dynamic plan stability. Reason is to prevent them from getting a bad accesspath. After operations like "ALTER TABLE ... ROTATE PARTITION..." the query is flagged to valid N in SYSIBM.SYSDYNQRY. Than we...
over 6 years ago in Db2 for z/OS 0 Not under consideration

Expand IFCID 258 to include the last available partition (based on MAXPARTITIONS) of a partitioned table spaces.

IBM already produces IFCID 258 when an extent is taken. Would IBM may consider the expansion into the last available partition to be a noteworthy event or either inform the MAXPARTITION value. So, the percentage of available partitions can be calc...
about 3 years ago in Db2 for z/OS 0 Future consideration

Violation of referential integrity - enrich the inaccurate messagetext DSNT408I for sqlcode -530 with parent <> child information

If the insert in a child table is not successful because the foreign key value does not match with a primary key value for a given relationship DB2 sends DSNT408I. Looking into this messagetext you will find only the name of the relationship. That...
about 2 years ago in Db2 for z/OS 1 Future consideration

Create a new BiF to do a real TIMESTAMPDIFF

The current scalar function TIMESTAMPDIFF is great if the difference is not over one month, then it starts guessing at how many days are involved. If you want to know the number of seconds between two timestamps it gives variously bad degrees of e...
over 2 years ago in Db2 for z/OS 1 Not under consideration

Invalid maximum timestamp value availble in DB2

Currently there is documented maximum timestamp value available in DB2 as '9999-12-31-24.00.00.000000'. However, using this value can lead to various problems which are recognized by DB2 development already as during introduction of temporal table...
over 7 years ago in Db2 for z/OS 1 Not under consideration

DSNTIAUL should support input LRECL size of > 80 bytes and not ignore input beyond the first 72 bytes

It is sometimes easy to put SQL all on one record as long as the LRECL of that record is very large. It becomes difficult to parse that SQL so it is divided into 72 byte records. Currently, the IBM utilities have input files that can have a LRECL ...
about 7 years ago in Db2 for z/OS 1 Not under consideration

Set Partition Index, DPSI to the same DSSIZE as Tablespace when converting to RPN and ALTER TABLESPACE DSSIZE is after ALTER TABLESPACE PAGENUM RELATIVE

In numerous cases it is impossible to put the ALTER TABLESPACE DSSIZE in front of the ALTER TABLESPACE PAGENUM RELATIVE due to the number of partitions and page size. Currently this only works with the following. After the reorg materialization th...
about 3 years ago in Db2 for z/OS 0 Future consideration

Allow a join of a temporal table with an archive-enabled table.

Allowing us to join a temporal table with an archive-enabled table would allow us to take advantage of both features. As is we will have to choose one or the other.
over 2 years ago in Db2 for z/OS 4 Not under consideration

SQLCODE -413: Add an ID of Column/Host-Variable

Currently SQLCODE -413 looks like this: DSNT408I SQLCODE = -413, ERROR: OVERFLOW OR UNDERFLOW OCCURRED DURING NUMERIC DATA TYPE CONVERSIONDSNT418I SQLSTATE = 22003 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNTZEXE SQL PROCEDURE DETECTING ERROR This...
over 3 years ago in Db2 for z/OS 0 Not under consideration