Informix Server

Showing 266

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

90 VOTE

Backup Individual database, not entire instance

Need a mechanism, similar to ontape, to backup a live database (as opposed to entire instance), without locking it.

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

4 VOTE

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

20 VOTE

Allow placement of tablespace BYTE and TEXT data in a separate dbspace from the table's base row data.

Allow specifying a normal dbspace for a BYTE or TEXT column to isolate IOs for the blob data from main row data for the table. This would be logged space just like IN TABLE as opposed to IN blobspace blob pages.

almost 3 years 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

18 VOTE

255 rows/page limit should be addressed

Informix has a rows/page limit of 255 rows/page. Perhaps this was not a problem originally but over time we have seen new features: larger page sizes (up to 16 kB against 2 kB or 4 kB previously, dependent on operating system). compression option....

almost 3 years 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

17 VOTE

Full HDR switch between primary and secondary with a single command and without any downtime

We have 2 servers with 2 HDR instances each. For each cluster we have also 2 connection manager each. On server one there is the primary of cluster 1 and the secondary of cluster 2 On server two there is the primary of cluster 2 and the seconda...

over 3 years ago in Informix / Informix Server 0 Not under consideration

38 VOTE

allow repack of TBLSpace extents

When a database has been created in a single (not root) dbspace and the dbspace has been greatly expanded with large tables that are subsequently moved to separate dbspace, the chunks used for original dbspace expansion may contain TBLSpace extent...

over 7 years ago in Informix / Informix Server 2 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

Please enter your email address

FILTER BY CATEGORY