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
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...
Allow a DBA connection even if maximum connections has been exceeded.(RIMS)
Note from customer: Jill, We need a feature enhancement, where there is a way for a DBA to always be able to connect to the DB (at least one connection), even if maxappls, maxagents, maxwhatever has been hit. DBAs shouldnt have to force off applic...
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...
A description of Oracle's 'multi-version read consistency' can be found here: http://www.ss64.com/orasyntax/10locking.html. Even DB2's most liberal CS isolation is more strict then this. [update 04-27-2009]: Support for isolation level 3 queries t...
LOCK ESCALATION: Ability to specify table-level lock-escalation criteria.(RIMS)
Customer wants more granularity on lock-escalation semantics. currently, lock escalation occurs either when an application hit's the MAXLOCKS constraint, or when the database LOCKLIST becomes full. Since lock-escalation is more detrimental on tabl...
New access path for faster first fetch with a good global time
Firstly, I don't know if it is possible. We can encounter this following performance issue : select on a big table with an order by. Depending on the statistics, we can have list prefetchs on an index. If the index is very big, we have to wait a l...
Error DIA3202C in db2diag.log does not include database name
getting an error in db2diag.log that a connection to a database ist not possible because of a TCP/IP call does not work. In our case a connection to a remote database should be established, which was already dropped. But there is no database name ...
Do not place IBM confidential, company confidential, or personal information into any field.