Informix Server

Showing 450 of 15912

UPDATE STATISTICS misleading message with AUTO_STAT_MODE active

After running Update Statistics Medium/High for Table XY, the constr_time in sysdistrib is not updated reliably. Turned out that this is because AUTO_STAT_MODE is active and statistics are only updated when determined by the engine this is necessa...

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

2 VOTE

Allow SPL variables to be used to define index directives.

Inside a stored procedure allow the index name for a directive to come from a variable:...define v_bs_index varchar(100);define p_id like tBS.id,...let v_bs_index = ( select cfg from Cfg where group = 'INDEXES' and name = 'TBS_INDEX' )...

over 2 years ago in Informix / Informix Server 0 Future 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 8 years ago in Informix / Informix Server 0 Not under consideration

2 VOTE

Informix 4gl based Datablades

I would like the ability to create database/SPL's using Informix 4GL syntax and features. I know forms and such wouldn't work but I could then leverage legacy into efficient data retrieval processes for for Java and Typescript to access

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

7 VOTE

ENABLE ONCHECK DATA CROSS-CHECKING FOR FUNCTIONAL INDEX

oncheck -cI on a functional index still says:"Non vanilla index. data crosschecking not enabled" After so many years supporting functional indices we should consider enabling this. I had a customer with a corruption in a functional index on a huge...

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

1 VOTE

Create an InformixHQ sensor to obtain the slowest queries directly from InformixHQ repository instead local SQLTRACE on the instance..

Complementing idea INFX-I-557, it would be great if we may have the report of the heaviest/slowest queries from the InformixHQ repository, instead the local SQLTRACE tables.

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

1 VOTE

Create an Informix-HQ sensor that populates an historical data table with the slowest/heaviest queries on an instance.

SQLTRACE has proved been a valuable resource to identify slow/heavy queries. An even sysadmin may store a history of the SQLTRACE output, it would be great to have a filter for the heaviest/slowest queries, and store them as a sensor of Informix-HQ.

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

2 VOTE

Improve L1 backup usability

We would like to use incremental backups with 'onbar'. However this is difficult because we use storagepools and chunks can be added at any time. Once a chunk has been added this forces a L0 backup of at least the dbspace concerned and the root db...

almost 3 years ago in Informix / Informix Server 0 Future 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...

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

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

Please enter your email address

FILTER BY CATEGORY