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 |