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
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;
With the following the existing compound index is not used for the foreign key and another index is required. This adds overhead with additional maintenance. create table p1 (t char(4) not null);
create unique index px1 on p1(t);
alter table p1 ...
Informix row level auditing masks (INRW, DLRW and UPRW) can be used to audit DML operations on application tables. During batch jobs (that use temporary tables extensively) it was noted that Informix is auditing temporary tables unnecessary causin...
Whenever Informix performs a backup of the rootdbs, it automatically backs up Informix critical files (oncfg, onconfig & sqlhosts). When the Informix critical files are restored via "onbar -r -cf only -t <A TIMESTAMP>", it restores the l...
For lock spinslocks show if loops are for read or writes
When reviewing onstat -g spi for lock spinlocks e.g. Num Waits Num Loops Avg Loop/Wait Name 433407 127960809035 295243.98 fast mutex, lockhash I would be great to know if this access is for reading or writing so we can determine if this is ap...
For buffer spinslocks show if loops are for read or writes
When reviewing onstat -g spi for buffer spinlocks e.g. fast mutex, 3:bf fast mutex, 3:bhash It would be great if we could tell if this is from either: a) Read access i.e. more app caching/better query plans/more data archiving+purgin needed ...
Unable to Remove Previous Informix FC version from Windows Programs and Features
I tried to install the Informix Fix Pack in another folder as instructed by IBM support. However the Informix FC version stays the same and there is a an error or bug in uninstalling the previous Informix FC versions from the Windows Programs and ...
We are checking if we can use Informix HQ for our Production system. We have noticed Informix HQ doesn't have AD integration on it. There's not much auditing /logging on what has changed on the Informix HQ.
As per case opened with IBM 'TS005358731' , currently it is not possible to identify user created function/procedure . so kindly develop a mechanism to identify user and system related function/procedures.
Do not place IBM confidential, company confidential, or personal information into any field.