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

RUNSTATS DIRECTORY (DSNDB01) TABLESPACES

Till now (DB2 12) it is not allowed to run RUNSTATS on the directory tablespaces.Because of features like LOB COMPRESSION or SPT01 COMPRESSION it is strongly recommended to have the possibility to run RUNSTATS on the directory tablespaces. We have...
about 7 years ago in Db2 for z/OS 1 Not under consideration

Provide N-Access for IN-lists containing non-column-expressions

Hi SAS-Queries of generate queries containing the following type of predicate:IN (YEAR(CURRENT DATE – 1 YEAR), YEAR(CURRENT DATE))Unfortunately this expression is not indexable
about 7 years ago in Db2 for z/OS 0 Not under consideration

CREATE or REPLACE VIEW

After a DROP Table the view still exists, but it will only be invalidated;when the base-table is re-created any references to view will re-validated. Privileges for the View are still valid. This mechanism already works for DB2 for LUW where one c...
about 7 years ago in Db2 for z/OS 2 Not under consideration

256 VLDB2012 - DB2 command addition -DISPLAY SCHEMA

DB2 commands need to be improved in many aspects to provide additional usability, functionality and detail. -DISPLAY SCHEMA This would provide identical functionality to -DISPLAY DATABASE but with qualifiers based on SCHEMA and TABLE/INDEX (OBJECT...
about 7 years ago in Db2 for z/OS 1 Not under consideration

V12-CERT-2017 - Support for Range-list index Scan in rowset Cursors

Range-list index scan is not supported for a cursor with rowset positioning. Rowset positioning is very popular as multiple fetch is very efficient for reading several rows from a result set. Range-list index scan is very efficient for SQL paginat...
about 7 years ago in Db2 for z/OS 1 Not under consideration

V12-CERT-2017 - Stop predicates in Range-list index scan (Accesstype NR).

Range-list index scan is a very efficient access for SQL Pagination. Whatever we use DB2 11 Syntax: Where ((Col1 = ? AND Col2 >?) OR Col1 > ? ORDER BY Col1, Col2 Or DB2 12 Syntax: Where (Col1, Col2) > ( ?, ?)ORDER BY Col1, Col2 In both ca...
about 7 years ago in Db2 for z/OS 1 Not under consideration

Support Logical Partition Numbers

Due to the new V12-feature of insert partition the need to support logical partition is growing. We want to specify logical partition numbers where ever physical partition numbers can be specified.
about 7 years ago in Db2 for z/OS 1 Not under consideration

Reorg Rebalance should consider available pages (FREEPAGE, DSSIZE)

Reorg Rabalance should not always distribute the rows evenly across the partitions, but instead should also take into account the available space, e.g. if the partitions have different DSSIZE distributing the rows evenly is not feasable. The same ...
about 7 years ago in Db2 for z/OS 1 Not under consideration

DB2 lock escalation should be able to break-in into UOW running REL(DEALLOCATE)

At DB2 12 CERT (V12-CERT-2017) we discussed the following scenario : Changing CICS work to run REL(DEALLOCATE) from REL(COMMIT) was made possible in DB2 11 as BIND and DDL can now break-in. The change should give a CPU-reduction. However running b...
about 7 years ago in Db2 for z/OS 0 Not under consideration

DB2 SQLCA feedback field indicating if this UOW is blocking others

On DB2 12 CERT (V12-CERT-2017) we discussed the possibility of increasing concurrency in DB2. In a typical batch environment we try to balance #of commits towards concurrency using a so-called commit-control-system that will have COMMIT on a numbe...
about 7 years ago in Db2 for z/OS 1 Not under consideration