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 1332

DB2 CLI driver should include all public Root CA certificates

Our applications connect to DB2 using the CLI driver. For years this was not an issue until the SSL certificate expired on the DB2 server and had to be replaced. The replacement certificate was not signed with the same Root CA packaged with the dr...
11 months ago in Db2 / Db2 Connect and Drivers 0 Not under consideration

Improved functionality for tablespace fast pre-allocation

My customer is experiencing huge performance problems due to Tablespace Pre-allocation (DB2_USE_FAST_PREALLOCATION).At this time, IOCP Timeout occurs in Db2 and many tossbuffers occur in GPFS.This customer has been struggling with this problem for...
11 months ago in Db2 / pureScale 5 Future consideration

adjust card estimates on predicates using both COL = '?' and COL > <value> similar to accounting for NUMNULLS

Component: DB2 optimizer When a column is NULLable, a predicate COL = ? will account for numnulls to estimate cardinality. The problem comes when column is NOT NULL, and "the NULL value" is a real value. Peoplesoft has been designed to use a major...
12 months ago in Db2 / Other/Unknown 0 Not under consideration

Enhance correlated subquery cardinality estimate with stat views

Peoplesoft application extensively uses correlated subqueries on EFFDT to check that EFFDT = (SELECT MAX(EFFDT) FROM ...). Cardinality estimations can be derived from PK, but this sometimes is not sufficient. We need to be able to get EFFDT estima...
12 months ago in Db2 / Other/Unknown 0 Not under consideration

Db2 PureScale Spectrum Scale Package (GPFS) should include performance sensor and collector package

Dear IBM, in the Spectrum Scale distribution bundled with DB2 pureScale, the binary of mmperfmon is included but the packages for the required sensors and collectors are missing. mmperfmon is needed to identify possible performance bottlenecks wit...
12 months ago in Db2 / pureScale 1 Future consideration

Log Failed LOADS in db history file

Please refer to IBM CASE TS012541333 for further details Db2 database history file registers several SUCCESS and FAILED operations. If a backup has been executed, and if it failed or completed ok . if a restore has been done, and if it failed or c...
12 months ago in Db2 / Utilities (Export Import Load db2look etc) 2 Future consideration

Change stored procedure SYSPROC.NNSTAT to use method 2 for ODBC based nicknames

The SYSPROC.NNSTAT stored procedure uses method 1 for automatic, asynchronous statistics collection for ODBC based nicknames.This results in lack of statistics being collected, leading the optimizer to derive at inefficient access plans.
12 months ago in Db2 / Federation 0 Future consideration

allow LDAP based db2 instance user for PureScale instance creation

Right now instance creation and maintainance in PureScale (db2icrt/db2iupdt) requires that the db2 instance user is local, i.e. has an entry in local /etc/passwd and /etc/shadow. This expose a huge problem for LDAP based environments like ours whe...
12 months ago in Db2 / Installation & Upgrade 0 Not under consideration

Get sequence's NEXTCACHEREFRESHVALUE from cache.

Please see the attached word document and as our development teams are trying to retrieve the NEXTCACHEREFESHVALUE value after ALTER SEQUENCE ..RESTART and before invoking NEXT VALUE but could not able to find the way to get the value of NEXT CACH...
12 months ago in Db2 / Other/Unknown 0 Future consideration

Alert or Threshold Based on Number of Execution of SQL Query

We have noticed that customer is facing database failover issue when number of execution of any one query is very high which is utilizing all of the system resources. Is there any feasiblity of creating alert/threshold on number of execution of qu...
about 1 year ago in Db2 / Data Management Console 1 Future consideration