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 Data & AI Roadmaps (http://ibm.biz/Data-and-AI-Roadmaps) - Use this site to view roadmaps for Data & AI products.

IBM Employees should enter Ideas at https://hybridcloudunit-internal.ideas.aha.io/


ADD A NEW IDEA

FILTER BY CATEGORY

Informix

Showing 417

Identify/log slow queries on a busy system

SQLTrace offers the DBA the tooling required to monitor a user session. However its difficult to monitor heavily used systems. For example one needs to have a buffer large enough to store 90 seconds of SQL queries (small lookup SQL's consume the b...
6 months ago in Informix / Informix Server 0 Under review
104 VOTE

Obtain the query plan of a running query

Many times a DBA is called to check upon a slow process. Most of the times those processes are running a slow query.Sometimes it's hard to know if the query is using the best query plan or not. A DBA can reproduce the query, but it it was prepared...
over 9 years ago in Informix / Informix Server 0 Planned for future release

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

JDBC driver shouldn't require SSLCONNECTION to be set when SQLHOSTS is used

Currently, the Informix JDBC driver requires SSLCONNECTION=true for connection strings that involve a TLS database listener. But when SQLH_TYPE and SQLH_FILE are set, the sqlhosts file already contains this information in the protocol field; it th...
7 months ago in Informix / Informix Client Products 0 Future consideration

Improve Stored Procedures features

We are trying to increase the usage of SP in our system environment. Migrating business code from 4GL to the database.But this process becomes very painful for our developers since the support for SPL is limited. Mainly the inexistence of a native...
almost 4 years ago in Informix / Informix Server 0 Future consideration

Implement LIMIT clause in DELETE Statement

Expand DELETE syntax implementing LIMIT clause and maybe also ORDER BY. Delete syntax can be like: DELETE [FROM] tbl_name [WHERE where_condition ] [ORDER BY ...] [LIMIT row_count ] This limit + order by syntax is already implemented in other major...
over 1 year ago in Informix / Informix Server 1 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.
over 1 year ago in Informix / Informix Server 3 Future consideration

CM should support majority-vote failover arbitration as an alternative to priority-based

Currently, the Informix Connection Manager handles failover arbitration on the basis of a priority setting in the ${CMCONFIG} file. This has the effect of making a single CM the judge, jury and executioner when it comes to failover events. And it ...
7 months ago in Informix / Informix Client Products 0 Future consideration

CM should report client IP and SLA when errors occur

Our connection managers routinely log failed client attempts to connect via the CM, but when this happens, it doesn't report the client's IP nor does it report the name of the SLA via which it's trying to connect. Both of these would be incredibly...
7 months ago in Informix / Informix Client Products 0 Future 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.
over 2 years ago in Informix / Informix Server 0 Future consideration