Fix list for Informix Dynamic Server 10.00.xC10
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.xC10. This report combines both Windows- and UNIX-specific defect fixes, and is more current than the defect information included in the product release.
NOTE: some detail links below have been disabled as they are not available.
|
APAR
|
Description
|
| IC49667 | DROP SYNONYM FAILS IF HOST TABLE IS NOT PRESENT |
| IC51225 | ONSTAT -G IOV OUTPUT SHOWS INACTIVE KAIO VPS |
| IC53866 | ISM_WATCH IS NOT INCLUDED IN INFORMIX STORAGE MANAGER FOR MICROSOFT WINDOWS |
| IC54370 | FEATURE REQUEST - 3-DIGIT YEAR FORMAT FOR TAIWAN MING GUO DATE |
| IC55042 | MIGRATION FAILS WITH ASSERT FAILURE WHEN ONPLOAD DATABASE IS NOT LOGGED |
| IC55157 | ERROR -211/-103 FROM REMOTE QUERY WITH PDQ AND DIFFERENT DATABASE LOCALES |
| IC55367 | INSERTS INTO A TABLE WITH SEVERAL SPECIFIC CONDITIONS WILL CAUSE A UNIQUE INDEX ON THE TABLE TO CONTAIN DUPLICATE INDEX VALUE |
| IC55820 | IDS DOES NOT WORK PROPERLY WITH SECURE SHELLS LIKE SSH |
| IC56031 | OPTIMIZER CHOOSING WRONG PATH FOR LARGE TABLE WITH SKEWED DATA WHEN DISTRIBUTIONS ARE PRESENT |
| IC56106 | APPLICATION FAILS WITH SQL ERROR -259 WHEN PDQPRIORITY IS INCREASED |
| IC56384 | REMOTE QUERY TO SYSMASTER RETURNS -23101 IF THE LOCALE SETTING IS DIFFERENT AND CSM ENCRYPTION IS USED |
| IC56486 | ACCESSING A SEQUENCE PRODUCES ERROR 211 AND DOES NOT RESET RESTART_VAL AFTER AN ALTER SEQUENCE WITH RESTART OPTION |
| IC56508 | INSERTING LARGE ROWS INTO A TEMP TABLE IS MUCH SLOWER THAN INSERTING INTO A REGULAR TABLE |
| IC56563 | DBEXPORT ENDS WITHOUT APPROPRIATE ERROR WHEN EXPORTING A DATABASE WITH INVALID LO DESCRIPTORS IN DATA PAGE |
| IC56583 | CDR: REPLICATION FLAG ON A PARTITION CAN STILL PERSISTS IF THE REPLICATES ARE DELETED IN THE WRONG ORDER |
| IC56676 | UNHELPFUL ERROR MESSAGE IN AC_MSG.LOG WHEN ARCHECKER ATTEMPTS TO RESTORE TABLE TO A POINT IN TIME PRIOR TO THE ARCHIVE |
| IC56696 | INSERTING SMART LARGE OBJECTS FROM TEMP TABLE TO REGULAR TABLE FAILS |
| IC56809 | ENGINE ASSERT FAILS DUE TO INCORRECT NUMBER OF COLUMNS IN PROJECTION LIST OF THE STATEMENT CACHE |
| IC56851 | USING THE AVOID_EXECUTE DIRECTIVE ON A PROCEDURE WITH A CURSOR FAILS WITH ERROR 9791 AND AN AF OCCURS |
| IC56860 | RUNNING CREATE DATABASE/TABLE AND ONCHECK -PE/-CE IN PARALLEL CAUSES DEADLOCK |
| IC56891 | COULD NOT GET THE REMOTE HOST NAME ERROR BECAUSE PAM_RUSER AND PAM_RHOST ITEMS ARE NOT MAINTAINED BY INFORMIX DYNAMIC SERVER |
| IC56948 | ERROR 392 RETURNED FROM IDS WHEN ESQL/C PARAMETERS USED IN SELECT ON MULTISET UNION AND EXTEND DATE COLUMN YEAR TO MONTH |
| IC56949 | AFTER EXECUTING MULTISET SELECT ERRORS -229/-101 ARE RETURNED |
| IC56991 | SESSION HANGS AND SQLEXEC THREADS WAIT AT COND WAIT NOTIFY_MC1 WHEN QUERIES USE PDQPRIORITY SETTING |
| IC57232 | ASSERT FAILED: ROLLBACK ERROR 126 WHEN RUNNING PARALLEL UPDATE STATS FOR A PROCEDURE |
| IC57259 | THE SYSUSERS SYSTEM CATALOG TABLE DOES NOT DESCRIBE COLUMN TYPE EXPLANATION FOR U |
| IC57263 | QUERY CREATES HUGE MEMORY ALLOCATION OF RTN AND SAPI MEMORY WHEN PDQ IS ENABLED |
| IC57306 | AUTOMATIC RETRY OF PHYSICAL RESTORE DOES NOT ENSURE DBSPACE HAS ALREADY BEEN SUCCESSFULLY RESTORED IN THE MEANTIME |
| IC57307 | SIGNAL HANDLING OF SIGPIPE WHILE INITIALIZING A REMOTE QUERY CAN LEAD TO UNEXPECTED VIRTUAL PROCESSOR TERMINATION |
| IC57310 | CRASH IN PREPSELECT WITH CB_ITROOT=NULL IS POSSIBLE IF THE PREVIOUS OPEN_CURSOR CALL ABORTED IN ITBLDQUERY |
| IC57312 | DROPPING LOGICAL LOG WITH AUDITING ACTIVATED CAN LEAD TO INSTANCE ABORT IF INSTANCE IS UNBLOCKED |
| IC57421 | AN ONSPACES ERROR MESSAGE GIVES AN INCORRECT PAGE SIZE |
| IC57453 | BAD SEQUENTIAL SCAN PATH FOR COMPLEX ANSI QUERY USING LEFT JOIN |
| IC57466 | INCOMPLETE IMPLEMENTATION OF SHARE_MMU USAGE FOR SOLARIS INTIMATE SHARED MEMORY |
| IC57520 | ALTER TABLE WITH DISTINCT TYPE FAILS WITH ERROR -206 WHEN TABLE EXISTS AND HAVE CHECK CONSTRAINT ON TWO COLUMNS |
| IC57539 | A SELECT STATEMENT WHICH JOINS A VIEW AND A TABLE IS VERY SLOW AFTER UPGRADE WITHIN IDS 10 FAMILY |
| IC57541 | INSTANCE LOCK-UP IS POSSIBLE IF A WHOLE SYSTEM BACKUP HANGS AND LOGICAL LOGS RUN FULL. |
| IC57554 | LOGICAL LOG BACKUP ATTEMPTED DURING LEVEL-0 RESTORE CAN LEAD TO RESTORE FAILURE AND TO THE NEED TO RESTART RESTORE AGAIN |
| IC57569 | RENAMING A TABLE TO A LONGER NAME SHOULD FAIL IF PARTITION PAGE IS FULL. |
| IC57570 | Stored Procedure using float compute different result between version 7.31 and version 10 |
| IC57582 | STSN AUDIT INCORRECTLY REPORTS FAILED ATTEMPTS TO CONNECT TO A REMOTE SERVER AS USER INFORMIX |
| IC57586 | ER DATA APPLY PERFORMANCE DEGRADATION RESOLVED BY REDUCING NUMBER OF DATASYNC THREADS |
| IC57696 | MEMORY LEAK WHEN USING CONCAT ( || ) WITH LVARCHAR INSIDE STORED PROCEDURES |
| IC57701 | MULTIPLE UPDATES IN A SINGLE TRANSACTION CAN LEAD TO UNIQUE CONSTRAINT VIOLATION ON TARGET SERVERS OF A REPLICATE |
| IC57758 | LONG WAITING TIME IN ASF_CHECKEXP CAN LEAD TO THE IMPRESSION THAT THE INSTANCE HANGS DURING SHUTDOWN |
| IC57772 | TEMP SPACE NOT FREED WHEN PDQ, MULTIPLE TEMP SPACES AND CPU VPS ARE AVAILABLE AND QUERY FAILS |
| IC57790 | SERVER CAN CRASH IN STCMPR TRYING TO AUTHENTICATE A USER IF THE CALL TO CRYPT RETURNS NULL |
| IC57800 | SYSCOLUMNS ENTRY FOR A REMOTE VIEW DOES NOT SHOW NOT NULL COLUMN ATTRIBUTE |
| IC57815 | ONSMSYNC USAGE DESCRIPTION INCORRECT FOR -B OPTION |
| IC57851 | ONSMSYNC -B USAGE INCORRECTLY DESCRIBED IN BACKUP AND RESTORE GUIDE |
| IC57878 | MEMORY LEAK IN UDR WHICH CALLS MI_TRIGGER_NEW_ROW() OR MI_TRIGGER_OLD_NEW() |
| IC57880 | FAILED PTMAP CALL IN BFRADATAX CAUSES SEGV IN BUFFGET |
| IC57898 | WITH SOME TSM CONFIGURATION, ARCHECKER TABLE-LEVEL RESTORE CANNOT RETRIEVE BACKED UP OBJECTS FROM THE TIVOLI STORAGE MANAGER |
| IC57917 | UPDATE ON TABLE WITH TRIGGER / SPL WHICH UPDATES SAME TABLE WITH FK TO PARENT MAY FAIL IF OTHER OPEN TX AGAINST FK KEY |
| IC57973 | ERROR 212 ISAM 179 TRYING TO CREATE AN INDEX AFTER A MIS CALCULATION OF TEMPSPACE AVAILABLE |
| IC58084 | ERROR -999 RECEIVED WITH REMOTE SELECT OF VARCHARS CONCATENATED WITH || |
| IC58085 | MEMORY LEAK OCCURRS IN GLS POOL WHEN CLIENT_LOCALE IS SET TO DE_DE.CP1252@EURO |
| IC58182 | ERROR 176 DURING CDR SYNC AFTER A SECOND RESTORE FROM BACKUP |
| IC58235 | ERRORS 208 AND CAN NOT BE RESOLVED WHEN SELECTING A ROUTINE ON DBACCESS |
| IC58341 | WITH A MULTI CPU INSTANCE, ONMODE -KUY DOES NOT ALWAYS PRINT SHUTDOWN MODE IN THE ONLINE.LOG |
| IC58374 | ERROR -206 RECEIVED EXECUTING ON A TABLE RENAMED BY A CONSTRAINT |
| IC58378 | ERROR -201 WHEN RUNNING A REMOTE SELECT NVL FUCTION WITH A CURRENT EXPRESSION |
| IC58400 | DROPPING AND RECREATING FUNCTION WITH DIFFERENT USER CAUSES ERROR WHEN USING A VIEW |
| IC58405 | 100% EMPTY PAGES IN THE BTREE ARE NOT COUNTED AS DIRTY HITS |
| IC58408 | SHMTOTAL ERROR MESSAGES SHOULD NOT KEEP REPEATING |
| IC58409 | USING ONAUDIT AND LARGE GRANT STATEMENT WILL CORRUPT AUD_FPRINTF BUFFER |
| IC58412 | USING A HOSTVARIABLE CAN ABEND THE SERVER |
| IC58413 | INTERRUPTION OF CDR SYNC OPERATION STARTED ON TARGET SERVER CAN LEAD TO SYNC SHADOW REPLICATE NOT BEING DELETED |
| IC58468 | DATABASE SERVER ABEND IN UNCOMPRESS_ROW IF NULL POINTER IS PASSED IN FOR THE LOCATION FOR THE UNCOMPRESSED ROW OUTPUT |
| IC58564 | MEMORY LEAK IN RALLOC AND POOR PERFORMANCE WHEN INSERTING INTO A TABLE WITH A FOREIGN KEY ON A PARENT TABLE WITH AN RTREE INDEX. |
| IC58606 | IDS CRASHES IF THE TABLE NAME IN UPDATE STATISTICS COMMAND IS TABLE |
| IC58690 | QUERY ON TABLE FRAGMENTED ON WEEKDAY() DOES NOT DO FRAGMENT ELIMINATION |
| IC58706 | ERRORS -7470/-937 AND VARIOUS MEMORY CORRUPTIONS WHEN EXECUTING A TRIGGER CONTAINING A SPATIAL FUNCTION |
| IC58719 | ROWS CAN BE MISTAKENLY REPLICATED IF REPLICATE EXPRESSION EVALUATION GETS AN ERROR |
| IC58721 | CHANGING THE ORDER THAT FILTERS ARE LISTED IN QUERY WHERE CLAUSE CAN CHANGE QUERY PLAN PRODUCED |
| IC58757 | AF WITH LOG_PUT LOGWRITE BAD PAGE (1) POSSIBLE WHEN TIMESTAMP WRAP OCCURS WHILE NO LOG RECORDS ARE WRITTEN |
| IC58758 | OPTIMIZER COSTS AND ROWS RETURNED FOR LEFT OUTER JOINS VARY UNPREDICTABLY |
| IC58781 | ONTAPE BACKUP OF DATABASE SERVER CONTAINING SMART BLOB SPACES MAY ASSERT FAIL WITH INVALID MUTEX TYPE ERROR WHEN INTERRUPTED |
| IC58783 | A MISLEADING LOGICAL LOG WARNING ON INFORMIX DYNAMIC SERVER STARTUP |
| IC58875 | DBIMPORT RETURNS ERROR -302 FOR VIEWS WITH DERIVED COLUMNS ON THE GRANT INSERT ON VIEW ... COMMAND |
| IC58892 | ALLOW JVM TO RECOGNIZE DB_LOCALE DYNAMICALLY |
| IC58899 | AN ALTER FRAGMENT ON INDEX USING AFTER/BEFORE CAUSES SERVER TO ABEND |
| IC58908 | SYSTEM COMMAND IN SPL TAKES SECONDS TO RUN |
| IC58928 | UPDATE STATISTICS FOR PROCEDURE LEAKS MEMORY IF THE PROCEDURE CASTS IMPLICIT STRING TO LVARCHAR |
| IC58939 | PREPARED JOIN USING PDQ CAN RUN ON LOCK THAT NO LONGER EXISTS |
| IC58974 | DOC - BEHAVIOR OF AN ALTER TABLE ON A VARCHAR WHICH USES A SLOW ALTER |
| IC58978 | SOCIMCPOLL THREAD SEGV BECAUSE OF CORRUPTION IN IMC_INTERUPT_INPUT |
| IC58988 | DBACCESS HANGS WHEN RUNNING A QUERY WITH REMOTE SYNTAX ON THE LOCAL MACHINE |
| IC58989 | LOGICAL RESTORE BROKEN FOR INDEXED RAW TABLES TURNED INTO STANDARD TABLES |
| IC59059 | REMOTE SELECT FROM IPCSTR CONNECTION WITH MORE THAN ONE POLL THREAD GIVES ASSERT FAILED AND SERVER ABENDS |
| IC59061 | WINDOWS: IDS CRASHES WHEN ACCESSING SYSPTNHDR |
| IC59062 | EXCESSIVE MEMORY ALLOCATION IN ANSI-JOIN QUERY WITHOUT DATA IN TABLES |
| IC59085 | ASSERT FAILURE AND MEMORY CORRUPTION USING STORED PROCEDURE WITH A COLLECTION DERIVED TABLE |
| IC59136 | CHECKPOINTS BETWEEN HDR PRIMARY AND HDR SECONDARY ARE NOT SYNCHRONOUS BUT CHECKPOINT INITIATION IS |
| IC59141 | AN ERROR 999 IN A STORED PROCEDURE EXECUTING SQL AGAINST A REMOTE TABLE INCLUDING AN OPAQUE DATATYPES |
| IC59171 | SEQUENCE OBJECT RESTART WITH CACHE PLUS CURRENT VALUE THOUGH CACHE VALUE HAD NOT BEEN USED UP. |
| IC59194 | AN ERROR -908 IS RETURNED WHEN USING * IN HOSTNAME COLUMN IN SQLHOSTS |
| IC59314 | UNABLE TO ROLLBACK UPDATE/DELETE OF SMART BLOBS PERFORMED IN XA TRANSACTION AFTER SERVER RESTART |
| IC59317 | MEMORY CORRUPTION OCCURS WHEN A QUERY WITH MORE THAN 15 HOST VARIABLES FAILED IN SQBIND() CALLED FROM SQ_COMMON_BIND(). |
| IC59381 | QUERY USING DECODE WITH GROUP BY IN A TABLE MULTISET MAY RETURN INCORRECT RESULTS |
| IC59445 | ARCHECKER SHOULD ATTACH TO THE DATABASE SERVER SHARED MEMORY SEGMENT AT A MORE OPTIMAL LOCATION |
| IC59461 | THE DATABASE SERVER MAY SEGV IN HASHFULLNAME() WHEN A CURSOR IS LEFT OPEN FOR A TABLE THAT HAS ALREADY BEEN DROPPED |
| IC59512 | ONLOAD FAILS WHEN LOADING ONUNLOAD TAPE OF DATABASE WITH TABLES IN DBSPACES OF DIFFERENT PAGE SIZES |
| IC59609 | ADDING AN INDEX FRAGMENT USING THE BEFORE CLAUSE STILL SCANS ALL THE FRAGMENTS |
| IC59610 | ADDITIONAL SORT FILE LOCATION SEQUENCE CHANGES NEED TO BE ADDED TO THE RELEASE NOTES |
| IC59616 | HPL CONVERSION JOB ERROR WHEN DELETING AND THEN TRYING TO RECREATE AGAIN |
| IC59696 | ALTER FRAGMENT ATTACH PARTITION COMMAND ON A TABLE CAUSES THE SERVER TO ASSERT FAIL |
| IC59722 | IDS TOOLS ARE UNABLE TO ATTACH TO SHARED MEMORY ON WINDOWS 2003 SP2 WITH LARGE SHARED MEMORY |
| IC59723 | DBEXPORT GIVES SEGMENTATION VIOLATION. NO CORE FILE IS GENERATED. |
| IC59724 | SIGPIPE PANIC ON SOLARIS PRE IDS11 |
| IC59726 | LONG TRANSACTION (LTX) ABORTED IS LOGGED BUT LTX ROLLBACK COMPLETED IS NOT |
| IC59727 | MEMORY LEAK IN RALLOC WHEN A SPL WITH A LVARCHAR AND LIST(LVARCHAR) IS CALLED REPEATEDLY WITH DIFFERENT VALUES |
| IC59729 | CDR CHECK RECEIVES A 201 SYNTAX ERROR WHEN TABLE CONTAINS MULTIPLE OF 10 UNIQUE INDICES, PRIMARY KEY AND ADDITIONAL COLUMNS |
| IC59731 | REPLICA DEFINITION WITH SUBQUERY IN THE SELECT STATEMENT CRASHES THE DATABASE SERVER. |
| IC59732 | SERVER CRASHES WHEN EXECUTING NESTED STORED PROCEDURES WITH TEMPORARY TABLES AND UDTS |
| IC59735 | UTILITIES CAN SEGV IF SHMEM SEGMENT WITH KEY -1 EXISTS |
| IC59782 | INSERT INTO REMOTE TABLE FAILS WITH ERROR -999 |
| IC59836 | DISCONNECTING FROM IDS CAUSES A BUILD-UP OF CONNECTIONS IN A BOUND STATE EVENTUALLY CAUSING A HANG |
| IC59839 | CHECKPOINT HANG POSSIBLE IF ROLLED BACK TRANSACTION HAD STARTED IN NEXT LOG FILE |
| IC60091 | ENGINE HANGS WITH 'SELECT FIRST' QUERY ON FRAGMENTED TABLE IN PDQ ENVIRONMENT |
| IC60093 | QUERY AGAINST SYSTEM CATALOG SYSPAGHDR PRODUCES -244 ERRORS ON DBSPACE WITH PAGESIZE LARGER THAN DEFAULT PAGESIZE |