Search results: Informix Server

Showing 52 of 1578

Implement LIMIT clause in DELETE Statement

Expand DELETE syntax implementing LIMIT clause and maybe also ORDER BY. Delete syntax can be like: DELETE [FROM] tbl_name [WHERE where_condition ] [ORDER BY ...] [LIMIT row_count ] This limit + order by syntax is already implemented in other major...

almost 4 years ago in Informix / Informix Server 1 Future consideration

23 VOTE

Allow Informix to accept Non PAM aware clients to connect when using PAM PASSWORD mode

Standard Informix Authentication on unix will perform a getpwnam() call to retrieve the encrypted shadow password from the OS, it will then compare an encrypted version of the password supplied by the client against this, and if they match, authen...

over 5 years ago in Informix / Informix Server 0 Future consideration

2 VOTE

Need to revisit timestemp for incremental backup

our database backup size approaches 17 TB on a very busy system. When we attempt to take a Level 1 backup with ontape, the database engine throws an exception indicating that the backup is too old. As a result, we are forced to take a Level 0 back...

7 months ago in Informix / Informix Server 1 Delivered

42 VOTE

Need an onmode option to terminate orphaned, tightly coupled global transactions. Onmode -Z does not address this case.

If a Java application that uses tightly coupled global transactions (such as from Geronimo / WebSphere app servers) abnormally terminates, it may leave the global transaction orphaned on the Informix database server. In this case, an onstat -G wil...

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

2 VOTE

RSS_FLOW_CONTROL will be managed for each RSS separatly

Currently RSS_FLOW_CONTROL parameter will be used for all RSS at the same time but we want to use this for 1 RSS only .

7 months ago in Informix / Informix Server 0 Submitted

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

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

30 VOTE

Allow column ALIAS in HAVING clause

Just recently while working on a customer we were able to speedup a very slow query by using the recently introduced OLAP functions. The query looks like this: SELECT col1, col2, col3, col4, rank() over (partition by col1, col2 order by col4 desc)...

about 11 years ago in Informix / Informix Server 0 Not under consideration

25 VOTE

Allow "group commit" as other RDBMS

For high use OLTP systems, there can be a lot of I/O pressure on the logical log due to intense rate of logical log buffer flushing (most customer don't ant data loss so they use UNBUFFERED LOG). Setting BUFFERED LOG at session level would hardly ...

over 11 years ago in Informix / Informix Server 3 Future consideration

4 VOTE

Implement nested loop join of external and indexed tables

We raised a support case for this, but creating here will help it progress. The description was as shown below. Please vote for it! Regards,Doug LawryOninit Consulting Try this in the "stores_demo" database: SET EXPLAIN ON;SELECT {+USE_NL(cust...

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

2 VOTE

Make range fragmentation work on high-write systems

Our application is INCREDIBLY write-heavy with highly transient data. Frankly, it doesn't even belong in Informix at all; it ought to be in something like MongoDB or even an in-memory DB. [I'm not kidding: 75-90K inserts per minute, involving BYTE...

about 1 year ago in Informix / Informix Server 0 Submitted

Please enter your email address

FILTER BY CATEGORY