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
VARCHAR_FORMAT/TO_CHAR function does not support timestamp formatting using brackets(RIMS)
PMR 28054,020,649 Customer is moving from Oracle to DB2 and under their Oracle applications they are using the TO_CHAR function. That function works in DB2 under the name of VARCHAR_FORMAT or TO_CHAR. The following TO_CHAR function is not working ...
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...
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...
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...
Do not place IBM confidential, company confidential, or personal information into any field.