Search results: Informix

Showing 56 of 1690

When AUTO_REPREPARE is non zero only have 1 sessions recompile a stored procedure

When AUTO_REPREPARE is non zero only have 1 sessions recompile a stored procedure. Currently with many sessions executing the same stored procedure, the stored procedure can be recompiled by many sessions causing a bottleneck. A new condition is n...

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

8 VOTE

Archecker table level restore utility does not compatible of handling Informix engine complex table schema clauses

Individual Table restoration 'archecker' utility only support simple schema definition contents as the schema file. However, Informix engine support complex clauses when setting up a table. E.g. When fragmenting a table based on interval based fra...

almost 8 years ago in Informix / Informix Server 0 Under review

4 VOTE

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

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

2 VOTE

Add Readonly Database Connection Support

It would be beneficial to have a readonly connection when accessing the database from third party software. Many products provide the ability to connect via JDBC but they also have the ability to make changes. Example LibreOffice Base can be setup...

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

about 12 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:

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

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

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

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

Please enter your email address

FILTER BY CATEGORY