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 |