Informix Server

Showing 309

Add profile counter for number of long transactions since most recent "onstat -z"

Rollback most of the time is a time and resource consuming action. We would like to be able to monitor how many long transactions we (just a simple profile counter), as currently it is not easy and accurate on how to determine the amount of long...

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

2 VOTE

Shorten the time spent by "onstat -z" when zeroing internal structures

As was diagnosed in ticket TS002495910, in customer's system "onstat -z" processing is causing about 1 second "block" every 5 minutes for all threads, that needed to acquire the global mutex. This causes problems in customer's system (one of the l...

over 4 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 bec...

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

5 VOTE

alter table online when modifying char length without killing the sessions

today my db is accessed through many web server. the main table is frequently modified : char increased and new fields. i had to bounce the engine to remove all the sessions easily.

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

2 VOTE

create a foreign key allowing one to one tables relationships

Our Primary Key and Foreign key constraints always have allowed creaing and ensuring '1 to many' table relationships. After researching, there is no direct way to implement such a case with Informix. The only safe way is to create a primary key on...

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

3 VOTE

14.10 macOS port

Informix 14.10 should available for macOS

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

13 VOTE

IF NOT EXISTS should not be saved as part of stored routine source

When creating a stored procedure or function with the IF NOT EXISTS optional clause included, the option text is currently included in the saved source code for the procedure. This is not true of any other database object created with the IF NOT E...

almost 5 years ago in Informix / Informix Server 2 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 ...

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

3 VOTE

Prepend machine's name to Assert files written to DUMPDIR

Scenario: The customer site uses a single network mount for DUMPDIR across hundreds of servers. Impact: difficulty in identifying AF files generated by specific servers. Current workaround: search online.log for all "stack trace for pid" strin...

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

3 VOTE

log_rotate sysadmin job for CONSOLE, PSM_ACT_LOG, PSM_DEBUG_LOG

There is a sysadmin job for rotation of logfiles for MSG_PATH, BAR_ACT_LOG and BAR_DEBUG_LOG.But for CONSOLE, PSM_ACT_LOG and PSM_DEBUG_LOG these sysadmin tasks are not configured/prepared in $INFORMIXDIR/etc/sysadmin/sch_tasks.sql

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

Please enter your email address

FILTER BY CATEGORY