Informix Server

Showing 431

SELinux policies for Informix on RHEL version 7 and upwards

At startup the Informix database spawns a number of processes, that run as unconfined SeLinux processes. From the permission perspective, some of these processes run as informix user (example: cpu and encrypt vps) whilst others run as root user (l...

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

5 VOTE

alter table online when modifying char length without killing the sessions

today my db is accessed through many web server. the main table is frequently modified : char increased and new fields. i had to bounce the engine to remove all the sessions easily.

over 4 years ago in Informix / Informix Server 0 Not under 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

informix HQ

Current version of Informix HQ is not able to trap and sent alert for engine in block state.

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

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.

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

Please enter your email address

FILTER BY CATEGORY