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

My ideas

Showing 15444 of 15444

Enable/Disable Query OPT(RIMS)

Ability to enable/disable query optimization for foreign keys at a statement level. Example, many ETL (Extract, Transform, Load) processes utilize SQL statements to verify data integrity when foreign keys are not enforced. In order to return corre...
almost 10 years ago in Db2 / Analytical Functions 0 Not under consideration

Session level LOCK TIMEOUT should apply to all lock types.(RIMS)

Currently, the session-level lock timeout only applies to SQLP_TABLE, SQLP_RECORD, SQLP_KEYVALUE, and SQLP_MDCBLOCK. Customer would like this to apply to all locks acquired by the application that set the session-level timeout value.[Michael Snowb...
almost 10 years ago in Db2 / Serviceability 0 Not under consideration

Enhance Notify Log(RIMS)

Enhance the notify log to include Recovery Status, and don't split lines at 80chars.
almost 10 years ago in Db2 / Serviceability 0 Not under consideration

db2support enhancement(RIMS)

From Eric Egdorf at Verizon: It would be nice to be able to provide the db2support command with a pmr number and have it automatically upload the support file.
almost 10 years ago in Db2 / Serviceability 0 Not under consideration

New db2diag.log message to indicate when an optimizer plan is missed due to missing temp tablespace(RIMS)

(See Discussion entry for full details) When an optimizer plan is ineligible due to the non-existence of a sufficiently large temporary tablespace (ie. sort is unable to handle the width of workload row size), a db2diag.log message should be writt...
almost 10 years ago in Db2 / Analytical Functions 0 Not under consideration

Optimizer should account for bufferpool hit-ratio when estimated page access time.(RIMS)

In PMR 00962,7TD,000, Goldman Sachs had a scenario where optimizer was choosing a more expensive HSJN over a less expensive NLJN. Shu Lin summaries the problem well: 'In terms of CPU cost and number of IOs, we correctly estimate that NLJN is bette...
almost 10 years ago in Db2 / Serviceability 0 Not under consideration

Larger CLP output limit.(RIMS)

� CLP output is currently limited to 2GB.
almost 10 years ago in Db2 / Other/Unknown 0 Not under consideration

new optimizer guideline to break CSE for a specific query or as a global guideline(RIMS)

Customer encountered scenario where use of CSE resulted in degradation in query performance (details below). This requirement is to implement a new optimizer guideline that will allow customer to break CSE for a specific query or as a global guide...
almost 10 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

MOD function FF Optimizer PMR 26759;122;000(RIMS)

Calisto suggested if the MOD function FF issue is pervasive in the customer's environment, we could do an enhancement(under regvar maybe), so please ask for it. I will ask Satya to collect the stats across the partitions. The current stats shows a...
almost 10 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

QReplication - ability to add columns with default values without having to Reorg(RIMS)

When adding a column with a default value, currently one must Reorg the table before replication of that column can begin: http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.swg.im.iis.repl.qrepl.doc/topics/iiyrqsubtchgadc1.html JPMC asks...
almost 10 years ago in Db2 / Replication 0 Not under consideration