IBM Support

IBM Informix CSDK/Server v15.0 Published Cumulative Special Build Fix Lists

Fix Readme


Abstract

IBM Informix CSDK/Server v15.0 Published Cumulative Special Build Fix Lists

CSBs are cumulative, with each CSB containing all fixes delivered in previous CSBs.
CSBs are listed in descending order, with the most recent ones at the top. As a result, earlier-listed CSBs include all the fixes from those listed further below.
CSBs and the listed Known Issues (KIs) may be updated retroactively.
The list covers only Informix Server, Client SDK and Warehouse.
Not all CSBs are included in this list.
CSBs are generally not available for download on Fix Central.

Content

15.0.1.0 Cumulative Special Build 1

2026-1-28

KI NumberKI Title
DT420102Running the oncheck -cDI command against an HDR primary results in an Assert Warning if the table contains a mix of BTREE and BTS indexes.
DT423212Select on a bson column throws error -937 "bson_to_char: mi_lo_to_buffer returned 8136, but the UDT had 8498 bytes".
DT454571When updating a page with outstanding in place alters after ALTER TABLE from char to varchar, errors with 'bfcheck bad page pg_frptr <size> < sizeof(ifx_page_t) 24 or > slotbeg <size>'.
DT455110When btscanner invokes BTMERGE on a raw table index, the resulting BTMERGE log record triggers an assertion failure during log roll-forward.
DT456203The dbload option -i, which specifies the number of rows to ignore in the input file, is not functioning correctly.
DT456590Updating BSON columns with ASCII characters above 127 may throw 959/172 error(s) a trigger an Assert Failure.
DT456892Running dbschema -d <databasename> -t all -ss <filename> with STMT_CACHE=2 generates errors: -959,-172, -25582, -349.
DT457129Considering two tables populated with the same data but with different indexes; when executing the same query on both tables, the results varied. The expected outcome is that the results should be identical.
DT457498The 'onstat -g afr smartblob' command should show the originating location allocating the memory.
DT458516Errors are displayed while running 'oncheck -ccp <database>' after migrating from 12 or 14 to 15.
DT458702A query with just the skip clause might not get a good plan.
DT461016When STMT_CACHE=2, dbschema induces 'Assert Failed: No Exception Handler'.
IT45658CREATE A FUNCTION WITH A LVARCHAR PARM USING SQL_LOGICAL_CHAR AND UTF8 CAUSE PROBLEMS IN SCHEMA GENERATION
IT45946ROLLBACK EXCEPTION HANDLER WITH OPEN CURSOR RAISING ERROR 721 WITH A NON-EXISTENT UDR NAME
IT46130ORPHANED TEMP PARTITIONS FROM A COLLECTION DERIVED TABLE INSIDE A STORED PROCEDURE COMPILED WITH NON-ZERO PDQPRIORITY
IT46413SESSION HANG OR ASSERT FAILURE MAY OCCUR IF INSUFFICIENT RESOURCES AVAILABLE WHILST CREATING THREADS FOR PARALLEL INDEX BUILD

 

 

15.0.0.2 Cumulative Special Build 5*

2025-12-4

*This is the final CSB for this mod/fix pack release.

KI NumberKI Title
DT213836IT43658: RESTORE FAILS WHEN DIRECT_IO IS SET TO 2 AND RESTORE IS MADE TO A CORRUPT FILE USING EXPRESS EDITION
DT416321IT42532: ONCHECK -PE OR -CE MIGHT REPORT SMART BLOB ERRORS WHEN RUN ON A HDR / RRS SECONDARY
DT447941Multiple concurrent execute function task 'pushdata delete' on the same session id could caused AF.
DT450808Logical log backup is running infinitely with 'ontape -a -d'.
DT452716DBACCESS THROWS UNKNOWN ERROR MESSAGE -36206.
DT453684'Tab' character gets lost in replication when replicate is defined with the --UTF8=y option.
DT455027AF in charcmp() in FOREACH inside SPL with ORDER BY and VARCHAR / LVARCHAR data type size mismatch at SPL definition.
DT455118When total memory used across the stmt. cache memory pools > STMT_CACHE_SIZE then statements won't be cached impacting the performance of server.
DT456348CREATE OR REPLACE PROCEDURE results in the error 201: Syntax error using dbimport.

 

15.0.0.2 Cumulative Special Build 4

2025-11-18

