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 Server

Showing 377

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...
8 months ago in Informix / Informix Server 0 Future consideration

Allow Bufferpool Min_lru_dirty and Max_lru_dirty Threshold values to be altered dynamically

onparams -b can be used to add a new bufferpool and AUTO_LRU_TUNING are available on informix server but first only adds a bufferpool of a new page size and the latter only kicks in if some foreground writes occur on a server which ideally is neve...
about 1 year ago in Informix / Informix Server 2 Future consideration

Ability to rotate encryption at rest keys on the Engine

Corporate security has requested us to change the EAR keys on demand as they see having the same key as a security risk. We would like to see a feature to change the .sth and .p12 files in an easier manner.
3 months ago in Informix / Informix Server 0 Submitted

Backup Individual database, not entire instance

Need a mechanism, similar to ontape, to backup a live database (as opposed to entire instance), without locking it.
over 7 years ago in Informix / Informix Server 0 Future consideration

Fixing IPA in a 15TB OLTP database or large database

We have a 15 TB size oltp db running in 12.10.FC12. We want to fix the data with pending IPA,however, we cannot use the traditional way due to : - we cannot put the DB offline for hours to fix the data with pending IPA and it will be between 5 to ...
4 months ago in Informix / Informix Server 2 Submitted
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...
almost 10 years ago in Informix / Informix Server 0 Planned for future release

Add onmode -F <type> to free only certain memory e.g. vpcache.

When having e.g. excessive vpcache usage we need to free the memory and associated shared memory segments for just the vpcache. Our use case was smx buffers to it would be even better to be able to just free the 'free' smx buffers.Trying to free a...
about 1 month ago in Informix / Informix Server 0 Submitted

Add onstat -g vpcache detail to show breakdown of usage e.g. smx buffers

. When the vp-cache grows to gigabytes we need to see why it is growing. Currently shared memory dumps have to be sent to HCL for analysis. Propose 'onstat -g vpcache detail' to show what the vpcache on each cpu vp is being used for e.g. smx buffers.
about 1 month ago in Informix / Informix Server 0 Submitted

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

Implement nested loop join of external and indexed tables

We raised a support case for this, but creating here will help it progress. The description was as shown below. Please vote for it! Doug LawryOninit Consulting Try this in the "stores_demo" database: SET EXPLAIN ON; SELECT {+USE_NL(customer)} ...
about 1 month ago in Informix / Informix Server 0 Submitted