Fix list for Informix Dynamic Server 10.00.xC11
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.xC11. This report combines both Windows- and UNIX-specific defect fixes, and is more current than the defect information included in the product release.
|
APAR
|
Description
|
| IC58275 | SYSTEM TIME LEAPING BACKWARDS CAN LEAD TO ROWS/TRANSACTIONS FAILING AT TIMESTAMP CONFLICT RESOLUTION |
| IC58824 | ABORT OF LONG TRANSACTION CANNOT BE DONE IF SQL IS REMOTE PROCEDURE CALL AND REMOTE SERVER IS NOT RESPONDING |
| 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 |
| IC59282 | SLOW ALTER OF TABLE CONTAINING PARTITION BLOBS CAN FAIL WITH ERRORS 618/101 OR 618/770 |
| IC59321 | WINDOWS: ONSTAT NOT WORKING IF INFORMIXSERVER IS SET TO DBSERVERALIAS |
| IC59493 | SELECT MAX RESULTS IN ASSERT FAILURE IN BTPREV |
| 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 |
| IC59786 | USING SELECT WITHIN A STORED PROCEDURE WHICH HAS PDQPRIORITY SET AND IS CALLED MANY TIMES IN A SESSION WILL CAUSE MEMORY LEAK |
| IC59797 | IMPORTED RESTORE WITH VERITAS NETBACKUP FAILS DURING LOGICAL RESTORE WHEN SERVERNUM OF IDS DOES NOT MATCH THE SOURCE |
| 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 |
| IC59880 | SESSIONS CAN HANG IF A THREAD TERMINATES WITHOUT FIRST RELEASING SHAREABLE SPIN LOCKS |
| IC60006 | SELECT OF NON-EXISTENT COLUMN ON TABLE USING RESERVED WORD FOR COLUMN NAME RETURNS -9628 INSTEAD OF -217 ERROR |
| 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 |
| IC60251 | ERROR IN PROCESSING DYNAMIC EXPLAIN SHOULD NOT BE PASSED TO THE CLIENT |
| IC60286 | INDEX ROLLBACK KEEPS ENGINE IN CRITICAL SECTION |
| IC60320 | SQL QUERY WITH (1=0) IN WHERE CLAUSE TAKES LONGER TO RETURN RESULT |
| IC60471 | LIGHT APPENDS DOES NOT WORK ON RAW TABLES IN IDS UNLESS USING SELECT INTO TEMP |
| IC60502 | TIMESTAMPS WRAPS IN A SHORT SPACE OF TIME ON BUSY SERVERS |
| IC60514 | ASSERT FAILED: YIELD_PROCESSOR: CONDITIONAL LATCH COUNT NON-ZERO IN THREAD 2402 |
| IC60517 | ADDITION OF A NEW CHUNK INTO SBSPACE IN NOT ROLLED BACK CORRECTLY DURING FAST RECOVERY |
| 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) |
| IC60564 | AN INSERT ... SELECT STATEMENT WITH VIOLATIONS TABLE AND PDQ MAY HANG AND CAUSE A BLOCKED CHECKPOINT |
| 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 CDRSTOP 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 |
| IC60751 | ONAUDIT -L 0 DOES NOT PUT ENTRY IN ONAUDIT LOG FILE |
| 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. |
| IC60862 | ASSERT FAILURE IN SQCON_RESTORE_UDR_CONTEXT |
| 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. |
| 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 ENABLED IN REPLICATED ENVIRONMENTS |
| 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. |
| IC61097 | ERROR 206 WHEN USING A PROCEDURE REFERENCING A MISSING TABLE |
| 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 |
| IC61194 | INCLUDE MACHINE.H, SPECIFIED IN HPL CUSTOM DRIVER FILE EXAMPLE INFORMIXDIR/INCL/HPL/PLCSTDRV.H IS MISSING |
| IC61195 | LONG PASSWORD CAUSES ASSERTION FAILURE OR CRASH |
| IC61315 | UNABLE TO INSERT 3 DIGIT TAIWAN MIN GUO YEAR 100 WITHOUT DATE SEPARATORS |
| IC61340 | 25571 ERRORS FLOODS THE ONLINE.LOG WHEN WHEN SYSTEM EXCEEDS SHMTOTAL AND RISKS DISK FILL |
| IC61376 | MEMORY CORRUPTION WITH COLLECTION DATA TYPE AFTER MIGRATING ENGINE FROM 32-BIT TO 64-BIT |
| 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 |
| IC61534 | ENGINE DOES NOT RELEASE OPEN TABLES WHEN PDQ IS ENABLED AND AN UPDATE ON A NON-EXISTENT ROW IS PERFORMED. |
| 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 |
| IC61831 | CDR COMMANDS WITH -C OPTION FROM PRE-V11 TO V11 FAIL WITH ERROR MESSAGE |
| IC61836 | ASSERTION FAILURE IN GETROW WHEN SQ_NFETCH IS ATTEMPTED ON CURSOR THAT IS OPEN ON AN INSERT STATEMENT |
| 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 |
| IC62062 | ERROR 1809 WHEN KERBEROS USERS TRY TO CONNECT WITH PAM-CSM AND PASSWORD IS LONGER THAN 8 CHARACTERS |
| IC62142 | THE TO_CHAR FUNCTION RETURNS INCORRECT MONTH/DAY NAMES WHEN ANY OF THE CS_CZ.* LOCALES ARE IN USE |
| IC62230 | EXTENT OVERLAP OCCURS ON THE SOURCE DBSPACE WHEN MOVING THE PHYSICAL LOG FAILS DUE TO A LACK OF SPACE ON THE TARGET DBSPAC |
| IC62231 | SERVER ABEND IS POSSIBLE WHEN THE MAXIMUM BTREE DEPTH IS EXCEEDED |
| IC62278 | THE MAXIMUM EXTENT SIZE IS LIMITED TO 64GB FOR TABLES WITH A 16K PAGESIZE |
| IC62738 | A CURSOR WITH AN ORDER BY OR GROUP BY WHICH GETS RE-OPTIMIZED MAY RESULT IN A MEMORY LEAK |
| IC63305 | WITH STATEMENT CACHE ENABLED A SELECT IN A CASE STATEMENT USING A SUBQUERY IN THE PROJECTION LIST RETURNS -769 ERROR/SEGV ASSE |
| 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 |
| 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 |
| IC63454 | ENGINE HANG IN MT_SPIN_WAIT_LOCK DUE TO MEMORY ALLOCATION IN GENTCB_ALLOC |
| IC63516 | ONUNLOAD FAILS WITH ILLEGAL ARGUMENT TO ISAM FUNCTION IF THE DATABASE OR TABLE BEING UNLOADED CONTAINS A DISABLED CONSTRAIN |
| IC63630 | ONTAPE LEVEL 0 HANGS AS READ TICKET WITH DEAD PARENTS KEEPS THREAD WAITING TO BE PROMOTED TO READ/WRITE MUTEX |
| IC63669 | ONCHECK OCCASIONALLY ABEND THE SERVER IN RSREAD WITH VARIOUS STACKS |
| IC64296 | A SLOW QUERY PLAN IS USED FOR A TWO TABLE JOIN WITH A SUBSELECT |
| IC64312 | DOCUMENTATION ERRORS EXIST WITH THE ON EXCEPTION ENTRY |
| IC64361 | DBACCESS PRINTS A NEGATIVE NUMBER OF ROWS WERE LOADED/UNLOADED WHEN THE NUMBER OF ROWS EXCEEDS THE MAX VALUE FOR A SIGNED INT |
| IC64471 | THE SERVER MAY NOT ABORT ON THE HP ITANIUM PLATFORM AFTER A FATAL ASSERT FAILURE |
| IC64491 | SQL PARSING ABORT IN TLP2TNODE WHEN QUERY CONTAINS JOIN, LEFT JOIN AND TABLE DERIVED FROM SELECT WITH SUBSELECT |
| IC64681 | AF CRASH CAN OCCUR ON HDR PRIMARY IN BTSCANNER THREAD WHILE CLEANING AN INDEX CONTAINING AN EXTENDED DATA TYPE COLUMN |
| IC64778 | REPLACE TRUNCATES TO 2048 WHEN THE EXPRESSION TO BE EVALUATED IS BIGGER THAN 2048 AND THE SECOND ARGUMENT IS BIGGER THAN THE 3RD |
| IC64906 | MEMORY CORRUPTION IN OPLOOKSUBQ WHEN USING STMT_CACHE AND SELECT WITH ORDER BY COL[1,X] |
| IC65027 | INFORMIX CLUSTER INSTALL LEAVES CLUSTER.INI AS READ-ONLY WHICH LEADS TO A RUNTIME ERROR WITH INFORMIX CLUSTER UTILITY |
| IC65062 | MEMORY CORRUPTION CRASH WHILE REFERENCING FREED OR NULL REFERENTIAL CONSTRAINTS DURING INSERTS, DELETES, UPDATES |
| IC65118 | CDR DATASYNC THREADS CAN HANG WAITING FOR CONDITION CDRDSPN000X |
| IC65219 | A SUBQUERY USING AGGREGATES AND VIEW WITH DERIVED RESULTS FROM A STORED PROCEDURE RETURNS INCORRECT RESULTS |
| IC65228 | ASSERT FAIL AND CRASH IN CHKCHILDREN OR CHKPARENT DUE TO MISSING REFERENTIAL CONSTRAINTS TABLES INFO |
| IC65266 | CHARACTER VARIABLE (STRING) IN STORED PROCEDURE TRUNCATED WHEN ACCESSING REMOTE TABLE |
| IC65272 | HIGH PERFORMANCE LOADER (ONPLADM) SHOULD ALLOW SET LOCK MODE TO WAIT |
| IC65353 | 392 WITH AF IN COMP_UDR WHEN PREPARED SQL CONTAINING TO_DATE() CONVERSION IS EXECUTED IN EXCESS OF STMT_CACHE_HITS |
| IC65452 | ENGINE CAN CRASH IN GET_SAPI_MEM_DESC() |
| IC65467 | IDS THREADS CAN HANG IN AIO_QUEUE_OPS() BECAUSE OF TIMING PROBLEM WITH SMART BLOB LIGHT IO OPERATIONS |
| IC65520 | SLOW RUNNING SPL WHEN USING VARCHAR (255) AND CONCAT AFTER MIGRATING TO VERSION 10.00.XC9 OR HIGHER |
| IC65522 | LOG EVENT SPOOLING CAN HANG ER ACK PROCESSING |
| IC65635 | INSERTING MONEY VALUE INTO CHAR(1) COLUMN WITH DBMONEY SET ABENDS SERVER |
| IC65745 | A CLDB EVENT ENTRY IS NOT WRITTEN TO THE AUDIT LOG IF A DISCONNECT STATEMENT IS USED INSTEAD OF THE CLOSE DATABASE STATEMENT |
| IC65780 | ISTAR QUERIES FROM EXISTING SERVERS START FAILING AND ASSERTING AFTER UPGRADING ONE OF THE DISTRIBUTED SERVERS |
| IC65794 | HDR SECONDARY CAN ABORT WITH AF: LOG RECORD APPLY THREAD EXITED ABNORMALLY AND DR_DEBUG_ERR = -3 |
| IC66101 | MEMORY LEAK OF CDR_GLOBCAT MEMID FROM THE CDR POOL WHEN A TRANSACTION CONTAINS MODIFICATIONS TO MORE THEN 1 REPLICATED TABLE. |
| IC66266 | INSERT STRING NULL INTO DATE FIELD WORKS IN 7.31 BUT GIVES 1205 ERROR IN 11.5 |
| IC66413 | UNEXPECTED INSTANCE CRASH IN LOGWRITE WHEN A LOGICAL LOG IS ADDED |
| IC66416 | ENGINE CRASH IN READ_RECORD WHILE CREATE INDEX PERFORMED ON WRONG DATA PAGE REFERENCED BY LIGHT SCAN |
| IC66469 | INDEX BUILD CAN HANG FOREVER |
| IC66544 | SELECT UNION ALL WITH SYNONYMS TO REMOTE DATABASE CAN ASSERT FAIL WHEN UPDATE STATS RUN ON REMOTE DATABASE |
| IC67074 | OPTIMIZER USES WRONG INDEX FOR SELECT WITH SUBQUERY AND OPTCOMPIND SET TO 0 |
| IC67113 | A DATABASE SERVER CRASH IS POSSIBLE IN CNVTOLONG() |
| IC67140 | CDR CHECK PERFORMANCE PROBLEMS WHEN THERE ARE MANY DIFFERENCES IN DATA BETWEEN SOURCE AND TARGET |
| IC67188 | SET EXPLAIN CAN YIELD MEMORY BLOCK HEADER CORRUPTION |
| IC67190 | SOCIMCLSTNR THREAD CAN ASSERT DURING LISTEN_INIT IF IDS SERVER IS BOUNCED WHILE IMC SERVERS CONTINUE NEW CONNECTIONS |
| IC67192 | IMCSEND THREAD CAN AFCRASH WHEN CALLING MT_LOCK FROM IMC_SENTQ_CLEANUP |
| IC67194 | SOCIMCPOLL THREAD ASSERT FAILS WITH SEGV OR INVALID MUTEX |
| IC67195 | ARCHECKER CORE DUMPS WITH BUS ERROR WHEN VERIFYING A FAULTY ARCHIVE |
| IC67199 | SERVER ASSERT FAILS WHEN USING VTI FUNCTIONS IN PARALLEL SESSIONS |