Informix Server

Showing 34

Set explain on to show time spent on query optimixation.

Set explain on to show time spent on query optimixation. Then we can see which sql could benefit from optimizer hints to reduce cpu usage and improve performance.

3 months ago in Informix / Informix Server 0 Submitted

1 VOTE

Get Informix SQLTRACE working with DRDA

Our Informix server is currently being used by clients using the Informix Protocol ("onsoctcp") and the new web clients are using DRDA ("drsoctcp"). When addressing performance issue we extensively use SQLTRACE to pin point "slow" queries. We are ...

4 months ago in Informix / Informix Server 0 Submitted

1 VOTE

archecker provide audit summary of tablenames and row count number foreach database/table in a db archive.

when using archecker : having the utility produce an output report, that contains summary information of the contents of an informix archive (ontape or onbar ) :for example:a report that lists the DBNAMES, TABNAMES, NROWS within the archive object.

4 months ago in Informix / Informix Server 0 Submitted

1 VOTE

Support LIMIT clause in Common Table Expressions

Using LIMIT clause in a CTE gives a syntax error (with IDS 14.10.FC10) sf@toro (master):~/genero/devel/dbsync/dbsync$ cat x.sql WITH recent_rows AS (SELECT log_ordinal FROM dbsync_log WHERE log_table_name = 'stkitem' ORDER BY log_ordinal DESC LIMI...

4 months ago in Informix / Informix Server 0 Submitted

3 VOTE

For sysprocplan add reason for last change/recompile.

For sysprocplan add reason for last change/recompile. E.g. nidexname dropped, tablename changed version. Indexname changed version. This would help when sysprocplan changes keep being logged.

11 months ago in Informix / Informix Server 0 Submitted

2 VOTE

Connection Manager should have an option to initiate failover if a shared memory dump is started.

In high transaction environments shared memory dumps could have enough impact they cannot be enabled.The connection manger should be able to detect that an instance is dumped shared memory and be able to initiate failover.

9 months ago in Informix / Informix Server 0 Submitted

1 VOTE

Add function of updating chunk path by ontape and onbar

add a new feature/function to onbar & ontape, to allow it to update chunk path. This will be very useful when customers do DB clone/db refresh from a cooked chunk db instance. So after clone/copy, customers just need to update the new chunk pa...

4 months ago in Informix / Informix Server 1 Submitted

1 VOTE

Certify Informix 14.10 on red-hat 7

Our version of Informix will expire before our extended contract for red-hat 7, so we would like to upgrade the database in place to 14.10 from 12.10.fc13. Can you certify that? And give us a download for 14.10 that will not fail if we load it to ...

4 months ago in Informix / Informix Server 0 Submitted

2 VOTE

Increase 128 character limit for ADMIN_MODE_USERS onconfig parameter

ADMIN_MODE_USERS is a useful way of ensuring DBAs and critical monitoring scripts can connect in single user mode. Unfortunately this parameter is limited to 128 characters which is insufficient for the team we have and the three system accounts t...

10 months ago in Informix / Informix Server 1 Submitted

3 VOTE

Support DESC keyword for describing schema objects

Simple request: Support the DESC keyword commonly used by other databases as a synonym for the wordy 'INFO COLUMNS FOR'. This will help new users to Informix as well as being less to type for everybody else.

over 1 year ago in Informix / Informix Server 1 Submitted

Please enter your email address

FILTER BY CATEGORY