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
create a foreign key allowing one to one tables relationships
Our Primary Key and Foreign key constraints always have allowed creaing and ensuring '1 to many' table relationships. After researching, there is no direct way to implement such a case with Informix. The only safe way is to create a primary key on...
IF NOT EXISTS should not be saved as part of stored routine source
When creating a stored procedure or function with the IF NOT EXISTS optional clause included, the option text is currently included in the saved source code for the procedure. This is not true of any other database object created with the IF NOT E...
Create and use a BTS index over a temporary table.
drop table if exists tp01 ;create temp table tp01 ( nome varchar(100) ) with no log ;insert into tp01 select first 1000 tabname from systables ; create index i1_tp01 on tp01( nome bts_varchar_ops) using bts ; select * from tp01 where bts_contains ...
Prepend machine's name to Assert files written to DUMPDIR
Scenario: The customer site uses a single network mount for DUMPDIR across hundreds of servers.
Impact: difficulty in identifying AF files generated by specific servers.
Current workaround: search online.log for all "stack trace for pid" strin...
log capture from Read only secondary / updatable secondary
Currently I can on;y read log data from primary for CDC. I woule like to request
I read the transaction logs from read only secondary server (and not primary) as Informix source for CDC and apply to target.
log_rotate sysadmin job for CONSOLE, PSM_ACT_LOG, PSM_DEBUG_LOG
There is a sysadmin job for rotation of logfiles for MSG_PATH, BAR_ACT_LOG and BAR_DEBUG_LOG.But for CONSOLE, PSM_ACT_LOG and PSM_DEBUG_LOG these sysadmin tasks are not configured/prepared in $INFORMIXDIR/etc/sysadmin/sch_tasks.sql
BAR_RETRY should retry failed dbspace backup instead of complete archive
If you run a whole onbar backup (onbar -b -w -L 0) and have several dbspaces to backup and one dbspace backup failsthe complete archive must be retried. If you run parallel backup (BAR_MAX_BACKUP > 0) you also need to wait untilall dbspaces are...
identify special columns with same meaning easily and modify data type
Use case: We want find columns with same meaning distributed over several tables easily either to modify the data type or find out the affected columns/tables only.
For example there are price/money and other columns, each with an arbitrary colum...
Do not place IBM confidential, company confidential, or personal information into any field.