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 46

Support for common table expression (CTE)

Support for common table expression (CTE)
about 8 years ago in Informix / Informix Server 1 Delivered

SQL interface to obtain the temporary space usage (tables, hash, sorts...)

A DBA and possibly a programmer needs an easy way to monitor who is responsible for the temporary space usage.Currently it's possible a user may be consuming a lot of temporary space and impacting other sessions, without the DBA being able to quic...
over 8 years ago in Informix / Informix Server 2 Delivered

Add COALESCE function

Add a COALESCE function to Informix just like DB and many other databases have it.
almost 9 years ago in Informix / Informix Server 2 Delivered

Identify Query in IWA on the Database

I have an informix database and the IWA configured and would like to be able to map the query currently running on the IWA (ondwa tasks gives me the list) with a process on the database server. Currently all I see is the task information on the ac...
about 9 years ago in Informix / Informix Server 1 Delivered

IWA: Include session_id information in ondwa tasks output

We need a method to have a relationship between an IWA task executing or in the queue and the sessions_id on the original IDS server. I think best approach is to include the session_id value in the output of ondwa tasks, but other solutions are we...
over 9 years ago in Informix / Informix Server 1 Delivered

Allow virtual rowid columns in fragmented by range tables

Allow rowid columns in tables fragmented by range or rolling window. Syntax "WITH ROWIDS" is already working but engine throws exception: Trying to execute: alter fragment on table pepe init with rowids fragment by range(fecmov) interval(interval(...
over 9 years ago in Informix / Informix Server 2 Delivered

CTAS (Create Table As)

Implement "CTAS", i.e. the ability to create and populate a table based on another existing table. Common in other DBMSes (even Netezza!). CREATE TABLE dba1.item_new AS SELECT * FROM dba1.itemandCREATE TABLE dba1.item_new AS SELECT * FROM dba1.ite...
over 9 years ago in Informix / Informix Server 1 Delivered

syslog support for informix audit logging. or an easier mechanism to forward logs in the shortterm

We will prefer a syslog compliant logging or in the short-term an easier interface for forwarding logs (audit logs) to a centralized system. There is a new PCI/PA-DSS requirement for the financial/banking industry. To send all security logging to ...
over 9 years ago in Informix / Informix Server 2 Delivered

IWA: Adding a column in a table used on datamart shouldn't invalidate the datamart

If you alter the schema of a fact table used on datamart, adding a new column, the datamart is invalidated and you're forced to republish the datamart and reload the mart. The request is about not invalidating the datamart if you just add a new co...
almost 10 years ago in Informix / Informix Server 2 Delivered
112 VOTE

Backup from RSS or HDR Secondaries using ontape, onunload, onbar, dbexport

In HDR enviroments, being able to backup or export databases from and HDR, HDR read-only, or an RSS secondary server is critical. Programs like ontape, onunload, dbexport, and onbar generate locks on tables during backups and data-exports. This cr...
about 10 years ago in Informix / Informix Server 1 Delivered