Informix Server

Showing 454

Functionality for optimizer to prevent it to miscalculate the plan to execute derivedtable query

Functionality for optimizer to prevent it to miscalculate the plan to execute derived tables query generated by Cognos

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

Column level encryption, an option to cleanup passwords on certain/all rows for DBSO or Informix

All users which are granted permissions for insert/modify data into tables are also allowed to use their own password for column level data encryption. But not all user are their whole lifetime in the company and move. What happened with their dat...

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

1 VOTE

Column encryption, select rows with different passwords without errors

When using char/varchar columns with the option of encryption each user can choose his own password and more worse multiple passwords. All is well in case I read the data without decrypt() then I see the raw data for encrypected data and the real ...

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

1 VOTE

determine length of data stored in smartblob

Just because data is stored as a smartblob not blob, we have to go to a work around solution to get "LENGTH" of blob stored. By using length(smartblob) the amount of bytes stored in the smartblob should be returned. The LENGTH function works if ...

almost 5 years ago in Informix / Informix Server 1 Functionality already exists

2 VOTE

Killl a Query on the IWA

I would like to be able to kill a query currently being processed by the IWA accelerator using an ondwa command.

over 9 years ago in Informix / Informix Server 1 Not under consideration

2 VOTE

Cannot logically restore a table when restoring smart blobs

System: IDS archeckerActor: Barmenia DBA Team We use archecker to perform table-level-restores. For various reasons it has to be on a point-in-time basis, which is not possible if a table has columns of data type blob.The following error occurs: E...

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

1 VOTE

InformixHQ - Backup Sensor

I would kike InformixHQ Backup Sensor notify me whenever Backup Level 0 is greater than 24 (hours). But the Backup Sensor did not work with "hours format", just "timestamp", so It is impossible to know when the backup is older than 24 hours becau...

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

1 VOTE

Create and use a BTS index over a temporary table.

drop table if exists tp01 ;create temp table tp01 ( nome varchar(100) ) with no log ;insert into tp01 select first 1000 tabname from systables ; create index i1_tp01 on tp01( nome bts_varchar_ops) using bts ; select * from tp01 where bts_contains ...

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

2 VOTE

Feature Request: Allowing dirty read capability beyond ETX 1.31.xC2

IDS 11.70.FC7W2 OS AIX 6.1 ETX version expression) DataBlade version: Excalibur Text DataBlade Release 1.31.FC1X3 Problem: Due to the fix of IC73561 may have introduced the new behaviors on 1.31.xC2 that impact customer's current operation. Custom...

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

2 VOTE

Table statistics are zero'd from sysptprof everytime it is not open or there is no sessions accessing it.

Our understanding is that tblspace profile should remain in the records as long as 'onstat -z' is not issued. Besides, we are aware of situations when table profile is reset, while several sessions are still accessing the table. Therefore, we find...

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

Please enter your email address

FILTER BY CATEGORY