IBM Data and AI Ideas Portal for Customers


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:

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

Help IBM prioritize your ideas and requests

The IBM team may need your help to refine the ideas so they may ask for more information or feedback. The product management team will then decide if they can begin working on your idea. If they can start during the next development cycle, they will put the idea on the priority list. Each team at IBM works on a different schedule, where some ideas can be implemented right away, others may be placed on a different schedule.

Receive notification on the decision

Some ideas can be implemented at IBM, while others may not fit within the development plans for the product. In either case, the team will let you know as soon as possible. In some cases, we may be able to find alternatives for ideas which cannot be implemented in a reasonable time.

Additional Information

To view our roadmaps: http://ibm.biz/Data-and-AI-Roadmaps

Reminder: This is not the place to submit defects or support needs, please use normal support channel for these cases

IBM Employees:

The correct URL for entering your ideas is: https://hybridcloudunit-internal.ideas.aha.io


ADD A NEW IDEA

FILTER BY CATEGORY

Statements (DDL and DML)

Showing 77

allow "COMMENT ON" statement to add comments longer than 254-char to 2000

254-char long field too small to store comments attached to added objects (views, nicknames, columns, indices) when apps migrated from ORACLE to DB2
almost 7 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

Improve poor query compilation performance due to long lock list traversal in DB2 10.1 and later

Beginning with DB2 LUW 10.1 DGTT-referencing DML started to take catalog locks and therefore we have to free them and potentially traverse long lock chain if the DML is a part of a long-running transaction potentially holding millions of locks. Th...
almost 7 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

Reorg pending after three ALTER TABLE statements is not useful in 24x7 environment

After three ALTER TABLE statements (depending on the clause, but an error can be forced by changing type from VARCHAR to CHAR ) table switches into reorg pending state. This state can only be resolved by an offline reorg.Additional problem is that...
almost 7 years ago in Db2 / Statements (DDL and DML) 2 Delivered

DB2 LUW to have option to ignore QUERYNO clause of SQL on DB2 z/OS

The client has many SQL for z/DB2 production environment with QUERYNO clause like the following sample.    SELECT /* Comment */           A_ID,           A_NAME       FROM           A_MASTER       WHERE          Â...
almost 7 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

need to provide a RENAME SCHEMA statement (other database products provide this)

Need RENAME SCHEMA other databases other than DB2 LUW (i.e. MaxDB from SAP) provide a statement RENAME SCHEMA to rename a schema like a RENAME TABLESPACE/TABLE/INDEX. Needed on all supported operating systems.
almost 7 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

More heavy use of fetch first n rows to optimize the statement

see attachments (error of the server when submitting the RFE)
about 7 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

Intermediate commit in singleton delete / insert / update

Add a new WITH clause to store the commit interval which will triggers intermediate commits in the mass delete / insert / update.
about 7 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration