Fix list for Informix Server 14.10.xC8 release

Release Notes


Abstract

Informix Server provides periodic fixes for release 14.10. The following list is the most recent report of defect fixes for customer-reported defects in 14.10.xC8 releases. This report combines both Windows and UNIX-specific defect fixes, and is more current than the defect information included in the product release.

Content

Fix Pack 14.10.xC8

Fix release date: 15 April 2022

Status: Recommended

APAR

Abstract

IT39131

HQ Agent logs too many connection errors when Informix server is in quiescent mode

IT38276

XML Files Names are Incorrect in InformixHQ FAQS

IT39598

Naming Convention is not consistent for Secondary Informix Server in HQ Screen

IT39946

InformixHQ - "Cannot update server type" error in Informixhq-server.log when trying to view server status

IT38814

IHQ DBschema SPL Display Needs Formatting

IT39569

InformixHQ.sh list can give incorrect output

IT39333

RepositoryDataCleanupJob seems to write to console when there is an issue

IT39965

HQ user interface can show Informix server type as UPDATEABLE even when Informix server is standard

IT38932

INFORMIX HQ SERVER ALLOWS ENTRY FOR DUPLICATE SERVER

IT38273

USING DEBUG MODE FOR LOGGING IS DISPLAYING SSL_TRUSTSTORE_PASSWORD IN plain text

IT39156

Heavy sysprocplan logical log activity after updating stats for tables in a procedure or function

IT39862

Assert crash seen in bldfragexlist when table is being replicated with ER

IT39150

CM returns sporadically 908 when connecting to a SLA with a server group definition behind and target has multiple names

IT39909

Update using join updates more than one row.

IT39315

Potential memory leak in a SP environment when dynamic SQL with cursor is used and SQL errors occurred in the SPL flow

IT39508

Query with functional predicate with LIKE operator does not use functional index at all

IT39594

Statement Statistics of SQLTRACE incomplete when statement includes a function call in the predicate

IT40074

Missing read-ahead in RSS undergoing logical log restore

IT40221

Data dictionary mutex wait may never return leading to hang of multiple sessions

IT39394

--max_part_size units incorrectly defaulting to MB rather than kB

IT38573

Dbaccess receiving SEGV signal when loading UTF-8 data and GL_USEGLU is set to a value greater than 0

IT39149

Select with PDQ and subquery can produce wrong results

ICHCL

Update of table with TEXT column fails with error -346/-124 when number of rows updated is larger than 32767

IT38689

Looping "WARNING: mt_aio_wait: errno == EINVAL operation = 3" message when adding raw chunk when size+offset is too large

IT39738

"onstat -g ses NNN" doesn't work sometimes for customer on a busy system.

IT38543

Scary "CDR RQM Error: 'ctbufdata_inline' column missing for on-disk queue tables!" message when upgrading to xC6

IT39684

Unique constraint violation with duplicate value (error -268 / -100) seen on a replicate but row does not exist

IT38625

AF caused by -28014 in stress connection conditions

IT38594

Recommended settings for OFF_RECVRY_THREADS and SEC_APPLY_POLLTIME on larger systems may result in logical log apply performance degradation on Secondary Servers

IT38068

Error -998 not found with finderr

IT39035

Query with connect by can raise  9722: Specify a non-zero SQL error number in the RAISE EXCEPTION statement

IT38692

Running a backup with onbar to PSM to Amazon S3 hangs with error "ifxcurl_easy_perform() failed(35): SSL connect error."

IT38471

Error -9601 not found with finderr

IT39316

A chunk added with storage provisioning is not rolled back on the secondary when it was a long transaction

IT38986

On mode -c block via API on RSS may fail to fully block leaving mreplay thread in cond wait RESUME_app and then no more Log Apply occurs until restarted

IT37948

Migrate-console can throw -239/-100

IT35763

Exceptions in the JVM running on the jvp don't appear to be passed up to server threads executing the Java udrs, leaving them stuck

IT34056

On-Bar/PSM error is reporting while doing a logical log salvage

IT26490

Query with massive number of entries in in-clause can assert server

Document Information

Modified date:
18 April 2022

UID

ibm16572949