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

                            FIXED AND KNOWN DEFECTS

                                    IN

           IBM INFORMIX DYNAMIC SERVER 11.10.xC3E PRODUCT RELEASE

                            DATE: DECEMBER 2008

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



I.    KNOWN ISSUES WITH 11.10.xC3E

II.   CUSTOMER-REPORTED BUGS FIXED IN 11.10.xC3E

III.  CUSTOMER-REPORTED BUGS FIXED IN 11.10.xC2E


******

I.    KNOWN ISSUES WITH 11.10.xC3E

APAR:	Component:	Description

IC57309	ONLINE-RSAM	CONFIGURING AFFINITY PROCESSING FOR CPU VIRTUAL PROCESSORS SLOWS QUERIES

37133113ONLINE-BELIB    AF CONTEXT AND REGISTER DUMP OUTPUT FOR 64 BIT SYSTEMS IS 32 BIT|

IC58240	ONLINE-SLOB	INSERTING SMART LARGE OBJECTS FROM TEMP TABLE TO REGULAR TABLE FAILS

IC58055	ONLINE-SLOB	UPDATE AND SELECT OF SMART LARGE OBJECTS RUN IN PARALLEL WITH COMMITTED READ LAST COMMITTED MAY RESULT IN ERROR -9810

IC57272	ONLINE-RAS	UNEXPECTED VIRTUAL PROCESSOR TERMINATION CAN LEAD TO SITUATION IN WHICH NEARLY NO USEFUL DIAGNOSTIC INFORMATION IS COLLECTED

IC57328	ONLINE-INSTALL	INSTALLSERVER FAILS WITH ERROR NOT ENOUGH SPACE IN PARENT DIRECTORY IN INFORMIXDIR

IC55589	ONLINE-INSTALL	JAVA INSTALLER SHOULD DUMP THE INSTALL LOG FILE PATH AND NAME

37038061ONLINE-GENLIB   CPU VPS CAN LOOSE CONTEXT PRODUCING -202 ERROR

IC58929	ONLINE-SQL	VIEW USING ANSI JOINS AND UNION ALL RETURNS INCORRECT RESULTS WHEN IFX_FOLDVIEW IS SET

IC58176 ONLINE-SQL      PARALLEL UPDATE AND SELECT OF SIMPLE BLOBS MAY CAUSE ERROR -604/-164

IC57721	ONLINE-SQOPTIM	A QUERY RUNS FOREVER WITH FIRST_ROWS OPTIMIZATION AND OPTCOMPIND SET TO 0

37156917ONLINE-SQOPTIM  COMPLEX ANSI JOIN QUERY WITH A LOT OF ITEMS IN IN CLAUSE SPENDS EXCESSIVE TIME IN OPTIMIZATION


II.   CUSTOMER-REPORTED BUGS FIXED IN 11.10.xC3E

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

IC58198	ONUTILS-ONSTAT	ONSTAT -G OPN FAILS WITH CHANGING DATA STRUCTURE FORCED COMMAND TERMINATION

IC57074	ONUTILS-ONMODE	SETTING USELASTCOMMITTED WITH ONMODE -WF, CAUSES INVALID VALUE WHEN RESTARTING IDS

IC57517	ONUTILS-ONBAR	CTRL+C ON ONBAR -B -W BACKUP WAITING FOR MORE FREE SPACE, RETURNS AN ERROR WHEN EXECUTING A NEW BACKUP

IC58471	ONUTILS-ONTAPE	UNIX: ONTAPE LOG BACKUP TO DIRECTORY CAN BE LOST DUE TO NON-UNIQUE TEMP FILE NAME CREATION.

IC57503	ONLINE-GENLIB	CONVERSION FROM CHAR TO NUMBER WHILE USING FRENCH LOCALE (FR_FR8859-1) WILL RETURN AN ERROR 1213

IC55995	ONLINE-ASF	SLOW RSS SYNCHRONIZATION SPEED COMPARED TO HDR ON LINUX

IC58274	ONLINE-SQOPTIM	BAD QUERY PLAN FOR COMPLEX QUERY WITH OUTER JOIN AND IS NULL

