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