Fix list for Informix Dynamic Server 10.00.xC11

Informix Dynamic Server provides periodic fixes for release 10.00. The following list is the most recent report of fixes for customer-reported defects in Version 10.00.xC11. This report combines both Windows- and UNIX-specific defect fixes, and is more current than the defect information included in the product release.


APAR
Description
IC58275 SYSTEM TIME LEAPING BACKWARDS CAN LEAD TO ROWS/TRANSACTIONS FAILING AT TIMESTAMP CONFLICT RESOLUTION
IC58824 ABORT OF LONG TRANSACTION CANNOT BE DONE IF SQL IS REMOTE PROCEDURE CALL AND REMOTE SERVER IS NOT RESPONDING
IC58990 ONPARAMS HANGS IF DYNAMIC_LOGS SET TO 0 AND WHEN TRYING TO ADD A LOGICAL LOG WHILE WAITING FOR NEXT LOG TO BE FREED
IC59282 SLOW ALTER OF TABLE CONTAINING PARTITION BLOBS CAN FAIL WITH ERRORS 618/101 OR 618/770
IC59321 WINDOWS: ONSTAT NOT WORKING IF INFORMIXSERVER IS SET TO DBSERVERALIAS
IC59493 SELECT MAX RESULTS IN ASSERT FAILURE IN BTPREV
IC59652 MEMORY LEAK IN GENTCB WITH REPEATED CALLS TO SET COLLATION ON A GIVEN SESSION ID.
IC59761 THE GRANT COMMAND ALLOWS AN EMPTY STRING AFTER THE TO KEYWORD THIS CAN LATER CAUSE ERRORS -242/-104 IN DBEXPORT
IC59786 USING SELECT WITHIN A STORED PROCEDURE WHICH HAS PDQPRIORITY SET AND IS CALLED MANY TIMES IN A SESSION WILL CAUSE MEMORY LEAK
IC59797 IMPORTED RESTORE WITH VERITAS NETBACKUP FAILS DURING LOGICAL RESTORE WHEN SERVERNUM OF IDS DOES NOT MATCH THE SOURCE
IC59817 UPDATE TEXT COLUMN USING STRING LITERALS IN ODBC PRODUCES BLOB CORRUPTION ERRNO=-346 WHEN STMT_CACHE_HITS=2
IC59830 INITIAL CHECKPOINT AFTER HDR INDEX TRANSMISSION STARTS BLOCKS THE HDR PRIMARY INSTANCE
IC59880 SESSIONS CAN HANG IF A THREAD TERMINATES WITHOUT FIRST RELEASING SHAREABLE SPIN LOCKS
IC60006 SELECT OF NON-EXISTENT COLUMN ON TABLE USING RESERVED WORD FOR COLUMN NAME RETURNS -9628 INSTEAD OF -217 ERROR
IC60052 HIGH PERFORMANCE LOADER RETURNS WRONG VALUES IN RECORD IS TOO LONG TO PROCESS MESSAGE
IC60094 ONMODE -D SECONDARY CAUSES PRIMARY TO CRASH WHILE PRIMARY IS IN STANDARD MODE
IC60243 MISC VP CAN HANG WHEN SESSION WITH REMOTE QUERIES DISCONNECTS
IC60251 ERROR IN PROCESSING DYNAMIC EXPLAIN SHOULD NOT BE PASSED TO THE CLIENT
IC60286 INDEX ROLLBACK KEEPS ENGINE IN CRITICAL SECTION
IC60320 SQL QUERY WITH (1=0) IN WHERE CLAUSE TAKES LONGER TO RETURN RESULT
IC60471 LIGHT APPENDS DOES NOT WORK ON RAW TABLES IN IDS UNLESS USING SELECT INTO TEMP
IC60502 TIMESTAMPS WRAPS IN A SHORT SPACE OF TIME ON BUSY SERVERS
IC60514 ASSERT FAILED: YIELD_PROCESSOR: CONDITIONAL LATCH COUNT NON-ZERO IN THREAD 2402
IC60517 ADDITION OF A NEW CHUNK INTO SBSPACE IN NOT ROLLED BACK CORRECTLY DURING FAST RECOVERY
IC60559 CREATE TEMP TABLE WITH UNIQUE SERIAL AND NO LOG FAILS WITH ERRORS 626 AND 140 ON HDR SECONDARY
IC60560 ASSERT WARNING: CANNOT SEND INDEX INDEX WILL BE UNUSABLE ON SECONDARY
IC60561 ERROR MESSAGE -19831 INCORRECTLY DISPLAYED FOR ALTER TABLE WITH_CONSTRAINTS TYPE (RAW)
IC60564 AN INSERT ... SELECT STATEMENT WITH VIOLATIONS TABLE AND PDQ MAY HANG AND CAUSE A BLOCKED CHECKPOINT
IC60606 STORED PROCEDURE BEGINS INFINITE LOOP WHEN EXPRESSION IN THE RANGE IS NULL AND NO ERROR MESSAGE IS RETURNED
IC60612 CDRSTOP THREAD CAN CRASH WITH INVALID MUTEX TYPE IF ANOTHER CDRSTOP THREAD IS ALREADY RUNNING
IC60635 SET INDEXES IDXNAME ENABLED CAUSES A SERVER ABEND IN RSTIDXFRG WHEN A LONG TRANSACTION IS ENCOUNTERED
IC60654 ONCONFIG PARAMETER CONSOLE ERROR IN RESERVED PAGES
IC60687 ON AIX ONSHOWAUDIT ABORTS WHEN -L OPTION IS USED
IC60699 RUNNING ONCHECK WITH A VERY LONG ENVIRONMENT VARIABLE STRING DEFINED WILL CRASH THE ENGINE
IC60713 DBSCHEMA FAILS WITH SQL 211 AND ISAM 107
IC60751 ONAUDIT -L 0 DOES NOT PUT ENTRY IN ONAUDIT LOG FILE
IC60859 BEGIN ORDERED TRANSACTION LIST INCONSISTENT WHICH MAY CAUSE AN ASSERTION FAILURE
IC60860 WHOLE SYSTEM EXTERNAL RESTORE (EBR) FAILS WITH MESSAGE DBSPACE XXX NOT RECOVERED FROM SAME ARCHIVE BACKUP AS DBSPACE ROOTDBS.
IC60862 ASSERT FAILURE IN SQCON_RESTORE_UDR_CONTEXT
IC60886 ONSTAT -G MGM INCORRECTLY DISPLAYS NEGATIVE VALUES IN THE NUMBER OF FREE RESOURCES
IC60899 ATS FILE CREATION MESSAGE IS LOGGED IN ONLINE.LOG BUT NOT FOR RIS FILE CREATION
IC60990 ALARM 6 IN ONLINE.LOG IS TOO GENERIC. NEEDS TO IDENTIFY THE RESOURCE NAME THAT CAUSED THE ALARM.
IC60991 THE SIZE LIMIT OF 32 KB FOR ENVIRONMENT VARIABLES BLOCK AND THE RESULTING -1832 ERROR SHOULD BE DOCUMENTED
IC61050 CREATION AND USE OF RAW TABLES SHOULD BE ENABLED IN REPLICATED ENVIRONMENTS
IC61052 ORPHAN OBJECTS LEFT IN THE SPOOLING SMART BLOB SPACE SPECIFIED CDQ_QDATA_SBSPACE.
IC61072 PREFORMANCE DEGRADATION DUE TO CONTENTION ON THE DBS_PARTN MUTEX.
IC61080 DBEXPORT TOOK AN EXTREMELY LONG TIME TO FINISH WHEN DATABASE CONTAINS A LOT OF NOT NULL CONSTRAINTS.
IC61097 ERROR 206 WHEN USING A PROCEDURE REFERENCING A MISSING TABLE
IC61120 SPECIFYING DEFAULT VALUE FOR DATE DATATYPE INCORRECTLY RETURNS -591
IC61149 ONSYMSYNC -T RECEIVES INVALID POINT IN TIME VALUE SPECIFIED
IC61154 CHECKPOINTS OCCUR EVERY SECOND WHEN CREATING AN ONLINE INDEX ON A TEMPORARY TABLE IN A TEMP DBSPACE
IC61165 WINDOWS: IDS CRASHES IN NSOCPOLL WITH MESSAGE BUFFER ALLOCATION FAILED
IC61192 DBSCHEMA DOES NOT DISPLAY INDEX FRAGMENTATION ANY LONGER AFTER ALTER FRAGMENT DETACH
IC61194 INCLUDE MACHINE.H, SPECIFIED IN HPL CUSTOM DRIVER FILE EXAMPLE INFORMIXDIR/INCL/HPL/PLCSTDRV.H IS MISSING
IC61195 LONG PASSWORD CAUSES ASSERTION FAILURE OR CRASH
IC61315 UNABLE TO INSERT 3 DIGIT TAIWAN MIN GUO YEAR 100 WITHOUT DATE SEPARATORS
IC61340 25571 ERRORS FLOODS THE ONLINE.LOG WHEN WHEN SYSTEM EXCEEDS SHMTOTAL AND RISKS DISK FILL
IC61376 MEMORY CORRUPTION WITH COLLECTION DATA TYPE AFTER MIGRATING ENGINE FROM 32-BIT TO 64-BIT
IC61393 ALTER FRAGMENT INIT ON RAW TABLES WILL CREATE LOG RECORDS IN THE LOGICAL LOGS
IC61442 CHECKPOINT HANGS DURING UPDATE STATISTICS WHEN LIGHT SCAN IS TURNED ON
IC61443 ERROR 951/952 WHEN PASSWORD SHADOWING ENABLED ON HP-UX 11.11
IC61450 CHUNK MARKED DOWN WITH MESSAGE KAIO: ERROR IN KAIO_WRITE, KAIOCBP = 0X35047CA0, ERRNO = 0
IC61522 THE SERVER RECEIVES AN ASSERT FAILURE WHEN USERS CONNECT USING MAXCONNECT
IC61534 ENGINE DOES NOT RELEASE OPEN TABLES WHEN PDQ IS ENABLED AND AN UPDATE ON A NON-EXISTENT ROW IS PERFORMED.
IC61556 UNKNOWN ERROR MESSAGE DISPLAYED ON SQL EXCEPTION -21524
IC61558 PERMORMING MULTIPLE REMOTE QUERIES CAN CORRUPT THE DICTIONARY CACHE CAUSING AN ASSERT FAILURE
IC61664 769 RETURNED AFTER MULTIPLE EXECUTIONS OF QUERY WITH OUTER JOINS AND PLACEHOLDERS WHEN QUERY PLAN CHANGES IN BETWEEN EXECUTIONS
IC61747 UPDATE THE OUTPUT OF ISAM ERROR 136 TO INCLUDE THE LIMITATION OF MAX. NO. OF DATA PAGES
IC61831 CDR COMMANDS WITH -C OPTION FROM PRE-V11 TO V11 FAIL WITH ERROR MESSAGE
IC61836 ASSERTION FAILURE IN GETROW WHEN SQ_NFETCH IS ATTEMPTED ON CURSOR THAT IS OPEN ON AN INSERT STATEMENT
IC62025 STORED PROCEDURE FAILS WITH QPLAN SANITY FAILURE ERROR WHEN EXECUTED FROM AN HDR SECONDARY
IC62027 DATABASE SERVER CRASHES WHEN IT ACCESSES A CORRUPTED MEMORY POOL
IC62062 ERROR 1809 WHEN KERBEROS USERS TRY TO CONNECT WITH PAM-CSM AND PASSWORD IS LONGER THAN 8 CHARACTERS
IC62142 THE TO_CHAR FUNCTION RETURNS INCORRECT MONTH/DAY NAMES WHEN ANY OF THE CS_CZ.* LOCALES ARE IN USE
IC62230 EXTENT OVERLAP OCCURS ON THE SOURCE DBSPACE WHEN MOVING THE PHYSICAL LOG FAILS DUE TO A LACK OF SPACE ON THE TARGET DBSPAC
IC62231 SERVER ABEND IS POSSIBLE WHEN THE MAXIMUM BTREE DEPTH IS EXCEEDED
IC62278 THE MAXIMUM EXTENT SIZE IS LIMITED TO 64GB FOR TABLES WITH A 16K PAGESIZE
IC62738 A CURSOR WITH AN ORDER BY OR GROUP BY WHICH GETS RE-OPTIMIZED MAY RESULT IN A MEMORY LEAK
IC63305 WITH STATEMENT CACHE ENABLED A SELECT IN A CASE STATEMENT USING A SUBQUERY IN THE PROJECTION LIST RETURNS -769 ERROR/SEGV ASSE
IC63342 -143 DEADLOCK ERROR IS RETURNED WITH CONCURRENT READ AND WRITE OF THE SAME BLOB
IC63347 QUERY USING OUTER, GROUP BY AND DYN. HASH JOIN COULD RETURN WRONG RESULTS DEPENDING ON THE ORDER OF JOIN CLAUSES
IC63352 CDR CHECK REPLICATE/REPLICATESET COMMAND CORE DUMPS
IC63353 USING CDR MODIFY TO CHANGE REPLICATE FREQUENCY FROM IMMEDIATE TO TIME BASED DOES NOT WORK
IC63354 SEQUENCE OBJECT VALUE NOT CORRECT AFTER FAILOVER
IC63454 ENGINE HANG IN MT_SPIN_WAIT_LOCK DUE TO MEMORY ALLOCATION IN GENTCB_ALLOC
IC63516 ONUNLOAD FAILS WITH ILLEGAL ARGUMENT TO ISAM FUNCTION IF THE DATABASE OR TABLE BEING UNLOADED CONTAINS A DISABLED CONSTRAIN
IC63630 ONTAPE LEVEL 0 HANGS AS READ TICKET WITH DEAD PARENTS KEEPS THREAD WAITING TO BE PROMOTED TO READ/WRITE MUTEX
IC63669 ONCHECK OCCASIONALLY ABEND THE SERVER IN RSREAD WITH VARIOUS STACKS
IC64296 A SLOW QUERY PLAN IS USED FOR A TWO TABLE JOIN WITH A SUBSELECT
IC64312 DOCUMENTATION ERRORS EXIST WITH THE ON EXCEPTION ENTRY
IC64361 DBACCESS PRINTS A NEGATIVE NUMBER OF ROWS WERE LOADED/UNLOADED WHEN THE NUMBER OF ROWS EXCEEDS THE MAX VALUE FOR A SIGNED INT
IC64471 THE SERVER MAY NOT ABORT ON THE HP ITANIUM PLATFORM AFTER A FATAL ASSERT FAILURE
IC64491 SQL PARSING ABORT IN TLP2TNODE WHEN QUERY CONTAINS JOIN, LEFT JOIN AND TABLE DERIVED FROM SELECT WITH SUBSELECT
IC64681 AF CRASH CAN OCCUR ON HDR PRIMARY IN BTSCANNER THREAD WHILE CLEANING AN INDEX CONTAINING AN EXTENDED DATA TYPE COLUMN
IC64778 REPLACE TRUNCATES TO 2048 WHEN THE EXPRESSION TO BE EVALUATED IS BIGGER THAN 2048 AND THE SECOND ARGUMENT IS BIGGER THAN THE 3RD
IC64906 MEMORY CORRUPTION IN OPLOOKSUBQ WHEN USING STMT_CACHE AND SELECT WITH ORDER BY COL[1,X]
IC65027 INFORMIX CLUSTER INSTALL LEAVES CLUSTER.INI AS READ-ONLY WHICH LEADS TO A RUNTIME ERROR WITH INFORMIX CLUSTER UTILITY
IC65062 MEMORY CORRUPTION CRASH WHILE REFERENCING FREED OR NULL REFERENTIAL CONSTRAINTS DURING INSERTS, DELETES, UPDATES
IC65118 CDR DATASYNC THREADS CAN HANG WAITING FOR CONDITION CDRDSPN000X
IC65219 A SUBQUERY USING AGGREGATES AND VIEW WITH DERIVED RESULTS FROM A STORED PROCEDURE RETURNS INCORRECT RESULTS
IC65228 ASSERT FAIL AND CRASH IN CHKCHILDREN OR CHKPARENT DUE TO MISSING REFERENTIAL CONSTRAINTS TABLES INFO
IC65266 CHARACTER VARIABLE (STRING) IN STORED PROCEDURE TRUNCATED WHEN ACCESSING REMOTE TABLE
IC65272 HIGH PERFORMANCE LOADER (ONPLADM) SHOULD ALLOW SET LOCK MODE TO WAIT
IC65353 392 WITH AF IN COMP_UDR WHEN PREPARED SQL CONTAINING TO_DATE() CONVERSION IS EXECUTED IN EXCESS OF STMT_CACHE_HITS
IC65452 ENGINE CAN CRASH IN GET_SAPI_MEM_DESC()
IC65467 IDS THREADS CAN HANG IN AIO_QUEUE_OPS() BECAUSE OF TIMING PROBLEM WITH SMART BLOB LIGHT IO OPERATIONS
IC65520 SLOW RUNNING SPL WHEN USING VARCHAR (255) AND CONCAT AFTER MIGRATING TO VERSION 10.00.XC9 OR HIGHER
IC65522 LOG EVENT SPOOLING CAN HANG ER ACK PROCESSING
IC65635 INSERTING MONEY VALUE INTO CHAR(1) COLUMN WITH DBMONEY SET ABENDS SERVER
IC65745 A CLDB EVENT ENTRY IS NOT WRITTEN TO THE AUDIT LOG IF A DISCONNECT STATEMENT IS USED INSTEAD OF THE CLOSE DATABASE STATEMENT
IC65780 ISTAR QUERIES FROM EXISTING SERVERS START FAILING AND ASSERTING AFTER UPGRADING ONE OF THE DISTRIBUTED SERVERS
IC65794 HDR SECONDARY CAN ABORT WITH AF: LOG RECORD APPLY THREAD EXITED ABNORMALLY AND DR_DEBUG_ERR = -3
IC66101 MEMORY LEAK OF CDR_GLOBCAT MEMID FROM THE CDR POOL WHEN A TRANSACTION CONTAINS MODIFICATIONS TO MORE THEN 1 REPLICATED TABLE.
IC66266 INSERT STRING NULL INTO DATE FIELD WORKS IN 7.31 BUT GIVES 1205 ERROR IN 11.5
IC66413 UNEXPECTED INSTANCE CRASH IN LOGWRITE WHEN A LOGICAL LOG IS ADDED
IC66416 ENGINE CRASH IN READ_RECORD WHILE CREATE INDEX PERFORMED ON WRONG DATA PAGE REFERENCED BY LIGHT SCAN
IC66469 INDEX BUILD CAN HANG FOREVER
IC66544 SELECT UNION ALL WITH SYNONYMS TO REMOTE DATABASE CAN ASSERT FAIL WHEN UPDATE STATS RUN ON REMOTE DATABASE
IC67074 OPTIMIZER USES WRONG INDEX FOR SELECT WITH SUBQUERY AND OPTCOMPIND SET TO 0
IC67113 A DATABASE SERVER CRASH IS POSSIBLE IN CNVTOLONG()
IC67140 CDR CHECK PERFORMANCE PROBLEMS WHEN THERE ARE MANY DIFFERENCES IN DATA BETWEEN SOURCE AND TARGET
IC67188 SET EXPLAIN CAN YIELD MEMORY BLOCK HEADER CORRUPTION
IC67190 SOCIMCLSTNR THREAD CAN ASSERT DURING LISTEN_INIT IF IDS SERVER IS BOUNCED WHILE IMC SERVERS CONTINUE NEW CONNECTIONS
IC67192 IMCSEND THREAD CAN AFCRASH WHEN CALLING MT_LOCK FROM IMC_SENTQ_CLEANUP
IC67194 SOCIMCPOLL THREAD ASSERT FAILS WITH SEGV OR INVALID MUTEX
IC67195 ARCHECKER CORE DUMPS WITH BUS ERROR WHEN VERIFYING A FAULTY ARCHIVE
IC67199 SERVER ASSERT FAILS WHEN USING VTI FUNCTIONS IN PARALLEL SESSIONS