Fix list for Informix Dynamic Server version 9.40.xC9

---

Important: As part of IBM's ongoing effort to increase and enhance self-help information available to Informix customers, IBM ® Informix ® Dynamic Server (IDS) product defects are now being reported as Authorized Program Analysis Reports (APARs). Prior to October 1st, 2006, product defects were assigned a numeric-only ID. This version of IDS contains fixes for both APARs and legacy defects. If you are interested in learning more about Authorized Program Analysis Reports, review the following Technote, Informix APAR Information.

---

NOTE: some detail links below have been disabled as they are no longer available.

APAR	Description
IC49584	ONCHECK -CI NOT USING READ AHEADS THUS PERFORMANCE IS SLOW
IC49602	THE DROP TABLE COMMAND RESULTS IN ERROR 397 AND ISAM 111 WHEN A UNIQUE FILTERING INDEX EXISTS ON THE ITS VIOLATIONS TABLE
IC49649	SEGV IN LOCAL RESOLVED ROUTINE CACHE AFTER FREE ENTRY LINKED TO
IC49689	THE SYSMASTER:SYSSQLSTAT TABLE SHOWS THE WRONG STATEMENT IN THE SQS_STATEMENT COLUMN
IC49733	-1213 ERROR WHEN IDS 9.40 CONVERT CHAR TO FLOAT TYPE WHEN LOCALE IS SET
IC49746	AIO THREAD GETS SEGV AT SEARCH_EVAR<-IDX_GGETENV<-WORKON
IC49784	ERRORS 271 AND 144 OCCUR ON INSERT EVEN WITH LOCK MODE WAIT SET
IC49800	SEGV IN MEMCPY WHEN PERFORMING A SUB SELECT AND OPTCOMPIND IS SET TO 0
IC49818	SERVER CRASHES IN PHYSIO() WITH ASSERT WARNING "I/O WRITE CHUNK #, PAGENUM ###, PAGECNT ## ---> ERRNO = 4" WHEN IDS RUNS OUT OF VIRTUAL SHARED MEMORY
IC49832	LOADING EMPTY TEXT FIELDS WITH HPL RESULTS IN FIELDS WHICH ARE NOT EMPTY
IC49893	ERROR: INFORMIX.CUST_FRG_DET FEXTSIZE 16 DUE TO ALTER FRAGMENT DETACH WRONGLY SETTING FEXTSIZE AND NEXTSIZE IN SYSTABLES
IC49930	DBSCHEMA USING ADD NOT DISPLAYS AS ONE WORD ADDNOT
IC49984	USING A REMOTE QUERY TO SELECT FROM A SYSTEM TABLE INTO TEMP FROM A 7 INSTANCE TO A 9 OR 10 INSTANCE WILL RESULT IN AN ASSERTION FAILURE
IC49995	MEMORY LEAK IN GLOBAL POOL (MLS_MISC) ON WINDOWS
IC50021	PERFORMANCE PROBLEMS WHEN CONVERTING A DATABASE FROM NON-UNICODE TO UNICODE
IC50046	ASSERTION FAILURE DUE TO A RECURSIVE STACK OVERFLOW
IC50087	EXTERNAL ONBAR RESTORE USING RENAME CHUNK OPTION FAILS WHEN MANY CHUNKS ARE BEING RESTORED.
IC50121	QUERY RETURNS VERY SLOW AFTER UPGRADING FROM IDS9.40.FC5W2 TO IDS9.40.FC8W2
IC50142	DBEXPORT ON AIX IS EXTREMELY SLOW TO UNLOAD A TABLE THAT USES TEXT DATA TYPE
IC50143	IDS (ONSTAT -G SQL) DOES NOT SHOW THE CORRECT VALUE FOR F.E.
IC50166	DBLOAD DOES NOT ALLOW USERS TO USE ASCII 253 AS A DELIMITER
IC50168	THE STACKSIZE ONCONFIG PARAMETER AND INFORMIXSTACKSIZE ENVIRONMENT VARIABLES HAVE HARDCODED LIMITS NOT MENTIONED IN DOCUMENTATION
IC50217	ROLLBACK OF A TRANSACTION THAT REUSES TABLE NAMES LEADS TO ASSERTION FAILURE
IC50233	'ONCHECK -CD' DOES NOT CLEAN UP ORPHANED BLOBS, WHEN IT REPORTS IS HAS DONE SO. THE BLOB PAGE IS CORRECTED IN MEMORY, BUT NOT FLUSHED TO DISKSO THE PROBLEM IS PERSISTENT.
IC50236	UTILITIES SUCH AS ONBAR OR ONCHECK GENERATE AN ERROR 23353 MEMORY FAULT WHEN DBNLS AND CLIENT_LOCALE ARE SET
IC50237	USING A FILTER TWICE WHEN USING VARIABLES AFFECTS THE PERFORMANCE WHEREAS USING HARD CODED VALUES DOES NOT AFFECT IT
IC50340	USING ONMONITOR TO UPDATE ONCONFIG PARAMETERS DELETES VPCLASS ENTRIES
IC50348	ERROR -271 AND ISAM ERROR -151 OCCURS WHEN AN HPL LOAD JOB ENCOUNTERS A VALUE FOR A VARCHAR COLUMN LARGER THAN THE COLUMNS DE
IC50553	REPEATED USE OF VP PROFILING CAUSES MEMORY LEAK ON AIX
IC50630	SMART LARGE OBJECTS CRASH IN BF_DETACH(): BUFFER COUNT HELD COUNT AS -1
IC50631	THE CAST OF NULL TO CHAR(N) DOES NOT WORK
IC50648	ONPLOAD CRASHES WITH A SEGMENTATION VIOLATION WHEN RUNNING UNLOAD JOB IN AN LDAP ENVIRONMENT ON HP
IC50689	EXECUTING TWO PREPARED FUNCTIONS SUCCESSIVELY MAY FAIL IN
IC50693	INDEX CONTINUES TO GROW WHEN INSERT/UPDATE ON TABLE IS RUN
IC50707	HDR ASSERTION FAILURE:YIELD_PROCESSOR: CONDITIONAL LATCH COUNT NON-ZERO IN THREAD
IC50749	INCONSISTENT BEHAVIOUR OF IDS_INSTALL
IC50755	AFTER ALTER FRAGMENT ... INIT UNIQUE INDEXES START FAILING WITH ISAM 100 DUPLICATE VALUES
IC50756	SET CONSTRAINTS DEFERRED FOR A REFERENTIAL CONSTRAINT CAN CAUSE AN ASSERTION FAILURE
IC50799	THE SERVER CAN CREATE GLOBAL TRANSACTIONS WHICH CANNOT BE COMMITTED OR ROLLED BACK
IC50843	DBEXPORT FAILS FOR AN ANSI DATABASE IF THE OWNER OF A SEQUENCE IS DIFFERENT THAN THE DBA
IC50854	PAM CHALLENGE/RESPONSE NOT WORKING CORRECTLY
IC50878	HANDLING REMOTE DICTIONARY CACHE ENTRIES CAN PUT THE DICTIONARY CACHE UNDER CONSIDERABLE STRAIN AND CAUSE SERIOUS PERFORMANCE IMPACT
IC50879	SERVER WILL CRASH IN PTMAP WHEN ENCOUNTERING A CORRUPTED INDEX.
IC50902	THE SECONDARY SERVER CRASHES WHEN THE PRIMARY SERVER GOES OFFLINE IN AN ER/HDR SCENARIO WITH DRAUTO SET TO 1 (RETAIN TYPE)
IC50921	THE OPTIMIZER CHOOSES A WRONG INDEX FOR QUERIES WITH ANSI JOIN
IC50922	CONTRADICTION NOT ELIMINATED WHEN USING LOGICAL OPERATOR OR
IC50923	CRASH IN ADDBUFF_TO_SRLST AFTER A PARALLEL SORT OPERATION
IC50950	ALTER FRAGMENT DETACH CAN CAUSE AN SERVER ABEND IN FRAGEXPR_OVERLAP
IC50981	SELECT QUERY USING OUTER JOIN RETURN WRONG RESULTS
IC50989	DST2007: CHANGES TO DAYLIGHT SAVINGS TIME (DST) IN THE US AND CANADA AFFECT IBM IDS
IC51003	ENGINE HANGS IN CKPT REQ WHILE ALL AIO VPS ARE STUCK IN IOIDLE
IC51048	STORED PROCEDURE GETS A 565 AND 101 ERROR WHEN RUNNING AGAINST A PARTITIONED TABLE
IC51133	AN ASSERTION FAILURE OCCURS IN FUNCTION DECCVASC( )
IC51148	CORRUPTED SSC POOL BLOCKS DUE TO FREEING TO THE WRONG SSC POOL CAN CAUSE A CRASH AND MEMORY BLOCK CORRUPTION ERRORS
IC51159	AF WITH CONDITIONAL LATCH COUNT NON-ZERO IN XA ENV
IC51282	UNLINK_SD_CTCAST_ITEMS TRIES TO DE-REFERENCE MEMORY THAT HAS ALREADY BEEN FREED
IC51296	MAJOR PERFORMANCE PROBLEM ON VERY LARGE SYSTEMS DUE TO THE
IC51376	THE SERVER CRASHES DURING LOGICAL RECOVERY WHEN ONBAR CANNOT
IC51389	ERROR -874 OCCURS IN THE OPTIMIZER FROM A QUERY WITH JOINS AND
IC51414	ASSERTION FAILURE DUE TO XA TRANSACTION AND SYNONYM TO REMOTE USER1
IC51415	INCORRECT QUERY RESULT AFTER CREATE INDEX ON A TEMP TABLE
IC51416	A USER DEFINED FUNCTION WITH DEFINE
IC51495	TCP/IP CONNECTIONS ON SOLARIS CAN BE SLOW DUE TO RESET MESSAGES
IC51558	OPTIMIZER CHOOSES SEQUENTIAL SCAN INSTEAD OF INDEX IF TABLE HAS TOO MANY ROWS
IC51883	MULTI-STATEMENT PREPARE DOES NOT WORK FOR CONSECUTIVE UPDATES.
IC52297	THE CONVERT ERRPR 1260 RETURNS DURING SELECT QUERY WITH EXPRESSION ON THE TABLE WITH INTERVAL AND MONEY DATA TYPE.
IC52829	NVARCHAR COLUMN CAN CAUSE CORRUPTION IF USED IN A SELECT WITH MORE COLUMNS.

