Fix list for Informix Server 14.10.xC5

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.

APAR

Abstract

IT33788

libisi on Windows should not be dependent on INFORMIXDIR from "System Environment"

IT27640

sessions can connect to server during fast recovery

IT30689

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

IT32067

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

IT32196

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

IT32496

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

IT32768

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

IT32783

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

IT32830

selecting substring operator [] on views containing queries with substring operators [] on CHAR/NCHAR types can produce unpredictable results and possible crashes

IT32952

onpsm -C detail causes segmentation faults

IT33216

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

IT33390

memory duration problem with C UDR used in query WHERE clause

IT33397

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

IT33419

BTS index with default SBSPACE and dbimport failure

IT33524

TRUNCATED VALUES INSIDE STORED PROCEDURE USING NVL()

IT33526

onstat -g top on secondary doesn't work

IT33528

Last digit often truncated with MSG_DATE=2 or 3

IT33566

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

IT33677

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

IT33793

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

IT33823

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

IT33875

install_jar() is failing with -650 with SQL_LOGICAL_CHAR ON

IT33938

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

IT34031

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

IT34044

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

IT34066

set explain off can cause assert fail calling mt_aio_fclose from setexplain

IT34089

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

IT34132

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

IT34172

select statement using a subquery will fail with 528 error

IT34191

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

IT34195

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

IT34205

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

IT34246

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

IT34258

onstat -k hugely expensive with PARTITION_NAMES enabled

IT34344

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

IT34414

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

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