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 1339

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...
about 1 year 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...
about 1 year 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...
about 1 year 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.
about 1 year 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...
about 1 year 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...
about 1 year 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

DMC stats event monitoring needs to consider built-in wlm_collect_int

DMC WLM Statistics collection is completely independent of wlm_connect_int built-in functionality. This behavior is not ideal, as the database could have been configured for that already, and the final result is that you end up with 2 independent ...
about 1 year ago in Db2 / Data Management Console 0 Not under consideration

support for Decimal128 data type in nosqljson driver

please refer to case link below https://www.ibm.com/mysupport/s/case/5003p00002mdjpkAAA/data-conversion-issue-when-loading-mongo-json-into-db2?language=en_US sample record in import file {"_id":{"$oid":"5a15e486cf8e89614439bf9d"},"dealerCode":"200...
about 1 year ago in Db2 / Db2 Connect and Drivers 0 Not under consideration

There is no method to quickly get the "minimum recovery time" of a backup image

It is not possible to get the "minimum recovery time" of a backup image without first restoring the image or by using 'db2ckbkp -l' but it is also too long as it has to read the entire backup image (this can be long if the image is stored on TSM /...
about 1 year ago in Db2 / Backup/Restore/ Rollforward/ Recover 1 Future consideration