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