Skip to Main Content
ADD A NEW IDEA

Informix Server

Showing 308

Add profile counter for number of long transactions since most recent "onstat -z"

Rollback most of the time is a time and resource consuming action. We would like to be able to monitor how many long transactions we (just a simple profile counter), as currently it is not easy and accurate on how to determine the amount of long t...
almost 5 years ago in Informix / Informix Server 0 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...
about 7 years ago in Informix / Informix Server 0 Not under consideration

Accelerating Subqueries in IWA

Currently, IWA does not fully accelerate subqueries of the following two forms: 1) Subqueries in FROM clause 2) Subqueries in WHERE clause:
almost 10 years ago in Informix / Informix Server 0 Not under consideration

Need dead connection timeout parameter

The Cisco Call Manager team was recently testing LOGINTIMEOUT settings under various conditions. This testing led CUCM to ask IBM how to control the time out once the connection has been established but then the target is suddenly no longer reacha...
over 8 years ago in Informix / Informix Server 0 Not under consideration

SQL skeleton for SQLTrace

SQL skelecton for SQLTrace Most of the customers' product system have to run almost 1000 transactions per seconds, it means there are about 86M transactions per day. so there will be to many SQLs would be traced by current SQL trace.so customer ca...
about 10 years ago in Informix / Informix Server 0 Not under consideration

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...
over 10 years ago in Informix / Informix Server 0 Not under consideration

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...
almost 8 years ago in Informix / Informix Server 0 Not under consideration

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...
over 9 years ago in Informix / Informix Server 0 Not under consideration

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...
about 8 years ago in Informix / Informix Server 0 Not under consideration

Improve performance on multifact query on an informix database

We make Cognos reports on multifacts creating multifact queries with full outer join. To keep the query execution time low, we need absolutely the enhancement/fix be implemented in the next informix fixpack 12.10. It is unacceptable when the compe...
about 4 years ago in Informix / Informix Server 0 Not under consideration