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
Ability to sync tables to HDR & RSS secondaries when converting from RAW to STANDARD mode.
It is significantly faster to load a table in TYPE(RAW) mode than TYPE(STANDARD) mode. However, this option is not practical for sites using HDR and/or RSS secondary servers for replication as RAW mode tables do not replicate forcing the site to b...
Add SQL-statement COMMENT ON as in Oracle or PostgreSQL
For some tables or columns it would be helpful to describe what the table/column is used for since the names are not always self-explanatory. Although COMMENT ON is not part of standard SQL it would be helpful to have such a statement. The DOCUMEN...
Allow triggers install/updates without taking an outage for the box
Currently to install new triggers on a table or update triggers on a table requires outage for the box which impacts our end user customer. Our operations are 24X7X365 and don't have any outage window to work with.
Just recently while working on a customer we were able to speedup a very slow query by using the recently introduced OLAP functions. The query looks like this: SELECT col1, col2, col3, col4, rank() over (partition by col1, col2 order by col4 desc)...
Consolidate free space across entire chunk or dbspace
I suggest a repack-like tool which consolidates free space in an entire chunk or dbspace in order to get few, big enough, free spaces to use efficiently. Being able to do so online and with little blocking is desirable
Temporary table only cached in the memory, it does not to write into the temp dbspace.Requirement from China mobile (CMCC), CMCC use lots of temp table in the following 2 ways:Create temp table ... with no log; select * from tab into temp tabname ...
Since Lock resource (memory) would be automatically allocated when Informix engine defect that it's not enough. But these memory will be existing forever once allocate, unless restart Informix engine. Could these automatically allocated memory cou...
Character length semantics instead of byte length semantics
We want to store UTF8 text data into our database but using byte length semantics is counter intuitive on the char and varchar types. We are using Fourj's Genero tool to develop our application and Genero is able to switch to character length sema...
For high use OLTP systems, there can be a lot of I/O pressure on the logical log due to intense rate of logical log buffer flushing (most customer don't ant data loss so they use UNBUFFERED LOG). Setting BUFFERED LOG at session level would hardly ...
Do not place IBM confidential, company confidential, or personal information into any field.