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

Fix release date: 23 June 2020

Status: Recommended

APAR

Abstract

IT30087

DR_IXRDROP does not protect DRBRP->bt_rstcb from being cleared during attempt to call ixrdrop.

IT30851

cdr check --where clause on replication key columns rules out REPLCHECK index scan even if it could be used

IT30870

cdr defined with unique key having primary key on multiple columns throws an error (Primary key missing from column list) when running cdr sync

IT30899

Querying sysmaster:syssqexplain with CLIENT_LOCALE set generates assert failure

IT30902

"(-43082) Writing to backup and restore filter failed" with RESTORE_FILTER restoring reserved pages

IT30983

on linux x86-64 server can assert initializing kaio with -22 EINVAL from io_queue_init

IT31063

Executing a java based UDR where the jar file is bigger then 16KB returns 38000

IT31109

"ALTER SEQUENCE ... INCREMENT ..." can reset the sequence count after "ALTER SEQUENCE ... RESTART..."

IT31187

ALTER TABLE throws Assert Failed in setconcol when every column is in index and column list is long(?)

IT31262

dynamic explain is not taking updated filenames and takes only first file name when enabled it by executing task function in dbaccess

IT31506

Running a specific query returning in memory corruptions, invalid mutex types or an exception in groupcopyfunc

IT31587

-244/-126 on secondary when table with size big enough to need remainder pages and update needs before/after image

IT31666

Select with expression followed by  group by and the order by clause with expression causes assert failure

IT31693

sporadic -25824 alter fragment attach on table fragment by range interval month to month

IT31725

"Cannot update pagezero" errors as upgrading from pre-12.10.xC8 to 14.10 leaving pagezero in dubious state

IT31726

EXECUTE FUNCTION (...) INTO <column>, within a trigger action, broken if medium or high level SQL tracing is on

IT31766

wrong results, when alias names in sub query are the same as in outer query, and then used in order by clause

IT32022

Running "update statistics for procedure ..."  causes assertion failures however the updates statistics finishes without errors

IT32027

Errors -214 -242 & -958 can be reported when dropping and creating temp tables within a SPL and with AUTO_READAHEAD set to 2,4096

IT32257

sqlexec thread can get stuck spinning indefinitely in pfsc_add_or_upd() while in critical section and block checkpoints

IT32336

Reversion from 14.10.FC3 to 11.70.FC7 gives error : SCHAPI: SQL Error -705, ISAM Error 0 in file $INFORMIXDIR/etc/sysadmin/conv/revert_1410xC2.sql at line 50

IT32447

A query with JOIN and UNION which uses same alias on projection list gives 26088 error

IT32526

Querying data from sysmaster:sysconblock generates assert failure

IT32729

Archecker with CommVault errors on barGetObject() with ERROR(arc_onbar.c : 981) BUG, numbtes(0) < headerlen(4096)

IT32768

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

Document Information

Modified date:
23 June 2020

UID

ibm16235776