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

Officially document DB2_SELECTIVITY=ALL parameter setting

The query compiler statement DB2_SELECTIVITY is only documented to allow setting it to either YES or NO. However, YES is quite limited as you can only use the SELECTIVITY statement on predicates that include host variables or parameter markers.Thu...
over 6 years ago in Db2 / Statements (DDL and DML) 0 Delivered

SQL0437W warning should be eliminated(RIMS)

This customer is receiving the SQL0437W warning when the DB2 optimizer changes strategies, this warning makes applications and scripts fail. He is one of many customers complaining that it makes application and script fail. This warning should not...
over 6 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

Parallel index rebuild.

Allow to send the commands create index in parallel on the same table (or any other operation which could be parallelized).
almost 7 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

Create a storage group in a specific database partition group.

After discussing with Pavel Sustr & Quentin Presley there is current no plans to for this hence the request. I'm copied the initial e-mail request. Is there any plan to allow storage group definition, in DPF, to apply to a particular dbpart gr...
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

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

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

Start Commandline-Script in Stored Procedure

It will be nice to start a Commandline-Script like test.sh from attachement in DB2-Stored Procedures.In db2 commandline call it allready works:db2 " select * from (VALUES '`sh /tmp/test.sh`') AS TEMP(Testoutput) "Commandline Result:TESTOUTPUT-----...
5 months ago in Db2 / Statements (DDL and DML) 0 Future consideration

SQL20342 error should include schema when transferring ownership

When executing a transfer ownership over a stored procedure to a user that does not have privilege over another stored procedure, then Db2 raises this error message:SQL20342N auth-ID does not have one or more required privileges "EXECUTE" on objec...
12 months ago in Db2 / Statements (DDL and DML) 0 Future 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 depend...
12 months ago in Db2 / Statements (DDL and DML) 0 Future consideration