Search results: Informix Server

Showing 99 of 5234

Increasing LO_hdr_partn size limit in every chunk in sbspace Metadata partition

We have a system with a lot of users and big amount of BLOB/CLOB data. It's critical 24x7 application. It should be created a new sbspace about 1TB - with 8 chunks x 140GB every 6 months, because the limit in LO_hdr_partn in sbspace Metadata Parti...

6 months ago in Informix / Informix Server 0 Submitted

112 VOTE

Backup from RSS or HDR Secondaries using ontape, onunload, onbar, dbexport

In HDR enviroments, being able to backup or export databases from and HDR, HDR read-only, or an RSS secondary server is critical. Programs like ontape, onunload, dbexport, and onbar generate locks on tables during backups and data-exports. This cr...

over 11 years ago in Informix / Informix Server 1 Delivered

40 VOTE

Improve Stored Procedures features

We are trying to increase the usage of SP in our system environment. Migrating business code from 4GL to the database.But this process becomes very painful for our developers since the support for SPL is limited. Mainly the inexistence of a native...

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

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

35 VOTE

Ability to sync tables to HDR & RSS secondaries when converting from RAW to STANDARD mode.

It is significantly faster to load a table in TYPE(RAW) mode than TYPE(STANDARD) mode. However, this option is not practical for sites using HDR and/or RSS secondary servers for replication as RAW mode tables do not replicate forcing the site to b...

over 8 years ago in Informix / Informix Server 0 Future 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

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

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

14 VOTE

Unload to file should have option that prevents over writing of an existing file

A customer writes some SQL that captures the pre-data to an unload file and then does the updates/deletes etc. If the SQL is successful and inadvertently run again the initial pre-data will be lost.

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

19 VOTE

Enhance availability of readahead performance details

With the ubiquity of intelligent storage, the value of readahead in the Informix server is reduced and excessive readahead can be detrimental to performance. However, since the introduction of the AUTO_READAHEAD parameter and the associated change...

almost 6 years ago in Informix / Informix Server 2 Delivered

Please enter your email address

FILTER BY CATEGORY