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

Informix Server

Showing 75
104 VOTE

Informix should be able to change owner on tables and any other objects

If user=informix creates all database and all tables, then programmer creates table but user=informix cannot change it. Only drop it.
over 7 years ago in Informix / Informix Server 0 Future consideration

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...
4 months ago in Informix / Informix Server 0 Future consideration

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...
almost 4 years ago in Informix / Informix Server 5 Future consideration

Improve Stored Procedures features

We are trying to increase the usage of SP in our system environment. Migrating business code from 4GL to the database.But this process becomes very painful for our developers since the support for SPL is limited. Mainly the inexistence of a native...
about 5 years ago in Informix / Informix Server 0 Future consideration

Implement LIMIT clause in DELETE Statement

Expand DELETE syntax implementing LIMIT clause and maybe also ORDER BY. Delete syntax can be like: DELETE [FROM] tbl_name [WHERE where_condition ] [ORDER BY ...] [LIMIT row_count ] This limit + order by syntax is already implemented in other major...
over 2 years ago in Informix / Informix Server 1 Future consideration

Improve timestamp format in message and backup logs (ISO-8601)

Streaming messages to log ingestion systems, e.g. Elastic Stack, is a useful way of analysing logs and generating notifications when certain messages are seen. Displaying the messages in the right order when daylight saving switches occur is an is...
over 1 year ago in Informix / Informix Server 0 Future consideration

Allow Bufferpool Min_lru_dirty and Max_lru_dirty Threshold values to be altered dynamically

onparams -b can be used to add a new bufferpool and AUTO_LRU_TUNING are available on informix server but first only adds a bufferpool of a new page size and the latter only kicks in if some foreground writes occur on a server which ideally is neve...
about 2 years ago in Informix / Informix Server 2 Future consideration

Add columnar indexes to Informix.

Other databases e.g. DB2 have columnar index support builtin, we would like that in Informix as well. use case the same as for DB2.
over 1 year ago in Informix / Informix Server 0 Future consideration

Page limitation for single fragment, to avoid stop the business and recreate the table .

Remove or enlarge the 16,775,134 page limitation per fragment.
about 6 years ago in Informix / Informix Server 1 Future consideration

enhancements to sysprocedures table and dbschema utility

Currently, there does not appear to be anything in the sysprocedures table to identify which procedures are provided by Informix (system routines) vs those created by users (user routines). The mode column does not appear to address this particula...
over 1 year ago in Informix / Informix Server 0 Future consideration