Informix Server

Showing 441 of 14913

Add sql causing change when dictionary entries become dirty.

When onstat -g dic entries become dirty add sql causing this to the onstat -g dic output.This would allow diagnosing issues better. This does not need to be persisted to storage. When sysprocplan entries become invalid this would also allow diagno...

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

11 VOTE

insert into table default values

A number of database vendors offer insert into table values() or insert into tables default values;

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

2 VOTE

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

6 VOTE

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

11 VOTE

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

6 VOTE

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

4 VOTE

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

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

4 VOTE

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

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

2 VOTE

Automátic column-level encryption at rest

In Europe we have strong laws (GDPR) protecting personal data. Nobody, even programers or DBA can access personal data if not from an audited program who grants individual access to each user able to see this information. As application examples, ...

over 1 year ago in Informix / Informix Server 0 Not under consideration

3 VOTE

Global cursors in SPL

I would like the ability to define a global statement and global cursor that can be shared between routines within a single session. This would allow for modular code and create tremendous increases in performance and memoory usuage

about 2 years ago in Informix / Informix Server 0 Future consideration

Please enter your email address

FILTER BY CATEGORY