Informix Server

Showing 449

ER should have an option to replicate tables between different databases

Currently there is not an option in ER that would allows us to replicate a table from database A to database B. You must use the same database. There are real life situations where you need to replicate a table to a differente server/instance/data...

10 months ago in Informix / Informix Server 0 Submitted

6 VOTE

For sysprocplan add ability to view the plan

For sysprocplan add ability to view the plan. This would allow more visibility into how plans change when they do change.

12 months ago in Informix / Informix Server 0 Under review

6 VOTE

Add object names to onstat -k output

Add object names to onstat -k output this should include partition part name where apropriate.

12 months ago in Informix / Informix Server 0 Under review

14 VOTE

More efficient unique indexes for monotonically increasing keys and constraints

Currently an index on a SERIAL and other monotonically increasing keys only add to the last node in the index causing the node to split into two half filled nodes. Eventually a sufficient number of nodes have so split that the index's search effic...

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

19 VOTE

Implement LIMIT clause in DELETE Statement

Expand DELETE syntax implementing LIMIT clause and maybe also ORDER BY. Delete syntax can be like: DELETE [FROM] tbl_name [WHERE where_condition ] [ORDER BY ...] [LIMIT row_count ] This limit + order by syntax is already implemented in other major...

over 3 years ago in Informix / Informix Server 1 Future consideration

3 VOTE

Backups to use temp dbspaces with most closlely matching page size.

For backups store the before images it temporary dbspaces which most closely match the pagesize of the dbspace being backed up. Presumably this would be more efficent. E.g. If backing up a 16k dbspace prefer putting before images in a 16k,8k or 4k...

6 months ago in Informix / Informix Server 0 Submitted

10 VOTE

Allow INSERT to write to external tables

Currently one can only write to an external table by selecting from an existing table. There are many uses for writing to an external table that do not involved writing only the results of a SELECT query. Combined with RFE INFX-I-61, Appendable Ex...

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

37 VOTE

Page limitation for single fragment, to avoid stop the business and recreate the table .

Remove or enlarge the 16,775,134 page limitation per fragment.

over 6 years ago in Informix / Informix Server 1 Future consideration

15 VOTE

Allow Bufferpool Min_lru_dirty and Max_lru_dirty Threshold values to be altered dynamically

onparams -b can be used to add a new bufferpool and AUTO_LRU_TUNING are available on informix server but first only adds a bufferpool of a new page size and the latter only kicks in if some foreground writes occur on a server which ideally is neve...

over 2 years ago in Informix / Informix Server 2 Future consideration

6 VOTE

Add sid to onstat -g tpf output

When using onstat -g tpf it would be better if sid was displayed to make this easier to tie back to a session. E.g. when looking for reverse scans on the instance.

about 1 year ago in Informix / Informix Server 0 Under review

Please enter your email address

FILTER BY CATEGORY