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 309

Improve performance on multifact query on an informix database

We make Cognos reports on multifacts creating multifact queries with full outer join. To keep the query execution time low, we need absolutely the enhancement/fix be implemented in the next informix fixpack 12.10. It is unacceptable when the compe...
almost 4 years ago in Informix / Informix Server 0 Not under consideration

Make onstat -g rss log buffer(s) size configurable.

I have run onstat -g rss log and are seeing 10% cache misses on some systems. I would like the underlying buffer space to be configurable similar to etc. As per our Lab Advocate: From my interpretation of the source the information displayed on th...
almost 4 years ago in Informix / Informix Server 0 Not under consideration

Allow placement of tablespace BYTE and TEXT data in a separate dbspace from the table's base row data.

Allow specifying a normal dbspace for a BYTE or TEXT column to isolate IOs for the blob data from main row data for the table. This would be logged space just like IN TABLE as opposed to IN blobspace blob pages.
almost 4 years ago in Informix / Informix Server 0 Not under consideration

Automatic conversion of ifx_loc_t (TEXT/BYTE) to/from ifx_lo_t (CLOB/BLOB)

We have legacy ESQL/C code using ifx_loc_t to handle TEXT/BYTE columns. Customers want now to replace TEXT/BYTE by CLOB/BLOB columns in the database... and we would avoid to touch our ESQL/C code. Informix can support simple type conversion. For e...
almost 4 years ago in Informix / Informix Server 1 Not under consideration

A tmp database created with the server, analogous to the /tmp file system

In Linux systems (and in all Unix flavors) there is a /tmp directory or better, a /tmp file system. Anyone can create a file or directory in there and, in Linux, it cleared at boot time. (Other flavors use a cron job to clear out unused files.) I ...
almost 4 years ago in Informix / Informix Server 0 Not under consideration

Allow partial indexes in all editions

IDS 14.10 contains this important new feature: https://www.ibm.com/support/knowledgecenter/SSGU8G_14.1.0/com.ibm.sqls.doc/ids_sqs_partial_index.htm "Partial indexes avoid indexing common values. As the query searching for a common value wil...
about 4 years ago in Informix / Informix Server 0 Not under consideration

PN_STAGEBLOB_THRESHOLD - Set to 1Mb when first table containing BYTE or TEXT is partitioned by Round Robin

Currently, the PN_STAGEBLOB_THRESHOLD onconfig parameter is not present in the standard onconfig file, therefore it defaults to zero. It's absence also means that most DBAs will not be aware of its existence and the potential pain they are in for...
about 4 years ago in Informix / Informix Server 0 Not under consideration

Throttle writes during chunk creation

When adding chunks to an instance which is using filesystem files there can be a large amount of disk writes in a short period of time to zero out the new chunk which can impact production systems. E.g. Adding a 10GB chunk causes unacceptable clie...
about 4 years ago in Informix / Informix Server 0 Not under consideration

Multi Row Insert

Support Multi Row Insert: insert into table1 (col1, ..., colx) values (1, ..., x), ... (1000, ..., x) ; Using Multi Row Insert multiple rows can be inserted with just one statement. Other RDBMs provide this feature with a performance improvement o...
about 4 years ago in Informix / Informix Server 2 Not under consideration

Config for the server to refuse to start if shared memory segments do not use huge pages.

When shared memory segments are not using huge pages there can be performance impact I would like an option for the engine to abort startup similar to FULL_DISK_INIT=0 if huge pages cannot be used for shared memory segments. Scenario: sysmaster sy...
about 4 years ago in Informix / Informix Server 0 Not under consideration