KI NumberKI Title
DT259187IT45316: INSERT A CLOB COLUMN VIA AN EXTERNAL TABLE ON A UPDATABLE SECONDARY MAY FAIL WITH DIFFERENT ERRORS
DT454679Assert Failed when running update with join on a partitioned table.
DT455160Query returns incorrect data when the rowid value is NULL.
DT455632ONCHECK -CC REPORTS ROW SIZE MISMATCH ERROR, SELECT MAY THROW -480 ERROR AND AN UPDATE STATISTICS MAY THROW -252 ERROR AFTER MIGRATION FROM 12 TO 15

 

15.0.0.2 Cumulative Special Build 3

2025-11-4

KI NumberKI Title
DT416383IT45488: ARCHIVE PHYSICAL VALIDATION FAILED WHEN EXECUTED AGAINST ONPSM BACKUP
DT420636System table ph_run may not have any rows deleted when AlertCleanup() is run.
DT446292Alter fragment on table <tab1> attach on fragmented table rebuilds all the existing index partitions.
DT448677AF hanging thread on secure connection (SSL) which leads to stack overflow and hung session.
DT450006An OLAP query with over / partition by causes an exception in olap_open/ev_colret_int.
DT451902If the first call of a sysdbopen SPL fails after an instance restart, all subsequent calls fail too.
DT452555Query on a large fragmented table running slower in 14.10.xC11.
DT452611Update statistics high on fragmented temp table may fail with -768 mbmerge2bin error or error 312/100.
DT452616An infinite wait may occur on the ER sendq mutex rqmut_trg_send when memory is exhausted.
DT452624Assert Failed while closing a database after running a stored procedure.
DT453169Interactive dbaccess survives the loss of the terminal consuming an entire cpu.
DT454170OLAP query (OVER...PARTITION) with statement cache and nested table expression fails in ev_colret_int.
DT454248AUS Evaluation and Refresh throws Warning and Error -201 when table OWNER name has hyphen in it.

 

15.0.0.2 Cumulative Special Build 2

2025-9-23

KI NumberKI Title
117192The DBMS_LOB_SUBSTR function randomly displays garbage characters.
117546Sort operations may run for extended periods of time without yielding.
117549Potential for extended wait times on terminated readahead requests.
117702Performance issue and different query plan from inside SPL compared to a plain query when FIRST n is in the query and n is passed in as a SPL variable.
117728Update command with a join is failing with -245 error when PDQPRIORITY is set.
117793ASSERT FAILURE DURING CLEANUP OF FAILED IFXCLONE OPERATION
117794INTERACTIVE DBACCESS SURVIVING LOSS OF TERMINAL CONSUMING AN ENTIRE CPU
117816NO WAY OF KNOWING/AVOIDING DATA TRUNCATION WITH LENGTH RESTRICTED CHAR/NCHAR/VARCHAR/NVARCHAR FIELDS

 

15.0.0.2 Cumulative Special Build 1

2025-9-9

KI NumberKI Title
DT425421Index creation fails on small table which is created in a 256k dbspace.

 

 

15.0.0.1 Cumulative Special Build 4*

2025-8-5

*This is the final CSB for this fix pack release.