Legacy Defect	Description
171288	SERVER ASSERTS IN DELRECORD() COMPLAINING ABOUT BAD ROWID IN A MULTI CPU SCENARIO.
173099	OPTIMIZER USES SEQUENTIAL SCAN ON WHEN SELECTING IS NULL ON A ANSI OUTER JOIN COLUMN.
173695	ONPLOAD CANNOT LOAD DATA THAT IT HAS UNLOADED BEFORE.
174987	SELECTING WITH DECODE AND NVL FUNCTIONS ON A REMOTE SERVER WHICH HAS A SYNOMYM TO A TABLE IN ANOTHER INSTANCE RESULTS IN SQL ERROR -201.
175078	FULL OUTER JOIN RETURNS INCORRECT RESULTS WHEN LHS TABLE IS EMPTY.
175201	SQL STATEMENT DIRECTIVE EXPLAIN IS BEING SET FOR REST OF SESSION INSTEAD OF JUST FOR THE STATEMENT.
175348	STORED PROCEDURE STACK OBSERVED WITH ONSTAT -G SQL FOR EXAMPLE SHOWS FIRST DISPLAYED PROCEDURE TWICE.
175589	MODIFYING A COLUMN WITH PRIMARY KEY ALLOWS TO INSERT DUPLICATE KEYS.
175728	INSERTING SMARTBLOBS IN A LARGE TRANSACTION SLOWS DOWN WITH INCREASING NUMBER OF LOCKS.
175742	ASSERT FAIL CREATING A TABLE FRAGMENTED BY EXPRESSION.
175743	COMPLEX QUERY INVOLVING MULTIPLE SYNONYMS AND SUBSTR CAUSES CRASH WHEN USING SYNONYMS ON TABLES THAT ARE IN 9.40.FC4W1.
175779	CDR MODIFY REPL REPLACES ALL FLAGS OF A REPLICATE IN MEMORY, INSTEAD OF CHANGING OR ADDING ONLY THE FLAGS USED IN THE COMMAND.
175828	RUNNING ONLOAD USING TCP CONNECTION CAN RESULT IN A VARIETY OF HANG SYMPTOMS.
175847	ONPLOAD CAN ABORT A LOAD WITH BLOBS DEPENDING ON THE SIZE OF BUFFERS AND RECORDS TO LOAD.
175884	LEFT OUTER JOIN WITH SUBQUERY PERFORMS SEQUENTIAL SCAN ON DOMINANT TABLE WHEN INDEX PRESENT.
175899	DROP PROCEDURE XXX MAY FAIL WITH SQL ERR -211, ISAM -143 WHEN ANOTHER PROCEDURE IS CREATED CONCURRENTLY.
176024	INDEX CONTINUES TO GROW WHEN INSERT/UPDATE ON TABLE IS RUN WHILE PURGE.
176085	USING ONUNLOAD CAN CRASH ENGINE WHEN ONUNLOAD THREAD CLEAN UP BEFORE UNL_TAPE_WORKER MT_DETACH.
176270	QUERY CONTAINING A FROM CLAUSE USING MULTISET IN SUBQUERY NEVER RETURNS AND KEEP CPU VP BUSY..
176301	ONPLOAD MIGHT FAIL TO INSERT SQL DEFAULT VALUE FOR COLUMNS AND LEAD TO INSERTING NULL VALUES IN A COLUMN DEFINED WITH THE NOT NULL ATTRIBUTE.
176401	SERVER ALLOCATES (LEAKS) HUGE AMOUNT OF VIRTUAL MEMORY UNLOADING TABLE WITH ROW TYPE (RALLOC).
176625	MAJOR PERFORMANCE PROBLEM DUE TO LARGE NUMBER OF WAITERS ON MUTEX DBS_PARTN_1.
176631	SELECT STATEMENT ACCESSING A VIRTUAL FRAGMENTED TABLE WITH INDEX ASSERT FAILS IN PTMAPX.
176632	ONCHECK -CI NOT USING READ AHEADS THUS PERFORMANCE IS SLOW.
176782	ARCHECKER FAILS TO REPORT STORAGE MANAGER ERRORS, WHICH RESULTS IN MIS-LEADING AND INCOMPLETE INFORMATION IN THE ARCHECKER LOG.
176942	ASSERTION FAILURE / CRASH WHEN EXECUTING / RUN FUNCTION REPEATEDLY, PASSING LIST.
176991	HASH JOIN ON A VIEW USING A SUBSTRING RETURNS INCORRECT RESULTS.
177086	WRONG RESULTS IN QUERY THAT INVOLVES A COUNT(UNIQUE) EXPRESSION.