Fix list for Informix Dynamic Server 10.00.xC10W2

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

Cumulative APAR list for published IDS 10.00.xC10 PIDs

W1 APARs	Description
IC58824	ABORT OF LONG TRANSACTION CANNOT BE DONE IF SQL IS REMOTE PROCEDURE CALL AND REMOTE SERVER IS NOT RESPONDING
IC59282	SLOW ALTER OF TABLE CONTAINING PARTITION BLOBS CAN FAIL WITH ERRORS 618/101 OR 618/770
IC59797	IMPORTED RESTORE WITH VERITAS NETBACKUP FAILS DURING LOGICAL RESTORE WHEN SERVERNUM DOES NOT MATCH THE SOURCE
IC59880	SESSIONS CAN HANG IF A THREAD TERMINATES WITHOUT FIRST RELEASING SHAREABLE SPIN LOCKS
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
IC60286	INDEX ROLLBACK KEEPS ENGINE IN CRITICAL SECTION
IC60320	OPTIMIZER IN IDS 10.00.XC9 & 10.00.XC9W1 DOES NOT USE 1=0 IN THE WHERE CLAUSE AS A FILTER AND READS THROUGH THE WHOLE TABLE
IC60514	ASSERT FAILED: YIELD_PROCESSOR: CONDITIONAL LATCH COUNT NON-ZERO IN THREAD 2402
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)

IDS Does not Start if the Installation Path is Insecure (UNIX and Linux) In PID 10.00.xC10W2, the IDS executable binaries now check the security of the runtime path specified by the INFORMIXDIR environment variable to prevent an attacker from using privileged programs that run with the database server, such as the oninit, onmode, and onstat utilities. If a potential security vulnerability is discovered, the database server does not start and other essential operations are disabled. By default, if the $INFORMIXDIR directory is insecure, the IDS displays the following error and exits: # !!! SECURITY PROBLEM !!! # /path/to/informix (path is not trusted) Use the new onsecurity utility, which is provided in the installation media, to generate a script that the root user can use to correct the reported problems. Information about the onsecurity utility is documented in the version 11.50 IBM Informix Security Guide, in the Information Center located at: http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp. Detailed instructions are also published on the IBM support site at: http://www.ibm.com/support/ For further details on this utility, execute onsecurity -h for a help message.

W2 APARs	Description
IC59786	USING SELECT MAX() WITHIN A STORED PROCEDURE WHICH HAS PDQPRIORITY SET WILL CAUSE A MEMORY LEAK AND PERFORMANCE DEGRADATION
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
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
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
IC60006	SELECT OF NON-EXISTENT COLUMN ON TABLE USING RESERVED WORD FOR COLUMN NAME RETURNS -9628 INSTEAD OF -217 ERROR
IC60244	THERE IS A CHANCE THAT TXTYPE OF A DATABASE GET SET TO ISO_COMMIT IN GET_DIST() AND QD_SAVEPLAN() WHICH CAN CAUSE CRASH LATER
IC60251	ERROR IN PROCESSING DYNAMIC EXPLAIN SHOULD NOT BE PASSED TO THE CLIENT
IC60502	TIMESTAMPS WRAPS IN A SHORT SPACE OF TIME ON BUSY SERVERS
IC60517	ADDITION OF A NEW CHUNK INTO SBSPACE IN NOT ROLLED BACK CORRECTLY DURING FAST RECOVERY
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 CDRS TOP 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
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.
IC60866	BAD KEYDESC SLOT POSSIBLE AFTER TRUNCATING A TABLE THAT HAD AN ATTACHED INDEX
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.
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.
IC61340	25571 ERRORS FLOOD THE onling.log WHEN THE SYSTEM EXCEEDS SHMTOTAL AND RISKS FILLING A DISK