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 431

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 genBSON to process a MULTISET datatype

Our problem is to get complex data from the server in the fastest way. Usually, getting data from a parent -> child relation ships, should be done programatically iterating thru multiple resultsets and getting data one by one. Network overhead ...
almost 4 years ago in Informix / Informix Server 0 Future consideration

Perform update statistics based on selected Fragments of a table

This idea is to run update statistics based on selected fragment(s) to refresh table update statistics on latest or selective fragments only. As there are considerable number of fragmented transactional tables are located under current databases t...
almost 4 years 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...
about 4 years ago in Informix / Informix Server 6 Future 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