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

Fix release date: 15 Mar 2023

Status: Recommended

APAR	Abstract
IT31055	onpsm cloud stdio documentation wrong/old
IT42767	Server generating the AF with "Assert Failed: yield_processor: Conditional latch count nonzero Error"
IT42053	"cdr modify replicate --cascaderepl y\|n" nearly ineffective
IT42660	Informix dbms DataBlade returning 0 bytes for getlength on files > 2gb
IT42672	Replicating smartblobs greater than 2GB issue.
IT36979	An Admin CKPT is initiated during a Level 0 archive for each Logical Log dropped causing high contention in active environment
IT42221	Only one crypto vp is being used on the RSS node when the VP is set multiple.
IT42034	Update Statistics distributions are not using index when index definition matches table definition and FLS is enabled
IT42285	AF generated when using GROUP BY for select query with genbson function
IT42814	Running onstat -g cluster verobose on primary server with HDR setup shows "Time of last ack: 1970/01/01"
IT42433	Select first with year(today) query on fragmented table does not return any row
IT42536	Recursive CTE SELECT query works in 12.10 and fails in 14.10 with error 26088
IT42677	"onstat -g top session cpu 1" always throws "Errors found in session block list. May be caused by changing data structures."
IT41654	Massive parallel activity to the same table can create a bottleneck on mutex wait pt_partnum
IT42763	Error 706/111 - dbschema prints GRANT statements in alphabetical order
IT42601	Insert with a remote select part using a date/datetime SPL variable return -201 from the remote server
IT42999	Drop table with over 45 million sblobs can assert bad allocation size (negative) for pool smartblob
IT41553	DDRBLOCK / rsccompdict corruption after rollback of a transaction that created and filled a compressed table (For example, slow ALTER TABLE)
IT40284	Missing read-ahead recovering CLR records
IT40416	Memory corruption when executing two Java udrs on the same column in the same statement
IT39411	Colmin, colmax explanation needs to be changed
IT36316	Installation documentation should include the requirement for both /tmp and IATEMPDIR to not have noexec set for their respective filesystem
IT31575	Remove "Smart Analytics Optimizer Studio" from 14.10 IWA documentation
IT42708	Silent install on Windows does not install IBM GSKit
IT42749	Trailing blank after ssl.enable=true are not removed, leading to cryptic error messages, as connection will not use SSL
IT42992	Naming Convention is not consistent for Secondary Informix Server in HQ Screen
IT43218	We should have an option to show the password being typed in the setup for both ids instance and hq agent
IT43217	The time for incidents should not be an interval, but a real date and time
IT43053	HQ screen should tell why index is greyed out
IT41932	The informix hq agent does not change the frequency of running if server is in quiescent mode
IT39486	InformixHQ: When HDR is disconnected and then subsequently reconnects there is no alert sent
IT42106	Allows to hide system catalog tables in system reports -> table activity
IT43219	Informixsq agent still logs exception
IT43222	In Storage Tables & Indexes "Include System catalogs" needs to be changed to "Include System catalog Tables"
IT36618	The onconfig parameter BAR_ENCRYPTION and BAR_DECRYPTION is missing