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