Search results: Informix Server

Showing 179 of 2611

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

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

3 VOTE

Add lock wait time to oncheck

If oncheck encounters a row/table is locked it immeditely returns error: ERROR: Could not obtain lock for <database>:<user>.<table> It would be useful to have an option for user to select lock wait time for example: oncheck -cDI ...

over 4 years ago in Informix / Informix Server 1 Delivered

1 VOTE

Add DB2 ALTER TABLE VOLIATE feature.

Add DB2 ALTER TABLE VOLIATE feature, this would default to index scans rather than a table scan if there are no statistics.

over 1 year ago in Informix / Informix Server 1 Submitted

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

over 11 years ago in Informix / Informix Server 1 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...

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

2 VOTE

Add optional WHERE condition to MERGE statement

Oracle supports an optional WHERE condition for insert/update/delete operations when using MERGE on the source or target table This could be handy in some situations to skip some rows if the condition is not true.

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

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

2 VOTE

Limit open partitions to avoid very large rsam pool

In systems with a lot of tables informix can have a very large rsam pool. This can cause informix to allocate so much memory it starts swapping or in memory limiting versions (like workgroup, express etc.) to even let the engine crash. Sometimes t...

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

over 10 years ago in Informix / Informix Server 1 Not under consideration

5 VOTE

Do not lock table when entering alter table menu in isql/dbaccess tools

After entering alter table menu and selecting the table , the table will lock in exclusive mode until the opertion finish. If this table is an online trade table , this behaviour is very dangerous.So it should not lock table until user commit the ...

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

Please enter your email address

FILTER BY CATEGORY