Informix

Showing 503

Identify/log slow queries on a busy system

SQLTrace offers the DBA the tooling required to monitor a user session. However its difficult to monitor heavily used systems. For example one needs to have a buffer large enough to store 90 seconds of SQL queries (small lookup SQL's consume the b...

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

6 VOTE

Data Masking in INFORMIX

Our objective is not to see any sensitive data outside the production systems. As an example here is our real requirement. In a PROD environment, we can see the table data as usual . For data protection purposes, the data of the same table needs t...

almost 2 years ago in Informix / Informix Server 1 Future consideration

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.

11 months ago in Informix / Informix Server 1 Submitted

4 VOTE

Allow renaming a database when BTS Index is defined

When renaming a database that has a BTS (Basic Text Search) index defined, it fails with error -9874. In the documentation it reads: [...] The RENAME DATABASE statement fails with error -9874, however, if the specified database contains any of the...

over 1 year ago in Informix / Informix Server 1 Not under consideration

6 VOTE

CM should support majority-vote failover arbitration as an alternative to priority-based

Currently, the Informix Connection Manager handles failover arbitration on the basis of a priority setting in the ${CMCONFIG} file. This has the effect of making a single CM the judge, jury and executioner when it comes to failover events. And it ...

almost 2 years ago in Informix / Informix Client Products 0 Future consideration

6 VOTE

JDBC driver shouldn't require SSLCONNECTION to be set when SQLHOSTS is used

Currently, the Informix JDBC driver requires SSLCONNECTION=true for connection strings that involve a TLS database listener. But when SQLH_TYPE and SQLH_FILE are set, the sqlhosts file already contains this information in the protocol field; it th...

almost 2 years ago in Informix / Informix Client Products 0 Future consideration

6 VOTE

CM should report client IP and SLA when errors occur

Our connection managers routinely log failed client attempts to connect via the CM, but when this happens, it doesn't report the client's IP nor does it report the name of the SLA via which it's trying to connect. Both of these would be incredibly...

almost 2 years ago in Informix / Informix Client Products 1 Future consideration

4 VOTE

Ability to rotate encryption at rest keys on the Engine

Corporate security has requested us to change the EAR keys on demand as they see having the same key as a security risk. We would like to see a feature to change the .sth and .p12 files in an easier manner.

over 1 year ago in Informix / Informix Server 0 Not under consideration

2 VOTE

Add bloom filters similar to SQL Server.

Add bloom filters similar to SQL Server. https://sqlperformance.com/2019/08/sql-performance/batch-mode-bitmaps-in-sql-server This is complex bitmaps "This sets one or more bits in the bitmap structure according to the result of applying one or mor...

8 months ago in Informix / Informix Server 0 Not under consideration

30 VOTE

Allow column ALIAS in HAVING clause

Just recently while working on a customer we were able to speedup a very slow query by using the recently introduced OLAP functions. The query looks like this: SELECT col1, col2, col3, col4, rank() over (partition by col1, col2 order by col4 desc)...

about 10 years ago in Informix / Informix Server 0 Not under consideration

Please enter your email address

FILTER BY CATEGORY