Informix Server

Showing 452

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

1 VOTE

BAR_RETRY should retry failed dbspace backup instead of complete archive

If you run a whole onbar backup (onbar -b -w -L 0) and have several dbspaces to backup and one dbspace backup failsthe complete archive must be retried. If you run parallel backup (BAR_MAX_BACKUP > 0) you also need to wait untilall dbspaces are...

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

2 VOTE

Parallel index build and check is not supported on table with interval and range fragmentation.

CUSTOMER: CLEARTECH LTDA CONTACT.: Celso Cabral PRODUCT.: INFORMIX 11.70FC4X4 OS......: Red Hat Customer want to know how to if INFORMIX may use parallelism to create index using fragment by range and interval. eof--------------

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

Please enter your email address

FILTER BY CATEGORY