Informix Server

Showing 309

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

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

8 VOTE

Upgrade without outage in HDR environment

Upgrading without an outage in an HDR environment is a big deal when rolling out upgrades in the HDR environment. With the conversion from 12.10.FC4 to 12.10.FC5 we will have a failover and thats it! Thats a HUGE win for the product but I need thi...

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

8 VOTE

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:

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

7 VOTE

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

8 VOTE

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

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

8 VOTE

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

3 VOTE

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

almost 4 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

Please enter your email address

FILTER BY CATEGORY