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 updateson 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,
Post an idea
Upvote ideas that matter most to you
Get feedback from the IBM team to refine your idea
Specific links you will want to bookmark for future use
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 p...
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...
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...
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...
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...
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...
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...
Do not place IBM confidential, company confidential, or personal information into any field.