Informix Server

Showing 428

Allow "group commit" as other RDBMS

For high use OLTP systems, there can be a lot of I/O pressure on the logical log due to intense rate of logical log buffer flushing (most customer don't ant data loss so they use UNBUFFERED LOG). Setting BUFFERED LOG at session level would hardly ...

about 10 years ago in Informix / Informix Server 3 Future consideration

23 VOTE

Online.log could also print session detail of additional memory segment allocation

In high usage OLTP systems, it is a hard work to identify which session(s) is(are) demanding too much memory from the Informix engine.A good thing for us to help to identify abnormal programs execution/behaviour would be to print session details (...

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

23 VOTE

Improve performance of L1/L2 backups

Current, for L1 (or L2) backups we need to read all pages. This is highly inefficient and there are alternatives for implementing this.In the PMR we've been told this matches old FEA idsdb00010525. In this the proposed solution was to maintain a t...

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

16 VOTE

Make adoption of forest-of-trees indices easier with existing large tables

Rebuilding an index as a FOT is not supported using "alter fragment on index init". This would be useful to avoid dropping and later re-adding primary keys and referencing foreign keys. Building a FOT index is not possible in parallel. Building a ...

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

1 VOTE

Internal hash tables - remove limit on amount of data.

As per case TS006348841 currently internal hash tables have a limitation on the amount of data that can be copied into the internal hash table "At the end all the rows/columns must be copied into a hash table. And this is too much data." E.g. A gr...

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

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...

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

20 VOTE

Enable defined limits on sqltrace

We would like to see the ability to add limits when enabling sqltrace to limit it to only trace by specific requirements. The basic one, which this alone would make a huge difference would be the ability to list one or more tables and only have it...

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

2 VOTE

SQL Trace filtering

SQLTrace enable the DBA to get the query plan of all the queries executed by a user (when mode=user) or by all users (when mode=global). Given that nowadays web applications and/or APIs use connection pooling, they submit a large number of queries...

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

9 VOTE

Allow partial indexes in all editions

IDS 14.10 contains this important new feature: https://www.ibm.com/support/knowledgecenter/SSGU8G_14.1.0/com.ibm.sqls.doc/ids_sqs_partial_index.htm "Partial indexes avoid indexing common values. As the query searching for a common value wil...

almost 4 years 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

Please enter your email address

FILTER BY CATEGORY