Fix list for Informix Dynamic Server 10.00.xC9W2

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.xC9W2. This report combines both Windows- and UNIX-specific defect fixes, and is more current than the defect information included in the product release.


NOTE: some detail links below have been disabled as they are no longer available.
APAR
Description
xC9W1
IC49667 DROP SYNONYM FAILS IF HOST TABLE IS NOT PRESENT
IC51225 ONSTAT -G IOV OUTPUT SHOWS INACTIVE KAIO VPS
IC54370 FEATURE REQUEST - 3-DIGIT YEAR FORMAT FOR TAIWAN MING GUO DATE
IC55157 ERROR -211/-103 FROM REMOTE QUERY WITH PDQ AND DIFFERENT DATABASE LOCALES
IC55820 IDS DOES NOT WORK PROPERLY WITH SECURE SHELLS LIKE SSH
IC56106 APPLICATION FAILS WITH SQL ERROR -259 WHEN PDQPRIORITY IS INCREASED
IC56486 ACCESSING A SEQUENCE PRODUCES ERROR 211 AND DOES NOT RESET RESTART_VAL AFTER AN ALTER SEQUENCE WITH RESTART OPTION
IC56508 INSERTING LARGE ROWS INTO A TEMP TABLE IS MUCH SLOWER THAN INSERTING INTO A REGULAR TABLE
IC56563 DBEXPORT ENDS WITHOUT APPROPRIATE ERROR WHEN EXPORTING A DATABASE WITH INVALID LO DESCRIPTORS IN DATA PAGE
IC56583 CDR: REPLICATION FLAG ON A PARTITION CAN STILL PERSISTS IF THE REPLICATES ARE DELETED IN THE WRONG ORDER
IC56676 UNHELPFUL ERROR MESSAGE IN AC_MSG.LOG WHEN ARCHECKER ATTEMPTS TO RESTORE TABLE TO A POINT IN TIME PRIOR TO THE ARCHIVE
IC56809 ENGINE ASSERT FAILS DUE TO INCORRECT NUMBER OF COLUMNS IN PROJECTION LIST OF THE STATEMENT CACHE
IC56851 USING THE AVOID_EXECUTE DIRECTIVE ON A PROCEDURE WITH A CURSOR FAILS WITH ERROR 9791 AND AN AF OCCURS
IC56860 RUNNING CREATE DATABASE/TABLE AND ONCHECK -PE/-CE IN PARALLEL CAUSES DEADLOCK
IC56891 COULD NOT GET THE REMOTE HOST NAME ERROR BECAUSE PAM_RUSER AND PAM_RHOST ITEMS ARE NOT MAINTAINED BY INFORMIX DYNAMIC SERVER
IC56948 ERROR 392 RETURNED FROM IDS WHEN ESQL/C PARAMETERS USED IN SELECT ON MULTISET UNION AND EXTEND DATE COLUMN YEAR TO MONTH
IC56949 AFTER EXECUTING MULTISET SELECT ERRORS -229/-101 ARE RETURNED
IC56991 SESSION HANGS AND SQLEXEC THREADS WAIT AT COND WAIT NOTIFY_MC1 WHEN QUERIES USE PDQPRIORITY SETTING
IC57232 ASSERT FAILED: ROLLBACK ERROR 126 WHEN RUNNING PARALLEL UPDATE STATS FOR A PROCEDURE
IC57259 THE SYSUSERS SYSTEM CATALOG TABLE DOES NOT DESCRIBE COLUMN TYPE EXPLANATION FOR U
IC57263 QUERY CREATES HUGE MEMORY ALLOCATION OF RTN AND SAPI MEMORY WHEN PDQ IS ENABLED
IC57306 AUTOMATIC RETRY OF PHYSICAL RESTORE NEEDS TO ENSURE DBSPACE NOT ALREADY HAS BEEN SUCCESFULLY RESTORED IN THE MEANTIME
IC57307 SIGNAL HANDLING OF SIGPIPE WHILE INITIALIZING A REMOTE QUERY CAN LEAD TO UNEXPECTED VIRTUAL PROCESSOR TERMINATION
IC57310 CRASH IN PREPSELECT WITH CB_ITROOT=NULL IS POSSIBLE IF THE PREVIOUS OPEN_CURSOR CALL ABORTED IN ITBLDQUERY
IC57312 DROPPING LOGICAL LOG WITH AUDITING ACTIVATED CAN LEAD TO INSTANCE ABORT IF INSTANCE IS UNBLOCKED
IC57421 AN ONSPACES ERROR MESSAGE GIVES AN INCORRECT PAGE SIZE
IC57453 BAD SEQUENTIAL SCAN PATH FOR COMPLEX ANSI QUERY USING LEFT JOIN
IC57520 ALTER TABLE WITH DISTINCT TYPE FAILS WITH ERROR -206 WHEN TABLE EXISTS AND HAVE CHECK CONSTRAINT ON TWO COLUMNS
IC57539 A SELECT STATEMENT WHICH JOINS A VIEW AND A TABLE IS VERY SLOW AFTER UPGRADE WITHIN IDS 10 FAMILY
IC57541 INSTANCE LOCK-UP IS POSSIBLE IF A WHOLE SYSTEM BACKUP HANGS AND LOGICAL LOGS RUN FULL.
IC57554 LOGICAL LOG BACKUP ATTEMPTED DURING LEVEL-0 RESTORE CAN LEAD TO RESTORE FAILURE AND TO THE NEED TO RESTART RESTORE AGAIN
IC57569 RENAMING A TABLE TO A LONGER NAME SHOULD FAIL IF PARTITION PAGE IS FULL.
IC57570 STORED PROCEDURE USING FLOAT COMPUTES DIFFERENT RESULT BETWEEN VERSION 7.31 AND 10
IC57582 STSN AUDIT INCORRECTLY REPORTS FAILED ATTEMPTS TO CONNECT TO A REMOTE SERVER AS USER INFORMIX
IC57696 MEMORY LEAK WHEN USING CONCAT ( || ) WITH LVARCHAR INSIDE STORED PROCEDURES
IC57758 LONG WAITING TIME IN ASF_CHECKEXP CAN LEAD TO THE IMPRESSION THAT THE INSTANCE HANGS DURING SHUTDOWN
IC57772 TEMP SPACE NOT FREED WHEN PDQ, MULTIPLE TEMP SPACES AND CPU VPS ARE AVAILABLE AND QUERY FAILS
IC57790 SERVER CAN CRASH IN STCMPR TRYING TO AUTHENTICATE A USER IF THE CALL TO CRYPT RETURNS NULL
IC57800 SYSCOLUMNS ENTRY FOR A REMOTE VIEW DOES NOT SHOW NOT NULL COLUMN ATTRIBUTE
IC57815 ONSMSYNC USAGE DESCRIPTION INCORRECT FOR -B OPTION
IC57880 FAILED PTMAP CALL IN BFRADATAX CAUSES SEGV IN BUFFGET
IC57898 WITH SOME TSM CONFIGURATION, ARCHECKER TABLE-LEVEL RESTORE CANNOT RETRIEVE BACKED UP OBJECTS FROM THE TIVOLI STORAGE MANAGER
IC57917 UPDATE ON TABLE WITH TRIGGER / SPL WHICH UPDATES SAME TABLE WITH FK TO PARENT MAY FAIL IF OTHER OPEN TX AGAINST FK KEY
IC58085 MEMORY LEAK OCCURRS IN GLS POOL WHEN CLIENT_LOCALE IS SET TO DE_DE.CP1252@EURO
IC58182 ERROR 176 DURING CDR SYNC AFTER A SECOND RESTORE FROM BACKUP
IC58235 ERRORS 208 AND CAN NOT BE RESOLVED WHEN SELECTING A ROUTINE ON DBACCESS
IC58374 ERROR -206 RECEIVED EXECUTING ON A TABLE RENAMED BY A CONSTRAINT
IC58378 ERROR -201 WHEN RUNNING A REMOTE SELECT NVL FUCTION WITH A CURRENT EXPRESSION
IC58400 DROPPING AND RECREATING FUNCTION WITH DIFFERENT USER CAUSES ERROR WHEN USING A VIEW
IC58405 100% EMPTY PAGES IN THE BTREE ARE NOT COUNTED AS DIRTY HITS
IC58408 SHMTOTAL ERROR MESSAGES SHOULD NOT KEEP REPEATING
IC58409 USING ONAUDIT AND LARGE GRANT STATEMENT WILL CORRUPT AUD_FPRINTF BUFFER
IC58412 USING A HOSTVARIABLE CAN ABEND THE SERVER
IC59059 REMOTE SELECT FROM IPCSTR CONNECTION WITH MORE THAN ONE POLL THREAD GIVES ASSERT FAILED AND SERVER ABENDS
xC9W2
IC53866 ISM_WATCH IS NOT INCLUDED IN INFORMIX STORAGE MANAGER FOR MICROSOFT WINDOWS
IC55367 INSERTS INTO A TABLE WITH SEVERAL SPECIFIC CONDITIONS WILL CAUSE A UNIQUE INDEX ON THE TABLE TO CONTAIN DUPLICATE INDEX VALUES
IC56696 INSERTING SMART LARGE OBJECTS FROM TEMP TABLE TO REGULAR TABLE FAILS
IC57466 INCOMPLETE IMPLEMENTATION OF SHARE_MMU USAGE FOR SOLARIS INTIMATE SHARED MEMORY
IC57586 ER DATA APPLY PERFORMANCE DEGRADATION RESOLVED BY REDUCING NUMBER OF DATASYNC THREADS
IC57701 MULTIPLE UPDATES IN A SINGLE TRANSACTION CAN LEAD TO UNIQUE CONSTRAINT VIOLATION ON TARGET SERVERS OF A REPLICATE
IC57878 MEMORY LEAK IN UDR WHICH CALLS MI_TRIGGER_NEW_ROW() OR MI_TRIGGER_OLD_NEW()
IC57973 ERROR 212 ISAM 179 TRYING TO CREATE AN INDEX AFTER A MIS CALCULATION OF TEMPSPACE AVAILABLE
IC58413 INTERRUPTION OF CDR SYNC OPERATION STARTED ON TARGET SERVER CAN LEAD TO SYNC SHADOW REPLICATE NOT BEING DELETED
IC58084 -999 REMOTE SELECT OF VARCHARS CONCATENATED WITH ||
IC58468 DATABASE SERVER ABEND IN UNCOMPRESS_ROW IF NULL POINTER IS PASSED IN FOR THE LOCATION FOR THE UNCOMPRESSED ROW OUTPUT
IC58564 MEMORY LEAK IN RALLOC AND POOR PERFORMANCE WHEN INSERTING INTO A TABLE WITH A FOREIGN KEY ON A PARENT TABLE WITH AN RTREE INDEX.
IC58606 IDS CRASHES IF THE TABLE NAME IN UPDATE STATISTICS COMMAND IS MISTYPED AS TABLE
IC58690 QUERY ON TABLE FRAGMENTED ON WEEKDAY() DOES NOT DO FRAGMENT ELIMINATION
IC58706 ERRORS -7470/-937 AND VARIOUS MEMORY CORRUPTIONS WHEN EXECUTING A TRIGGER CONTAINING A SPATIAL FUNCTION
IC58719 ROWS CAN BE MISTAKENLY REPLICATED IF REPLICATE EXPRESSION EVALUATION GETS AN ERROR
IC58758 OPTIMIZER COSTS AND ROWS RETURNED FOR LEFT OUTER JOINS VARY UNPREDICTABLY
IC58783 A MISLEADING LOGICAL LOG WARNING ON INFORMIX DYNAMIC SERVER STARTUP
IC58875 DBIMPORT RETURNS ERROR -302 FOR VIEWS WITH DERIVED COLUMNS ON THE GRANT INSERT ON VIEW ... COMMAND
IC58899 AN ALTER FRAGMENT ON INDEX USING AFTER/BEFORE CAUSES SERVER TO ABEND
IC58908 SYSTEM COMMAND IN SPL TAKES SECONDS TO RUN
IC58928 UPDATE STATISTICS FOR PROCEDURE LEAKS MEMORY IF THE PROCEDURE CASTS IMPLICIT STRING TO LVARCHAR
IC58978 SOCIMCPOLL THREAD SEGV BECAUSE OF CORRUPTION IN IMC_INTERUPT_INPUT
IC58988 DBACCESS HANGS WHEN RUNNING A QUERY WITH REMOTE SYNTAX ON THE LOCAL MACHINE
IC59061 WINDOWS: IDS CRASHES WHEN ACCESSING SYSPTNHDR
IC59062 EXCESSIVE MEMORY ALLOCATION IN ANSI-JOIN QUERY WITHOUT DATA IN TABLES