Informix Server

Showing 309

dbschema should always print the content in the same order that two dbschema files are still easily comparable after many changes

Use case: Find the essential dbschema changes between two releases. How can I achieve that? – With a dbschema -d database > filename for each release and compare the files. Problem: For example if functions, procedures or views are dropped an...

almost 5 years ago in Informix / Informix Server 1 Not under consideration

6 VOTE

change the bufferpool size online

when I add the new dbspace, the page size is 16 k; Informix add a default bufferpool , I forget to create the bufferpool using onparams firstly, later I found it's too small, can't meet the performance requirement, I found I have no method to chan...

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

6 VOTE

optimize the interval fragment

when using interval fragment with date or datetime column, the latest fragment is in the last one, so the performance of the Insert will become slow. if Informix can keep the latest fragment as the first fragment, it will improve the performance o...

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

6 VOTE

Reclaim free space from chunks

Add a command to reclaim the free space (at the end of the chunk) , reducing the file size. This is very useful for cooked files. Just like SHRINKDATABASE at MS Sql Server, but for chunks....

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

6 VOTE

change rowid to 64 bit for fragment table,to aviod rowid reach the maximum values

change rowid to 64 bit for fragment table

about 6 years ago in Informix / Informix Server 1 Not under consideration

6 VOTE

Improvements to UPDATE STATISTICS LOW

The run time of UPDATE STATISTICS LOW can be reduced by setting the parameter USTLOW_SAMPLE which also reduces I/O by using a sampling algorithm. However the table data may be deemed to be too heavily skewed and the engine falls back to a full sca...

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

6 VOTE

In a HDR cluster, be able to shut down the primary without triggering the auto-failover regardless DRAUTO setting and CM

In a HDR cluster, one should be able to shut down the primary instance without triggering the auto-failover regardless the setting of DRAUTO and the existence of connection managers. In DHL environment, there are scenarios that the primary instanc...

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

6 VOTE

Improve automatic space management

Improve the usability of Automatic Space Management for multi-tiered storage systems.Our system is using backend storage systems where not all disks/LUNs are created with equal speed/bandwidth/latency and other performance factors. Informix storag...

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

6 VOTE

Make ifxcollect dump location configurable

The directory used by ifxcollect is hardcoded to $INFORMIXDIR/isa/data.This breaks as soon as IDS has been upgraded to a new version/special build and needs manual intervention which can be forgotten easily. What would probably work much better if...

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

6 VOTE

Add IF NOT EXISTS logic to ALTER TABLE ADD CONSTRAINT

alter table mytab add constraint if not exists foreign key .... alter table mytab add constraint if not exists primary key .... alter table mytab add constraint if exists drop constraint ....

almost 9 years ago in Informix / Informix Server 1 Not under consideration

Please enter your email address

FILTER BY CATEGORY