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 958

Allow alter column to drop NOT NULL constraint

Currently the only way to remove the NOT NULL constraint from a column is to unload the table, drop-recreate table (or drop-add column) and reload table. Such a small change needs so much effort, and causes unnecessary outage and service disruptio...
about 2 months ago in Db2 for z/OS 0 Under review

Way to tell if a Db2 view is not being used any longer

We are looking for a solution to tell if a Db2 view is still used or not.A request came to our team to rename a column in several tables. One of the tables have multiple view on it, and one of the view includes the column to be renamed. We cannot ...
3 months ago in Db2 for z/OS 1 Under review

Enable use of DSN_PROFILE* tables global variables for local workload

At the following link, we see global variables can be used with profile tables. https://www.ibm.com/docs/en/db2-for-zos/12?topic=connections-setting-built-in-global-variables-profile-tables However, there is a sentence that mentions the following:...
over 1 year ago in Db2 for z/OS 0 Future 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

RLF DSNRLMTxx table field RLFIP allow subnet wildcard

we have a need to restrict threads with RLF by specifying userid and source IP with a subnet wild card. the source ips change with each "logon". In order to restrict all possible ips under a given subnet, we would need to enter 255 X 255 ips. allo...
over 2 years ago in Db2 for z/OS 0 Future 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

Client IP Address from Db2 connect server

We use Db2 Connect as a gateway to access Db2 z/OS. We have several situations where a user connects to Db2 z/OS using an invalid password and the user is revoked. On the Db2 z/OS side, only the Db2 Connect IP (gateway) is registered. I would need...
about 3 years ago in Db2 for z/OS 0 Future 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

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.