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

Showing 539

Support LIMIT clause in Common Table Expressions

Using LIMIT clause in a CTE gives a syntax error (with IDS 14.10.FC10) sf@toro (master):~/genero/devel/dbsync/dbsync$ cat x.sql WITH recent_rows AS (SELECT log_ordinal FROM dbsync_log WHERE log_table_name = 'stkitem' ORDER BY log_ordinal DESC LIMI...
5 months ago in Informix / Informix Server 0 Submitted

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.
over 4 years ago in Informix / Informix Server 0 Not under 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 2 years ago in Informix / Informix Server 0 Future consideration

Allow Informix to accept Non PAM aware clients to connect when using PAM PASSWORD mode

Standard Informix Authentication on unix will perform a getpwnam() call to retrieve the encrypted shadow password from the OS, it will then compare an encrypted version of the password supplied by the client against this, and if they match, authen...
almost 5 years ago in Informix / Informix Server 0 Future consideration

Appendable External Tables

Need an option to open/create an external table that appends to the file(s) defined on the table on insert rather than overwriting the file(s).
over 7 years ago in Informix / Informix Server 0 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 2 years ago in Informix / Informix Server 0 Future consideration

Ability to sync tables to HDR & RSS secondaries when converting from RAW to STANDARD mode.

It is significantly faster to load a table in TYPE(RAW) mode than TYPE(STANDARD) mode. However, this option is not practical for sites using HDR and/or RSS secondary servers for replication as RAW mode tables do not replicate forcing the site to b...
over 7 years ago in Informix / Informix Server 0 Future consideration

allow repack of TBLSpace extents

When a database has been created in a single (not root) dbspace and the dbspace has been greatly expanded with large tables that are subsequently moved to separate dbspace, the chunks used for original dbspace expansion may contain TBLSpace extent...
about 9 years ago in Informix / Informix Server 2 Not under consideration

Support KAIO in cooked files using 4k formated disk for dbspaces with page size multiple of 4

Currently, filesystem on hard disk with 4k sector size disables usage of KAIO feature. Request is to allow dbspaces with pages multiple of sector size (4k, 8k, 12k and 16k) to be able to use KAIO. For sure, dbspcaces with other page sizes should r...
over 1 year ago in Informix / Informix Server 0 Not under consideration

For the -12.. Conversion errors, please specify the column name.

It is quite hard to find the column that contains a wrong value in update/inserts statements with many columns in case of such an error message. For other errors the column name is in the sqlca structure. Why is it missing for the conversion error...
about 1 year ago in Informix / Informix Client Products 0 Not under consideration