Search results

Showing 31 of 848

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

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

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

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

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

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

1 VOTE

Compatibility of SDS_ALTERNATE and logged SBSPACE

Our Standard Informix Cluster consists of Primary, SDS and RSS Server. While testing Failover with broken Network, we recognized that it is possible to get two Primarys when DRAUTO = 3 is set and the Network Connection of the Primary is interrupte...

4 months ago in Informix / Informix Server 0 Submitted

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

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

almost 12 years ago in Informix / Informix Server 3 Future 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 .

about 1 year ago in Informix / Informix Server 0 Submitted

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

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

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

almost 3 years ago in Informix / Informix Server 2 Not under consideration

3 VOTE

SQL Trace filtering

SQLTrace enable the DBA to get the query plan of all the queries executed by a user (when mode=user) or by all users (when mode=global). Given that nowadays web applications and/or APIs use connection pooling, they submit a large number of queries...

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

Please enter your email address

FILTER BY CATEGORY