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