Search results: Informix Server

Showing 152

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

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

38 VOTE

Improve Stored Procedures features

We are trying to increase the usage of SP in our system environment. Migrating business code from 4GL to the database.But this process becomes very painful for our developers since the support for SPL is limited. Mainly the inexistence of a native...

almost 5 years ago in Informix / Informix Server 0 Future consideration

18 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 2 years ago in Informix / Informix Server 1 Future consideration

11 VOTE

Add columnar indexes to Informix.

Other databases e.g. DB2 have columnar index support builtin, we would like that in Informix as well. use case the same as for DB2.

over 1 year ago in Informix / Informix Server 0 Future consideration

10 VOTE

enhancements to sysprocedures table and dbschema utility

Currently, there does not appear to be anything in the sysprocedures table to identify which procedures are provided by Informix (system routines) vs those created by users (user routines). The mode column does not appear to address this particula...

over 1 year ago in Informix / Informix Server 0 Future consideration

2 VOTE

Add Readonly Database Connection Support

It would be beneficial to have a readonly connection when accessing the database from third party software. Many products provide the ability to connect via JDBC but they also have the ability to make changes. Example LibreOffice Base can be setup...

4 months ago in Informix / Informix Server 0 Submitted

5 VOTE

Encrypting and Decrypting Stored Procedures

Would like Informix to have feature of encrypt the source code for a stored procedure and function.

10 months ago in Informix / Informix Server 2 Under review

2 VOTE

Add MDC Multidimension Clustering Tables to Informix same as DB2

4 months ago in Informix / Informix Server 0 Submitted

23 VOTE

Allow Informix to accept Non PAM aware clients to connect when using PAM PASSWORD mode

Standard Informix Authentication on unix will perform a getpwnam() call to retrieve the encrypted shadow password from the OS, it will then compare an encrypted version of the password supplied by the client against this, and if they match, authen...

almost 4 years ago in Informix / Informix Server 0 Future consideration

4 VOTE

Trap and/or Report running sql query on resource overflow

Currently Informix kills the session before being able to report the running sql on a Memory resource overflow. Possibly the engine has a memory leak or query could be causing the problem.

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

Please enter your email address

FILTER BY CATEGORY