Product Documentation
Abstract
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.
Content
Fix release date: 23 Sept 2009 Last modified: 2 April 2014 Status: Recommended |
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 |
[{"Product":{"code":"SSGU8G","label":"Informix Servers"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.0","Edition":"Enterprise","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg27016462