Informix Server

Showing 428 of 14544

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 2 years ago in Informix / Informix Server 0 Future consideration

6 VOTE

optimize the interval fragment

when using interval fragment with date or datetime column, the latest fragment is in the last one, so the performance of the Insert will become slow. if Informix can keep the latest fragment as the first fragment, it will improve the performance o...

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

6 VOTE

change the bufferpool size online

when I add the new dbspace, the page size is 16 k; Informix add a default bufferpool , I forget to create the bufferpool using onparams firstly, later I found it's too small, can't meet the performance requirement, I found I have no method to chan...

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

2 VOTE

Allow SPL variables to be used to define index directives.

Inside a stored procedure allow the index name for a directive to come from a variable:...define v_bs_index varchar(100);define p_id like tBS.id,...let v_bs_index = ( select cfg from Cfg where group = 'INDEXES' and name = 'TBS_INDEX' )...

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

7 VOTE

Allow disabling automatic Next Extent calculations

Informix automatically doubles the Next Extent size for every 16 extents on a table. This action will continue until an extent is large enough to provide at least 10% free space. On very large, slow-growing tables, this can lead to an incredible w...

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

6 VOTE

Reclaim free space from chunks

Add a command to reclaim the free space (at the end of the chunk) , reducing the file size. This is very useful for cooked files. Just like SHRINKDATABASE at MS Sql Server, but for chunks....

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

2 VOTE

Informix 4gl based Datablades

I would like the ability to create database/SPL's using Informix 4GL syntax and features. I know forms and such wouldn't work but I could then leverage legacy into efficient data retrieval processes for for Java and Typescript to access

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

11 VOTE

Commit Interval for Implicit Transactions

Allow user to set a commit interval in rows or time for SQL statements not contained in an explicit begin work/commit work block.

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

11 VOTE

UTF8 should be handled in background instead of setting SQL_LOGICAL_CHAR

More and more customers have to include data from all over the world. The solution for this is UTF8, but for now this feature does not work in the background and add space if needed. The feature is implemented using SQL_LOGICAL_CHAR as configurati...

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

10 VOTE

dynamically allocated 1000000 locks

this message will start to show repeatedly in the online log:dynamically allocated 1000000 locksbut no more info than that - in order to track down the issue, we need to know what session is causing the increase in locks

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

Please enter your email address

FILTER BY CATEGORY