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

Showing 1392

Breakdown of Estimated performance gain percent value for each Recommended Indexes (Used in Plan = "Y") in WhatIf Analysis

As per attached screenshot, there are 4 recommended indexes together provide 42.62% of Estimated Performance again if they are created. Its not possible to pick any one or two indexes instead of all the four indexes. If 1 of the 4 recommended inde...
7 months ago in Db2 / Data Management Console 0 Submitted

Full support for aggregate function with DISTINCT in OLAP SPECIFICATION

Use of DISTINCT with e.g. COUNT function in OLAP specification (PARTITION BY clause) returns error SQL0441N (SQLCODE -441). Due to the fact that Db2 does NOT support the use of DISTINCT option in such cases, we have a major impact with COGNOS gene...
over 3 years ago in Db2 / Statements (DDL and DML) 0 Future consideration

Remove Group Based Access Limitation

Description of Limitation: IBM has defined a few limitations with role based access which include the following: A role cannot own database objects. Permissions and roles granted to groups are not considered when you create the following database ...
about 2 years ago in Db2 / Security 2 Future consideration

Provide a documented and supported procedure to generate ddl (db2look as SP - like db2lk_generate_ddl)

db2lk_generate_ddl is a stored procedure that provides functionality to generate DDL via SQL (similar to db2look which is a tool as db2llok cannot be executed througha SQL client tool. This function already exists but is not documented and I am no...
over 5 years ago in Db2 / Utilities (Export Import Load db2look etc) 2 Not under consideration

Enable classic reorg with "allow write access"

Many customers want to REORG their tables quickly and efficiently. The classic REORG is by far the fastest option but puts the table in read only mode. Inplace reorg allows write access but is much slower and not suitable for tables that have a hi...
almost 8 years ago in Db2 / Utilities (Export Import Load db2look etc) 3 Future consideration

IBM Infosphere Data Replication Management Console – DB2 LUW LOAD Utility.

Change Data Capture (CDC) Subscriptions mirroring from DB2 LUW to Event Server (JMS) are constantly failing due to some LOADs performed on DB2 LUW side. We must manually recycle affected LOAD table whenever they fail to restart the subscriptions f...
about 1 year ago in Db2 / Replication 1 Submitted

Switch the "IBM Data Server Client" over to an MSI installer for Windows machines

Currently the installer uses an ancient InstallShield installer that is a nightmare to roll out. It would be nice if it could be transitioned over to an MSI installer because those are easier to uninstall and roll out.
over 1 year ago in Db2 / Db2 Connect and Drivers 0 Under review

Decouple archive log purging from BACKUP utility

For databases using AUTO_DEL_REC_OBJ, at the end of the BACKUP utility there is a synchronous process which purges any history records and their associated archive logs. This can take a very long time on busy systems. It is necessary to decouple t...
about 7 years ago in Db2 / Backup/Restore/ Rollforward/ Recover 1 Future consideration

Allow parallel offline table reorg of range partitioned tables with non partitioned indexes (NPI)

Offline (classic) table reorgs might still be necessary in certain scenarios and can run for a very long time for huge tables (>24h). It is very hard to find a suitable window in a 24x7 System. Offline table reorgs - which have at least one non...
about 1 year ago in Db2 / Tables/Index (Range MQ MDC etc.) 0 Future consideration

Use package collection other than NULLID for CLP and Db2 Utilities

Db2/zOS colleagues want to get rid of lock issues with rebind of packages in schema NULLID, thus the decided to have Db2/zOS release specific package collections to provide actual and rebound packages for every Db2 release to the distributed (Db2/...
over 3 years ago in Db2 / Utilities (Export Import Load db2look etc) 1 Not under consideration