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
Have a way to automatically create this table without typing this. Perhaps a 'gui' or a way to export from an Excel spreadsheet. Anything except to manually type in from a command line. Jeff Mousty State Farm during the Frequency Call with Tim Vin...
When a session is forced or rolled back, provide a facility to report percent complete (work done divided by total work). Also required for crash-recovery. It is currently impossible to determine how much longer a rollback or crash-recovery will t...
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...
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...
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...
Do not place IBM confidential, company confidential, or personal information into any field.