37156365ONLINE-SQOPTIM  SELECT STATEMENT WITH NVL AND GROUP BY RESULTS IN -768 ERROR (INCONSISTENT INDEX )

IC57853	ONLINE-SQOPTIM	874: GENERAL EXCEPTION ERROR HAS OCCURRED IN THE OPTIMIZER ERROR WHEN LOADING MORE THAN 2 MILLION ROWS

IC58685	ONLINE-SQOPTIM	OUTER JOINS PRODUCE INCORRECT RESULTS SINCE 10.00.XC5

IC57356	ONLINE-RSAM	ASSERT FAIL IN LKALLOC - LOCK ON FREE LIST BUT NOT FREE - ONLY ON THE HP-UX PLATFORM

IC57740	ONLINE-RSAM	INFORMIX SERVER REPORTS WRONG PAGE FOR CLEANING DELETED ITEMS

IC57544	ONLINE-RSAM	USAGE COUNT AND OPEN COUNT FOR PSEUDO TABLES ARE NEVER DECREMENTED WHEN PDQ IS SET

IC57588	ONLINE-RSAM	TAKING BACK A YIELDED MTS GLOBAL XA BRANCH MAY FREE MEMORY NOT OWNED

IC57810	ONLINE-RSAM	SINGLETON QUERY INCORRECTLY RETURNS -284 ERROR WHEN LEAF PAGE CONTAINING THE KEY BEING SEARCHED FOR UNDERGOES BTSPLIT OPERATION

IC57308	ONLINE-RSAM/TX	WIN64: ONMODE -H DOES NOT WORK AND RETURNS ERROR TRANSACTION ID NOT FOUND IN TRANSACTION  LIST

IC58452	ONLINE-SLOB	TABLE NEEDS TO BE RECREATED TO FIX CORRUPTED SMART BLOB OBJECT HANDLES

IC58189	ONLINE-SLOB	PARALLEL UPDATE OF SMART BLOBS IN GLOBAL TRANSACTION CAUSES ERROR -9810

IC57155	ONLINE-RSAM	A CHECKPOINT HANG IS POSSIBLE IF A ROLLED BACK TRANSACTION STARTED IN NEXT LOG FILE

IC57400	ONLINE-SQL	-229 -101 ERRORS RECIEVED AFTER EXECUTING MULTISET SELECT

IC57154	ONLINE-SQL	THE SYSSQLCACHEPROF TABLE DOES NOT REFLECT CURRENT STATEMENT CACHE STATISTICS

IC57225	ONLINE-SQL	IDS TERMINATES DURING XA_CLOSE WHILE CLEANING UP TEMP TABLES CONTAINING SPATIAL DATA TYPE

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

IC57545	ONLINE-SQL	PDQPRIORITY USED DURING COMPILE TIME OF SYSDBOPEN DETERMINES THE PDQPRIORITY FOR A SESSION

IC57581	ONLINE-SQL	ASSERT FAILURE WHEN USING MULTISETS IN A PROJECTION LIST OF A SELECT

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

IC57542	ONLINE-UDR	SERVER TERMINATES WHEN EXECUTING NESTED STORED PROCEDURES WITH TEMPORARY TABLES AND UDTS.

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

IC57777	ONLINE-SQL-DDL	THE SERVER TERMINATES WHEN CREATING A SECOND RTREE INDEX ON THE SAME COLUMN OF A TEMP TABLE.

IC58238	ONLINE-SQL	ERROR -201 WHEN A TABLE IS NAMED FINAL AND IS LISTED AS THE FIRST TABLE IN THE FROM CLAUSE

IC57357	ONLINE-FRAGM	DELETING FROM DELETE TABLE FAILED WITH ISAM ERROR -126

IC56619	ONLINE-INSTALL	INSTALL PROCESS FAILS TO SETUP IDS MESSAGE SERVICE AS WINDOWS SERVICE ON WINDOWS 2003


III.   CUSTOMER-REPORTED BUGS FIXED IN 11.10.xC2E

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

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

IC53852	ONUTILS-ONSTAT	WIN64 ONSTAT -G STK CAN ABEND THE SERVER ON WINDOWS 64 BIT

IC53856	ONLINE-RSAM	SYSTEM HANGS IN CHECKPOINT

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-ONMON	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