Fix list for Informix Dynamic Server 11.50.xC5W4

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 Version 11.50.xC5W4. This report combines both Windows- and UNIX-specific defect fixes, and is more current than the defect information included in the product release.

NOTE: some detail links below have been disabled as they are not available.


NOTE: some detail links below have been disabled as they are not available.
W3 APARs
Description
IC61163 HPL JOB CREATES UNL FILE WITH INFORMIX GROUP CREDENTIALS.
IC61534 ENGINE DOES NOT RELEASE OPEN TABLES WHEN PDQ IS ENABLED AND AN UPDATE ON A NON-EXISTENT ROW IS PERFORMED.
IC61548 -9791 ROUTINE EXECUTION TRAP ERROR IN IP_EVALEXPR AND IP_EVALSQL
IC61740 MEMORY LEAK IN ER CDRGTX# POOL WHEN LOADING OR DELETING DATA ON A TABLE WITH A LONG ROW SIZE TABLE.
IC61749 OUT OF VIRTUAL SHARED MEMORY MESSAGES FLOOD THE ONLINE.LOG AND RISK FILLING THE DISK SPACE.
IC61787 UNABLE TO CONNECT TO A DATABASE USING DRDA PROTOCOL IF DBPATH IS SET TO ANYTHING OTHER THAN .
IC61833 OUTPUT OF SES-ID IN ONSTAT -G PQS MISSING
IC61872 THE INITIAL RUN OF A QUERY RETURNS THE WRONG RESULTS. SUBSEQUENT RUNS RETURN THE PROPER RESULTS.
IC61903 ALTER TABLE CAUSES CRASH ON SECONDARY HDR SERVER WITH LOG_INDEX_BUILDS ENABLED
IC61977 ASSERT FAILURE IN SQCON_RESTORE_UDR_CONTEXT
IC62005 DRDA: ERROR READING BYTE FIELD WHEN DATABASE NAME HAS MORE THAN 18 CHARACTERS
IC62006 THE OPTIMIZER CHOOSES A MUCH SLOWER PATH FOR SOME SUBQUERIES WHILE THE BETTER PATH IS GIVEN A MUCH HIGHER COST
IC62013 DATA COMPRESSION CAN LEAVE INDICES CORRUPTED IF TABLE HAS OUTSTANDING IN-PLACE ALTERS
IC62014 THE UPGRADE TO 11.50.FC4W1 ON WINDOWS CHANGES SOME ONCONFIG PARAMETERS, INCLUDING SBSPACENAME
IC62025 STORED PROCEDURE FAILS WITH QPLAN SANITY FAILURE ERROR WHEN EXECUTED FROM AN HDR SECONDARY
IC62043 EXECUTING GENXMLQUERYCLOB OR GENXMLQUERY FUNCTIONS MAY CAUSE THE ENGINE TO CRASH OR CORRUPT MEMORY
IC62046 ASSERT FAILURE IN SQOPTIM WITH MULTIPLE LEFT OUTER JOINS CAN OCCUR, RETURNING ERROR -874
IC62119 DRDA: INTERRUPT REQUEST FAILS FOR SESSIONIDS > 65535
IC62146 THE WARNING THAT DUMPDIR HAS INSECURE PERMISSIONS IS WRITTEN TO THE MSG LOG IN A WINDOWS INSTALL AFTER THE CORRECTION WAS MADE
IC62155 CHANGING THE VALUE FOR PHYSFILE IN OCNONFIG DOES NOT CHANGE THE SIZE OF THE PHYSICAL LOG BUT INDICATES IT HAS IN THE ONLINE LO
IC62172 A QUERY MAY RETURN INCORRECT RESULTS WHEN PROCESSED USING A DYNAMIC HASH JOIN
IC62196 ON AN AIX INSTALL INCORRECT RESULTS ARE RETURNED WHEN THE OPTIMIZER CHOOSES THE WRONG INDEX AFTER UPDATE STATISTICS LOW
IC62245 WORKGROUP OR EXPRESS EDITION CAN USE WRONG HYPERTHREADS PER CORE SETTING LEADING TO A WARNING WITH UTILITIES LIKE ONTAPE/ONBAR
IC62273 QUERY USING OUTER, GROUP BY AND DYNAMIC HASH JOIN COULD RETURN WRONG RESULTS DEPENDING ON THE ORDER OF JOIN CLAUSES
IC62321 ASSERTION FAILURE IN INTERSTAGE_HEADER_ADD IS POSSIBLE DUE TO UNALIGNED ACCESS CAUSING A SIGBUS SIGNAL
IC62330 THE CHANGE DATA CAPTURE FUNCTION CDC_STARTCAPTURE IS LIMITING THE TABLE NAME TO 32 CHARACTERS
IC62357 EXECUTING GENXMLQUERYCLOB OR GENXMLQUERY FUNCTIONS MAY GENERATE WRONG RESULTS
IC62415 IDS FAILS IN _OSGETSPNAM() FUNCTION TO GET THE SHADOW PASSWORD
IC62441 AN SDS NODE CAN HANG RESULTING IN THE PRIMARY TIMING OUT THAT NODE AFTER THE SDS_TIMEOUT VALUE IS EXCEEDED
IC62486 USING ISQL TO UNLOAD FROM A VIEW CREATED ON REMOTE TABLES IN IDS VERSION 7.31 WILL CRASH THE SERVER IN ASF_SEND.
IC62505 WHEN A PREPARED SELECT FIRST STATEMENT IS RUN WITH PDQ ENABLED IT PRODUCES INCORRECT RESULTS EVERY OTHER TIME
IC62545 DBSCHEMA CAN GIVE A MISLEADING WARNING THAT A GENERATED STATEMENT MIGHT BE TOO LONG WHEN IN FACT NO LONG STATEMENT IS CREATED
IC62597 DATA LOSS WHEN CREATE CLUSTER INDEX ON NON-LOGGED TABLE IS ROLLED FORWARD DURING FAST RECOVERY
IC62598 DBEXPORT SHOULD WRITE OUT CREATE CLUSTER INDEX BEFORE ALL OTHER CREATE INDEX STATEMENTS
IC62693 NEED TO IMPROVE THE INDEX LOG REPLAY PERFORMANCE ON SECONDARY NODES
IC62695 INDEX TRANSFER RUNS SLOWLY IN SECONDARY SERVER
IC62697 SDS TIMEOUT WITH HEAVY I/O ACTIVITY
IC63189 IDS RETURNS A BAD PLACEHOLDER DESCRIPTION, INTERVAL INSTEAD OF DATETIME, IN CERTAIN CONDITIONS.
IC63191 SYSHA DATABASE FAILS TO BUILD AND RETURNS ERRORS SQLCODE:-330 ISAM:-388 WHEN IDS IS STARTED BY ROOT
IC63193 SEQUENCE NUMBERS MAY GET DUPLICATED WHEN A HDR FAILOVER OCCURS
IC63195 CDR CHECK REPL ON A TABLE WITH REFERENTIAL CONSTRAINTS FAILS WITH ERROR -266
IC63443 UPGRADING 11.50.XC5 TO 11.50.XC5W2 MIGHT TERMINATE THE SERVER OR CORRUPT DATA
W4 APARs
Description
IC56775 ARCHECKER RETURNS CRITICAL ERROR: WRONG TAPE NUMBER 1 != 2 USING A RETORE FILTER
IC57883 WIN64: ONSTAT -J CANNOT DISPLAY STACKS
IC59361 DISTRIBUTED TRANSACTION COORDINATOR IS DBSERVERNAME, SHOULD BE ACTUAL CONNECTION
IC61082 AUTO UPDATE STATISTICS CAUSES SERVER ABEND WHEN EVALUATING A DATABASE WHICH WAS RECREATED IN A DBSPACE OF NON-DEFAULT SIZE
IC61807 ERROR 999 IS RETURNED ON LOCAL DATABASE QUERY
IC61808 UNABLE TO SETUP SSO EVEN THOUGH KERBEROS APPEARS SETUP CORRECTLY.
IC61951 INCORRECT TIME DISPLAYED IN BAR_DEBUG.LOG WHEN ONBAR ENTERS BAR_SIGHDLR
IC61956 DOCUMENTATION FOR ONSTAT -G PQS IS MISSING FROM THE INFORMATION CENTER
IC62017 WHEN ERROR -951 OCCURS ON IDS WINDOWS 2003 DOMAIN INSTANCE THE ERROR MESSAGE PRINTS THE MACHINE NAME INSTEAD OF THE DOMAIN NAME
IC62081 NO ALARM IS RAISED ON RSS AND HDR SECONDARY INSTANCES WHEN STORAGE_FULL_ALARM IS SET AND A DBSPACE IS FILLED.
IC62191 XA_OPEN FAILS WHEN CONNECTING TO AN SDS INSTANCE FROM TUXEDO VIA THE CONNECTION MANAGER
IC62246 RUNNING TWO PARALLEL LEVEL 1 ARCHIVES USING ONBAR AND THE TIVOLI STORAGE MANAGER CAUSES DUPLICATE ENTRIES IN THE IXBAR FILE
IC62250 THE CDR_QDATA_SBSPACE CAN FILL IF THE NIF CONNECTION GETS INTERRUPTED WHILE RECEIVING A LARGE TRANSACTION
IC62424 COMMIT PROCESSING FAILURE IN SMART-LARGE-OBJECT SUBSYSTEM USING XA AND DRDA
IC62462 SPINLOCK AIOSHCB LOCK CAUSES PERFORMANCE PROBLEM IN PDQ SCAN
IC62526 CHANGE OF COLUMN TYPE FROM SMALLINT TO INTEGER RESULT IN ERROR: BAD KEY INFORMATION IN TBLSPACE DESCRIPTION.
IC62548 USING THE WITH VERCOLS WITH ROWIDS CLAUSE CAUSES ASSERT FAILURE
IC62568 ALTER FRAGMENT DETACH MODIFIES THE INDEX DEFINITION OF AN INDEX USING THE SAME EXPRESSION BUT NOT THE SAME STORAGE AS THE TABLE
IC62599 AUTO UPDATE STATS (AUS_EVALUATOR): POTENTIAL 1215 ERROR ON LARGE SYSTEMS.
IC62609 CORRUPT ROW DATA FOR DATETIME VALUES CAN CAUSE MEMORY CORRUPTION
IC62615 INDEX IN SDS IS DISABLED AFTER PG_FRPTR IS SET > SLOTBEG IN ADDITEM AND CAUSES A FAILURE IN BUFFPUT
IC62619 A DROPPED ROW TYPE STILL REFERENCED IN A FUNCTION OR PROCEDURE WILL LEAD TO FAILING CONVERSION
IC62640 WITH STATEMENT CACHE ENABLED A SELECT IN A CASE STATEMENT USING A SUBQUERY IN THE PROJECTION LIST RETURNS -769 ERROR/SEGV ASSERT
IC62734 THE ENGINE CAN CRASH IN MT_FREE_MUTEX IF ONMODE -U IS EXECUTED DURING CDR CATALOG RECOVERY PHASE.
IC62769 AFTER UPGRADING TO 11.50 ENGINE CRASHES IN COMMON_ROUTINE2EXPR WHEN ZOOMING ON A SPATIAL LAYER
IC62770 HDR: LOGICAL RESTORE (ONBAR -B -L) CAUSE PRIMARY TO FAIL
IC62774 DBSCHEMA ABORTS WITH SEGMENTATION VIOLATION WHEN -SL OPTION HAS NO ARGUMENT
IC62787 CRASHES CAUSED BY SIGNALS ON SOLARIS INTEL GENERATE RECURSIVE EXCEPTION. PARTIAL AF FILES AND SERVER EXITING MESSAGES IN LOG
IC62788 ONCHECK ON INDEX REMAINS SILENT ABOUT MISSING DATA ROWS IF -X OPTION IS NOT USED
IC62817 SELECT ON INDEX WITH LIKE, UNDERSCORE AND LEADING OR FILTER RETURNS INCORRECT RESULTS
IC62839 ARCHECKER TLR FAILS TO FIND A TABLE WHEN NON-INFORMIX OWNER IS SPECIFIED IN THE COMMAND FILE (-F)
IC62845 IPLOAD GETTING BUS ERROR IN SETIMAGEPIXELS32 ON HP-UX IA64
IC62899 A SCHEDULED TASK WAS NOT EXECUTED DUE TO A NULL VALUE IN THE TK_TYPE COLUMN
IC62981 PARALLEL ONBAR WHOLE SYSTEM L2 BACKUP GIVES ASSERT FAILED WHEN L0 BACKUP IS MISSING
IC63033 POOR PERFORMANCE FOR BUFFER POOL QUERY IS EXPERIENCED WHEN READ AHEAD IS ENABLED
IC63074 FRACTIONAL RESULTS FROM INT8 ARITHMETIC CAN BE EVALUATED DIFFERENTLY WHEN USING INT8 VERSUS INT
IC63113 RENAMING A TABLE WITH FOREIGN KEY CONSTRAINT MIGHT CRASH THE DATABASE SERVER
IC63136 MIGRATION TO IDS 11 CAN FAIL WITH ERRORS -312/-100 FOR A NON-DEFAULT LOCALE DATABASE WHEN THE INSTANCE HAS BEEN REVERTE
IC63192 MEMORY LEAK OBSERVED IN MT POOL WHEN REPLICATING ROWS
IC63212 PDQ QUERY WITH HASH JOINS AND BUILD OUTER RETURNS WRONG RESULT
IC63281 THE DBSCHEMA -HD COMMAND DOES NOT RETURN DISTRIBUTION INFORMATION OR ERROR MESSAGE ON A TABLE WITHOUT SELECT PRIVILEGES
IC63282 DBSCHEMA SPLITS CREATE TABLE STATEMENTS INTO PARTS WHEN IT IS NOT REQUIRED
IC63322 UDPATE STATISTICS HIGH ON FUNCTIONAL INDEX RESULTS IN ASSERT FAILED
IC63324 SERVER WILL BE CRASHED BY DBWORKER THREAD AFTER LOCK TABLE OVERFLOW, ERROR 271/134
IC63327 SDS CRASHED DUE TO I/O AFTER IT HAD BEEN CONNECTED CAN CAUSE PRIMARY TO HANG IF THE SDS IS BROUGHT UP AGAIN WITHOUT I/O ISS
IC63374 SPINLOCK SHMCB->SH_LOCK CAUSES A DEADLOCK SITUATION ON SOLARIS WHEN ALLOCATING ISM (INTIMATE SHARED MEMORY)
IC63376 A WIN64 MEMORY CONFIGURATION OF GREATER THAN 4GB WITH HDR LEADS TO BAD PAGE MEMORY CORRUPTION
IC63379 NEED TO DOCUMENT THAT THE HDR SECONDARY WILL ALWAYS BE AHEAD OF RSS IN TERMS OF REPLAYING LOGS
IC63442 AN ONBAR BACKUP WILL FAIL WITH SBERRNO=12073 IF A PREVIOUS ONBAR WHOLE SYSTEM BACKUP FAILED.
IC63445 MEMORY LEAK IN RALLOC DUE TO CONCAT FUNCTION
IC63447 IDS INSTALLATION CREATES THE ROOTDBS IN THE DEFAULT C DRIVE ON WINDOWS
IC63448 SELECT FROM SYSSQLTRACE CAN CRASH THE ENGINE.
IC63462 USING ONMODE -C BLOCK FOLLOWED BY ONMODE -H ADDRESS CAN LEAD TO AN IDS DEADLOCK
IC63507 INSERTING A SMART LARGE OBJECT THROUGH A VIEW USING HOST VARIABLE WILL KEEP SQLEXEC THREAD IN RUNNING STATE
IC63663 INTERRUPT ON VI IS NOT HANDLED WELL WHEN VI IS CALLED FROM MENU DBACCESS.
IC63794 SQL QUERY THAT PERFORMS A JOIN CAN ASSERT FAIL AND RETURN A -874 ERROR TO CLIENT
IC63851 MEMORY CORRUPTION CRASH WHILE UPDATING A COLUMN WITH NOT NULL FILTERING CONSTRAINT
IC63873 CREATE INDEX ON A TEMP TABLE REPORTS FAILED TO BUILD DISTRIBUTIONS IN THE ONLINE.LOG ON SDS NODE
IC63875 AF WITH LOG_FLUSHTOLSN: LSN GREATER THAN CURRENT LOG POSITION. NO AF MESSAGES IN ONLINE LOG
IC63943 QUERY WITH SUBQUERY FILTTER UNDER OR CLAUSE RUNS SLOWLY
IC64168 RSS NODES STOP TAKING LOGS UNTIL HDR RESYNCHRONIZES WHEN A HDR PAIR IS IN RECOVERY MODE AFTER RECONNECTING WITH THE PRIMARY
IC64211 #INCLUDE MACHINE.H, SPECIFIED IN HPL CUSTOM DRIVER FILE EXAMPLE INFORMIXDIR/INCL/HPL/PLCSTDRV.H IS MISSING
IC64212 DOC - ONPARAMS SYNTAX DIAGRAM FOR MOVING THE PHYSICAL LOG IS INCORRECT
IC64213 SCHAPI: ERROR -214 AND -106 WHEN AUS EVALUATOR AND REFRESHER START AT THE SAME TIME.
IC64216 IN LOW MEMORY SITUATION, CDR LIST SERVER CAN TAKE A LONG TIME TO RETURN OR SOMETIMES INDEFINITELY
IC64218 ARCHIVE HANGS WITH DBCRON ON MT_SPIN_LOCK_WAIT() AND BLOCKED:ARCHIVE STATUS