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 427

CREATE MATERIALIZED VIEW

The materialized view functionality will increase the performance.
over 8 years ago in Informix / Informix Server 1 Not under consideration

'onstat -g mem' should give a complete picture of all memory usage by an Informix instance

Currently 'onstat -g mem' does not include vp cache information and some other memory structures. Similarly syspools view is missing information too.
over 10 years ago in Informix / Informix Server 0 Not under consideration

Upgrade of secondary server without restore from primary

Assuming we're upgrading a sever which is a primary server in a MACH-11 cluster, it should be able to save all the new page images (of changed pages during the conversion) in the file system. Very similar to what we do in the CONVERSION_GUARD feat...
almost 11 years ago in Informix / Informix Server 0 Not under consideration

Improve readahead performance statistic reporting

Since the improved readahead code was established, onstat -p and the associated SMI tables no longer report all readahead pages nor all usage of those pages so that it is impossible to monitor the efficiency of readahead and so be able to determin...
almost 6 years ago in Informix / Informix Server 0 Not under consideration

Make adoption of forest-of-trees indices easier with existing large tables

Rebuilding an index as a FOT is not supported using "alter fragment on index init". This would be useful to avoid dropping and later re-adding primary keys and referencing foreign keys. Building a FOT index is not possible in parallel. Building a ...
over 6 years ago in Informix / Informix Server 0 Not under consideration

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...
almost 2 years ago in Informix / Informix Server 1 Not under 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

Unload to file should have option that prevents over writing of an existing file

A customer writes some SQL that captures the pre-data to an unload file and then does the updates/deletes etc. If the SQL is successful and inadvertently run again the initial pre-data will be lost.
almost 3 years ago in Informix / Informix Server 3 Future consideration

MSG_DATE format should follow $DBDATE if defined

Several customers would like the format of the date written to online.log when we have the MSG_DATE parameter defined/activated to follow the format of DBDATE.Currently it seems to follow the American standard (MONTH / DAY / YEAR2).
over 7 years ago in Informix / Informix Server 1 Not under consideration

UTC/GMT timestamp conversion function for Informix database

Informix does not have a UTC/GMT timestamp conversion function. Requirement :---------------------------------1) Cast function to convert from a particular datetime to UTC datetime based on the current timezone2) Cast function to convert from sysd...
about 9 years ago in Informix / Informix Server 1 Not under consideration