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:
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
Help IBM prioritize your ideas and requests
The IBM team may need your help to refine the ideas so they may ask for more information or feedback. The product management team will then decide if they can begin working on your idea. If they can start during the next development cycle, they will put the idea on the priority list. Each team at IBM works on a different schedule, where some ideas can be implemented right away, others may be placed on a different schedule.
Receive notification on the decision
Some ideas can be implemented at IBM, while others may not fit within the development plans for the product. In either case, the team will let you know as soon as possible. In some cases, we may be able to find alternatives for ideas which cannot be implemented in a reasonable time.
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...
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 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...
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...
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...
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...
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...
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...
Do not place IBM confidential, company confidential, or personal information into any field.