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 454 of 15475

More efficient unique indexes for monotonically increasing keys and constraints

Currently an index on a SERIAL and other monotonically increasing keys only add to the last node in the index causing the node to split into two half filled nodes. Eventually a sufficient number of nodes have so split that the index's search effic...
over 2 years ago in Informix / Informix Server 1 Not under 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 3 years ago in Informix / Informix Server 1 Future consideration

Allow INSERT to write to external tables

Currently one can only write to an external table by selecting from an existing table. There are many uses for writing to an external table that do not involved writing only the results of a SELECT query. Combined with RFE INFX-I-61, Appendable Ex...
almost 2 years ago in Informix / Informix Server 0 Not under consideration

Backups to use temp dbspaces with most closlely matching page size.

For backups store the before images it temporary dbspaces which most closely match the pagesize of the dbspace being backed up. Presumably this would be more efficent. E.g. If backing up a 16k dbspace prefer putting before images in a 16k,8k or 4k...
7 months ago in Informix / Informix Server 0 Submitted

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.
over 6 years ago in Informix / Informix Server 1 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...
over 2 years ago in Informix / Informix Server 2 Future consideration

Add sid to onstat -g tpf output

When using onstat -g tpf it would be better if sid was displayed to make this easier to tie back to a session. E.g. when looking for reverse scans on the instance.
about 1 year ago in Informix / Informix Server 0 Under review

Have another table sysesprof with reads/writes per session and bufferpool

Have another table sysesprof with reads/writes per sessioin and bufferpool https://community.ibm.com/community/user/datamanagement/discussion/error-25582-whats-a-reason-of?ReturnUrl=%2fcommunity%2fuser%2fdatamanagement%2fcommunities%2fcommunity-ho...
about 1 year ago in Informix / Informix Server 0 Not under 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 2 years ago in Informix / Informix Server 0 Future consideration

allow distributed queries when BLOBs involved

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.
about 1 year ago in Informix / Informix Server 0 Submitted