Skip to Main Content
ADD A NEW IDEA

Informix Server

Showing 443 of 14954

ADMIN_USER_MODE_WITH_DBSA and ADMIN_MODE_USERS shall be changeable values via onmode -wf/-wm.

The mentioned values shall be online changeable to avoid downtimes of informix. Especially within production landscape it is very important to avoid any unnecessary downtimes.
about 2 years ago in Informix / Informix Server 0 Future consideration

insert into table default values

A number of database vendors offer insert into table values() or insert into tables default values;
about 8 years ago in Informix / Informix Server 0 Not under consideration

Allow PAM in OleDB clients (for password mode)

Currently OleDB clients can't connect to PAM enabled ports.We recently allowed PAM connections for DRDA connections if in password mode (APAR IC99560). I'd say there is no reason why OleDB wouldn't work for password mode, just like it was implemen...
about 8 years ago in Informix / Informix Server 1 Not under consideration

Multi Row Insert

Support Multi Row Insert: insert into table1 (col1, ..., colx) values (1, ..., x), ... (1000, ..., x) ; Using Multi Row Insert multiple rows can be inserted with just one statement. Other RDBMs provide this feature with a performance improvement o...
over 4 years ago in Informix / Informix Server 2 Not under consideration

Permit blocking checkpoints on secondary nodes when raw tables exist on the primary node.

Currently we cannot issue a blocked checkpoint on a secondary (RSS in our case) when there exists raw tables on the primary node. We use raw tables heavily for admin jobs (mostly for the selection processing of archiving/purging jobs) to avoid swa...
over 4 years ago in Informix / Informix Server 0 Not under consideration

Allow trusted context to accept CIDR notation

Currently the syntax to define a trusted context accepts only IP's . In view that microservices are deployed on Kubernetes infrastructures, the DBA has to add all the IP's of the different subnets. This is both cumbersome and laborious. The propos...
about 3 years ago in Informix / Informix Server 0 Future consideration

Add onmode -F <type> to free only certain memory e.g. vpcache.

When having e.g. excessive vpcache usage we need to free the memory and associated shared memory segments for just the vpcache. Our use case was smx buffers to it would be even better to be able to just free the 'free' smx buffers.Trying to free a...
over 1 year ago in Informix / Informix Server 0 Not under consideration

Refresh for SSL Listeners (reload certificates)

Today, until current version (12.10 xC4) isn't possible to update/replace/implement a SSL certificate without restart the engine. This RFE include two related feature : 1) Allow stop/start SOCSSL listeners using command "onmode -P" and with this r...
almost 10 years ago in Informix / Informix Server 0 Not under consideration

Document "autotune" paramerer for cpu and aio in the onconfig.std file.

Its is not easy to find any document that cover all three of 1) AUTO_TUNE 2) VPCLASS cpu,autotune,noage and 3) VPCLASS aio,autotune=1,noage. The onconfig.std file does not even mention "autotune", yet this is the best place to concisely let it be ...
about 3 years ago in Informix / Informix Server 0 Future consideration

Backup / ReadAhead Performance

To speedup backup time, it would be nice if Informix can read with more than 64k from disk. Example 12G SAS SSD - read 100 GByte with dd iflag=direct:Blocksize Throughput Time64k 197 MB/Sec 519 Sec (8:39)256k 438 MB/Sec 233 Sec (3:53)2048k 1186 MB...
over 7 years ago in Informix / Informix Server 0 Not under consideration