IBM Support

Fix list for Informix Dynamic Server 11.50.xC3W2

Product documentation


Abstract

Informix Dynamic Server provides periodic fixes for release 11.50. The following list is the most recent report of fixes for customer-reported defects in PID 11.50.xC3W2. This report combines both Windows- and UNIX-specific defect fixes, and is more current than the defect information included in the product release.

Content





PID 11.50.xC3W2
Fix release date: 9 Feb 2009
Last modified: 9 April 2014
Status: Recommended

Download information

.


NOTE: some detail links below have been disabled as they are not available.
W1 APARs
Description
IC57613 DOCUMENTATION SHOULD INCLUDE A MORE PRECISE DISCUSSION ON DYNAMIC LOGS
IC57756 PDQ DOES NOT WORK WITH COLLECTION DERIVED TABLES IN THE FROM CLAUSE
IC57845 STORED PROCEDURE WITH SELECT FROM A COLLECTION DERIVED TABLE GIVES ASSERTION FAILURE AND -9791
IC58118 SYSMASTER TABLE FLAGS_TEXT, NO DESCRIPTION FOR ISOLATION COMMITTED READ LAST COMMITTED
IC58280 Table Level Restore fails to parse schema command files with some types of constraint expressions
IC58598 STORED PROCEDURE ON FRAGMENTED INDEX WITH SUBSTR EXPRESSION RETURN ERROR -346 / -111
IC58706 ERRORS -7470/-937 AND VARIOUS MEMORY CORRUPTIONS WHEN EXECUTING A TRIGGER CONTAINING A SPATIAL FUNCTION
IC58707 CDR SYNC ON TABLES WITH BLOB COLUMNS MAY ALLOCATE LARGE AMOUNTS OF MEMORY AND CRASH THE TARGET SERVER
IC58756 ERROR 640 QPLAN SANITY FAILURE EXECUTING A STORED PROCEDURE CONTAINING A VIEW AND UPDATE STATISTICS IS RUNNING SIMULATANEOUSLY
IC58825 ONSTAT -G OPN FAILS WITH CHANGING DATA STRUCTURE FORCED COMMAND TERMINATION
IC58840 CREATE INDEX USING BTS STATEMENT RETURNS A BTS90 ERROR AND ASSERT FAILURE
IC58898 BOTH THE OPTIMIZER COSTS AND NUMBER OF ROWS RETURNED FOR LEFT OUTER JOINS IS UNPREDICTABLE
IC58918 ANSI SIX-TABLE OUTER JOIN EXECUTES MUCH MORE SLOWLY THAN COMPARABLE INFORMIX OUTER JOIN
IC58929 VIEW USING ANSI JOINS AND UNION ALL RETURNS INCORRECT RESULTS WHEN IFX_FOLDVIEW IS SET
IC59023 CREATE INDEX FAILS WITH ERRORS 212/107 RECORD IS LOCKED EVEN IF THERE ARE NO OTHER SESSIONS CONNECTED TO THE DATABASE.
IC59150 ERROR 640 QPLAN SANITY FAILURE EXECUTING A STORED PROCEDURE CONTAINING A VIEW AND UPDATE STATISTICS IS RUNNING SIMULATANEOUSL
IC59159 ASSERT FAIL IN RANGE SEARCH WHEN USING BTS AND SPECIFYING AN INCOMPLETE RANGE
IC59170 AN INSERT TRIGGER CALLING A STORED PROCEDURE WITH TRIGGER REFERENCES RESULTS IN AN ASSERT FAILED AND ERROR -9791.
IC59171 SEQUENCE OBJECT RESTART WITH CACHE PLUS CURRENT VALUE THOUGH CACHE VALUE HAD NOT BEEN USED UP.
IC59206 LOGICAL LOGS FILL QUICKLY BECAUSE OF UNNECESSARY STORED PROCEDURE REOPTIMIZATION
IC59246 SYSTEM COMMAND IN STORED PROCEDURE TAKES SECONDS TO RUN
IC59271 ADDING A FRAGMENT USING THE BEFORE CLAUSE SCANS ALL FRAGMENTS
IC59289 NVL FUNCTION RETURNS EMPTY SPACE WHEN THE RETURN RESULT INVOLVES VARCHAR CONCATENATION
IC59291 ALTER FRAGMENT TO ADD A PARTITION THROWS -776 AND ISAM -111 ERRORS
IC59292 -211 ERROR ON SYSPROCPLAN
IC59293 DEFINE/LET COMBINATION IN SPL IMPLICITLY CASTS VARCHAR VARIABLES TO CHAR, CAUSING INCORRECT -9748 ERROR.
IC59294 WINDOWS: INSTALLATION OF 11.50.XC3 MIRRORS ROOTDBS AND SMARTBLOB SPACE WITHOUT PROMPTING
IC59296 ASSERT FAILURE WHEN USING MULTISETS IN A PROJECTION LIST OF A SELECT

W2 APARs
Description
IC57571 SCHAPI: ERROR -23197 DATABASE LOCALE INFORMATION MISMATCH ERROR IN ONLINE.LOG
IC58103 CREATE TEMP TABLE WITH UNIQUE SERIAL COLUMN AND NO LOG, RETURNS ERRORS 626/140 ON A HDR SECONDARY
IC58271 OPEN CURSOR WITH A USING CLAUSE IN A DYNAMIC SPL CAUSES A 1260 ERROR
IC58701 DBEXPORT PRODUCES A STATEMENT LONGER THAN IDS CAN HANDLE RESULTING IN A -460 ERROR ON DBIMPORT
IC59181 EXECUTING A FUNCTION WHOSE VALUES ARE BEING CONCATENATED, RETURNS ERROR -674
IC59272 DYNAMIC EXPLAIN DOES NOT WORK FOR DRDA CLIENTS
IC59291 ALTER FRAGMENT TO ADD A PARTITION THROWS -776 AND ISAM -111 ERRORS
IC59302 MI_REALLOC CAN CORRUPT RESULT SET IN GENXML/GENXMLCLOB
IC59326 BYTE COLUMN INSERT INTO VIEW RESULTS IN ERROR 618 AND 101
IC59348 BTS_CONTAINS DOES NOT RETURN CORRECT RESULT USING DEGREE OF SIMILARITY
IC59399 MQ DATABLADE DOES NOT SUPPORT LOCALLY DEFINED REMOTE QUEUES
IC59466 A QUERY RUNS FOREVER WITH FIRST_ROWS OPTIMIZATION AND OPTCOMPIND SET TO 0
IC59477 AN ALTER FRAGMENT ATTACH COMMAND IGNORES THE CHECK CONSTRAINT AND CAUSES A SEQUENTIAL SCAN
IC59478 "-208 MEMORY ALLOCATION FAILED DURING QUERY PROCESSING" RUNNING SQL USING THE REPLACE FUNCTION
IC59502 AN OPTIMIZER ERROR -874 WHEN RUNNING SQL THAT INCLUDES A ROW TYPE
IC59892 DBSCHEMA GIVES ERROR "-586 - CURSOR IS ALREADY OPEN."
IC59896 PERFORMANCE SLOWDOWN WHEN MANY NON-DBA USERS EXECUTE A STORED PROCEDURE
IC59898 BAD PERFORMANCE ON REMOTE CALLS WHEN USING LONG SQLHOSTS SERVER LIST







Document information

More support for: Informix Servers

Software version: 11.5

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Software edition: Enterprise, Workgroup

Reference #: 7015084

Modified date: 09 February 2009


Translate this page: