Search results: Informix Server

Showing 30

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

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

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

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

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

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

15 VOTE

UTC/GMT timestamp conversion function for Informix database

Informix does not have a UTC/GMT timestamp conversion function. Requirement :---------------------------------1) Cast function to convert from a particular datetime to UTC datetime based on the current timezone2) Cast function to convert from sysd...

about 10 years ago in Informix / Informix Server 1 Not under consideration

2 VOTE

When AUTO_REPREPARE is non zero only have 1 sessions recompile a stored procedure

When AUTO_REPREPARE is non zero only have 1 sessions recompile a stored procedure. Currently with many sessions executing the same stored procedure, the stored procedure can be recompiled by many sessions causing a bottleneck. A new condition is n...

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

13 VOTE

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

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

10 VOTE

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 8 years ago in Informix / Informix Server 0 Not under consideration

Please enter your email address

FILTER BY CATEGORY