Informix Server

Showing 428

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

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

6 VOTE

Shadow Column Creation "online"

Currently the shadow columns are very relevant with ER however it causes an outage and I dont see why we cant create them just as we create online indexes. Its the same concept and this would allow HDR database servers capable of migrating to ER w...

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

6 VOTE

Allow SPL UDR drop/recreate without taking an outage

Currently to change the body of an existing SPL procedure/function, even without changing the signature, requires an outage for applications executing those UDRs.The error returned is "9753: Unable to find User Defined Routine with the given id." ...

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

6 VOTE

Informix auditing (onaudit) should be able to record feprogram with the "start session" event

In 11.70 (or earlier) IBM enhanced the client tools and server so that a string for the "front end program" is sent to the server. This can be seen in the syssessions table if a compatible Client SDK or IConnect is used. It would be very useful fo...

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

6 VOTE

Need config param to allow user to specify what dbspaces should be used for Mongo collections

Currently (IDS 12.10.FC2X6) when a collection is created in the Informix server the dbspaces used are selected by some automated process. The user has no control where the data or indexes are placed. There should be a config parameter which could ...

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

Please enter your email address

FILTER BY CATEGORY