================================================== FIXED AND KNOWN DEFECTS IN IBM INFORMIX DYNAMIC SERVER 11.10.TC3E PRODUCT RELEASE DATE: DECEMBER 2008 ================================================== I. KNOWN ISSUES WITH 11.10.TC3E II. CUSTOMER-REPORTED BUGS FIXED IN 11.10.TC3E III. CUSTOMER-REPORTED BUGS FIXED IN 11.10.TC2E ****** I. KNOWN ISSUES WITH 11.10.TC3E APAR: Component: Description IC57721 ONLINE-SQOPTIM A QUERY RUNS FOREVER WITH FIRST_ROWS OPTIMIZATION AND OPTCOMPIND SET TO 0 IC57328 ONLINE-INSTALL INSTALLSERVER FAILS WITH ERROR NOT ENOUGH SPACE IN PARENT DIRECTORY IN INFORMIXDIR IC57309 ONLINE-RSAM CONFIGURING AFFINITY PROCESSING FOR CPU VIRTUAL PROCESSORS SLOWS QUERIES IC58240 ONLINE-SLOB INSERTING SMART LARGE OBJECTS FROM TEMP TABLE TO REGULAR TABLE FAILS IC56244 ONUTILS-ONSTAT ONSTATS BANNER INDICATES CHECKPOINTS ARE BLOCKED WHEN THEY ARE NOT IC55589 ONLINE-INSTALL JAVA INSTALLER SHOULD DUMP THE INSTALL LOG FILE PATH AND NAME IC58929 ONLINE-SQL VIEW USING ANSI JOINS AND UNION ALL RETURNS INCORRECT RESULTS WHEN IFX_FOLDVIEW IS SET 37156209ONLINE-SQL AF WITH MT_SHM_FREE_POOL CONDITION FAILED ON THEIR RSS SERVER IC58176 ONLINE-SQL PARALLEL UPDATE AND SELECT OF SIMPLE BLOBS MAY CAUSE ERROR -604/-164 IC58055 ONLINE-SLOB UPDATE AND SELECT OF SMART LARGE OBJECTS RUN IN PARALLEL WITH COMMITTED READ LAST COMMITTED MAY RESULT IN ERROR -9810 II. CUSTOMER-REPORTED BUGS FIXED IN 11.10.TC3E APAR: Component: Description IC58706 ONLINE-UDR ERRORS -7470/-937 AND VARIOUS MEMORY CORRUPTIONS WHEN EXECUTING A TRIGGER CONTAINING A SPATIAL FUNCTION IC59130 ONLINE-SQL MEMORY CORRUPTION WHEN A COMPLEX ANSI JOIN QUERY WITH A LOT OF HOST VARIABLES AND A LARGE IN CLAUSE GETS A TIMEOUT IC55995 ONLINE-ASF SLOW RSS SYNCHRONIZATION SPEED COMPARED TO HDR ON LINUX IC55831 ONLINE-SQL-SPL DEFINE/LET COMBINATION IN SPL IMPLICITLY CASTS VARCHAR VARIABLES TO CHAR, CAUSING INCORRECT -9748 ERROR. IC57854 ONLINE-SQL-SPL APPLICATION FAILS WITH SQL ERROR -259 WHEN PDQPRIORITY IS INCREASED IC56619 ONLINE-INSTALL INSTALL PROCESS FAILS TO SETUP IDS MESSAGE SERVICE AS WINDOWS SERVICE ON WINDOWS 2003 IC57074 ONUTILS-ONMODE SETTING USELASTCOMMITTED WITH ONMODE -WF, CAUSES INVALID VALUE WHEN RESTARTING IDS IC57154 ONLINE-SQL THE SYSSQLCACHEPROF TABLE DOES NOT REFLECT CURRENT STATEMENT CACHE STATISTICS IC57155 ONLINE-RSAM A CHECKPOINT HANG IS POSSIBLE IF A ROLLED BACK TRANSACTION STARTED IN NEXT LOG FILE IC57225 ONLINE-SQL IDS TERMINATES DURING XA_CLOSE WHILE CLEANING UP TEMP TABLES CONTAINING SPATIAL DATA TYPE IC57503 ONLINE-GENLIB CONVERSION FROM CHAR TO NUMBER WHILE USING FRENCH LOCALE (FR_FR8859-1) WILL RETURN AN ERROR 1213 IC57742 ONLINE-SQL NEW CONNECTIONS HANG IF A SESSION HAS LOTS OF PREPARED STATEMENTS THAT HAVE NOT BEEN CLOSED IC57304 ONLINE-SQL FREQUENT -211 ON SYSPROCPLAN IN 10.00.XC8, 11.10.XC2 AND IN ABOVE VERSIONS IC57308 ONLINE-RSAM/TX WIN64: ONMODE -H DOES NOT WORK AND RETURNS ERROR TRANSACTION ID NOT FOUND IN TRANSACTION LIST IC57357 ONLINE-FRAGM DELETING FROM DELETE TABLE FAILED WITH ISAM ERROR -126 IC57356 ONLINE-RSAM ASSERT FAIL IN LKALLOC - LOCK ON FREE LIST BUT NOT FREE - ONLY ON THE HP-UX PLATFORM IC57542 ONLINE-UDR SERVER TERMINATES WHEN EXECUTING NESTED STORED PROCEDURES WITH TEMPORARY TABLES AND UDTS. IC57517 ONUTILS-ONBAR CTRL+C ON ONBAR -B -W BACKUP WAITING FOR MORE FREE SPACE, RETURNS AN ERROR WHEN EXECUTING A NEW BACKUP IC57545 ONLINE-SQL PDQPRIORITY USED DURING COMPILE TIME OF SYSDBOPEN DETERMINES THE PDQPRIORITY FOR A SESSION IC57544 ONLINE-RSAM USAGE COUNT AND OPEN COUNT FOR PSEUDO TABLES ARE NEVER DECREMENTED WHEN PDQ IS SET IC57581 ONLINE-SQL ASSERT FAILURE WHEN USING MULTISETS IN A PROJECTION LIST OF A SELECT IC57588 ONLINE-RSAM TAKING BACK A YIELDED MTS GLOBAL XA BRANCH MAY FREE MEMORY NOT OWNED IC57777 ONLINE-SQL-DDL THE SERVER TERMINATES WHEN CREATING A SECOND RTREE INDEX ON THE SAME COLUMN OF A TEMP TABLE. IC57853 ONLINE-SQOPTIM 874: GENERAL EXCEPTION ERROR HAS OCCURRED IN THE OPTIMIZER ERROR WHEN LOADING MORE THAN 2 MILLION ROWS IC58394 ONLINE-SQL CDR DEFINE REPLICATE MASTER COMMAND FAILS WITH TABLE DOES NOT CONTAIN PRIMARY KEY (18) IC57802 ONLINE-SQL SELECT COUNT(*) DOES NOT WORK CONSISTENTLY IN A TRIGGER PROCEDURE WITH REFERENCES IC57810 ONLINE-RSAM SINGLETON QUERY INCORRECTLY RETURNS -284 ERROR WHEN LEAF PAGE CONTAINING THE KEY BEING SEARCHED FOR UNDERGOES BTSPLIT OPERATION IC58452 ONLINE-SLOB TABLE NEEDS TO BE RECREATED TO FIX CORRUPTED SMART BLOB OBJECT HANDLES IC58685 ONLINE-SQOPTIM OUTER JOINS PRODUCE INCORRECT RESULTS SINCE 10.00.XC5 IC58471 ONUTILS-ONTAPE UNIX: ONTAPE LOG BACKUP TO DIRECTORY CAN BE LOST DUE TO NON-UNIQUE TEMP FILE NAME CREATION. IC58274 ONLINE-SQOPTIM BAD QUERY PLAN FOR COMPLEX QUERY WITH OUTER JOIN AND IS NULL IC58198 ONUTILS-ONSTAT ONSTAT -G OPN FAILS WITH CHANGING DATA STRUCTURE FORCED COMMAND TERMINATION IC58189 ONLINE-SLOB PARALLEL UPDATE OF SMART BLOBS IN GLOBAL TRANSACTION CAUSES ERROR -9810 IC58238 ONLINE-SQL ERROR -201 WHEN A TABLE IS NAMED FINAL AND IS LISTED AS THE FIRST TABLE IN THE FROM CLAUSE III. CUSTOMER-REPORTED BUGS FIXED IN 11.10.TC2E APAR: Component: Description IC53851 ONLINE-INSTALL WIN64: INSTANCE MANAGER LIMITS INITIAL DBSPACE AND SBSPACE SIZES TO 2GB IC53846 ONLINE-BELIB ONTAPE COLD RESTORE HANGS AT LOGICAL RECOVERY TRANSACTION CLEANUP PHASE IC53856 ONLINE-RSAM SYSTEM HANGS IN CHECKPOINT IC53824 ONLINE-RSAM THE SQLEXEC THREAD HUNGS WHILE WAITING FOR I/O IC53928 ONLINE-RSAM ARCHIVE CAN HANG WHEN BTREE SCANNER HAS VERY LITTLE WORK IC53797 ONLINE-RSAM ASSERT FAILURE CAN OCCUR IN PTMAPX() FUNCTION WHILE DOING READ AHEAD OF INDEX PAGES. IC53170 ONLINE-ASF ENGINE CRASHES/HANGS IN DELASSOCINQ IC53850 DBATOOLS-GEN DBEXPORT/DBSCHEMA TREATS ENTRIES IN SYSDEFAULTS FOR CLASS=P AS DEFAULTS FOR TABLES IC53849 DBACCESS-GEN CREATE TABLE MENU IN DBACCESS RETURNS ERROR SQL 206/ISAM 111 IC53848 ONLINE-SQOPTIM ERROR -874 FROM OPTIMIZER USING LIKE/MATCHES CONDITION WITH A PROCEDURE VARIABLE IC53762 ONLINE-SQL RUNNING AN INSERT VIA AN SP WITH A TRIGGER EVENT ON A SYSTEM WITH LOW DD VALUES CAUSES ASSERTION FAILURES IC53571 ONLINE-SQL-DDL ERROR 591 IS GIVEN WHEN CREATING A TABLE IF THE DEFAULT OPTION OF AN INTERVAL EXCEEDS THE DEFAULT PRECISION IC53852 ONUTILS-ONSTAT WIN64 ONSTAT -G STK CAN ABEND THE SERVER ON WINDOWS 64 BIT IC51329 ONUTILS-ONPLOAD HPL REQUESTS 4 MB MEMORY SEGMENTS DURING LOADING OF A TABLE IC53612 ONUTILS-ONMON ONMONITOR DUMPS CORE ON AIX IF TERMINAL WINDOW IS TOO WIDE (C) Copyright IBM Corp. 1994, 2008