Search results: Informix Server

Showing 52 of 1578

Document "autotune" paramerer for cpu and aio in the onconfig.std file.

Its is not easy to find any document that cover all three of 1) AUTO_TUNE 2) VPCLASS cpu,autotune,noage and 3) VPCLASS aio,autotune=1,noage. The onconfig.std file does not even mention "autotune", yet this is the best place to concisely let it be ...

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

9 VOTE

Remove the physical storage limitations on Innovator-C

At release of Informix Innovator-C Edition 11.70 xc5, a large number of functionality has been withdrawn ( ER and more), as well as new ressource limitations have been implemented or inreased, such as limitation to 1 CPU vp for instance. We think ...

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

10 VOTE

Lock table (or database) in exclusive mode does not work as expected in HDR

If one attempts to update a table with many rows in an HDR environment with updateable secondary code like this does not work (if you are on the primary):begin work; lock table mytab in exclusive mode; update mytab set col1="xxx" where 1=1; commit...

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

5 VOTE

Config option to raise an SQL error on inserting a too long string value

Inserting of any string value should not result with a silent automatic truncation of a given value and with an OK transaction result status. Exactly this is the default DBMS behaviour for non-ANSI databases.One solution for this could be the intr...

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

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

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

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

1 VOTE

oncheck should report all bad rowids in an index.

oncheck should report all bad rowids in an index. Current oncheck stops at the first bad rowid, this makes it impossible to tell if there is more than 1 bad rowid in an index.

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

2 VOTE

Informix incremental backups (L1)

Hi, L0 and L1 backups of informix are taking almost same time since it seems that is limited by disk reading performance: we are using IBM spectrum backup to backup. From IFX logs we see that they are using /usr/informix/server12/bin/onbar_d...

about 3 years ago in Informix / Informix Server 1 Delivered

Please enter your email address

FILTER BY CATEGORY