Fix list for Informix Dynamic Server 10.00.xC10W4

Informix Dynamic Server provides periodic fixes for release 10.00. The following list is the most recent cumulative report of fixes for customer-reported defects in Version 10.00.xC10W4. 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.
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

W3 APARs	Description
IC58275	SYSTEM TIME LEAPING BACKWARDS CAN LEAD TO ROWS/TRANSACTIONS FAILING AT TIMESTAMP CONFLICT RESOLUTION
IC59493	SELECT MAX RESULTS IN ASSERT FAILURE IN BTPREV
IC60471	LIGHT APPENDS DOES NOT WORK ON RAW TABLES IN IDS UNLESS USING SELECT INTO TEMP
IC60564	AN INSERT ... SELECT STATEMENT WITH VIOLATIONS TABLE AND PDQ MAY HANG AND CAUSE A BLOCKED CHECKPOINT
IC60751	ONAUDIT -L 0 DOES NOT PUT ENTRY IN ONAUDIT LOG FILE
IC60862	ASSERT FAILURE IN SQCON_RESTORE_UDR_CONTEXT
IC60991	THE SIZE LIMIT OF 32 KB FOR ENVIRONMENT VARIABLES BLOCK AND THE RESULTING -1832 ERROR SHOULD BE DOCUMENTED
IC61050	CREATION AND USE OF RAW TABLES SHOULD BE RE-ENABLED IN REPLICATED ENVIRONMENTS
IC61072	PREFORMANCE DEGRADATION DUE TO CONTENTION ON THE DBS_PARTN MUTEX.
IC61097	CREATE PROCEDURE REFERENCING A MISSING TABLE, GET ERROR 206 WHEN CREATING A TRIGGER USING THIS PROCEDURE
IC61120	SPECIFYING DEFAULT VALUE FOR DATE DATATYPE INCORRECTLY RETURNS -591
IC61149	ONSYMSYNC -T RECEIVES INVALID POINT IN TIME VALUE SPECIFIED
IC61154	CHECKPOINTS OCCUR EVERY SECOND WHEN CREATING AN ONLINE INDEX ON A TEMPORARY TABLE IN A TEMP DBSPACE
IC61165	WINDOWS: IDS CRASHES IN NSOCPOLL WITH MESSAGE BUFFER ALLOCATION FAILED
IC61192	DBSCHEMA DOES NOT DISPLAY INDEX FRAGMENTATION ANY LONGER AFTER ALTER FRAGMENT DETACH
IC61195	LONG PASSWORD CAUSES ASSERTION FAILURE OR CRASH
IC61315	UNABLE TO INSERT 3 DIGIT TAIWAN MIN GUO YEAR 100 WITHOUT DATE SEPARATORS
IC61393	ALTER FRAGMENT INIT ON RAW TABLES WILL CREATE LOG RECORDS IN THE LOGICAL LOGS
IC61442	CHECKPOINT HANGS DURING UPDATE STATISTICS WHEN LIGHT SCAN IS TURNED ON
IC61443	ERROR 951/952 WHEN PASSWORD SHADOWING ENABLED ON HP-UX 11.11
IC61450	CHUNK MARKED DOWN WITH MESSAGE KAIO: ERROR IN KAIO_WRITE, KAIOCBP = 0X35047CA0, ERRNO = 0
IC61522	THE SERVER RECEIVES AN ASSERT FAILURE WHEN USERS CONNECT USING MAXCONNECT
IC61556	UNKNOWN ERROR MESSAGE DISPLAYED ON SQL EXCEPTION -21524
IC61558	PERMORMING MULTIPLE REMOTE QUERIES CAN CORRUPT THE DICTIONARY CACHE CAUSING AN ASSERT FAILURE
IC61664	769 RETURNED AFTER MULTIPLE EXECUTIONS OF QUERY WITH OUTER JOINS AND PLACEHOLDERS WHEN QUERY PLAN CHANGES IN BETWEEN EXECUTIONS
IC61747	UPDATE THE OUTPUT OF ISAM ERROR 136 TO INCLUDE THE LIMITATION OF MAX. NO. OF DATA PAGES
IC61836	ASSERTION FAILURE IN GETROW WHEN SQ_NFETCH IS ATTEMPTED ON CURSOR THAT IS OPEN ON AN INSERT STATEMENT
IC62062	ERROR 1809 WHEN KERBEROS USERS TRY TO CONNECT WITH PAM-CSM AND PASSWORD IS LONGER THAN 8 CHARACTERS

W4 APARs	Description
IC61534	ENGINE DOES NOT RELEASE OPEN TABLES WHEN PDQ IS ENABLED AND AN UPDATE ON A NON-EXISTENT ROW IS PERFORMED.
IC62025	STORED PROCEDURE FAILS WITH QPLAN SANITY FAILURE ERROR WHEN EXECUTED FROM AN HDR SECONDARY
IC62027	DATABASE SERVER CRASHES WHEN IT ACCESSES A CORRUPTED MEMORY POOL
IC62278	THE MAXIMUM EXTENT SIZE IS LIMITED TO 64GB FOR TABLES WITH A 16K PAGESIZE
IC63342	-143 DEADLOCK ERROR IS RETURNED WITH CONCURRENT READ AND WRITE OF THE SAME BLOB
IC63347	QUERY USING OUTER, GROUP BY AND DYN. HASH JOIN COULD RETURN WRONG RESULTS DEPENDING ON THE ORDER OF JOIN CLAUSES
IC63350	CDR GC: OPERATION OPEN ON TABLE USER TABLE FAILED (ISAM ERROR -102) IN ONLINE.LOG DURING ONINIT -D
IC63352	CDR CHECK REPLICATE/REPLICATESET COMMAND CORE DUMPS
IC63353	USING CDR MODIFY TO CHANGE REPLICATE FREQUENCY FROM IMMEDIATE TO TIME BASED DOES NOT WORK
IC63354	SEQUENCE OBJECT VALUE NOT CORRECT AFTER FAILOVER