==================================================

                            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