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
Different message when transaction time limit reached
When transaction duration limit is reached the following message occurs in the online log file 08:56:28 sid 11617 - email@example.com - pid 6811 terminated because session transaction duration (60 seconds) has exceeded limit. This session i...
Allow SPL variables to be used to define index directives.
Inside a stored procedure allow the index name for a directive to come from a variable:...define v_bs_index varchar(100);define p_id like tBS.id,...let v_bs_index = ( select cfg from Cfg where group = 'INDEXES' and name = 'TBS_INDEX' )...
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...
I would like the ability to create database/SPL's using Informix 4GL syntax and features. I know forms and such wouldn't work but I could then leverage legacy into efficient data retrieval processes for for Java and Typescript to access
I would like the ability to define a global statement and global cursor that can be shared between routines within a single session. This would allow for modular code and create tremendous increases in performance and memoory usuage
We would like to use incremental backups with 'onbar'. However this is difficult because we use storagepools and chunks can be added at any time. Once a chunk has been added this forces a L0 backup of at least the dbspace concerned and the root db...
L0 and L1 backups of informix are taking almost same time since it seems that is limited by disk reading performance: we are using IBM spectrum backup to backup.
From IFX logs we see that they are using /usr/informix/server12/bin/onbar_d...
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...
Need a function or pseudo-field to return the number of elements in a BSON array
Put in simplest terms, if I have a JSON/BSON record with an embedded array, I need to know how many elements are in the array. I need a function similar to bson_size() (which returns the string length of the total array) which instead returns the ...
In the below the foreign key does not use the compound index. Another index is created with adds overhead. create table p1 (t char(4) not null);
create unique index px1 on p1(t);
alter table p1 add constraint primary key (t) constraint p1_pk;
Do not place IBM confidential, company confidential, or personal information into any field.