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 781

New Access Type to Support Table Changes

Problem statement/ pain point: When making changes to Db2 tables there are times when you need to put the table space into a read only status to prevent update from occurring but allow the users the most time with the table being changed. The prob...
about 5 years ago in Db2 for z/OS 1 Not under consideration

I/O required for RI check against the parent table when inserts done on the child table.

We have noticed that there is a high number of get pages on the parents indexes when doing an INSERT of a child row. Here are the details of our situation: The parent table has a partitioned primary key index with 132 partitions....
about 5 years ago in Db2 for z/OS 0 Not under consideration

Drop Databases Created by Implicit Mapping Tables

Problem statement/ pain point: We have started to use on-line reorgs without specifying the mapping table because v11 will generate one for you. Pretty cool. Db2 will create a database, DSNnext_db_identity_number, create a table space, create the ...
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

Drop partition in UTS PBR RPN tablespaces

Dropping partitions in a tablespaces can only be done by dropping and re-creating the entire tablespace In earlier versions of DB2 for z/OS you could not add partition to an existing tablespace. Consequently we created about 60 tablespaces with 2...
about 5 years ago in Db2 for z/OS 2 Not under consideration

Labelling a column changes access path

With table TB1(COL1, COL2, COL3, COL4) and index IX1(COL1, COL2, COL3), query: SELECT COL1, COL2, VARCHAR(COL3) COL3, COL4 FROM TB1 WHERE COL1 = ? AND COL2 = ? ORDER BY COL1, COL2, COL3; requires sort even though the order by is following ...
about 5 years ago in Db2 for z/OS 2 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

Enhance ALTER INDEX that columns can be reordered without drop and recreate

Recently we had a major incidence in production because an automatic bind happened after the drop of an index of a very big table and before the recreate of that index, although the Create used the Option DEFER YES. We wanted to reorder some colum...
about 5 years ago in Db2 for z/OS 4 Not under consideration

Expand loading size of static SQL statement to SPA from 4000 byte to 2MB.

[Request] Expand loading size of static SQL statement to SPA from 4000 byte to 2MB.Guardium S-TAP for Db2 on z/OS uses SPA(Space Block) to capture executed static SQL statement. Currently static SQL statement is loaded only first 4000 bytes of th...
about 5 years ago in Db2 for z/OS 0 Not under consideration

Incorporate Query Monitor Style Capture Into Base Db2 Product

Incorporate Query Monitor-like data capture into base Db2 product. This would greatly improve the stability of DB2 itself and might provide IBM supported API to the tool vendors.
about 5 years ago in Db2 for z/OS 1 Not under consideration