KI NumberKI Title
DT260110IT45398: DBSCHEDULER IS NOT STARTED ON SECONDARY SERVER AFTER PROMOTION TO PRIMARY AND HAVING JUST MIGRATED TO 14.10
DT409388IT47209: ALTER TABLE CAN LEAD TO CORRUPTED DATA FOR THE NEXT SELECT WHEN VARCHAR IS INVOLVED
DT417603Dbimport failed with "Assert Failed: Thread exited with 1 buffers held."
DT425192Accessing a corrupted index with a MUTLI_INDEX scan results in an exception.
DT436091[POWERPC] ST_Union is very slow
DT438564Assert Fail while executing a query that includes MOD() and has an argument passed as a host variable.
DT438578Restore between editions should be possible if the version is exactly the same.
DT440534Physical logging activity prior to physical recovery may lead to recovery errors.
DT444015Improvements for oninit -S command line option to start server in standard mode.
DT444134Server crash in uhash_find_71() when connecting to an UTF-8 database with GL_USEGLU set.
DT444833Prepared statement using ENCRYPT_AES which has an empty parameter throws Assert Failed: Condition Failed (Bad allocation size (0) in fnencrypt().
DT447054There needs to be a termination and/or timeout mechanism for hung ER connections.
DT448077RTREE rollback error in recovery.
DT448600A query on table with in-place alters fails with "Assert Failed: rowalter: PTOCOPYVC: collen (0x1f) > max_vc_len (0x7) (cmpoff: 0x10b, uncmpoff 0x227".
DT448869INSERT INTO...SELECT FROM an external table into a raw table inserts more rows into the raw table than what is in the external table if PDQPRIORITY is set high enough.

 

15.0.0.1 Cumulative Special Build 3

2025-7-29

KI NumberKI Title
DT416393IT45465: SYSMASTER DATABASE MAY BE RELOCATED OUTSIDE THE ROOT DBSPACE DURING MIGRATION WHEN AUTOLOCATE IS ENABLED
DT447373CDRPager Warning  CDR Pager: Read mismatch, checksum error found or not, but then  bfcheck: bad page: pg_addr  != bp->bf_pagenum.
DT454043Sblob and buffer corruption from creating sblobs using LO_BUFFER.

 

15.0.0.1 Cumulative Special Build 2

2025-7-1

KI NumberKI Title
DT390062IT46394: RESTART OF INSTANCE WILL START MIGRATION OF BLADES WHEN MIGRATION HAS HAPPENED WITH DIFFERENT EDITION
DT415846IT29600: BTS index creation on a temporary table should fail with a proper error message.
DT436546Remote select on a view can throw Assert Failed and then fail with -874.
DT438240Error -9753 when executing a remote stored procedure from within a DRDA connection with SQLTRACE enabled.
DT440529Using the extractvalue function will change the codeset of the included data.

 

15.0.0.1 Cumulative Special Build 1

2025-6-10

KI NumberKI Title
DT178531IT42679: SYSADMIN TASKS FAILING WITH SQL ERROR -217
DT225047IT44181: GETMETADATA().GETCOLUMNS IS RETURNING WRONG TYPE FOR COLLECTION TYPE LIST
DT225718IT44233: REBUILD OF SYSMASTER DATABASE DURING INSTANCE STARTUP WHILST SESSIONS ARE CONNECTING MAY RESULT IN ASSERTION FAILURE
DT259228IT46671: IF MISSING PAGES CAN BE REPAIRED FOR A SMARTBLOB SPACE, A WARNING INSTEAD OF AN ERROR SHOULD BE REPORTED.
DT261850IT45556: VERY SPECIFIC CONNECT BY QUERY RESULTS IN EXCEPTION IN MAKEIDXFUNC
DT365702IT45842: ONUNLOAD FAILURE WRITING TO OUTPUT DEVICE POTENTIALLY CRASHING  THE SERVER
DT392081IT46571: UPDATE STATS ON A SP USING REQEXP DATABLADE DEADLOCKS WITH AUTOREGEXE SCHEDULER TASK ON SP LOCKS
DT392527IT46575: ATTEMPT TO EXTEND A CHUNK WHICH BELONGS TO A TENANT MAY FAIL WHEN THE TENANT IS NOT IN THE CACHE
DT400935IT46880: OPTIMIZER IS CHOOSING A LESS EFFECTIVE INDEX FILTER WITH 'OR' COMPARED TO 'IN' CONDITION.
DT416380IT45635: AF IN OPTIMIZER DUE TO RANGE FILTER WITH CHAR COLUMN ON A TABLE PARTITIONED WITH ROUND ROBIN FASHION.
DT416423IT46163: ASSERT FAIL WHILE EXECUTING INSERT STATEMENT IN DRDA_SQLCA_DATA
DT417605Query with 'set environment implicit_pdq 1' returns error -768: Internal error in routine compute_op_mem: operator not in phase.
DT420192Using the NO_SUBQF environment variable in an SPL environment is inconsistent.
DT421753SERVER FAILS IN TLSETOBJ WHEN RENAMING CONSTRAINT INSIDE A PROCEDURE
DT423220Potential for assert failure on remote secondary server during connection establishment.
DT423234AF in conby_addcoltotab while executing a 'WITH CTE AS' SQL and onstat -g ses shows error -522.
DT425325A large, poorly written IN clause may cause memory corruption.
DT425830DATABASEMETADATA FUNCTIONS NO LONGER WORK WITH INFORMIX JDBC 15.0.0.0
DT426148Users other than informix or dbsa are still able to connect to the server in Single-User mode if ADMIN_USER_MODE_WITH_DBSA is set to 1.
DT426753Assert Failed: Dropping wrong TBLSpace, requested 14904545 != actual 14904544.
DT436660Assert Failed in ASF_FreeSqlhOptions
DT436661RSS_Recv thread on RSS server can assert while submitting the readahead request.

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"ARM Category":[{"code":"a8m500000008cmKAAQ","label":"Installation \/ Upgrade \/ Migration-\u003EPID \/ Patch \/ Fix List"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"15.0.0;15.0.1"},{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCVRDE","label":"Informix Client Software Development Kit"},"ARM Category":[{"code":"a8m0z000000TNARAA4","label":"Informix-\u003EClient SDK"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"15.0.0;15.0.1"}]

Document Information

Modified date:
29 January 2026

UID

ibm17257092

Page Feedback