==================================================
FIXED AND KNOWN DEFECTS
IN
IBM INFORMIX DYNAMIC SERVER 11.10.TC3 PRODUCT RELEASE
DATE: DECEMBER 2008
==================================================
I. KNOWN ISSUES WITH 11.10.TC.3
II. CUSTOMER-REPORTED BUGS FIXED IN 11.10.TC3
III. CUSTOMER-REPORTED BUGS FIXED IN 11.10.TC2
*****
I. KNOWN ISSUES WITH 11.10.TC.3
APAR: Component: Description
IC57324 ONLINE-CDR THE CDR CHECK REPLICATE CMD. GIVES ERR -403 ISAM 0 WHEN USING VERBOSE MODE WHEN TABLES HAVE A BLOB COLUMN.
IC57799 DRDA-GENERIC ER STOPS WHEN RECREATING A REPLICATE THAT ALREADY EXISTS
IC57309 ONLINE-RSAM CONFIGURING AFFINITY PROCESSING FOR CPU VIRTUAL PROCESSORS SLOWS QUERIES
IC57184 ONLINE-CDR ABORTED TRANSACTIONS (ATS FILES WITH SQL ERROR -691) OR REMOVED ROWS WITH VIOLATIONS TABLE ON ER TARGET
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
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
IC57721 ONLINE-SQOPTIM A QUERY RUNS FOREVER WITH FIRST_ROWS OPTIMIZATION AND OPTCOMPIND SET TO 0
IC58929 ONLINE-SQL VIEW USING ANSI JOINS AND UNION ALL RETURNS INCORRECT RESULTS WHEN IFX_FOLDVIEW IS SET
IC57359 ONLINE-MACH CHUNK STATUS NOT SYNCHRONIZED BETWEEN PRIMARY AND SDS NODES
II. CUSTOMER-REPORTED BUGS FIXED IN 11.10.TC3
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
IC58999 ONLINE-SQL SELECT STATEMENT WITH NVL AND GROUP BY RESULTS IN -768 ERROR (INCONSISTENT INDEX )
IC59000 ONLINE-BELIB AF CONTEXT AND REGISTER DUMP OUTPUT FOR 64 BIT SYSTEMS IS 32 BIT
IC59002 ONLINE-SQL RUNNING SET INDEXES CONCURRENTLY CAN RESULT IN ERROR 211/143
IC58240 ONLINE-SLOB INSERTING SMART LARGE OBJECTS FROM TEMP TABLE TO REGULAR TABLE FAILS
IC57328 ONLINE-INSTALL INSTALLSERVER FAILS WITH ERROR NOT ENOUGH SPACE IN PARENT DIRECTORY IN INFORMIXDIR
IC59004 BTS-DOCUMENT BTS_CONTAINS DOESN'T PROVIDE THE EXPECTED RESULT PER DOCUMENTATION
IC58698 ONLINE-DOCUMENT /INFORMIXTMP DOCUMENTATION INDICATES THE DIRECTORY IS CREATED IN /TMP OR DRIVE:\TMP
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
IC56725 ONLINE-MACH RSS SERVER FAILS TO RECONNECT OR RECEIVE LOGS FROM PRIMARY SERVER AFTER AN OUTAGE ON THE PRIMARY SERVER
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.
IC57482 ONLINE-CDR CDR REPAIR ATS DOES NOT WORK WITH INHERITED REPLICATED TABLES
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
IC57568 ONLINE-CDR ENTERPRISE REPLICATION DOES NOT RECOGNIZE NODE DATA TYPE
IC57616 ONLINE-MACH ONMODE -D SECONDARY <PRIM_NAME> SHOULD NOT SET SDS UPDATER NODE ALIAS NAME ON THE SECONDARY
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
IC57732 ONLINE-MACH SERVER MAY ASSERT FAIL IN GET_LOGFILE_BY_ID WHEN PERFORMING MANY INSERTS OR UPDATES TO SIMPLE BLOBS
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
IC58078 ONLINE-MACH WHEN A BACKUP FROM AN HDR PRIMARY IS RESTORED, THE DR TYPE IS NOT ALWAYS CLEARED DURING THE STARTUP OF THE RESTORE
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
IC58699 ID-EREP CDR REMOVE BACKWARDS COMPATIBILITY WITH IDS VERSION 10 TO IDS 11
III. CUSTOMER-REPORTED BUGS FIXED IN 11.10.TC2
APAR: Component: Description
IC53851 ONLINE-INSTALL WIN64: INSTANCE MANAGER LIMITS INITIAL DBSPACE AND SBSPACE SIZES TO 2GB
IC53571 ONLINE-SQL-DDL ERROR 591 IS GIVEN WHEN CREATING A TABLE IF THE DEFAULT OPTION OF AN INTERVAL EXCEEDS THE DEFAULT PRECISION
IC51329 ONUTILS-ONPLOAD HPL REQUESTS 4 MB MEMORY SEGMENTS DURING LOADING OF A TABLE
IC53860 ONLINE-DOC DOC - ONMODE PARAMETERS ARE NOT CLEARLY DEFINED IN TABLE 6-1. GUIDE TO SQL: SYNTAX ADMINISTRATIVE API COMMANDS
IC53846 ONLINE-BELIB ONTAPE COLD RESTORE HANGS AT LOGICAL RECOVERY TRANSACTION CLEANUP PHASE
IC53848 ONLINE-SQOPTIM ERROR -874 FROM OPTIMIZER USING LIKE/MATCHES CONDITION WITH A PROCEDURE VARIABLE
IC53849 DBACCESS-GEN CREATE TABLE MENU IN DBACCESS RETURNS ERROR SQL 206/ISAM 111
IC53580 ONUTILS-DOCU DESCRIPTION OF SMI TABLE SYSCHUNKS IN THE ADMINISTRATORS REFERENCE MANUAL IS NOT CORRECT
IC53852 ONUTILS-ONSTAT WIN64 ONSTAT -G STK CAN ABEND THE SERVER ON WINDOWS 64 BIT
IC53856 ONLINE-RSAM SYSTEM HANGS IN CHECKPOINT
IC53824 ONLINE-RSAM THE SQLEXEC THREAD HUNGS WHILE WAITING FOR I/O
IC53762 ONLINE-SQL RUNNING AN INSERT VIA AN SP WITH A TRIGGER EVENT ON A SYSTEM WITH LOW DD VALUES CAUSES ASSERTION FAILURES
IC53928 ONLINE-RSAM ARCHIVE CAN HANG WHEN BTREE SCANNER HAS VERY LITTLE WORK
IC53850 DBATOOLS-GEN DBEXPORT/DBSCHEMA TREATS ENTRIES IN SYSDEFAULTS FOR CLASS=P AS DEFAULTS FOR TABLES
IC53170 ONLINE-ASF ENGINE CRASHES/HANGS IN DELASSOCINQ
IC53612 ONUTILS-ONM ONMONITOR DUMPS CORE ON AIX IF TERMINAL WINDOW IS TOO WIDE
IC53797 ONLINE-RSAM ASSERT FAILURE CAN OCCUR IN PTMAPX() FUNCTION WHILE DOING READ AHEAD OF INDEX PAGES.
IC54021 ONLINE-INSTALL OPERATING SYSTEM UPGRADE ON AIX 5.3 CAUSES THE INFORMIX DYNAMIC SERVER INSTALL SCRIPT TO FAIL
(C) Copyright IBM Corp. 1994, 2008