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
Increase 128 character limit for ADMIN_MODE_USERS onconfig parameter
ADMIN_MODE_USERS is a useful way of ensuring DBAs and critical monitoring scripts can connect in single user mode. Unfortunately this parameter is limited to 128 characters which is insufficient for the team we have and the three system accounts t...
Internal hash tables - remove limit on amount of data.
As per case TS006348841 currently internal hash tables have a limitation on the amount of data that can be copied into the internal hash table "At the end all the rows/columns must be copied into a hash table. And this is too much data." E.g. A gr...
When trying to reference a table which contains a BLOB data type using syntax ddbb@dbservername:table, the following error is returned: error 9270: Type (informix.blob) is unsupported in distributed queries.
When AUTO_REPREPARE is non zero only have 1 sessions recompile a stored procedure
When AUTO_REPREPARE is non zero only have 1 sessions recompile a stored procedure. Currently with many sessions executing the same stored procedure, the stored procedure can be recompiled by many sessions causing a bottleneck. A new condition is n...
Add sql causing change when dictionary entries become dirty.
When onstat -g dic entries become dirty add sql causing this to the onstat -g dic output.This would allow diagnosing issues better. This does not need to be persisted to storage. When sysprocplan entries become invalid this would also allow diagno...
Add Query Store functionality to Informix and revert to Last Good Plan
Add functionality to Informix similar to SQL Server Query Store. SQL and plans are logged to a system database. Also if a plan gets worse then the server can learn and go back to the previous query plan if still valid. This would be helpful when t...
Add ability to print deadlock infomation to the online.log. This should be possible to enable at the session level so if this is enabled for a session then if the session is involved as part of a deadlock the information will be written to the onl...
Do not place IBM confidential, company confidential, or personal information into any field.