Skip to Main Content
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

Statements (DDL and DML)

Showing 94 of 14436

Real-time statistics with statistics profile can lead to deadlocks and lock timeouts

DB2 real-time statistics facility honors RUNSTATS options specified in the statistics profile, while performing synchronous statistics collection during statement compilation. If the statistics profile contains ALLOW READ ACCESS option, this can l...
over 8 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

Urgent need for committing more frequently when using merge sql statement

Need a way a way to ensure that commits can be done more frequently during merge operations - > The MERGE statement updates a target (a table or view, or the underlying tables or views of a fullselect) using data from a source (result of a tabl...
over 8 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

Set integrity at schema level

Allow to do a set integrity at the schema level
over 8 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

optimizer choice when comparing plans in DPF

DB2 does not identify the tables as collocated even though they exist on the same set of db partitions because they reside in different database partition groups. The optimizer doesn't always make a good choice when comparing plans in DPF. With th...
almost 9 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

Allow blu and row tables to be mixed when using shadow tables

Allow blu and row tables to be mixed when using shadow tables.
about 9 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

SQL0437W warning should be eliminated(RIMS)

This customer is receiving the SQL0437W warning when the DB2 optimizer changes strategies, this warning makes applications and scripts fail. He is one of many customers complaining that it makes application and script fail. This warning should not...
about 9 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

Why isn't CLIENT_USERID special register populated correctly by default(RIMS)

The customer was looking to create a table trigger using the CLIENT_USERID special register in order to populate a column that would indicate the actual OS user that last updated or inserted a row in a table. He later found out that this special r...
about 9 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

MQTs with REFRESH IMMEDIATE need to allow more flexible definitions(RIMS)

1. MQTs with REFRESH IMMEDIATE need to allow more flexible definitions. To make MQTs feasible for an environment where quick ingest and low data latency is a priority, they cant be REFRESH DEFERRED because of the excessive locking that occurs dur...
about 9 years ago in Db2 / Statements (DDL and DML) 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.
about 9 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...
about 9 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration