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 1389 of 15639

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

Parallel I/O work on indexes for SQL Inserts.(RIMS)

it would be wonderful to have parallel I/O work on indexes for SQL Inserts. For instance, a table with 6 indexes,  A SQL insert is sent to DB2 from an app program,,, The Insert takes place on the data page, now the RID is known and can be used in...
almost 10 years ago in Db2 / Tables/Index (Range MQ MDC etc.) 0 Not under consideration

Ability to change an attribute on a cluster index(RIMS)

Verizon would like the ability to change an attribute on a cluster index without having to drop and recreate the inex. They need to avoid a rebind. IDS has this functionality. Ref PMR07542,442,000 Benefit: Verizon needs to avoid having to bring do...
almost 10 years ago in Db2 / Tables/Index (Range MQ MDC etc.) 0 Not under consideration

View invalid but be able to check if the dependant object(RIMS)

If an object that a view is dependant on (table, UDF etc) is dropped Rather than becoming permanently inoperable the view should become invalid but be able to check if the dependant object has been restored the next time it is accessed. If the dep...
almost 10 years ago in Db2 / Tables/Index (Range MQ MDC etc.) 0 Not under consideration

Allow aliases for user defined functions and stored procedures.(RIMS)

Allow aliases for user defined functions and stored procedures. This would allow an application or view to switch from one version of a routine to another without requiring a coding change.
almost 10 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.