Search results: Informix Server

Showing 179 of 2614

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 6 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 6 years ago in Informix / Informix Server 0 Future 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 12 years ago in Informix / Informix Server 0 Not under 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 12 years ago in Informix / Informix Server 0 Not under consideration

2 VOTE

Prevent ER sync job of deleting records from child table on target

After talk with lab and support group the follwoing became clear: Under certain circumstances ER sync job can delete data from tables even if these tables are not part of the ER system. When a replicated table (target) has an unique index on a non...

over 12 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 6 years ago in Informix / Informix Server 0 Not under consideration

1 VOTE

Implement UUID keyword/function

Implement UUID keyword and function and allow to use it in: 1. SELECT operations 2. As default value when creating a new table 3. Inside an SPL procedure/function Security is a must. Using serials or any other autoincrease numbers as ident...

over 6 years ago in Informix / Informix Server 0 Delivered

1 VOTE

External Tables - export whole database

There should be a functionality to create external tables automatically for all tables in a database, similar to dbexport or onpladm. Unfortunately, not all data types support external tables fully (timeseries, for example). Datablade data types s...

almost 7 years ago in Informix / Informix Server 0 Delivered

1 VOTE

OnBar selective space backup restore allow non-backup spaces online but empty

Most of our customer base rely on selective space OnBar backups. As 99% of our customer base have been used a concept called Copy live database to a test database under the same instance (obviously, with different database and DBspace name) for ev...

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

1 VOTE

Lock monitor, show table name and How long has waited?

onstat -k can show table name;Can save below information when lock wait occurred.1) session id and SQL statement which hold the lock.2) How long it hold the locks. 3) Table lock information.

over 7 years ago in Informix / Informix Server 2 Not under consideration

Please enter your email address

FILTER BY CATEGORY