IBM Support

Fix list for Informix Server 14.10.xC6 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.xC6 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.xC6

Fix release date: 16 June 2021

Status: Recommended

Download: IBM Marketing Registration Services or Passport Advantage

APAR

Abstract

IT36867

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

IT35838

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

IT35176

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

IT35717

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

IT35049

NEEDODBCTYPESONLY NOT WORKING AS DOCUMENTED

IT35392

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

IT35946

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

IT34770

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

IT35726

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

IT35784

onmode -c block can result in a very busy cpu vp

IT35908

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

IT35514

TLR (archecker) is broken on 14.10.xC5 with CommVault as Storage Manager.

IT35284

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

IT35174

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

IT36073

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

IT34875

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

IT35390

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

IT36315

Setting IATEMPDIR does not redirect all output to $IATEMPDIR

IT35940

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

IT36410

Potential contention on checkpoint fast mutex during non-blocking checkpoint

IT36187

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

IT35490

onstat -g laq shows wrong numbers for Queue Size

IT36138

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

IT35329

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

IT35527

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

IT36349

cdr migrate server: dbschema -noindex is not suppressing Constraint

IT36530

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

IT35580

okstore can return EAR ERROR -91105 parsing JSON answer from server

IT35218

Search of SDS paging file is inefficient for large file sizes

IT34937

select from sysonlinelog may result in assertion in add_mb_gfd_to_list

IT34812

Combination of keyword and semicolon inside return statement giving syntax error

IT35875

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

IT34139

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

IT34194

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

IT34310

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

IT34687

onmode -b: drop 11.50 as a possible option for reversion in usage display

IT34965

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

IT35970

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

IT34875

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

IT34762

Tenant re-create is not working after using compression

IT35125

HQ Agent can drop too many tables when cleaning sensor tables

IT32018

Incident screen same message is getting printed repeatedly

IT35375

Informix HQ Unknown? Status for Online Server.

IT35042

informixHQ:  OS memory graph shows all memory used

IT35575

InformixHQ.sh gives function: not found

IT35565

FileNotFoundException by Agent for .keystore in distributed Informix HQ Setup

IT35757

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

IT36375

Performance degradation opening Hikari datasource

IT36070

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

IT35942

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

IT35220

JDBC fails to connect to group when using SSL

[{"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"ARM Category":[{"code":"a8m0z0000001ifkAAA","label":"Informix Publications-\u003E14.10"}],"ARM Case Number":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF017","label":"Mac OS"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"14.10.0","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
02 September 2021

UID

ibm16473487