Fix list for Informix Server 14.10.xC5

APAR

Abstract

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

sessions can connect to server during fast recovery

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

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

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

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

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

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

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

onpsm -C detail causes segmentation faults

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

memory duration problem with C UDR used in query WHERE clause

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

BTS index with default SBSPACE and dbimport failure

TRUNCATED VALUES INSIDE STORED PROCEDURE USING NVL()

onstat -g top on secondary doesn't work

Last digit often truncated with MSG_DATE=2 or 3

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

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

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

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

install_jar() is failing with -650 with SQL_LOGICAL_CHAR ON

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

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

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

set explain off can cause assert fail calling mt_aio_fclose from setexplain

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

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

select statement using a subquery will fail with 528 error

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

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

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

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

onstat -k hugely expensive with PARTITION_NAMES enabled

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

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

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

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

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