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 Employees should enter Ideas at https://ideas.ibm.com


ADD A NEW IDEA

Search results: Informix Server

Showing 52 of 1578

Function to move sysadmin database

Product : IDS 12.10We like to have a build APIto move sysadmin database from 1 dbspace to another.Currently we are using execute function task ("reset sysadmin",);And this will reset the entire database. We found out lately, multitenant database i...
about 10 years ago in Informix / Informix Server 0 Not under consideration

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

Foreign keys to use compound indexes

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; ...
over 3 years ago in Informix / Informix Server 0 Future consideration

Foreign keys to be able to use compound indexes.

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

Enable chunk rename during log recovery

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

Implement UUID keyword/function

Implement UUID keyword and function and allow to use it in: 1. SELECT operations 2. As default value when creating a new table 3. Inside an SPL procedure/function Security is a must. Using serials or any other autoincrease numbers as ident...
about 6 years ago in Informix / Informix Server 0 Delivered

deliver customer report like Oracle AWR

Provide SQL statistics and Latch statistics for performance tuning, customer understand those information more easy. most customer don't understand the output of "onstat -g spi" .
over 6 years ago in Informix / Informix Server 1 Delivered

Lock monitor, show table name and How long has waited?

onstat -k can show table name;Can save below information when lock wait occurred.1) session id and SQL statement which hold the lock.2) How long it hold the locks. 3) Table lock information.
about 7 years ago in Informix / Informix Server 2 Not under consideration

Only update rows in referenced tables only once per template repair (with p > 0), thus avoid deadlock & LongTX

Product in Use IBM Informix 11.70UC8X6Customer Information Duane GuthrieEmail: dguthrie@cisco.com Phone: 972-813-5115Sizing info TBDProduct Enhancement Request Abstract Request to only update rows in referenced tables (t1 and t2 here) only once ...
almost 10 years ago in Informix / Informix Server 0 Not under consideration

use spatial datatypes and functions from another database

Using spatial functions is limited to the database in which it is defined. If you have to combine a spatial function with spatial data in 2 different databases you first need to convert 1 datatype to varchar. This is slowing down the performance.
over 10 years ago in Informix / Informix Server 0 Not under consideration