Search results: Informix

Showing 7 of 314

Reset the serial value in the partition page if the table no longer has a serial column

If you want to check whether a serial value is close to its maximum value, it is very unpleasant that tables that no longer have a serial value or whose serial value has been changed to a Serial8 or BigSerial value still have the last value in the...

8 months ago in Informix / Informix Server 1 Submitted

3 VOTE

Backups to use temp dbspaces with most closlely matching page size.

For backups store the before images it temporary dbspaces which most closely match the pagesize of the dbspace being backed up. Presumably this would be more efficent. E.g. If backing up a 16k dbspace prefer putting before images in a 16k,8k or 4k...

over 1 year ago in Informix / Informix Server 0 Submitted

2 VOTE

Support LIMIT clause in Common Table Expressions

Using LIMIT clause in a CTE gives a syntax error (with IDS 14.10.FC10) sf@toro (master):~/genero/devel/dbsync/dbsync$ cat x.sql WITH recent_rows AS (SELECT log_ordinal FROM dbsync_log WHERE log_table_name = 'stkitem' ORDER BY log_ordinal DESC LIMI...

over 1 year ago in Informix / Informix Server 0 Submitted

14 VOTE

Require NODEFDAC as a server side general setup

This is a follow up on RFE 34407.The original request was classified as "Delivered" but I'd say that veridict totally misses the point. The answer provided states that we can use informix.rc file to set the variable. That's true for UNIX. But in t...

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

9 VOTE

Allow DBA to re-initialize OS process cache created by the resolver routines

This is a follow up of RFE 33797.The original RFE was closed as "Delivered", but I think the analysis was incorrect. The complain is that whenever a OS process calls gethostbyaddr() or equivalent, the OS itself will cache some information about th...

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

2 VOTE

Limit open partitions to avoid very large rsam pool

In systems with a lot of tables informix can have a very large rsam pool. This can cause informix to allocate so much memory it starts swapping or in memory limiting versions (like workgroup, express etc.) to even let the engine crash. Sometimes t...

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

2 VOTE

Connection pooling should not lock databases if all connections are closed

In case connection pooling is enabled in the driver (no matter if using ODBC, .NET Provider or the .NET Core provider), the driver keeps connections from the pool open to the database server in order for a faster reconnect in the applications. Any...

over 4 years ago in Informix / Informix Client Products 0 Future consideration

Please enter your email address

FILTER BY CATEGORY