Informix Server

Showing 447 of 15368

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

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

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

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

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

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

6 VOTE

Have another table sysesprof with reads/writes per session and bufferpool

Have another table sysesprof with reads/writes per sessioin and bufferpool https://community.ibm.com/community/user/datamanagement/discussion/error-25582-whats-a-reason-of?ReturnUrl=%2fcommunity%2fuser%2fdatamanagement%2fcommunities%2fcommunity-ho...

about 1 year ago in Informix / Informix Server 0 Not under 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

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

12 VOTE

Improve timestamp format in message and backup logs (ISO-8601)

Streaming messages to log ingestion systems, e.g. Elastic Stack, is a useful way of analysing logs and generating notifications when certain messages are seen. Displaying the messages in the right order when daylight saving switches occur is an is...

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

Please enter your email address

FILTER BY CATEGORY