IBM Support

Fix list for Informix Server 14.10.xC5 releases

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.xC5 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.xC5

Fix release date: 10 December 2020

Status: Recommended

Download information

APAR

Abstract

IT34038

SQL Administration API Functions - Task with onstat command's -r option fails

IT33939

Incomplete choices for DUMPSHMEM parameter in Informix HQ

IT33887

InformixHQ- Not able to display and Delete more than 50 rows from Incidents tab, Also wrong incidents count on server card.

IT31538

InformixHQ misbehaves while repack/shrink of attached indexes

IT31535

InformixHQ-Agent throws exeptions on AIX "diskio info out of iostat" when trying to use sensor

IT30370

Refresh not happening at Row level

IT34404

Connection Properties value for a 'Password field' should not be in Readable Format

IT34513

select on datetime can throw  -1268 when index is read via upper index filter and lower index filter

IT34626

-874 or -768 or sigsegv when repeatedly opening/closing a cursor involving distinct aggregate

IT34640

Windows: Edition installer fails if gskit dlls are not in path

IT33528

Last digit often truncated with MSG_DATE=2 or 3

IT34195

Assert Failure or hang possible on primary server when using CDC and HDR secondary server

IT33526

onstat -g top on secondary doesn't work

IT32830

Select substring op [] on views w/ queries using substring ops [] on *char types can produce unpredictable results/crashes

IT33766

PSM, when splitting backup objects in multiple pieces, potentially unable to find all of them again

IT33566

Windows: In some cases libisi.dll is not installed as a dll, but instead a directory is created

IT34246

log recovery errors on secondaries if restarted too soon after instatiation from physically restored non-whole-system backup

IT34089

onlog does not work on a file being created with ontape and backup/restore filters.

IT34172

select statement using a subquery will fail with 528 error

IT33823

ifxclone for an RSS may fail with "HDR: Could not start HDR subsystem." resulting in engine terminating with no diagnostics

IT34191

log recovery can hang when skipping log records older than the dbspace being recovered

IT33390

memory duration problem with C UDR used in query WHERE clause

IT32783

upgrade from 11.70.FC9 to 14.10.FC3 of database with spatial blade  leaves old external name in sysprocbody for GeometryEqual

IT33419

BTS index with default SBSPACE and dbimport failure

IT32768

dbinfo(dbspace) raises 727: Invalid or NULL TBLspace number

IT27640

sessions can connect to server during fast recovery

IT33938

update statistics for procedure can fail with -959/-172 and Assert Failed

IT34258

onstat -k hugely expensive with PARTITION_NAMES enabled

IT33793

STS_SubtrackCreate() can fail with (USE31) Too few points for geometry type in SE_API_make_linestring.

IT34044

Running 'oncheck -cR' in an encrypted instance fails with errors 'Log page error: invalid address.  Log number 1, addr -43:-1160213497'

IT22083

dodelitem could not delete item failures on secondary nodes

IT34414

During big inserts AUTOLOCATE can continue to create new fragments, when the orignal dbspaces for the table are full

IT33677

Version upgrade can fail with no clue on what's wrong

IT34031

CDRNs thread  can get stuck continually running after spooling with loopback repl2spl replication

IT34132

SUBSTRING_INDEX('ÖA-Ö','-',1) does not return expected result

IT33875

install_jar() is failing with -650 with SQL_LOGICAL_CHAR ON

IT33216

Cleanup of suspended XA transactions using MSFT style may corrupt RSAM memory

IT34344

ALTER TABLE ADD using BEFORE clause can change the definition of a functional index

IT34066

set explain off can cause assert fail calling mt_aio_fclose from setexplain

IT30689

DR:Warning: The table minversion DBA feature is enabled on this secondary printed in online.log eventhough no mismatch within pri/hdr

IT34205

Statement with group by can cause -640 error in statement cache and then trigger SEGV assertion trying to cleanup

IT32196

Rollback of transactions involving logrecords > 10k will trigger readahead messages in MSGPATH file

IT33524

TRUNCATED VALUES INSIDE STORED PROCEDURE USING NVL()

IT32496

select with SORT is slower because it is using sequential scan even if index exists

IT33397

Front end version (FEVERS) is sent as '14.10' rather than '9.59' the SQL version (SQVERS)

IT33816

InformixHQ- NULL error on the SDS Status Information screen

IT33553

Schema Manager Information tab throws "Value exceeds limit of INTEGER precision" error

IT32067

RA_Q_List mutex contention and hot ReadAhead spin lock when there are many readahead threads

IT34925

query on RSS can assert segv in btnext when primary table is truncated

IT32952

onpsm -C detail causes segmentation faults

IT33445

aio vp keeps library loaded even after function module is unloaded

IT33563

SCRIPT INFORMIXHQ.SH CAUSES : SYNTAX ERROR: '=~' UNEXPECTED OPERATOR/OPERAND USINF KSH IN LINUX

IT33562

SCRIPT INFORMIXHQ.SH CAUSES 0403-057 SYNTAX ERROR AT LINE 26 : `(' IS NOT EXPECTED. USING SH/KSH IN AIX

IT32988

Error on enabling Compression in InformixHQ

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"ARM Category":[{"code":"a8m0z0000001ifkAAA","label":"Informix Publications->14.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:
10 February 2021

UID

ibm16372974