Informix Server

Showing 428

Allow indexes to be made invisible to queries

When removing unused indexes the first step we want is to be able to make index invisible to queries similar to the Oracle feature. As the index is still being maintained the rollback to make the index visible to queries is quick.

almost 3 years ago in Informix / Informix Server 2

1 VOTE

Add sql causing change when dictionary entries become dirty.

When onstat -g dic entries become dirty add sql causing this to the onstat -g dic output.This would allow diagnosing issues better. This does not need to be persisted to storage. When sysprocplan entries become invalid this would also allow diagno...

6 months ago in Informix / Informix Server 0 Not under consideration

2 VOTE

Create a replicate table between a single instance and the root node of a Sharding

Why is it useful? It is useful because it allows archiving of very large tables. This is useful for achiving of big tables. Addicionally, it allows higher performance to the applications, since the data is distributed in several nodes. Who would b...

11 months ago in Informix / Informix Server 0 Not under consideration

3 VOTE

Smart Trigger API for Java to monitor smart trigger session changes at the backend DB

The Smart Trigger Java library allows for the use of a detachable session which is assigned a session ID. One can use this session ID to reconnect to an existing session when starting up a Smart Trigger. But, if for some reason this session ID in ...

over 1 year ago in Informix / Informix Server 1 Not under consideration

9 VOTE

Allow Informix to kill sessions not only limited by session-id

Informix should be able to kill sessions not only limited by session-id:For example: If a admin should kill sessions from a specific user or host a script is needed. So it would be helpfull if onmode -z would accept following syntax for example:$ ...

over 4 years ago in Informix / Informix Server 0 Not under consideration

7 VOTE

Add onconfig parameter to not allow slow alters.

Add an onconfig parameter so that slow alters are not allowed by default. This is to prevent outages for customers from long transaction rollbacks.

over 3 years ago in Informix / Informix Server 0 Not under consideration

1 VOTE

oncheck should report all bad rowids in an index.

oncheck should report all bad rowids in an index. Current oncheck stops at the first bad rowid, this makes it impossible to tell if there is more than 1 bad rowid in an index.

6 months ago in Informix / Informix Server 0 Not under consideration

5 VOTE

Evaluate using io_uring for I/O in Informix Linux Platform

Create some performance tests and evaluate an architecture change in Informix to migrate AIO or Kernel AIO to using kernel io_uring Maybe it's not possible to use io_uring in Informix and nowadays, performance increase from using IO_DIRECT KAIO to...

over 2 years ago in Informix / Informix Server 0 Future consideration

6 VOTE

Allow DDL changes on a table with full row logging

We want to use CDC to replicate data changes to a different system. We do schema changes once a month, and this complicates things a lot. According to our vendor, this is a limitation for Informix only, other source systems can hande DDL changes t...

almost 3 years ago in Informix / Informix Server 0 Future consideration

1 VOTE

Enhance onstat -g prc information

Enhance onstat -g prc information: Last recompile datetime Add sql statement that causes this entry to last recompile if changed Add location column (module/line) similar to onstat -g afr output for last change to this entry if an object changed s...

6 months ago in Informix / Informix Server 0 Under review

Please enter your email address

FILTER BY CATEGORY