Informix Server

Showing 445 of 15039

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.

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

11 months ago in Informix / Informix Server 0 Not under consideration

3 VOTE

Restore of chunks of one dbspace in parallel

In a case of an onbar restore and depending on the onconfig configuration of BAR_MAX_RESTORE setting a parallel restore of dbspaces is possible. In the case that one of the dbspaces have lots of chunks, all of these chunks will be restored sequent...

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

about 2 years ago in Informix / Informix Server 1 Not under 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...

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

5 VOTE

allow distributed queries when BLOBs involved

When trying to reference a table which contains a BLOB data type using syntax ddbb@dbservername:table, the following error is returned: error 9270: Type (informix.blob) is unsupported in distributed queries.

10 months ago in Informix / Informix Server 0 Submitted

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

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

4 months ago in Informix / Informix Server 0 Submitted

2 VOTE

Allow temp tables and backup before images to handle temp dbspaces which fill up.

If temporary tables/backup before images are spread across multiple temp dbspaces and one fills then put the data/page into the temp dbspaces which have space.This would stop backups/jobs failing.

4 months ago in Informix / Informix Server 0 Submitted

Please enter your email address

FILTER BY CATEGORY