Fix list for IBM Informix Dynamic Server 11.10.xC2W5

IBM Informix Dynamic Server provides periodic fixes for release 11.10. The following list is the most recent report of fixes for customer-reported defects in PID Version 11.10.xC2W5. This report combines both Windows- and UNIX-specific defect fixes, and is more current than the defect information included in the product release. The content of Wx versions is cumulative.


NOTE: some detail links below have been disabled as they are no longer available.
W1 APARs
Description
IC53659 ON LINUX EXTERNAL RESTORE ABORTS WHEN USING -RENAME OPTION
IC53945 RUNNING THE GLFILES COMMAND ON LINUX PLATFORM RETURNS AN ERROR
IC53956 MSDTC/XA: RUNNING XA APPLICATIONS IN PARALLEL CAN CAUSE GTRID CORRUPTION AND PERMANENT ORPHANED TX IN THE SERVER
IC54020 STRANGE ORDER OF PORT USAGE DURING INSTANCE SETUP
IC54127 XA: SERVER WILL ABEND IN TX_XA_HASH USING THE SAME XA XID IN MULTIPLE APPLICATIONS
IC54129 onbar whole system backup can cause memory corruption if BAR_MAX_BACKUP is not set to 1
IC54154 ONSTAT -P CAN CONSUME THE CPU ON A SYSTEM WITH A LARGE NUMBER OF BUFFERS
IC54321 A CREATE INDEX STATEMENT FAILS WITH AN ERROR -212/-107 WHEN USELASTCOMMITTED IS SET
IC54399 NEED A WAY TO MONITOR IF USER HAS BEEN SWITCHED TO THE IDENTITY OF ANOTHER USER BY USING SET SESSION AUTHORIZATION
IC54424 THE DBSPACE AND NATIONAL LANGUAGE SUPPORT LIST IS EMPTY WHEN USING DBACCESS - DATABASE - INFO MENU OPTION
IC54468 INSERT INTO TABLE CONTAINING COLUMNS WITH DEFAULT VALUES CAN RETURN ERROR -391
IC54492 WHEN INSTALLING IDS ON WINDOWS, THE -SYSTEM OPTION INCORRECTLY CREATES AN INFORMIX USER ACCOUNT
IC54513 INFORMIX DYNAMIC SERVER SHOULD COMPLETE A CHECKPOINT AFTER COMPLETING FAST RECOVERY WHEN TRANSACTIONS HAVE BEEN PROCESSED
IC54514 WIN64: RUNNING A CREATE TABLE SCRIPT TWICE CAUSES THE INFORMIX DYNAMIC SERVER TO ABENDS
IC54530 SELECT WITH ORDER BY DESCENDING RETURNS NO ROWS WHEN INDEX IS USED
IC54566 OPTIMIZER FAILURE CAUSES ERROR -874 IN OPCLASSIFYFLTR
IC54571 SELECT ON INDEX WITH LIKE, UNDERSCORE AND LEADING OR FILTER RETURNS INCORRECT RESULTS
IC54575 LOGICAL LOG 2147483647 NOT FOUND IN IXBAR FILE
IC54612 WIN: IDS 11.10 SHOULD NOT INSTALL THE AUTOMATIC UPDATE FEATURE BY DEFAULT
IC54804 NEGATED HOST VARIABLE CORRUPTS SHARED MEMORY
IC54820 ERROR -19819 RETURNED FROM COMPLEX ANSI JOIN
IC54830 DBEXPORT FAILURE DOES NOT REPORT AN ERROR BUT IT PRODUCES UNUSABLE UNLOAD FILES
IC54840 AN IDS UPGRADE ON WINDOWS REINITIALIZES EXISTING INSTANCE WITHOUT ASKING
IC54857 ERROR -9720 IF LOAD EXTERNAL MODULE FROM SUBDIRECTORY IN $INFORMIXDIR/EXTEND AND WHEN DB_LIBRARY_PATH=$INFORMIXDIR/EXTEND
IC54870 HEAVY LOADS WITH EXPRESSIONS LIKE COLUMN CONCATENATION CAUSE INFORMIX DYNAMIC SERVER TO ASSERT FAIL DUE TO MEMORY CORRUPTION
IC54873 WRONG RESULTS RETURNED WHEN THE OPTIMIZER USES A COMPOSITE INDEX WITH OR INDEX PATH AND LEADING COLUMNS HAVE EQUALITY FILTERS
IC54929 ADDING A CHUNK BEYOND THE 4TB DBSPACE LIMIT WILL CORRUPT THE DBSPACE
IC54934 INFORMIX INSTANCE CANNOT BE IN ONLINE MODE WHEN WE SET ENVIRONMENT VARIABLE FOR LOCALE
IC55027 THE INSTALLATION OF IDS 11.10 RETURNS AN ERROR FOR C++ RUNTIME MINIMUM REQUIREMENTS FOR HIGHER VERSION
IC55067 UPDATES DURING A CHECKPOINT INTERVAL CAN CAUSE FAST RECOVERY PROBLEMS
IC55077 GRANT SELECT ON VIEW THAT HAS A DERIVED TABLE BUILT OFF OF A FUNCTION GETS ERROR -302
IC55134 DBEXPORT CORE DUMPS AFTER A MIGRATION TO IDS 11
IC55215 ASSERT FAIL AND SERVER CRASH ON EXCHANGE THREAD WHEN SHMTOTAL IS EXCEEDED DURING INDEX BUILD
IC55228 OPTIMIZER UNABLE TO CHOOSE OPTIMUM PLAN FOR LARGE TABLES IF DISTRIBUTIONS ARE AVAILABLE
IC55348 UPDATING SMART LARGE OBJECTS FAILS WHEN EXECUTED IN MSDTC TRANSACTION
IC55417 LEVEL-1 OR LEVEL-2 ARCHIVE ON SD PRIMARY PREVENTS INITIALIZATION OF SD SECONDARY
IC55422 ER DEADLOCK IN CDRGFREE
IC55423 UPDATE TO HP MACHINES TO SPECIFY KAIO AND DIRECT_IO AND FILESYSTEMS
IC55490 INSTALLING IDS 11 ON A WINDOWS DOMAIN CONTROLLER FAILS WITH NOROLESEP_CREATEINFXUSER 3 ERROR
IC55794 MIGRATION FROM IDS 10 TO 11 ASSERT FAILS WITH ERROR 211 WHEN UDR REFERENCES TABLE WITH LIKE AND LET STATEMENTS
IC56156 IDS CANNOT START AFTER RESTORING AN ONTAPE ARCHIVE FROM A HDR PRIMARY SERVER WHICH WAS PREVIOUSLY A SECONDARY
IC56800 WHEN UPGRADING TO VERSION 11 YOU CAN GET STUCK IN PHYSICAL RECOVERY
W2 APARs
Description
IC54613 BAD PERFORMANCE FOR A QUERY WHICH USES THE IN CONDITION IN THE WHERE CLAUSE
IC54917 THE START_ONPLOAD PROCEDURE IS NOT WORKING ON WINDOWS
IC54955 CONVERSION OF DECIMAL SEPARATOR IS NOT WORKING FOR PARAMETERIZED INSERT
IC55116 ASSERT FAILURE RELATED TO GET_FULL_QBUFH WHEN TSM STORAGE POOL IS FULL
IC55163 HPL: EXCEEDING THE 3^32 NUMBER OF ROWS, THE NUMBER OF ROWS PROCESSED GOES NEGATIVE.
IC55164 DBSCHEMA -D -HD CAUSES ERROR -1215 - VALUE EXCEEDS LIMIT OF INTEGER PRECISION
IC55213 AUTHENTICATION FAILURE ACCESSING REMOTE TABLES FROM TRIGGERS
IC55350 ONBAR REGRESSION ERROR CONNECTING TO IDS WITH LARGE SHARED MEMORY
IC55409 HUGE MEMORY ALLOCATION DURING INDEX BUILD
IC55416 CDR SYNC COMMAND HANGS WHEN COLUMN DATA VALUES ARE OUT OF THE FILTER RANGE IN THE REPLICATE
IC55419 QUERY USING OUTER JOIN RETURNS WRONG RESULT
IC55436 STANDARD MODE INFORMIX INSTANCE BECOMES PRIMARY AFTER RESTART IN A HDR/RSS ENVIRONMENT
IC55455 PHYSICAL RECOVERY CAN HANG IN V11, WHEN USING CONFIGURABLE PAGE SIZE
IC55490 INSTALLING IDS 11 ON A WINDOWS DOMAIN CONTROLLER FAILS WITH NOROLESEP_CREATEINFXUSER 3 ERROR
IC55661 DRDA: SELECT STATEMENTS WAIT FOR A LOCK TWICE THE TIME OF LOCK WAIT TIMEOUT PERIOD
IC55663 CRASH IN SQL WHEN USING SBLOBS IN MTS (XA) TIGHTLY COUPLED APPLICATION.
IC55673 RUNNING ONINIT -S ON HDR SECONDARY CRASHES THE SERVER
IC55983 WINDOWS DOMAIN USERS ARE ONLY ACCEPTED AS DOMAINUSERNAME NOT USERNAME.
IC56222 ABORTED TRANSACTION (ATS) OR DATA CORRUPTION POSSIBLE WITH UPDATE TRIGGER ON REPLICATED TABLE
W3 APARs
Description
IC55520 ONCHECK PROCESS RATE IS SLOWER THAN PREVIOUS VERSIONS
IC55577 IDSXMLPARSE() ASSERT FAILS ON A WINDOWS PLATFORM IF THE XML IS BADLY FORMED
IC55812 SERVER CRASHES IN TBL2TAB() FUNCTION IF ANSI JOIN AND INFORMIX OUTER JOIN ARE MIXED IN A QUERY WITH DERIVED TABLES
IC55818 USING WITH REOPTIMIZATION CURSOR WITH GROUP BY RESULTS IN MEMORY LEAK IN RALLOC POOL
IC55978 LOCKING ERRORS FOR SELECT STATEMENTS ARE NOT STORED IN STATEMENT HISTORY
IC56002 DBSCHEMA OUTPUT DISPLAYS REPEATED } SYMBOLS, IF {} STYLE OF COMMENTS ARE USED INSIDE A FOR EACH ROW() BRACKET
IC56003 ASSERT FAILURE WHEN CALLING MI_TRIGGER_EVENT() IN USER-DEFINED ROUTINE
IC56004 ONTAPE CANNOT CONNECT IF SHARED MEMORY SIZE IS BIG ON WIINDOWS
IC56088 SCHEDULER SHUTDOWN AFTER MODE CHANGE TO STANDARD CAUSES ORPHANED THREAD AND EVENTUAL ASSERT FAILURE.
IC56105 ERROR -212/-101 WHEN CREATING AN INDEX ON A FRAGMENTED TABLE WITH PARTITIONS IF THE IN CLAUSE IS NOT SPECIFIED
IC56392 DBSIZE PARAMETER BEING IGNORED IN THE SETUP.EXE FILE WHEN RUNNING A SILENT INSTALL
IC56609 ASSERTION FAILURE IN ISLKINTX DUE TO BADLY CREATED KEY LOCK
IC56636 MULTIPLE ALTER TABLE STATEMENTS CAN CAUSE THE SERVER TO ABEND
IC56647 INTERRUPTING A DBACCESS COMMAND-LINE SESSION WHILE EXECUTING SPL MAY COMMIT ALL OR A PORTION OF THE SQL STATEMENTS
IC56672 XA_ROLLBACK IN MTSDTC MODE CAN CORRUPT GLOBAL TRANSACTION ID
IC56678 ENGINE ASSERTION FAILURE IN EV_COLRET_INT WHEN SELECTING ROWID FROM A VIEW THAT IS DEFINED AS A UNION ALL ON MULTIPLE TABLES
IC56772 ERROR RETURNED WITH EXECUTE FUNCTION SYSADMIN:TASK(CHECK EXTENTS, NUMBER)
IC56794 CONNECTION IS NOT CLOSED PROPERLY IN DR_SESSION_THREAD() UNDER ERROR CONDITIONS
IC56795 SIMPLE SP CAN CRASH SERVER IN PCODE_GET_OPCODE()
IC56801 CDR CHECK REPLSET FAILS WITH ERROR 178 ON FIRST TABLE THAT IS OUT OF SYNC
W4 APARs
Description
IC55979 MIGRATION FROM 11.10.XC2 TO 11.10.XC2W1 CAN FAIL WITH TRANSACTION NOT FOUND
IC56157 DBEXPORT CAN TAKE A LONG TIME TO COMPLETE, WHEN THE DATABASE CONTAINS A LOT OF NOT NULL CONSTRAINTS.
IC56446 QUERY OPTIMIZER SHOULD PREFER UNIQUE INDEXES OVER NON-UNIQUE INDEXES
IC56447 IDS CAN ASSERT FAIL IN UDR_OPENSEQ AFTER READING PAST END OF SEGMENT
IC56626 IF USELASTCOMMITED IS SET TO COMMITTED READ THEN SYSADMIN TASKS FAIL
IC56629 IF ONBAR STOPS COMMUNICATING WITH THE STORAGE MANAGER, THE IDS WILL HANG IN A BLOCKED CHECKPOINT
IC56768 ABORTING LONG TRANSACTION WHICH UPDATES SMART BLOB IN GLOBAL TRANSACTION REPORTS ERROR -241/-124
IC56777 USING EXPLAIN AS AN QUERY OPTIMIZER DIRECTIVE CAN CAUSE AN ASSERT FAILURE ON THE DATABASE SERVER.
IC56787 SYSTEM HANGS IN CHECKPOINT -- XCHG_* THREADS WAITING FOREVER IN CRITICAL SECTION
IC56788 SELECT USING BUILT-IN FLOOR() OR CEIL() FUNCTION CAN CORRUPT SHARED MEMORY AND CRASH SERVER
IC56799 PROCEDURE ROWSEND MAY FAIL WITH ERROR -9791 RETRIEVING A COLLECTION TYPE WHEN OS LOCALE IS USED
IC56836 FAILURE DURING CDR DEFINE REPLICATE ON 9.40, 10.00, 11.10, OR 11.50 CAUSES CORRUPT ERROR MESSAGES TO BE SENT TO 7.31 NODES
IC56945 BRINGING UP A RSS WITHOUT A LIVE PRIMARY CAUSES A WAIT/HANG OF 7MIN UNTIL THE SERVER IS AVAILABLE
IC57004 USELASTCOMMITTED FEATURE DOES NOT WORK WITH GLOBAL TRANSACTIONS
IC57011 FAST RECOVERY LOOPS IN ISSAMPLE/ERAND48 WHEN CREATING AN INDEX ON A TABLE CONTAINING LARGE PARTITION BLOBS
IC57157 ERROR 392 WHEN SELECTING FROM MULTISET UNION WITH EXTEND ON DATE COLUMN YEAR TO MONTH BETWEEN TWO HOST VARIABLES
IC57425 ROLLING FORWARD A TRUNCATE TABLE FAILS IN FAST RECOVERY IF CHECKPOINT OCCURS BETWEEN TRUNCATE AND COMMIT
IC57426 FAILURE BY PTMAP CALL IN BFRADATAX LEADS TO SEGV IN BUFFGET
IC57427 MANY DROPPED CONNECTIONS RESULT IN LONG WAIT TIME
IC57428 XA: KILLING XA APPLICATIONS WITH OPEN TRANSACTIONS MAY REPORT FREEING A TRANSACTION ENTRY STILL HOLDING LOCK MESSAGE
IC57431 VPCLASS AIO OR NUMAIOVPS SET TO 0 OR LEFT BLANK MAY SPAWN THOUSANDS OF ONINIT PROCESSES.
W5 APARs
Description
IC56619 INSTALL PROCESS FAILS TO SETUP IDS MESSAGE SERVICE AS WINDOWS SERVICE ON WINDOWS 2003
IC56725 RSS SERVER FAILS TO RECONNECT OR RECEIVE LOGS FROM PRIMARY SERVER AFTER AN OUTAGE ON THE PRIMARY SERVER
IC56810 SDS RETURNS AN ASSERT FAILURE WARNING: ERROR DURING RECOVERY LEFT INDEX INCONSISTENT.
IC57074 SETTING USELASTCOMMITTED WITH ONMODE -WF, CAUSES INVALID VALUE WHEN RESTARTING IDS
IC57155 A CHECKPOINT HANG IS POSSIBLE IF A ROLLED BACK TRANSACTION STARTED IN NEXT LOG FILE
IC57225 IDS TERMINATES DURING XA_CLOSE WHILE CLEANING UP TEMP TABLES CONTAINING SPATIAL DATA TYPE
IC57304 FREQUENT -211 ON SYSPROCPLAN IN 10.00.XC8, 11.10.XC2 AND IN ABOVE VERSIONS
IC57308 WIN64: ONMODE -H DOES NOT WORK AND RETURNS ERROR TRANSACTION ID NOT FOUND IN TRANSACTION LIST
IC57357 DELETING FROM DELETE TABLE FAILED WITH ISAM ERROR -126
IC57400 -229 -101 ERRORS RECIEVED AFTER EXECUTING MULTISET SELECT
IC57482 CDR REPAIR ATS DOES NOT WORK WITH INHERITED REPLICATED TABLES
IC57503 CONVERSION FROM CHAR TO NUMBER WHILE USING FRENCH LOCALE (FR_FR8859-1) WILL RETURN AN ERROR 1213
IC57542 SERVER TERMINATES WHEN EXECUTING NESTED STORED PROCEDURES WITH TEMPORARY TABLES AND UDTS.
IC57545 PDQPRIORITY USED DURING COMPILE TIME OF SYSDBOPEN DETERMINES THE PDQPRIORITY FOR A SESSION
IC57732 SERVER MAY ASSERT FAIL IN GET_LOGFILE_BY_ID WHEN PERFORMING MANY INSERTS OR UPDATES TO SIMPLE BLOBS
IC57740 INFORMIX SERVER REPORTS WRONG PAGE FOR CLEANING DELETED ITEMS
IC57742 NEW CONNECTIONS HANG IF A SESSION HAS LOTS OF PREPARED STATEMENTS THAT HAVE NOT BEEN CLOSED
IC57777 THE SERVER TERMINATES WHEN CREATING A SECOND RTREE INDEX ON THE SAME COLUMN OF A TEMP TABLE.
IC57853 874: GENERAL EXCEPTION ERROR HAS OCCURRED IN THE OPTIMIZER ERROR WHEN LOADING MORE THAN 2 MILLION ROWS
IC57854 APPLICATION FAILS WITH SQL ERROR -259 WHEN PDQPRIORITY IS INCREASED