Informix

Showing 533 of 15535

ADMIN_USER_MODE_WITH_DBSA and ADMIN_MODE_USERS shall be changeable values via onmode -wf/-wm.

The mentioned values shall be online changeable to avoid downtimes of informix. Especially within production landscape it is very important to avoid any unnecessary downtimes.

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

4 VOTE

Document "autotune" paramerer for cpu and aio in the onconfig.std file.

Its is not easy to find any document that cover all three of 1) AUTO_TUNE 2) VPCLASS cpu,autotune,noage and 3) VPCLASS aio,autotune=1,noage. The onconfig.std file does not even mention "autotune", yet this is the best place to concisely let it be ...

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

6 VOTE

HQ: Add a 'Hot tables" sub-menu in the Performance tab, same for LOCKS

It would be a good thing to have, in HQ's performance sub-menu, a 'Hot tables' (and indexes) section which can be based on the output of onstat -g ppf. The idea is to have a view on the tables that are more active, and eventually click on one tabl...

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

4 VOTE

Implement CREATE OR REPLACE option for triggers/views/synonyms/row types

Since a similar option for stored procedures is available starting with version 14.10 it would be handy if this syntax could also be introduced for triggers, views, synonyms and row types. Currently you first have to drop a trigger/view/synonym or...

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

13 VOTE

the task "Table Shrink" allow to specify unit of work or duration

I used "table shrink" on large table, sometime it caused the long transaction on the other application processes due to the logical logs usage. In some cases, the size of table is large so the "table shrink" take too long and impact system on peak...

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

3 VOTE

Global cursors in SPL

I would like the ability to define a global statement and global cursor that can be shared between routines within a single session. This would allow for modular code and create tremendous increases in performance and memoory usuage

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

7 VOTE

Support limit (first xx) on delete statements

Currently limiting the number of rows to be deleted like "delete first 500 from " is not supported.Only supported in simple selects.To define which 500 records are deleted, this might be an alternate solution:delete from where ID in (select first ...

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

1 VOTE

Smart shared memory dumps

Other database products when dumping shared memory including context relevant information. E.g. which partition was being accessed. Contents of last buffer pool page being accesssed.If the buffers pools are massive e.g. hundreds of gigabyes then t...

11 months ago in Informix / Informix Server 0 Submitted

8 VOTE

Archecker table level restore utility does not compatible of handling Informix engine complex table schema clauses

Individual Table restoration 'archecker' utility only support simple schema definition contents as the schema file. However, Informix engine support complex clauses when setting up a table. E.g. When fragmenting a table based on interval based fra...

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

10 VOTE

DBSPACETEMP environment variable needs to accommodate multiple page sizes concurrently

When using DBSPACETEMP, the listing in onconfig is limited to one pagesize. The environment variable for DBSPACETEMP also allows for one page size. The engine needs to be able to pick the correct pagesize for temp space usage, and the current arch...

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

Please enter your email address

FILTER BY CATEGORY