Fix list for Informix 12.10.xC1

Informix Server provides periodic fixes for release 12.10 The following list is the most recent report of fixes for customer-reported defects in Version 12.10.xC1. This report combines both Windows- and UNIX-specific defect fixes.


APAR
Description
IC78379 [WINDOWS] USER INFORMIX AND GROUP INFORMIX-ADMIN EXIST AFTER CUSTOM INSTALL SPECIFYING LOCAL SYSTEM ACCOUNT
IC81331 MESSAGE ASSERT WARNING: LOGPUTX(EXTEND_CHUNK) - RSBEGIN() NEVER CALLED SEEN WHEN EXTENDING PHYSICAL LOG CHUNK SIZE
IC83706 CONFUSING NUMBERS IN COLUMN QUEUE IN CDR LIST SERV OUTPUT
IC83955 THREADS STARTED WITH FORK_BE_SESSION END UP WITH RSTCB->TID THAT DOES NOT MATCH TCB->THREAD_ID SO THREAD ID OUTPUT IN ONSTATS DO
IC85171 SYSADMIN:ALERTCLEANUP FUNCTION MUST BE RECREATED DURING MIGRATION/CONVERSION
IC85584 INCONSISTENT BEHAVIOR CASTING BOOLEAN AS CHARACTER FOR RETURN VALUE FROM STORED PROCEDURE - ERROR 9634
IC85636 ONCHECK CANNOT BFGET BUFFER FOR PARTNUM BECAUSE OF NEGATIVE PAGENUM
IC85882 ONSTAT -G DBG CAN STOP WITH CHANGING DATA STRUCTURE FORCED COMMAND TERMINATION.
IC85883 ASSERTION FAILURE IN UNCOMPRESS_ROW() MISSES TO GIVE PRECISE REASON FOR WHY IT HAPPENED
IC86023 IDS FAILS IN MT_AIO_WAIT() WITH CIO AND MULTIPLE CHUNKS IN A SINGLE COOKED FILE
IC86077 LINUX: WHEN USING HUGE MEMORY AND RESIDENT SET TO -1, SERVER IS UNABLE TO ADD V SEGMENTS AFTER THE INITIAL V ALLOCATIONS
IC86112 SELECT NROWS, FROM SYSMASTER:SYSPTNHDR RETURNS A NEGATIVE VALUE
IC86189 REMOTE SUB-QUERY HAS INCORRECT QUERY PATH WITH VERY LOW PERFORMANCE
IC86329 A STORED PROCEDURE IN SOME CASES INSTEAD OF RETURNING ONLY -9791, CAN ASSERT FAIL OR EVEN CRASH
IC86365 RESTORING AN INSTANCE WHEN USERMAPPING IS ON WILL MAKE ENGINE CRASH
IC86369 ONSTAT -G IDXSCAN DOES NOT WORK ANYMORE AND THEREFORE ONSTAT USAGE SHOULD NOT MENTION IT
IC86442 ERROR 768 IN OPEXPRRG WHEN THERE IS AN INDEX ON NCHAR COLUMN AND THERE ARE DIFFERENT LOCALES.
IC86443 SELECT WITH WHERE CLAUSE CONTAINING MATCHES CONDITION WITH MULTIPLE WILDCARDS RETURNS WRONG RESULTS WITH CUSTOMIZED LOCALE
IC86445 A QUERY CALLED FROM JAVA UDR MAY RETURN CORRUPTED VALUES DEPENDING ON PREDICATE ORDER
IC86493 MISLEADING ERROR MESSAGE, UNEXPECTED RSS AUTHENTICATION FAILURE WHEN HA_ALIAS IS NOT SET
IC86500 HDR SECONDARY DOES NOT PING TIMEOUT AFTER PRIMARY LOSES CONNECTION AND TRIES TO RECONNECT TO SECONDARY
IC86784 AN ASSERT FAILURE IN INIT_TERM_PER_VALUE IS POSSIBLE WHEN MULTI INDEX SCAN IS USED
IC86822 OPTIMIZER PREFERS INDEX PATH OVER SKIP SCAN WHICH RESULTS IN LONGER EXECUTION TIME
IC86848 IDS CRASHES ON ROLLBACK OF LONG TRANSACTIONS
IC86933 IPCSTRPOLL THREAD CAN ASSERT FAIL ON RARE OCCASIONS WHEN THERE ARE MULTIPLE IPCSTR OR SOCTCP/TLITCP POLL THREADS
IC86951 USAGE OF MENU DRIVEN TABLE MODIFICATION CHANGED BETWEEN 11.50 AND 11.70 AND HAS PROBLEMS
IC86952 POSSIBILITY OF ERKEY (IFX_ERKEY_2 COLUMN) CORRUPTION
IC86993 CDR CHECK REPLICATESET IFX_INTERNAL_SET RETURNS SQL FAILURE 195 WHEN THERE IS NETWORK DELAY BETWEEN SOURCE AND TARGET
IC87024 ASSERT FAILURE OR CRASH WITH LEFT JOIN SQL WHEN TABLES HAVE MANY INDEXES
IC87060 DBSCHEMA REPORTS WRONG SIZE OF EXTENT AND NEXT SIZE WHEN INDEX IS CREATED WITH EXTENT SIZE OPTION
IC87067 SETTING UP A REPLICATE BETWEEN IDS 10.00 AND 11.70 CAN FAIL WITH DIFFERENT SYMPTOMS
IC87069 MORE MEMORY CONSUMED THAN CONFIGURED WHEN HIGH AMOUNT OF BUFFERS AND VIRTSIZE
IC87248 EXECUTING ONMODE -L WHILE RUNNING ONTAPE -A CAUSES CORRUPTED LOGICAL LOG FILE
IC87250 WRONG RESULTS FOR SQL WITH MULTIPLE COUNT(DISTINCT) POSSIBLE WHEN QUERY RUNS WITH PDQ AND MANY CPU VPS CONFIGURED
IC87252 SQL -604 AND ISAM -164 ON DELETE FROM TABLE WITH LIST FIELD
IC87257 CDR DEFINE SERVER RETURNS ERROR 123 DURING INTERNAL REPLICATE DEFINE FOR GLOBAL CATALOG SYNC IN A MULTI NODE CLUSTER
IC87310 INDEX ON CDR_DELTAB_* IS CREATED WITH EXTENT AND NEXT SIZE WHEN BASE TABLE HAS AN INDEX (PRIMARY KEY) DEFINED WITH EXTENT AND NEXT SIZE
IC87311 SERVER CAN CRASH IN LDDBLNULL() INSTEAD OF REPORTING ERROR 321 OR 595 IF AN AGGREGATED COLUMN IS USED IN A JOIN WITH GROUP BY
IC87341 IFXCLONE FAILS WITH ERROR SMX FAILED TO CREATE PIPES FOR CLONE RESTORE ON SOLARIS WHEN PROTOCOL/INTERFACE IS SET TO TLITCP
IC87375 BTSCANNER THREAD CAN ASSERT FAIL WHEN BUFFER MODIFIED IN INCONSISTENT CHUNK WHEN CLEANING EN_US.UTF8 NVARCHAR INDEX
IC87399 CDR CHECK REPL --TIMESTAMP WITH REPLCHECK DEFINED SELECTS ALL THE COLUMNS MOST OF TIME THAN INDEX DEFINED ON IFX_REPLCHECK
IC87401 NO DATA PAGE READAHEAD OCCURS WHEN AUTO_READAHEAD IS 0 (OFF) AND RA_PAGES IS PRESENT AND SET
IC87444 INFORMIX USER/GROUP CREATION ERROR DURING INSTALLATION WITH ROLE SEPARATION
IC87489 SYSCDR:REPLCHECK_STAT.REPLCHECK_STATUS IS NOT SHOWING THE CORRECT STATUS FOR REPLICATES THAT FAILED REPAIR
IC87490 ASSERT FAILURE DUE TO MEMORY CORRUPTION DOES NOT PROPERLY SET RESULTS: STRING IN ASSERT FAILURE MESSAGE
IC87587 WITH BATCHEDREAD_INDEX ENABLED, A QUERY THAT FILTERS ON A DECIMAL INDEX WILL RETURN NO ROWS
IC87589 SERVER CAN ABEND WHEN DOING SELECTS FROM SYSCDRSEND_BUF WHILE PUTTING LOTS OF LOAD ON THIS TABLE
IC87681 SERVER TERMINATES UNEXPECTEDLY WHEN EXECUTING A QUERY WITH SUBQUERY AND STATEMENT CACHE IS ON
IC87771 DROP SPECIFIC FUNCTION IF EXISTS SPECIFIC_NAME; FAILS WITH 201: SYNTAX ERROR
IC87802 HOW TO DETERMINE HOW MANY TEMPORARY DBSPACES REQUIRED?
IC87805 PREPARED STATEMENT CAN CAUSE HUGE ALLOCATION OF RALLOC MEMORY WHEN CALLED REPEATEDLY WITH DIFFERENT TYPES OF HOST VARIABLES
IC87814 BTS OUT OF MEMORY ERROR POSSIBLE AND CAUSING A MEMORY CORRUPTION WHEN OCCURRING
IC88153 THE EXAMPLE GIVEN TO CREATE A COMPOSITE BTS INDEX SHOWS THE INCORRECT KEYWORD DEFAULT_QUERY_FIELD
IC88157 BTS QUERY FINDS NO ROWS WITH WILDCARD
IC88170 AUTO_CRSD() SHRINK THRESHOLD DOES NOT CONSIDER EMPTY TABLES
IC88171 EMPTY LIST TYPE COLLECTION IN EXPLICIT CASTING CAUSES ASSERT FAILED
IC88172 ALTER TABLE MODIFY DOES NOT MODIFY THE COLUMN WHEN THERE ARE FRAGMENT LEVEL STATISTICS FOR THIS COLUMN
IC88201 AFTER ALL THE MEMBERS IN CLUSTER HAVE BEEN RESTARTED EXCEPT CM, ONSTAT -G CMSM DOES NOT DISPLAY A STATUS OF FAILOVER ARBITRATOR
IC88202 CM DOES NOT IDENTIFY THE TYPE OF SECONDARY INSTANCE IF THE INSTANCE WAS BROUGHT UP BEFORE THE PRIMARY
IC88203 CONNECTION MANAGER DOES NOT NOTICE THAT RSS IS BACK ONLINE IF IT WAS RESTARTED TWO TIMES IN A ROW
IC88219 FAST RECOVERY CAN FAIL WITH TRANSACTION STILL OPEN BECAUSE OF COMITTED TRANSACTION IN CHECKPOINT RECORD
IC88260 PROBLEM WITH DBACCESS AND ALTER TABLES HANDLING
IC88265 TIMESTAMP BASED REPAIR (CDR CHECK REPLSET --TIMESTAMP --REPAIR), REPAIRS DATA INCORRECTLY
IC88289 DBIMPORT FAILS WITH -201 SYNTAX ERROR FOR DATABASES WITH UTF8 AND SQL_LOGICAL_CHAR AND DATABLADES REGISTERED
IC88393 FUNCTION NEXT_PAGE_CALLBACK() MAKES A CALL TO MACRO DREQUIRE WITH THE REQUEST TO EV_AFCRASH, BUT END MARCO REGARDLESS CALLS AFWARN_INTERFACE
IC88543 ASSERTION FAILURE POSSIBLE IN SETCDRALTMODE() WHEN UNIQUE CONSTRAINT IS DROPPED ON A REPLICATED TABLE WHILE ER IS STOPPED
IC88586 ONPLOAD THROWS ASSERT FAILURE ON WINDOWS-7 64-BIT
IC88590 MESSAGES: ERROR IFKNOWNCREATE() LOOKUP FAILED, NAME IS EMPTY. IN THE ONLINE LOG FILE.
IC88699 RUNNING A CORRELATED NESTED QUERY GENERATES AF WITH MEMORY BLOCK HEADER CORRUPTION DETECTED IN MT_SHM_MALLOC_SEGID 6
IC88746 INSERT ON UPDATABLE RSS WITH XA TRANSACTION ALLOWS DUPLICATES IN COLUMN WITH A PRIMARY KEY OR A UNIQUE CONSTRAINT
IC88810 DBIMPORT DOES NOT DETECT INVALID SYNTAX IN CREATE PROCEDURE STATEMENT LEADING TO UNEXPECTED INCOMPLETE DATABASE IMPORT
IC88812 DBSCHEMA STORAGE SPACE STATEMENT OUTPUT ORDER CAN BE WRONG
IC88911 IF VIEW BASED ON REMOTE TABLE IS QUERIED WITH REVOKED SELECT PRIVILEGE THEN THE QUERY TO VIEW WILL ALWAYS BE GIVING ERROR -583
IC88998 AUTO READAHEAD IS NOT PERFORMING INDEX-DATA READ AHEAD WITH OLD-STYLE ATTACHED INDEXES WHICH CAN LEAD TO A PERFORMANCE PROBLEM
IC88999 ASSERT FAILURE WHEN EXECUTE FUNCTION ADMIN (CREATE GLFILES) IS RUN
IC89002 PRIMARY OR SOURCE SERVER CAN ASSERT FAIL WHILE DECRYPTING DATA USING IBM GLOBAL SECURITY KIT (GSKIT)
IC89125 QUERY USING SEQUENTIAL SCAN ON A TABLE WITH VARCHAR GIVES TRUNCATED STRING BUT USING INDEX GIVES CORRECT STRING
IC89310 ASSERT FAIL, CRASH OR SESSION HANG POSSIBLE FOLLOWING LONG TRANSACTION ROLLBACK INVOLVING REMOTE SERVER
IC89479 COUNT (*) VS ACTUAL SELECT * RETURNS DIFFERENT RESULTS
IC89618 DBSCHEDULER AND WORKER THREADS FAIL TO START WHEN SYSADMIN IS MOVED TO ITS OWN DBSPACE USING TASK(RESET SYSADMIN) FUNCTION