Informix

Showing 315

Ability to rotate encryption at rest keys on the Engine

Corporate security has requested us to change the EAR keys on demand as they see having the same key as a security risk. We would like to see a feature to change the .sth and .p12 files in an easier manner.

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

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

3 VOTE

Fixing IPA in a 15TB OLTP database or large database

We have a 15 TB size oltp db running in 12.10.FC12. We want to fix the data with pending IPA,however, we cannot use the traditional way due to : - we cannot put the DB offline for hours to fix the data with pending IPA and it will be between 5 to ...

6 months ago in Informix / Informix Server 2 Not under consideration

2 VOTE

Smart Trigger API for Java to monitor smart trigger session changes at the backend DB

The Smart Trigger Java library allows for the use of a detachable session which is assigned a session ID. One can use this session ID to reconnect to an existing session when starting up a Smart Trigger. But, if for some reason this session ID in ...

6 months ago in Informix / Informix Server 1 Not under consideration

2 VOTE

Allow changing of S3 Prefix for onbar backups

Scenario is you have 1000+ sites to backup all with the same informix server name. instead of changing the informixserver name you can set prefix on the onpsm backup. this allows for reducing the amount of buckets for this setup in cases where you...

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

3 VOTE

Dbexport/dbimport validate *_LOCALE vars before accessing data files

When working with UTF8 database, DB_LOCALE and CLIENT_LOCALE are required to interact correctly with the databases. This RFE is about issuing a warning to the DBA when doing a dbexport/dbimport with CLIENT_LOCALE unset, especially when DB_LOCALE i...

8 months ago in Informix / Informix Server 1 Not under consideration

2 VOTE

SELinux policies for Informix on RHEL version 7 and upwards

At startup the Informix database spawns a number of processes, that run as unconfined SeLinux processes. From the permission perspective, some of these processes run as informix user (example: cpu and encrypt vps) whilst others run as root user (l...

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

3 VOTE

Enhancement to DROP PROCEDURE / DROP FUNCTION syntax

Currently, the DROP PROCEDURE statement requires that the all of the procedure parameters necessary to completely identify the specific procedure. This is important due to Informix supporting polymorphic procedures, and is generally a good thing. ...

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

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

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

5 VOTE

Identify/log slow queries on a busy system

SQLTrace offers the DBA the tooling required to monitor a user session. However its difficult to monitor heavily used systems. For example one needs to have a buffer large enough to store 90 seconds of SQL queries (small lookup SQL's consume the b...

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

Please enter your email address

FILTER BY CATEGORY