Informix Server

Showing 431

Unable to see fully qualified name in a trigger for seme instance

we have created as view using fully qualified name but while getting schema it is not showing complete DB address. scenario is given below. create table test_table ( col1 int, col2 varchar(20),col3 datetime year to second default current year to s...

11 days ago in Informix / Informix Server 0 Submitted

1 VOTE

Add new chunks while a backup is in progress

In huge environments with lots of data changes it is important to add more space (chunks) to a dbms at any time. Currently this is not possible while an L0 backup is running. Depending on the size of an dbms an L0 backup can take several hours. Th...

about 2 months ago in Informix / Informix Server 0 Submitted

1 VOTE

Improve Ontape Point-in-Time Restores for Tables

The archecker tool can be used for point-in-time restores of table data from Level 0 Informix backups in conjunction with whatever logs were created after the Level 0 backup. However, if an organization does one Level 0 backup per week, then they ...

3 months ago in Informix / Informix Server 2 Submitted

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

4 months ago in Informix / Informix Server 0 Submitted

1 VOTE

DDL alters to not disable auditing on tables.

DDL (See with Alter table) to not disable WITH AUDIT on tables.

4 months ago in Informix / Informix Server 1 Submitted

1 VOTE

Internal hash tables - remove limit on amount of data.

As per case TS006348841 currently internal hash tables have a limitation on the amount of data that can be copied into the internal hash table "At the end all the rows/columns must be copied into a hash table. And this is too much data." E.g. A gr...

6 months ago in Informix / Informix Server 0 Not under consideration

1 VOTE

Add sql causing change when dictionary entries become dirty.

When onstat -g dic entries become dirty add sql causing this to the onstat -g dic output.This would allow diagnosing issues better. This does not need to be persisted to storage. When sysprocplan entries become invalid this would also allow diagno...

6 months ago in Informix / Informix Server 0 Not under consideration

1 VOTE

oncheck should report all bad rowids in an index.

oncheck should report all bad rowids in an index. Current oncheck stops at the first bad rowid, this makes it impossible to tell if there is more than 1 bad rowid in an index.

6 months ago in Informix / Informix Server 0 Not under consideration

1 VOTE

Enhance onstat -g prc information

Enhance onstat -g prc information: Last recompile datetime Add sql statement that causes this entry to last recompile if changed Add location column (module/line) similar to onstat -g afr output for last change to this entry if an object changed s...

6 months ago in Informix / Informix Server 0 Under review

1 VOTE

Enhance onstat -g dic information

Enhance onstat -g dic information Add datetime entry was created Add sql statement that causes this entry to be created if an object changed. Add location column (module/line) similar to onstat -g afr output that causes this entry to be created if...

6 months ago in Informix / Informix Server 0 Under review

Please enter your email address

FILTER BY CATEGORY