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

Fix release date: 14 Jun 2024

Status: Recommended

APAR ID Abstract
IT38039 CDR VIEW RISDIR -R ON EXISTING RIS FILES REPORT "PARSE INPUT FILE FAILED:"/"ATS OR RIS FILE FORMAT ERROR" MESSAGE
IT38813 INFORMIX HQ - SQL EDITOR IS NOT ALLOWING TO RUN MULTIPLE SQL STATEMENTS AT A TIME
IT40417 COMPRESSION CREATES THOUSANDS OF BACKGROUND TASKS IN PH_TASK
IT42994 IMPROVE HQ WHEN INFORMIX SERVER IS HANGING IN BLOCKED:LAST_LOG_RESERVED4BACKUP
IT41190 IWA HAS DEPENDENCY ON LIBXERCES-C-3.1.SO BUT RED HAT 8.5 COMES WITH LIBXERCES-C-3.2.SO
IT41511 IDS AND CSDK INSTALLERS THROW EXCEPTION ON WINDOWS 2019 OR NEWER
IT42080 UPDATE STATISTICS CAN FAIL WITH -567/-179 ERROR EVEN WITH PLENTY OF FREE SPACE IN THE TEMP DBSPACE
IT42302 SERVER CAN ASSERT IN STMP_CHOOSEDBS_INTERNAL IF DBSPACETEMP CONTAINS NON TEMP DBSPACES
IT42405 EXTENT-LESS PARTITIONS BLOCK THE DROP OF A SEEMINGLY EMPTY DBSPACE
IT42519 WINDOWS INTERMITTENT MAPVIEWOFFILEEX ERROR, NOT ABLE TO ATTACH TO SHM FROM UTILITIES IE. ONSTAT, ONCHECK DUE TO WINDOWS ASLR
IT42662 HQ SERVER SHOULD SHOW STORAGE - SPACES - STATUS AS ENCRYPTED WHEN THE DBSPACE IS ENCRYPTED
IT30618 SQEXPLAIN QUERY STATISTICS LESS THAN HELPFUL AND INCORRECT WITH RE-EXECUTED PREPARED STATEMENTS
IT42892 SLOW BLOBSPACE BLOB CREATION WITH LARGE NUMBER OF UNCOMMITTED FREED BLOBPAGES
IT35313 SESSIONS MIGHT SHOW BUFFER AND LOG BUFFER WAITS WHEN A HDR SECONDARY IS STARTING
IT43214 HQ SERVER DISPLAYS A MISLEADING ERROR MESSAGE AFTER A CONNECTION ERROR
IT43213 INFORMIX HQ Agent CAN THROW NULLPOINTER EXCEPTIONS
IT43028 UPDATE STATISTICS CAN FAIL WITH -567/-172 AND ASSERT WARNING: SORT FAILED: TOO MANY ROWS FIT INTO SORT MEMORY
IT45223 ALTER TABLE REMOVES ROW-LEVEL AUDITING
IT43100 CREATE BTS INDEX IN PARALLEL CAUSES "BTS: MUTEXES BEING HELD TO END_SESSION CALLBACK" MESSAGES OR INFINITE MUTEX WAITS
IT43143 SYSTEM SEARCHES EVERY FEW SECONDS FOR A CONNECTION MANAGER AND "MAKES ALARM" ON THE HQ SCREEN
IT43185 REPLICATION->HIGH AVAILABILITY->CLUSTER TOPOLOGY DOES NOT REFLECT "UPDATABLE" PROPERLY
IT43211 CREATE INDEX ON TEMPORARY TABLE FAILS WITH 517 ERROR WHEN RUN ON SECONDARY SERVER WITH AUTOLOCATE ENABLED
IT43206 LAG() AND LEAD() OLAP RANKING FUNCTIONS CORRUPTING LARGER RESULT SETS WITH IGNORE NULLS
IT43235 INSERT STMT ON VIEW CAN FAIL WITH AF, WHEN RUN AFTER ALTER TABLE ON UNDERLYING TABLE DUE TO OLD COLUMN TYPE IN DATA DICTIONARY
IT43242 AF RAISED AFTER NEW FRAGMENT ADDED TO A TABLE WHILE RUNNING UPDATE STATISTICS WITH PDQ.
IT42809 CDR AND SPOOL PROCESSING CAN HALT WITH WAITERS ON CDRGSERIAL MUTEX WHEN ANY CDR STOP REPLICATE
IT43290 "ARCHECKER FAILED! ERRNO = 3." VERIFYING A BACKUP OF A NON-DEFAULT PAGE SIZE DBSPACE WITH MANY CHUNKS
IT43291 USING ****** FOR USER AND PASSWORD WILL THROW ASSERT WARNING: WARNING: MT_AIO_WAIT: ERRNO == EINVAL ON AIX
IT43293 .NET CORE: CALLING GETSTRING() PRIOR TO CALLING GETDATETIME() THROWS INVALIDCASTEXCEPTION
IT43306 ONSTAT -G BPA CAN BE HUGE, SHOULD BE EXCLUDED FROM BOTH ONSTAT -A AND -G ALL
IT43299 ALTER FRAGMENT DETACH DOES NOT DELETE INDEX FRAGMENT AND IS ALSO RECREATING THE INDEX WHEN INDEX IS FUNCTIONAL INDEX
IT43357 DELETE A LARGE AMOUNT OF ROWS FROM AN BTS INDEX IS ALLOCATING A LOT OF VX MEMORY
IT43328 CDR REPAIR THROWS ERROR IF THE ABORTED TRANSACTION CONTAINS NEWLINE (\N) CHARACTER.
IT43422 SELECT CHOOSING SLOWER QUERYPLAN IN 14.10. THAN IN 11.50 - RELATED TO MULTI INDEX SCAN
IT43426 INFORMIXHQ:  OPERATING SYSTEM DISK I/O SENSOR ON AIX CRASHES AGENT
IT43435 ERROR -937 WHEN USING UNLOAD/LOAD ON A TABLE WITH BLOB > 2GB
IT43446 SQLEXEC CAN HANG USING UPPER() WITH TURKISH SPECIAL CHARACTER
IT43478 ONSMSYNC CAN FAIL WITH "-535  ALREADY IN TRANSACTION" AFTER A RESTORE
IT43492 HQ SERVER SYSTEM REPORTS -> TABLE ACTIVITY IS NOT SHOWING USER TABLES
IT43499 CONNECTING A JAVA PROGRAM TO IDS USING SSL CAN FAIL WITH ERROR "UNSUPPORTED PROCTOCL TLS" WHEN USING IBM SEMERU 11 OR 17
IT43516 USE OF GLOBAL SQL TRACE MAY LEAD TO REDUCED PERFORMANCE
IT43578 AF IN OPLOOKSUBQ DURING PREPARE OF MULTIPLE SQL STATEMENT WHICH INCLUDES SET ENVIRONMENT AND SSC IS ENABLED
IT43642 CTE SIMPLE SELECT BASED ON AN EXPRESSION BASED TABLE WITH MORE THAN 100 FRAGMENTS GETS STUCK IN TLGETCOLLTAB
IT43653 VAGUE EXTENT CHECKING ERROR AND EMPTY CHUNK OR DBSPACE "NOT EMPTY" BECAUSE ADMIN API ALLOWS CHUNK SIZE UNALIGNED WITH PAGE SIZE
IT43666 IDS_INSTALL EXECUTED WITH ROOT FAILS WITH MSG "INSTALLER RUNNING AS INCORRECT USER" IF THE INFORMIXDIR ALREADY HAS IDS INSTALLED
IT43676 RESTORE POINT AF WITH BAD ALLOCATION SIZE (-268435456) FOR POOL 'RSTPOINT' (0XXXX)), IN (MT_SHM_MALLOC_SEGID) IF A CHUNK IS 4 TB
IT43684 WRONG OR MISSING INDEX ON CR SHADOW TABLE IF TABLE REPLICATED VIA UNIQUE INDEX RATHER THAN PRIMARY KEY
IT43686 INSERT MAY RAISE -874 WITH TRIGGER CALLING A STORED PROCEDURE WHICH WILL START ANOTHER TRIGGER
IT43688 DELETE ON AN EMPTY TABLE CAN FAIL WITH -244/-111 WHEN TABLE IS CREATED WITH AN EXTENT SIZE
IT43711 SMART TRIGGER EVENT RETURNS ONLY 256 CHARACTERS FOR A LVARCHAR(32000) COLUMN
IT43744 RESTORE USING CHUNK RENAME OPTION AND RENAMED ROOT CHUNK INCORRECTLY UPDATES ROOTOFFSET
IT43752 9952 - AGGREGATE WITHIN A ROW IN A SELECT PROJECTION LIST IS NOT ALLOWED
IT43830 768: INTERNAL ERROR IN ROUTINE WRTMBDIST() WHEN DOING UPDATE STATISTICS BY USER HAVING RESOURCE PRIVILEGE.
IT43562 A THREAD CAN CONSUME 100% CPU UTILIZATION IN A SOCKET BACK FLOW SCENARIO LOOPING SEND() CALLS
IT43844 QUERY_TIMEOUT CONSTRAINT GETTING BYPASSED EXECUTING A PLAN-BASED QUERY IN KEY-ONLY AND/OR PARTITIONED MODE
IT43898 AN ALTER FRAGMENT INIT STATEMENT ON A PRIMARY WILL ALLOCATE LOTS OF LOCKS ON AN UPDATEABLE SDS INSTANCE, CAN LEAD TO A CRASH.
IT43904 USING THE OLAP LAG FUNCTION WITH A COLUMN NAME AS THE DEFAULT VALUE WILL LEAD TO A 959 ERROR
IT43906 SELECT WITH A SUB-QUERY GENERATES ASSERT FAILURE ALONG WITH ERROR 874: GENERAL EXCEPTION ERROR HAS OCCURRED IN THE OPTIMIZER
IT43728 SESSIONS ABLE TO CONNECT DURING FAST RECOVERY MAY CAUSE ASSERT FAILURE
IT43984 ADD A LIMIT TO THE NUMBER OF ATTEMPTS TO LINK A STATEMENT TO THE SHARED STATEMENT CACHE
IT41337 SETTING SESSION_LIMIT_TEMPSPACE LIMIT KILLS INFORMIX/DBSA USER SESSION
IT44033 SMX_PING_INTERVAL SETTING PING MECHANISM CAN BE VERY CPU EXPENSIVE WHEN ELAPSED TIME REACHED CAUSING PERFORMANCE SPIKES
IT44034 VARIOUS MEMORY CORRUPTION WITH STMT_CACHE AND EXT_DIRECTIVES ARE ENABLED
IT44047 PERFORMANCE IMPROVEMENTS TO REDUCE WAITS RELATING TO PARTITION OR DBSPACE MUTEX
IT44068 ER STARTUP FAILURE DUE TO BAD CDR_QDATA_SBSPACE CONFIGURATION POTENTIALLY LEADING TO ASSERTIONS
IT44146 LONG LASTING PUSH DATA SESSIONS CAN ACCUMULATE LARGE AMOUNTS OF MEMORY EVEN IF CONFIGURED TO DISCARD MOST RECORDS
IT44064 CREATING OR EXECUTING SOME STORED PROCEDURES CAN ASSERT IN CMPREXPRTREE2 WITHIN SQOPTIM
IT44087 ROWS RETURNED BY A QUERY WITH MULTISET AND A CONNECT BY - STOPS SOMETIMES CAN ASSERT AND SHOWS AN ERROR
IT44076 ONCHECK -PE ON TEMP DBSPACES CAN OCCASIONALLY REPORT ERROR:CHUNK FREE PAGES: ###, EXTEND FREE PAGES: ####.
IT44113 GRANT ADMIN TO USER THAT HAS "-" OR "." RAISES ERROR "FAILED TO ADD USER IDS-USER2 AS AN ADMIN USER"
IT44118 AN ENCRYPT THREAD CAN LOOP FOREVER IN A RUNNING STATE WHEN ERRNO IS 11
IT44133 SET ENVIRONMENT IFX_FOLDVIEW DEFAULT NO LONGER FUNCTIONAL
IT44137 HQ STORAGE DBSPACE USAGE GRAPHICAL REPRESENTATION IS OVERPOPULATED
IT44199 EXT_DIRECTIVES ONCONFIG PARAMETER CHANGE IS NOT REFLECTED IN ONLINE.LOG
IT44299 QUERY RETURNS 768: INTERNAL ERROR IN ROUTINE OPJOIN() WHEN IFX_FOLDVIEW=1
IT44239 THE ERROR "SENSOR NOT FOUND" SHOULD ALSO GIVE THE NAME OF THAT SENSOR.
IT44264 LONG LASTING PUSH DATA SESSIONS CAN ACCUMULATE LARGE AMOUNTS OF MEMORY EVEN IF CONFIGURED TO DISCARD MOST RECORDS
IT44348 STORAGE -> TABLES & INDEXES: SELECTION OF A DBSPACE IS IGNORED AFTER "UPDATE INFORMATION"
IT44376 AUS REFRESH REPORTS ERROR 206 FOR ANSI DATABASE TABLE WITH TABLE OWNER IN LOWERCASE LETTERS
IT44369 .NET CORE: COMMUNICATION LINK FAILURE AFTER DATABASE IS BROUGHT DOWN AND BACK ONLINE
IT44371 INFORMIXHQ: H2DB EXCEPTION "VALUE TOO LONG FOR COLUMN" WHEN SAVING DASHBOARD
IT44867 REDUCE CONTENTION ON DDH CHAIN MUTEX FOR OPERATIONS ON SAME DATABASE TABLE
IT44460 REPLICATESET COMMANDS ASSERT CRASH IN DAC_MODIFY_REPL WHEN SET DEFINED AS EXCLUSIVE.
IT44485 CDR START' CAN GENERATE ASSERT FAILED: YIELD_PROCESSOR: CONDITIONAL LATCH COUNT NON-ZERO IN THREAD.
IT44565 ASSERT FAILURE IN SMX PIPE CREATIONS DURING ER STARTUP.
IT44604 POST COMMIT TRIGGER (ER2SPL): MULTIPLE PROBLEMS WITH ALTER SUPPORT, REMASTER AND (LIFTED) PRIMARY KEY REQUIREMENT
IT44609 ONSTAT -G SCH CAN CORE DUMP WHILE STARTING THE SERVER.
IT44711 SOMETIMES THE  NUMBER OF ALERTS IN THE ROOT GROUP DOES NOT MATCH THE NUMBERS SHOWN FOR INDIVIDUAL SERVERS
IT44715 MEMORY LEAK IN RITEM (RSBTREE.C:3914)
IT44734 TASK 'MODIFY CHUNK EXTENDABLE' MAY RETURN ERROR  'FAILED: STORAGE PROVISIONING - INVALID ARGUMENT' FOR VALID CHUNK NUMBER
IT44815 CREATING AN INDEX USING UDT COLUMNS LIMITS THE SIZE OF THE INDEX TO 16,775,134 DATA PAGES PER FRAGMENT
IT45433 A COUNTER IN THE BUFFERPOOL MAY NEGATIVELY AFFECT PERFORMANCE EVEN WHEN BUFFERPOOL IS NOT MARKED AS EXTENDABLE
IT44928 LIBNCURSES.5 IS NOT LONGER SUPPORTED ON RHEL9
IT44925 COLLECTION SUBQUERY RETURNING A LVARCHAR CAN THROW ASSERT FAILED IN CHECK_SUBQUERY_REMAKE
IT44934 VARIOUS ASSERTION FAILURES SEEN IN FUNCTION STCMPRI WHEN RUNNING A STORED PROCEDURE MORE THAN ONCE
IT44984 MEMORY CORRUPTION WITH CERTAIN QUERIES CONTAINING SPL THAT UTILIZE LVARCHARS AND FUNCTIONAL INDICIES
IT44960 ONSTAT -A CORE DUMPS OCCASIONALLY AND CORE FILE DOESN'T SHOW ANY USEFUL BACK TRACE.
IT44996 SMX4ER PROBLEMS IN LOW FOOTPRINT ENVIRONMENTS
IT45029 DELETING ROWS FROM TABLE WITH PRIMARY KEY ON 2 VARCHAR COLUMNS LEAKS RITEM POOL MEMORY WHEN DTC CLEANER RUNS
IT45048 CONTINUAL UPDATE OF SYSPROCPLAN ENTRIES FOR STORED PROCEDURES QUERYING TABLES WITH PARTIAL INDEXES
IT45122 LOOPBACK PSEUDO SERVER DEFINITION FAILS IF ER SERVER IS A NON-ROOT
IT45169 ERROR -665 WHEN USING "CREATE OR REPLACE" PROCEDURE ON AN UPDATABLE SECONDARY.
IT45250 TABLES & INDEXES PAGE IN HQ WHEN ALL DATABASES IS SELECTED IS OPENING MULTIPLE JDBC CONNECTIONS
IT45269 SPORADIC -908 FROM CONNECTION MANAGER WITH SERVERS PROVIDING LISTENERS FOR DIFFERENT PROTOCOLS
IT45391 ASSERT FAILURE WHEN USING HASH INDEX AND SPL
IT45318 POTENTIAL FOR DATA LOSS OR INDEX PROBLEMS IN TABLES LOCATED IN ROOT DBSPACE WHEN EXTENDED RESERVED PAGES ARE IN USE
IT45385 OR A DRDA CONNECTION, THE IP ADDRESS SHOULD NOT BE RETURNED TO THE CLIENT
IT45397 SERVER STATUS IS INCONSISTENT IN IHQ
IT45413 A PRIMARY & RSS CAN STOP TRANSMITTING DATA AND STATUS SHOWS BLOCKED OR BLOCKLOGXMIT
IT45420 ONSTAT -G CFG SHOWS SEC_LOGREC_MAXBUFS AS DYNAMIC (TUNABLE =*) BUT IT NEEDS RESTART TO TAKE EFFECT.
IT45509 DBSCHEMA IS STUCK IN "WITH SYSPROCAUTH_CTE..." QUERY APPARENTLY TRYING TO DETERMINE THE STORED PROCEDURE PERMISSIONS STATEMENTS
IT45632 NEW ER NIF CONNECTION OVER SMX MIGHT HANG IN 'CONNECTING' STATE WITH UNRELIABLE NETWORK
IT45626 MEMORY LEAK OF OSMUTEX BLOCKS IN GLOBAL POOL WHEN USING REMOTE QUERY WITH PAM ENABLED.
IT45593 QUERY FAILING WITH -959/-172 IN EV_NULL_FUDT
IT45640 POTENTIAL PARTITION CORRUPTION WHEN TRUNCATING A TABLE AFTER ALTERING ITS EXTENT SIZE
IT45641 ASSERT FAILURE POSSIBLE DURING INSERT OPERATION INTO A TABLE WITH AN ACTIVE CREATE INDEX ONLINE OPERATION
IT45676 A DBSCHEMA OR DBEXPORT WILL HANG IF THE THE DATABASE IS CREATED WITH 8859-2 CODE SET AND CLIENT_LOCALE IS SET TO UTF8.
IT45693 DBIMPORT IS RETURNING 201 ERROR WHILE IMPORTING A PROCEDURE/FUNCTION WITH CREATE OR REPLACE SYNTAX
IT45782 GRANTS ON STORED PROCEDURE IS MISSING IN DBSCHEMA OUTPUT
IT45843 .NET CORE:  CONNECTION POOLING IS NOT TAKING INTO ACCOUNT IDLE CONNECTIONS
IT45859 REPLICATION -> HIGH AVAILABILITY -> SMX INFO IS SHOWING SAME INFORMATION FOR SECONDARY AND PRIMARY
IT45985 GET_PRODUCT_INDEX() POTENTIALLY CAUSING UNDETECTED STACK OVERFLOW AND MEMORY CORRUPTION
IT46185 HUGE MEMORY CONSUMPTION USING AN LVARCHAR WITH A LIKE WITHIN A STORED PROCEDURE IN A UTF8 DATABASE