Fix list for Informix Dynamic Server version 9.40.xC9

IBM ® Informix ® Dynamic Server (IDS) provides periodic fixes for release 9.40. The following is a complete listing of fixes for 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.
Back to Top

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.

2007/5/30