Search results: Informix

Showing 187 of 2588

allow repack of TBLSpace extents

When a database has been created in a single (not root) dbspace and the dbspace has been greatly expanded with large tables that are subsequently moved to separate dbspace, the chunks used for original dbspace expansion may contain TBLSpace extent...

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

21 VOTE

Allow placement of tablespace BYTE and TEXT data in a separate dbspace from the table's base row data.

Allow specifying a normal dbspace for a BYTE or TEXT column to isolate IOs for the blob data from main row data for the table. This would be logged space just like IN TABLE as opposed to IN blobspace blob pages.

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

9 VOTE

JDBC suport of collection data types in scroll cursors

Currently the usage of collection data type columns in scroll cursors are disabled by default throwing an Exception with this stack trace. Stack trace returned is: at com.informix.util.IfxErrMsg.buildExceptionWithMessage(IfxErrMsg.java:416) at com...

over 2 years ago in Informix / Informix Client Products 0 Not under consideration

5 VOTE

Add option to set explain on to see what the optimizer is doing.

Add option to set explain on to see what the optimizer is doing. - Which statistics were looked at - Relative costs for table scan/index usage - Why a given index is not used - Which join orders are considered - Why join orders are excluded from t...

over 1 year ago in Informix / Informix Server 0 Submitted

2 VOTE

HDR shall handle blobs which are located in a blob space

In contrast to CLR (Continous Log Restore) is HDR not able to replicate blobs which are lying within a blob dbspace. HDR is only able to replicate blobs when they are within a table space. Work-Around: => see addional details #Customers: More o...

6 months ago in Informix / Informix Server 0 Submitted

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

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

19 VOTE

255 rows/page limit should be addressed

Informix has a rows/page limit of 255 rows/page. Perhaps this was not a problem originally but over time we have seen new features: larger page sizes (up to 16 kB against 2 kB or 4 kB previously, dependent on operating system). compression option....

over 5 years ago in Informix / Informix Server 3 Delivered

38 VOTE

New feature to have FORCE_DDL_EXEC functionality for all DDL changes

The 12.10 manual states that the FORCE_DDL_EXEC environment variable can be used "to force out other transactions that have opened or have locks on the tables involved in an ALTER FRAGMENT ON TABLE operation". We'd like to see this functionality e...

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

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

2 VOTE

Provide "time to complete" estimations for specific operations

It would be nice to provide a decent estimate on the time it will take to perform atypical operations such as:Alter tableCreate IndexArchivesCould estimate time needed or provide percent progress information while operation is ongoing

7 months ago in Informix / Informix Server 0 Submitted

Please enter your email address

FILTER BY CATEGORY