Fix list for Informix Dynamic Server 11.50.xC4

<Product> provides periodic fixes for release <major release>. The following list is the most recent report of fixes for customer-reported defects in Version <version>. This report combines both Windows- and UNIX-specific defect fixes, and is more current than the defect information included in the product release.


APAR
Description
IC57167 IN SOME SITUATIONS THE OPTIMIZER DOES NOT USE A KEY-ONLY INDEX.
IC57571 SCHAPI: ERROR -23197 DATABASE LOCALE INFORMATION MISMATCH ERROR IN ONLINE.LOG
IC57613 DOCUMENTATION SHOULD INCLUDE A MORE PRECISE DISCUSSION ON DYNAMIC LOGS
IC57702 ENABLING PDQ DURING UPDATE STATISTICS CAN INCREASE TEMPORARY SPACE REQIREMENT
IC57756 PDQ DOES NOT WORK WITH COLLECTION DERIVED TABLES IN THE FROM CLAUSE
IC57784 IDS SERVICE NOT STARTED IF "INITIALIZE SERVER" BOX IS UNCHECKED
IC57788 ATTEMPTING TO DROP A PROCEDURE AFTER EXECUTION CAUSES -705 ERROR
IC57845 STORED PROCEDURE WITH SELECT FROM A COLLECTION DERIVED TABLE GIVES ASSERTION FAILURE AND -9791
IC58103 CREATE TEMP TABLE WITH UNIQUE SERIAL COLUMN AND NO LOG, RETURNS ERRORS 626/140 ON A HDR SECONDARY
IC58118 SYSMASTER TABLE FLAGS_TEXT, NO DESCRIPTION FOR ISOLATION COMMITTED READ LAST COMMITTED
IC58271 OPEN CURSOR WITH A USING CLAUSE IN A DYNAMIC SPL CAUSES A 1260 ERROR
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
IC58689 RUNNING SCHEDULER START/STOP IN PARALLEL CAUSES MULTIPLE DBSCHEDULER THREADS AND SUBSEQ ABENDS
IC58701 DBEXPORT PRODUCES A STATEMENT LONGER THAN IDS CAN HANDLE RESULTING IN A -460 ERROR ON DBIMPORT
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 SIMULATANEOUSL
IC58815 TO_DATE() CONVERTS TAIWAN MINGUO YEAR TO INCORRECT JULIAN YEAR
IC58824 ABORT OF LONG TRANSACTION CANNOT BE DONE IF SQL IS REMOTE PROCEDURE CALL AND REMOTE SERVER IS NOT RESPONDING
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
IC58947 THE LET STATEMENT IN A STORED PROCEDURE MAY INCORRECTLY RETURN ERROR -661.
IC58966 KILLING AN ONBAR_D PROCESS WHILE RUNNING AN ONBAR PARALLEL WHOLE SYSTEM BACKUP MAY CRASH THE DATABASE SERVER
IC59023 CREATE INDEX FAILS WITH ERRORS 212/107 RECORD IS LOCKED EVEN IF THERE ARE NO OTHER SESSIONS CONNECTED TO THE DATABASE.
IC59032 EILSEQ_COMPAT_MODE SHOULD HAVE A THIRD OPTION TO SILENTLY TRUNCATE STRINGS
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 INCORRECT NEXT SEQUENCE VALUE WHEN SESSION KILLED USING SEQUENCE WITH CACHE AND ENGINE RESTARTED
IC59181 EXECUTING A FUNCTION WITH CONCATENATED VALUES RETURNS ERROR -674
IC59202 USING LIKE CLAUSE IN A CONDITION WITHIN A SIMPLE SELECT WITH TWO LEFT JOINS GENERATES AFS ON SERVER
IC59206 LOGICAL LOGS FILL QUICKLY BECAUSE OF UNNECESSARY STORED PROCEDURE REOPTIMIZATION
IC59246 SYSTEM COMMAND IN STORED PROCEDURE TAKES SECONDS TO RUN
IC59269 PROCESSOR AFFINITY ASSUMES THAT PROCESSOR IDS ARE CONTIGUOUS
IC59271 ADDING A FRAGMENT USING THE BEFORE CLAUSE SCANS ALL FRAGMENTS
IC59272 DYNAMIC EXPLAIN DOES NOT WORK FOR DRDA CLIENTS
IC59281 DRDA: INCONSISTENT HANDLING OF ERROR -1215 WITH DATA SERVER DRIVER
IC59282 SLOW ALTER OF TABLE CONTAINING PARTITION BLOBS CAN FAIL WITH ERRORS 618/101 OR 618/770
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.
IC59296 ASSERT FAILURE WHEN USING MULTISETS IN A PROJECTION LIST OF A SELECT
IC59302 MI_REALLOC CAN CORRUPT RESULT SET IN GENXML/GENXMLCLOB
IC59309 ALTER FRAGMENT ON INDEX USING AFTER OR BEFORE CAUSES A SERVER CRASH
IC59326 BYTE COLUMN INSERT INTO VIEW RESULTS IN ERROR 618 AND 101
IC59348 BTS_CONTAINS DOES NOT RETURN CORRECT RESULT USING DEGREE OF SIMILARITY
IC59366 ER DOES NOT SUPPORT ROLE SEPARATION
IC59381 QUERY USING DECODE WITH GROUP BY IN A TABLE MULTISET MAY RETURN
IC59399 MQ DATABLADE DOES NOT SUPPORT LOCALLY DEFINED REMOTE QUEUES
IC59422 TOO MANY NET BUFFERS ARE BEING ALLOCATED FROM GLOBAL POOL WHILE REPLICATING BLOB DATA USING ER
IC59437 CONFUSING HANDSHAKE DETECTED DUPLICATE ID FOR ER GC SYNC ATTEMPT IF IN FACT AN SQLHOSTS ENTRY IS MISSING
IC59438 CDR CHECK TAKES SEVERAL MINUTES PER TABLE TO EXECUTE, BEHAVIOR CHANGES AFTER CDR SYNCH IS RUN
IC59466 A QUERY WITH FIRST_ROWS OPTIMIZATION AND OPTCOMPIND SET TO 0 NEVER RETURNS
IC59468 -143 DEADLOCK DETECTED ERROR IS RETURNED WHEN DOING A CONCURRENT READ AND WRITE OF THE SAME BLOB
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
IC59494 ASSIGNING A SUBSTRING OF INCORRECT SIZE TO A VARCHAR WITH THE LET STATEMENT DOES NOT GIVE AN ERROR MESSAGE BUT A MEMORY OVERFLOW
IC59502 AN OPTIMIZER ERROR -874 WHEN RUNNING SQL THAT INCLUDES A ROW TYPE
IC59528 AUTO UPDATE STATISTICS MAY CAUSE A -201 SYNTAX ERROR WHERE THE TOTAL LENGTH OF COLUMN NAMES EXCEEDS 1000 CHARACTERS
IC59648 DEFINING A REPLICATE BETWEEN 7.31 AND NON 7.31 SERVERS WHEN THE REPLICATE EXISTS CAUSES THE SERVER TO ASSERT FAIL AND CRASH
IC59669 AN ERROR 951/952 WHEN PASSWORD SHADOWING ENABLED ON HP-UX 11.11
IC59674 MEMORY LEAK IN GENTCB WITH REPEATED CALLS TO SET COLLATION ON A GIVEN SESSION ID.
IC59695 THE RPAD FUNCTION IS NOT PADDING A STRING WITH BLANK SPACES CORRECTLY
IC59786 USING SELECT WITHIN A STORED PROCEDURE WHICH HAS PDQPRIORITY SET AND IS CALLED MANY TIMES IN A SESSION WILL CAUSE MEMORY LEAK
IC59797 IMPORTED RESTORE WITH VERITAS NETBACKUP FAILS DURING LOGICAL RESTORE WHEN SERVERNUM OF IDS DOES NOT MATCH THE SOURCE
IC59798 LOGICAL LOG SWITCHES TO THE NEXT LOG FILE EVEN IF IT DOES NOT FILL UP
IC59812 A QUERY THAT USES AN OR RETURNS INCORRECT RESULTS WHEN AN INDEX IS USED.
IC59813 BTS 2.0 INDEXING ROUTINES USING SBSPACE RATHER THAN EXTSPACE ARE SLOW.
IC59881 STRESS TEST ON CONNECT/DISCONNECT TO THE SERVER RESULTS IN BUILD-UP OF CONNECTIONS IN A BOUND STATE TO THE SERVERS PORT
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
IC59910 CDRSITES_731 ENVIRONMENT VARIABLE DOES NOT WORK
IC59964 AF ABENDS IDS WHEN INTO CLAUSE OF A FOREACH STATEMENT IN A SPL CONTAINS MORE THAN ONE OCCURRENCE OF TWO SINGLE QUOTES
IC59965 ANSI OUTER JOIN APPLIES FILTER TOO LATE AND PERFORMS BADLY
IC59982 RUNNING A SELECT STATEMENT USING AN OUTER JOIN CAUSES ERROR 874 AND AN ASSERTION FAILURE
IC60056 IT TAKES MUCH LONGER TO CREATE INDEX OR ENABLE INDEX
IC60059 REMOTE QUERIES LEAVE MULTIPLE ENTRIES FOR ONE TABLE IN THE DATA DICTIONARY
IC60072 RTN MEMORY LEAK FROM SYSADMIN SCHEDULER
IC60096 ERRORS 425 AND 107 WHEN YOU RUN A DROP DATABASE COMMAND
IC60108 NESTED TRIGGERS AGAINST REMOTE DATABASE TABLES CAN RESULT IN SQL ERRORS -394 OR -710
IC60139 ADMIN GUIDE OR ADMINISTRATORS REFERENCE DOES NOT PROVIDE INFORMATION ABOUT THREAD AND EFF COLUMNS PRODUCED BY ONSTAT -G GLO
IC60141 TABLE LEVEL RESTORE (TLR) RESTORES AN EMPTY TEXT AS NULL
IC60145 EXECUTION OF DBSCHEMA IS SLOW.
IC60150 CONNECTION MANAGER WITH SSL CONNECTIONS FROM CLIENTS RESULTS IN -408 OR 28014: SECURE SOCKETS LAYER ERROR: GSK_ERROR_BAD_CERT.
IC60169 SERVER FAILS TO UPDATE/DELETE A ROW ON UPDATABLE SDS
IC60188 WHEN USING DRDA PROTOCOL TEMP TABLES ARE CREATED IN ROOTDBS EVEN IF A DBSPACETEMP IS SPECIFIED.
IC60219 IDS CRASHES WITH STACK THREAD OVERFLOW WHEN RUN AUS REFRESH EVALUATION .
IC60258 CONNECTION MANAGER USES DBSERVERNAME FOR CLIENT RE-DIRECTION NOT CM INFORMIXSERVER
IC60261 ARCHECKER TABLE LEVEL RESTORE (TLR) DOES NOT WORK WHEN TAPEDEV IS SET TO $INFORMIXDIR
IC60287 NO ERROR MESSAGE IS RETURNED WHEN EXECUTING TRUNCATE TABLE FOR A TEMP TABLE ON AN SDS UPDATABLE SECONDARY.
IC60299 ONBAR BACKUP ABORTS WITH XBSA ERROR: EXCEEDED AVAILABLE RESOURCES THOUGH TIMEOUT IS NOT REACHED
IC60322 IDS DOES NOT START WHEN THERE IS A TYPOGRAPH. ERROR IN ANY OF CDR_ENV PARAMETERS IN ONCONFIG FILE
IC60335 IDS DOES NOT RECOGNIZE THE CDRSITES_731, CDRSITES_92X AND CDRSITES_10X ENV. VARIABLES
IC60357 EXECUTION OF SPL PROCEDURE SYSDBCLOSE() CAN CAUSE AN ASSERT FAILURE AND CRASH
IC60371 SETTING SQLTRACE TO ON WITH HOST VARIABLES HAVING NULL VALUES CAN CAUSE IDS CRASH
IC60435 ASSERT FAILURE DUE TO MEMORY CORRUPTION IF A QUERY IS REOPTIMIZED WHILE DOING A SAPI FETCH AND PDQ IS SET DYNAMICALLY
IC60438 EXECUTING SET INDEXES IDXNAME ENABLED MAY CAUSE A SERVER ABEND IN RSTIDXFRG WHEN HITTING A LONG TRANSACTION
IC60481 ONSTAT -G CMSM PRINTS ONLY 8 CHARACTERS OF CONNECTION MANAGER NAME WHICH COULD BE 128 CHARACTERS
IC60510 HDRMKPRI.SH DOES NOT PARSE ONSTAT -G DRI OUTPUT PROPERLY IF MODE SWITCHED FROM SECONDARY TO PRIMARY
IC60514 ASSERT FAILED: YIELD_PROCESSOR: CONDITIONAL LATCH COUNT NON-ZERO IN THREAD 2402
IC60549 SELECT FROM TABLE IS POSSIBLE WHEN DATABASE IS IN QUIESCENT MODE AND USING A DRDA CONNECTION
IC60564 AN INSERT ... SELECT STATEMENT WITH VIOLATIONS TABLE AND PDQ MAY HANG AND CAUSE A BLOCKED CHECKPOINT
IC60578 PING TIMEOUT AND HDR CONNECTION NOT RE-ESTABLISHED WHEN RUNNING ONCHECK ON A TABLE WHICH IS BEING UPDATED ON THE PRIMARY
IC60621 ASSERT FAILURE WHILE CONVERTING FUNCTIONS OR PROCEDURES WITH PARAMETER OF TYPE LIST SPECIFIED WITH DEFAULT VALUES
IC60631 A DISTRIBUTED QUERY REFERENCING MULTIPLE SERVERS OF DIFFERENT VERSIONS CAN RESULT IN ERROR 934
IC60675 DBIMPORT INTO DBSPACE OF NON-DEFAULT SIZE USING DIRECT_IO MAY CORRUPT THE DATABASE
IC60700 DBSCHEMA DOES NOT PRINT CONSTRAINTS IN A CONSISTENT ORDER
IC60701 REVERSION FROM 11.50 TO 7.30 CHANGES ONCONFIG PARAM LOG_INDEX_BUILDS FROM 0 TO 1 CAUSING REVERSION TO FAIL
IC60703 OPTIMIZER CHOOSES LESS EFFICIENT QUERY PLAN FOR COMPLEX SUBQUERY
IC60705 NEED A ALARM EVENT WHEN A PEER ER NODE GETS DISCONNECTED UNINTENTIONALLY
IC60706 CREATION AND USE OF RAW TABLES SHOULD BE RE-ENABLED IN REPLICATED ENVIRONMENTS
IC60707 BTSCANNER CAUSES SERVER ABORT IN ATTEMPT TO CLEAN A NO LONGER EXISTING INDEX ON A TABLE
IC60711 ERROR -8335 WHEN SELECTING TABLE FIELD "DELETING" EVEN WITH DELIMIDENT
IC60718 DBSCHEMA FAILS WITH SQL 211 AND ISAM 107
IC60728 SERVER CRASHES WHEN RUNNING SELECT WITH WHERE IN SERIAL COLUMN
IC60729 MACHINE NOTES DOES NOT HAVE CORRECT KERNEL CONFIGURATION INFORMATION FOR SOLARIS 10
IC60731 CURRENT DOCUMENTATION ON SETTING UP IDS CLIENTS AND SERVERS FOR SSL COMMUNICATION NEEDS UPDATE
IC60732 ENTERPRISE REPLICATION ALARMS ARE MISSING FROM THE LIST OF ALARMS IN THE ADMINISTRATOR'S REFERENCE
IC60733 WHEN ROOTDBS CONTAINS MULTIPLE CHUNKS, THE ARCHIVE LOGPOS/LOGUNIQ NOT RECORDED IN THE SECONDARY ROOT CHUNKS
IC60734 CDR DEFINE SERVER CAN PRODUCE AMBIGUOUS ERROR MESSAGE
IC60737 FAILED LDAP CALLS CAUSE SIGABRT PANIC IN IDS SERVER
IC60740 HDR FAILOVER CONTROLLED BY CONNECTION MANAGER IS SET BY TCP KEEPALIVE WHEN MACHINES ARE DISCONNECTED
IC60741 ERROR -674 WHEN YOU RUN CREATE TRIGGER
IC60743 ERROR -244 AND AN ASSERTION FAILURE OCCUR WHEN YOU RUN A SELECT ON SYSTEM CATALOG TABLE SYSPAGHDR