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 updateson 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,
Post an idea
Upvote ideas that matter most to you
Get feedback from the IBM team to refine your idea
Specific links you will want to bookmark for future use
Support DESC keyword for describing schema objects
Simple request: Support the DESC keyword commonly used by other databases as a synonym for the wordy 'INFO COLUMNS FOR'. This will help new users to Informix as well as being less to type for everybody else.
When no suitable index is created, the optimizer does an "auto create index" for the query. This proposed index should be printed out to the online.log to help the admin to create the optimized indexes for the queries.
Provide the DBA with detailed connection information
When a user connects, the information of sysmaster:syssessions, onstat -u, onstat -g ses <session ID> provide information related to username, client hostname, etc. Currently its difficult/laborious to determine the Informix listener used by...
Enhance availability of readahead performance details
With the ubiquity of intelligent storage, the value of readahead in the Informix server is reduced and excessive readahead can be detrimental to performance. However, since the introduction of the AUTO_READAHEAD parameter and the associated change...
Create an Informix-HQ sensor that populates an historical data table with the slowest/heaviest queries on an instance.
SQLTRACE has proved been a valuable resource to identify slow/heavy queries. An even sysadmin may store a history of the SQLTRACE output, it would be great to have a filter for the heaviest/slowest queries, and store them as a sensor of Informix-HQ.
We raised a support case as follows: Following the recent change in status of Centos, we have customers who wish to convert their Informix servers to Rocky Linux soon. This will be for both IDS 12.10 and 14.10. Can you confirm that IBM/HCL would s...
Do not allocate MGM memory to UPDATE STATISTICS MEDIUM/HIGH with PDQ if index is used for sort
If an UPDATE STATISTICS MEDIUM/HIGH statement with PDQ is run, Informix will allocate memory for sorts from the memory grant manager (MGM). This happens regardless of whether there is any sorting to do. If a single indexed column is specified in t...
Need an onmode option to terminate orphaned, tightly coupled global transactions. Onmode -Z does not address this case.
If a Java application that uses tightly coupled global transactions (such as from Geronimo / WebSphere app servers) abnormally terminates, it may leave the global transaction orphaned on the Informix database server. In this case, an onstat -G wil...
Our objective is not to see any sensitive data outside the production systems. As an example here is our real requirement. In a PROD environment, we can see the table data as usual . For data protection purposes, the data of the same table needs t...
Every query which need to group by and concat few columns is impossible with informix. For example for this SQL : select t.tabname, c.constrname
from sysconstraints c, systables t , outer syschecks k
where t.tabname = 'my...
over 3 years ago
Not under consideration
Do not place IBM confidential, company confidential, or personal information into any field.