Informix Server

Showing 450 of 15912

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

almost 12 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 12 years ago in Informix / Informix Server 0 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 5 years ago in Informix / Informix Server 0 Not under consideration

1 VOTE

Smart shared memory dumps

Other database products when dumping shared memory including context relevant information. E.g. which partition was being accessed. Contents of last buffer pool page being accesssed.If the buffers pools are massive e.g. hundreds of gigabyes then t...

about 1 year ago in Informix / Informix Server 0 Submitted

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

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

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

3 VOTE

Online index rebuild

We need command tool in Informix >>-ALTER INDEX--index--REBUILD------------>< | | '-ONLINE-' working like: REBUILD INDEX online utility in DB2 or ALTER INDEX index REBUILD ONLINE in Oracle or REINDEX [INDEX|TABLE] in PostgreSQL

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

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

8 VOTE

Mark a row as "archived" so it will not show up in regular SELECT (or other SQL) operations

Oracle style Data invisibility (archiving) with In Database Archival. See this article ==> http://www.toadworld.com/platforms/oracle/w/wiki/11420.oracle-12c-data-invisibility-archiving-with-in-database-archival The idea is to mark a row as arch...

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

Please enter your email address

FILTER BY CATEGORY