Search results: Informix

Showing 88 of 2942

onmode -I <error No> should have an optional flag to automagically turn off the trapping

Real world, intermittently I see a 208 error from the app layer, typically in batches of 100 or so and normally at inconvenient times. This would allow me to set the onmode -I and walk away until the error trips and not having the server swamped w...

2 months ago in Informix / Informix Server 0 Submitted

10 VOTE

Limited the number of row processed with an update/delete statement

THis is similar to MS Server (and other DBs) DELETE ... TOP <N> and TOP <n> PERCENT This would help avoid LTX issues without custom SQL coding, it would minimize the time the table is locked UPDATE FIRST 10000 COUNT 0 ... N <table&g...

12 months ago in Informix / Informix Server 0 Submitted

3 VOTE

Add in a "cdr learn server" or something similiar to connect two servers on an ER domain that may not have known about each other previously.

Servers and networking change around. There may be cases where two ER nodes who previously were unaware of each other or 'forgot' about each other need to be reconnected. Right now the only way to resolve this cleanly is to drop one of them from t...

6 months ago in Informix / Informix Server 0 Submitted

1 VOTE

Connection Manager should check if a secondary server is in sync before allowing connections to that server

When you have a primary and a secondary both server are in sync. But if you need to stop one of them for maintenaince reasons then it becomes out of sync. When you start it again the server might be so many log ahead and need to sync but the serve...

3 months ago in Informix / Informix Client Products 0 Submitted

20 VOTE

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

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

10 VOTE

Allow INSERT to write to external tables

Currently one can only write to an external table by selecting from an existing table. There are many uses for writing to an external table that do not involved writing only the results of a SELECT query. Combined with RFE INFX-I-61, Appendable Ex...

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

11 VOTE

enhancements to sysprocedures table and dbschema utility

Currently, there does not appear to be anything in the sysprocedures table to identify which procedures are provided by Informix (system routines) vs those created by users (user routines). The mode column does not appear to address this particula...

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

40 VOTE

Implement CREATE OR REPLACE option for stored procedures

We are looking to deploy more code into the system hot, taking advantage of improvements have made to trap any -710 errors internally and re-parse transparent to the user session. Currently it is necessary to drop a procedure before creating a new...

over 12 years ago in Informix / Informix Server 2 Delivered

3 VOTE

SERVERNUM limitation need to increase

As you know, now servers are more powerful and can take more load, also there is not issue for storage and we can use SAN for this purpose so it is time to increase SERVERNUM limitation, currently we can only create 256 instances on one server . W...

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

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

Please enter your email address

FILTER BY CATEGORY