Informix Server

Showing 449 of 15426

SYSSQLTRACE SHOULD STORE HOST VARIABLES VALUE

When trying to use SQLTRACE to audit queries, in HIGH Mode, host variables are not saved in the system catalog syssqltrace table, but in the onstat -g his output. Customer needs that information in the system tables as their audit job, loads syssq...

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

2 VOTE

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.

over 5 years ago in Informix / Informix Server 0

2 VOTE

Informix HQ should have a dark theme like grafana

No description provided

over 5 years ago in Informix / Informix Server 1 Planned for future release

2 VOTE

Support for ON UPDATE CASCADE

Use case: There is a table called release with a primary key id of type integer and an additional column name (the release name). And further tables (e.g. table_x, table_y, …) with a reference (foreign key) to release.id. The working tables are ta...

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

2 VOTE

cleanup of ER structures if ER was not in use prior to utilizing 'cdr migrate server'

If Enterprise Replication did not exist prior to the execution of cdr migrate server, then the utility should as its last step, at user option, dismantle and remove all Enterprise Replication structures in the background that were created to do th...

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

3 VOTE

TBLSpace can not be sized on temporary tables

Trying to use -ef and -en to size the TBLSpace on a system that use a lot to temp tables but the command fails. This is correct functionaility. Various docs/presentation etc existing stating that better performance can be gained from sizing the TB...

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

1 VOTE

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

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

1 VOTE

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

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

1 VOTE

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

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

4 VOTE

DR repair index - Not applicable to RSS servers

We have an index corrupted as a result of applying a new fragmentation strategy. The index is fine on the primary but corrupted on both HDR and two RSS servers. The only way of fixing this index is to rebuild the index online which will take a hou...

about 11 years ago in Informix / Informix Server 0 Not under consideration

Please enter your email address

FILTER BY CATEGORY