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