Search results: Informix Server

Showing 99 of 5250

Enable chunk rename during log recovery

Whenever Informix performs a backup of the rootdbs, it automatically backs up Informix critical files (oncfg, onconfig & sqlhosts). When the Informix critical files are restored via "onbar -r -cf only -t <A TIMESTAMP>", it restores the l...

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

3 VOTE

Use mapped user rather than UID in SQLTRACE data

When getting ready to use mapped users, we have found that SQLTRACE does not distinguish the externally named users, but rather uses the local systerm's mapped user UID. This is a security and usability issue. From the usability standpoint, there ...

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

3 VOTE

Completely drop storage of all data and index partitions with truncate table command

I just truncated 2 huge tables, after "alter table extent size nnnn".. It took a while for the storage to come down to new extent size, but only table partition shrunk. Index partitions was unaffected, still huge.

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

2 VOTE

restore to point in time when using external table with archecker

With IDS11.7 , when using external table, I could only restore the table being deleted from the instance Level 0 backup with archecker, can't restore those data from logical log. If i use normal table, archecker could restore the data from both th...

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

1 VOTE

For buffer spinslocks show if loops are for read or writes

When reviewing onstat -g spi for buffer spinlocks e.g. fast mutex, 3:bf[1024] fast mutex, 3:bhash It would be great if we could tell if this is from either: a) Read access i.e. more app caching/better query plans/more data archiving+purgin needed ...

about 4 years ago in Informix / Informix Server 0 Future consideration

2 VOTE

Avoid engine crash during page reads after hardware failure

the index was corrupted by a hardware malfunction, it was not corrupted by Informix, so there were very likely index pages that had been zeroed out, or had garbage on them. When engine try to access the corrupted index or data page it crashes de i...

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

1 VOTE

Show mapped paths in ontape restore

Customer has two instances in same server one "real" for production and one for development. Development instance data is synchronized from real data by restoring production instance ontape Level 0. As both are in the same server, a chunk mapping ...

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

2 VOTE

odbc support for Red Hat Enterprise Linux 7.1

When use redbrick ODBC on Red Hat Enterprise linux 7.1 we are getting ERROR ** (10127) Data type -8 out of range. (SQL-WS000) when we try to query char type. All works well on numeric data types. That is the reason we decided that we need updated ...

about 10 years ago in Informix / Informix Server 0 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 11 years ago in Informix / Informix Server 0 Not under consideration

1 VOTE

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

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

Please enter your email address

FILTER BY CATEGORY