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

UNION should automatically be rewritten to "UNION ALL" when it is logically equivalent

In the following query, the developer coded "UNION". Because it is part of a "WHERE EXISTS" subselect, replacing the UNION with "UNION ALL" will perform much better and deliver the same results: SELECT * FROM PDBR111.VCLI095_SELECT V01WHERE V01.A...
almost 5 years ago in Db2 for z/OS 1 Not under consideration

Recover Statistics based on Statistic History Tables

In most cases an up-to-date RUNSTATS will result in better execution plans and SQL performance. But there are also cases, where new statistics result in worser execution plans and performance. For static SQL we have many possibilities to control t...
almost 5 years ago in Db2 for z/OS 0 Not under consideration

IBM Unload to support parallelism for LOB Tablespaces

We are trying to unload large LOB tablespaces in a performant manner. Please see PMR 76429 999 866 in relation to this. IBM Unload currently issues misleading messages saying parallelism will be invoked. However this is not the case and the utili...
about 5 years ago in Db2 for z/OS 1 Not under consideration

Allow the alteration to another bufferpool (with the same page size) for a specific partition.

When deciding on which bufferpool to place a tablespace in, I have found that different partitions have different requirements. when the "hotspot" of a table (that would benefit by being in a larger bufferpool) is at the end, putting the last part...
about 5 years ago in Db2 for z/OS 1 Not under consideration

Enhance Runstats when using profiles

RUNSTATS enhancement - an execution of RUNSTATS with REPORT YES would provide the actual and complete information in the PROFILE_TEXT column of the SYSIBM.SYSTABLES_PROFILES row for the table of interest without executing the stats. Also, when act...
about 5 years ago in Db2 for z/OS 0 Not under consideration

Full length of timestamp not seen in data studio

We are not able to see the full lenght of a timestamp when running a sql select agains a db2 table using data studio.DS is only showing 29 characters. the total lenght of the field is 32 characters. Column is declared timestamp 13 in DB2. I can r...
about 5 years ago in Db2 for z/OS 0 Not under consideration

DB2 z/OS LOAD utility fail in utilinit holds UTUT status

LOAD REPLACE LOG(YES) fails due to share locks/claims being held on tablespace but leaves tables in UTUT status which makes in inaccessible. Suggest that the UTUT is removed or changed to UTRW and can attempt UTUT again upon restart of the utility...
over 5 years ago in Db2 for z/OS 0 Not under consideration

Db2 FCIC should provide option to avoid taking long time with IGD17291I message

Please refer to the existing RFE ID 126885, "FCIC JOB takes long time with msg IGD17291I", opened from z/OS (DFSMS DSS) side, also. The data amount will be extremely increasing in our customer. To minimize data unavailability, they are trying to...
over 5 years ago in Db2 for z/OS 0 Not under consideration

Allow multiple ALTER PART nnn VALUES clauses in one ALTER TABLE stmt instead of SQLcode -637 error

Requirement to alter many partition limit key values for a PBR tablespace. New values come from external source so REORG REBALANCE is not suitable. With index-based partitioning it is possible to alter multiple partition limit keys in a single AL...
over 5 years ago in Db2 for z/OS 0 Not under consideration

Message when IFI interface and monitor traces are disabled due to errors

When the IFI abend count reaches some hardcoded number which is not externalized this results in the disabling of all IFI request and MONITOR trace processing. Then when an application tries to use IFI it receives 00E60831 but the msg only goes to...
over 5 years ago in Db2 for z/OS 1 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.