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 Employees should enter Ideas at https://ideas.ibm.com


ADD A NEW IDEA

Db2 for z/OS

Showing 777

Give the option to make an index "invisible" to DB2

Sometimes, when I have added and index, I have had some surprises in the optimizer using that index when it should not. I would like a quick way to make the index "invisible" to the optimizer and make it not eligible for access paths until I speci...
over 6 years ago in Db2 for z/OS 1 Not under consideration

Enhancement request to turn off DB2 security

Could we get a ZPARM that allows the deactivation of DB2 security in favor of a security product (ie. RACF). It would be nice if RACF was the ONLY authoritative source for security requests. Currently if a result isn't returned by RACF, DB2 checks...
over 6 years ago in Db2 for z/OS 1 Not under consideration

Modify DSNJU004 to print all information stored in a Db2 BSDS

Not everything that resides in a BSDS can be printed via this utility. However several items are stored in the BSDS that we need to go to several other places to get the information
about 2 years ago in Db2 for z/OS 1 Not under consideration

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: EXPLAIN A...
almost 3 years ago in Db2 for z/OS 1 Not under consideration

DB2 Z/OS Sync Logical and Physical Parts after full Reorg

ADD PART was used to insert a new physical partition in the middle of a tablespace. Now the Logical and Physical partitions are mismatch. If a Full Reorg on the full tablespace is performed, the utility can include an option to resync the logical ...
about 3 years ago in Db2 for z/OS 1 Not under consideration

Simplify Alter

In Db2 z/OS version 10 Pending Alters/Deferred Alters were introduced. Deferred Alters are not compatible with most Immediate Alters. Deferred Alters need materializing REORG before immediate Alter, or the Immediate Alter has to be run before...
about 4 years ago in Db2 for z/OS 0 Not under consideration

Have GET generate a useful Swagger doc for REST services that call native SQL SPs

Within a REST client like Postman or SoapUI, you can call the URI for a Db2 REST service with the GET command and the client will, from information passed to it from Db2, build a Swagger document that describes the data being sent to/from the REST...
almost 5 years ago in Db2 for z/OS 3 Not under consideration

Stop of utilities during migration except for SYSADM

During Migration it would be nice to turn off all utilities through a DB2 issued online command except for utilities submitted by SYSADM. This would guarantee that utilities would not be able to run during the migration on any datasharing member b...
over 5 years ago in Db2 for z/OS 1 Not under consideration

CAF plan name new feature

There are applications that have hardcoded the plan name in their programs using CAF. In some cases, it is wide spread that it will take a lot of work coding and testing due to program change. To avoid the cost of coding and testing, can there be ...
over 5 years ago in Db2 for z/OS 1 Not under consideration

Allow for an option in the syntax of a (compiled scalar) SQL function to use RELEASE(DEALLOCATE).

Thread reuse and High performance DBATs are dependent on packages being bound with RELEASE(DEALLOCATE). But, there is no provision for the package associated with compiled SQL scalar functions to have RELEASE(DEALLOCATE) as an option. I have been ...
almost 6 years ago in Db2 for z/OS 0 Not under consideration