Informix

Showing 426 of 13751

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

7 months ago in Informix / Informix Server 0 Future consideration

98 VOTE

Informix should be able to change owner on tables and any other objects

If user=informix creates all database and all tables, then programmer creates table but user=informix cannot change it. Only drop it.

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

12 VOTE

Allow Bufferpool Min_lru_dirty and Max_lru_dirty Threshold values to be altered dynamically

onparams -b can be used to add a new bufferpool and AUTO_LRU_TUNING are available on informix server but first only adds a bufferpool of a new page size and the latter only kicks in if some foreground writes occur on a server which ideally is neve...

12 months ago in Informix / Informix Server 2 Future consideration

88 VOTE

Backup Individual database, not entire instance

Need a mechanism, similar to ontape, to backup a live database (as opposed to entire instance), without locking it.

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

104 VOTE

Obtain the query plan of a running query

Many times a DBA is called to check upon a slow process. Most of the times those processes are running a slow query.Sometimes it's hard to know if the query is using the best query plan or not. A DBA can reproduce the query, but it it was prepared...

almost 10 years ago in Informix / Informix Server 0 Planned for future release

11 VOTE

LDAP Authenication for HQ

Allow the option to use LDAP for HQ Authentication. Build the user name in HQ but allow it to use domain authentication. This would also allow HQ to write backups to mapped drives. See Support Case TS007408895 for further details.

about 1 year ago in Informix / Informix Server 1 Future consideration

28 VOTE

Add SQL-statement COMMENT ON as in Oracle or PostgreSQL

For some tables or columns it would be helpful to describe what the table/column is used for since the names are not always self-explanatory. Although COMMENT ON is not part of standard SQL it would be helpful to have such a statement. The DOCUMEN...

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

2 VOTE

Smart Trigger API for Java to monitor smart trigger session changes at the backend DB

The Smart Trigger Java library allows for the use of a detachable session which is assigned a session ID. One can use this session ID to reconnect to an existing session when starting up a Smart Trigger. But, if for some reason this session ID in ...

3 months ago in Informix / Informix Server 1 Submitted

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

almost 4 years ago in Informix / Informix Server 0 Future consideration

6 VOTE

Different message when transaction time limit reached

When transaction duration limit is reached the following message occurs in the online log file 08:56:28 sid 11617 - test@server.domain.local - pid 6811 terminated because session transaction duration (60 seconds) has exceeded limit. This session i...

8 months ago in Informix / Informix Server 1 Future consideration

Please enter your email address

FILTER BY CATEGORY