Fix list for Informix Server 14.10.xC6 release

APAR

Abstract

When GSkit or openSSL is not preinstalled the required link for <code>$INFORMIXDIR/lib/libisi.so.2</code> is not created.

.NET Core Provider: Memory still leaking after fix for APAR IT35176

.NET Core Provider: Memory leaking bug in Informix CSDK for Windows 64 4.50.FC4W1

unixODBC isql utility throws error "undefined symbol: isi_init" when using CSM module for encryption

NEEDODBCTYPESONLY NOT WORKING AS DOCUMENTED

Connection Manager will not start when using CSM module.  Undefined symbol: isi_cipher_ctx_set_padding

"DATABASE <db>" works but "CONNECT TO <db>" reports -202 error.

Informix instance running on Ubuntu 20.04 fails to start after adding a shared memory connection

A password greater than 311 characters for a mapped user will crash the database server

<code>onmode</code> -c block can result in a very busy cpu vp

SCHAPI: SQL Error -530, ISAM Error 0 in file $INFORMIXDIR/etc/sysadmin/upgrade_ph_task.sql at line 817 while migrating from previous 12.10.xC10

TLR (<code>archecker</code>) is broken on 14.10.xC5 with CommVault as Storage Manager.

ReadAhead thread may not receive wakeup call resulting in hang of other threads

Complex CTE query hangs server with infinite loop in findtabloc()

<code>Ontape</code> level 0 does not archive temporary (implicit or explicit) partitions on dbspaces hence after restore different errors on <code>mappages</code> can be found.

compress, repack, shrink of Functional Index is showing as SUCCEEDED wrongly

14.10.FC4W1 optimizer choses assigns lower cost to slower query plan that uses index scans and 6 nested loop joins

Setting IATEMPDIR does not redirect all output to $IATEMPDIR

Memory leak on <code>ralloc</code> on remote server when using where date(datetime_col) = subquery with date_col from a synonym to the remote server

Potential contention on checkpoint fast mutex during non-blocking checkpoint

Server assert fail in valstore_deepcopy from query using union and concat of character fields > 215 and other fixed types

<code>onstat -g laq</code> shows wrong numbers for Queue Size

Re-optimization of query containing duplicate removal operation may result in error -392

Informix HQ error "Command failed: <code>onstat -r</code> (repeat) option is not supported with the admin api"

When trying to compress blobs in a table, if the compression would fail because < 2000 blobs, a 161 error is also generated

cdr migrate server: <code>dbschema -noindex</code> is Not suppressing Constraint

ER grouper memory leak with discrepancy between tables' real schema and ER's master schema

<code>okstore</code> can return EAR ERROR -91105 parsing JSON answer from server

Search of SDS paging file is inefficient for large file sizes

select from sysonlinelog may result in assertion in add_mb_gfd_to_list

Combination of keyword and semicolon inside return statement giving syntax error

External restore can fail during check of second chunk of the rootdbs

"rscGetCompDictRow: Dictionary not found" followed by log replay assertion on secondary servers

14.10.FCW1 dbaccess connections that perform a single insert are slower than 12.10

Print message in the bar_act.log, confirming that the object is encrypted

<code>onmode -b: drop</code> 11.50 as a possible option for reversion in usage display

Running <code>'oncheck -S'</code> on AIX fails with error 'Symbol get_product_letters was referenced but it was not found in <code>astools</code> library'

IFMX-2538 -- We need an ONSTAT_LEGACY environment variable that can be used to hide changes to <code>onstat</code> outputs

compress, repack, shrink of Functional Index is showing as SUCCEEDED wrongly

Tenant re-create is not working after using compression

HQ Agent can drop too many tables when cleaning sensor tables

Incident screen same message is getting printed repeatedly

Informix HQ Unknown? Status for Online Server.

informixHQ:  OS memory graph shows all memory used

InformixHQ.sh gives function: not found

FileNotFoundException by Agent for .keystore in distributed Informix HQ Setup

A blob is inserted into the wrong smart blobspace when using PreparedStatement.getParameterMetaData()

Performance degradation opening Hikari datasource

Metadata getColumns() is missing quotes for COLUMN_DEF for strings default values

With JDBC table parsing regex overflows the JVM stack on large inputs

JDBC fails to connect to group when using SSL