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

If you have not registered on this portal please register at http://ibm.biz/IBM-Data-and-AI-Portal-Register . To complete registration you will need to open the email you will receive from Aha to confirm your identity.

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 offering manager 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

Db2 for z/OS

Showing 884

OPTIMIZER IGNORE INDEX indexcreator.indexname

Looking to replace NPI with DPSI. DSPI is created, and would like to verify that all SQLs that were using NPI, when Rebound/executed dynamically would either a) use either newly created DPSI or another index on the table and b) have run time ...
2 days ago in Db2 for z/OS 0 Submitted

Improve messaging surrounding the +20272 SQL warning in cases of a -904

A DBA was running an ALTER NOT CLUSTER. The ALTER should have converted the tablespace to table-controlled partitioning, but it encountered a -904. I have copied the output to "additional details".In the SPUFI output, after the -904, the ALTER dis...
3 days ago in Db2 for z/OS 0 Submitted

Eliminate IN list limitation of 32767.

Our organization has a major customer that has run up against this limitation. They have migrated from DB2 LUW and they did not have this limitation. They have IN lists that exceed 100k at times.
about 1 month ago in Db2 for z/OS 1 Under review

Allow for "OPTIMIZE FOR n ROWS" to be added to DELETE, UPDATE Statements

OPTIMIZE FOR 1 ROW can be added to SELECT SQL. One reason may be to influence the optimizer to chose one index over another, or to not perform a SORT with List Prefetch Adding OPTIMIZE FOR 1 ROW to a DELETE statement results in an error: EXPLA...
about 1 month ago in Db2 for z/OS 0 Under review

Alias for REST Services

Db2 REST services, with versioning enabled, sets the first service created via the BIND SERVICE command to be the default service.at this stage the URL and the REST service are in sync and the URL need not reference the version as DB2 will invoke ...
about 1 month ago in Db2 for z/OS 2 Delivered

QUIESCE utility: Add the functionality described in the REORG drain-spec to the QUIESCE utility

Currently the QUIESCE utility has no capability to mitigate its impact on end user application workloads like the REORG utility does via its drain-spec functionality.
about 2 months ago in Db2 for z/OS 0 Future consideration

EXPLAIN PACKAGE - Populate all EXPLAIN tables

EXPLAIN PACKAGE only populates the PLAN_TABLE It should allow for the population of explain tables
2 months ago in Db2 for z/OS 1 Not under consideration

Distributed Thread cancelled due to Idle Thread Timeout or MONITOR IDLE THREADS not writing record to SYS1.LOGREC

We noticed that every DB2 distributed thread that is cancelled because: 1) Idle thread timeout value that is specified by Db2 subsystem parameter IDTHTOIN in macro DSN6FAC is exceeded; or 2) ATTRIBUTE2 value in a row with KEYWORD value MONITOR...
2 months ago in Db2 for z/OS 0 Under review

Different Column Names for Union Query

IBM Db2 z/OS development team to allow different column names in different parts of a UNION clause, as long as their types match, and assign the column names from the first part of the UNION clause to the columns of resulting table
2 months ago in Db2 for z/OS 6 Delivered

No Implicit Runstats when running Reorg that materializes pending DDL

When a REORG is run to materialize a pending DDL change, the REORG enforces an inline statistics (RUNSTATS) even though no statistics keywork is added to the REORG statement/card. it defaults to TABLE(ALL) INDEX(ALL).This obviously can impact acce...
2 months ago in Db2 for z/OS 0 Future consideration