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 Data & AI Roadmaps (http://ibm.biz/Data-and-AI-Roadmaps) - Use this site to view roadmaps for Data & AI products.

IBM Employees should enter Ideas at https://hybridcloudunit-internal.ideas.aha.io/


ADD A NEW IDEA

FILTER BY CATEGORY

Statements (DDL and DML)

Showing 86

New NOT NULL columns cannot be added to an empty table without a default value.

Submitted on behalf of Gregor Hack (ghack@zeb.de). New NOT NULL columns cannot be added to an empty table without a default value (WITH DEFAULT). Customer currently sets a dummy default value, which they drop afterwards.
over 5 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

Undo logs are unacceptably large for DELETE statements that require deletion via a cursor.

Submitted on behalf of Gregor Hack (ghack@zeb.de). Undo logs are unacceptably large for DELETE statements that require deletion via a cursor or a truncate of previously partitioned tables.
over 5 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

SQLCODE SQL0302N should give hint which parameter is too long.

Scenario: prepared statementsError: host variable too longProblem: SQL0302N should give a hint which parameter is affected. Details:Using prepared statements with parameter markers such as INSERT INTO TESTTAB (COL1, COL2) VALUES (?, ?)"); DB2 thro...
over 5 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

Improve access plan resolution for SELECT MAX() (or MIN()) statements on range-partitioned tables with local (partitioned)

Context: range partitioned table with partitioned indexes A SELECT MAX() statement is issued on a field that is not the part of the partitioned key. The query is resolved by performing a full index scan on a partitioned index on that field. That i...
about 6 years ago in Db2 / Statements (DDL and DML) 2 Not under consideration

I hope add 'UPDATE CASCADE' like 'DELETE CASCADE'.

System: BASActor: DBA and Developers.
about 6 years ago in Db2 / Statements (DDL and DML) 2 Not under consideration

Create a trigger after having created a new table

Referring to PMR 67177,650,758 Customer wish to have an "after create" option for the "create trigger" command so that is possible to execute some actions after any new object is created inside a DB
about 6 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

Allow complete acces path in optimization hint (like db2 for ZOS)

We have the same cobol application that on both z/os and luw.We are using static sql in packages. We run 12 schemas using the same sets of tables in each for manual application parallelism.Occasionally a package for a given schema will flip access...
about 6 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

Avoidance of deadlock error in DB2 partitioning environment

After our customer delete and create the original table of view table with the partitioning environment, deadlock occurs when they access the view table from each partition at the same time.The view table is invalid when the original table is dele...
over 6 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

Add invisible index

Add the possibiltity to set an index as visible or invisible so that, when it is alter as invisible, the optimizer only takes it in account when the session ask for the index
almost 7 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

DB object version control

Idea of versioning objects: UDFs, views, mqts and procedures. When we are replacing mentioned above objects with new statements we have to save old statements in notepad (or sth similar) in case if we want to return to previous version.
about 7 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration