Fix list for Informix Server 12.10.xC3 and PID 12.10.xC3W1

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


W1 APARs
Description
IC97673 12.10.XC2 ON SOLARIS NOT GENERATING .RAWSTK FILES FOR ASSERTION FAILURES
IC98613 DROP AND CREATE OF A SEQUENCE CAN CAUSE A PREPARE STATEMENT TO SEGV
IC98730 ERROR 79784 LOCALE NOT SUPPORTED WHEN LOADING A JAR WITH PL_PL.PC-LATIN-2 LOCALE
IC98836 WHEN A TRUNCATE TABLE FAILS ON A REPLICATED TABLE THE ALTER MODE ON THE TABLE IS NOT UNSET
IC98870 AFTER A RESOLVED NETWORK PROBLEM SESSIONS ON THE SDS WILL RECEIVE ERROR MESSAGE 7351
IC98895 TIMESERIES VTI SCANCOST FUNCTION IS FIXED AND MAKES NO REFERENCE TO THE PASSED IN QUALIFIER TO DETERMINE THE REAL COST
IC99131 RUNNING A MERGE ... WITH DELETE CLAUSE TWICE CAN CAUSE A INVALID MUTEX IN CHK_MRG_DISTTAB
IC99444 TRANSPOSE() OF A TIMESERIES RETURNED FROM A SP COULD FAIL WITH INSUFFICIENT MEMORY OR 9791: (DEEPCOPY) EXECUTION FAILED
IC99688 WHEN USING MULTIPLE BUFFERPOOL AND RESIDENT=1 AND HUGE PAGES ON LINUX, WE DO NOT CALCULATE A SHMAT ADDRESS ALIGNED ON HUGE PAGE
IC99711 A SESSION WHICH DOES A LOAD FROM EXTERNAL TABLE VIA PIPE CANNOT BE KILLED WITH ONMODE -Z
IC99822 WITH LASTCOMMITTED SET TO COMMITTED READ IT IS POSSIBLE TO ACCESS A DATABASE LOCKED IN EXCLUSIVE MODE BY ANOTHER SESSION
IC99824 UNHANDLED -9791 ERROR LEAD TO AN ENGINE CRASH
IC99836 DYNAMIC LOG ADDITION WOULD HANG IF DBSPACE EXPANSION REQUIRED
IC99837 FMTAB CAN OVERFLOW (ERROR -104) WHEN TEMPORARY TABLES ARE CREATED IN STORED PROCEDURES WITHIN GLOBAL TRANSACTIONS
IC99893 ONSTAT(S) HEADER SHOWING ERRONEOUS INSTANCE SIZE
IT00291 PROMOTING AN SDS TO A PRIMARY SERVER REPORTS A PANIC ON THE PRIMARY INSTEAD OF A PROPER SHUTDOWN
IT00329 AUTHENTICATION OF MAPPED USER ON SECONDARY SERVER FAILS WITH ERROR -951
xC3 APARs
Description
IC92003 ONSMSYNC CRASHES WHEN NO ARGUMENT IS PASSED TO -CF OPTION
IC92378 TAKES EXTREMELY LONG TIME TO EXECUTE AN ANSI JOIN WHICH IS RUNNING WELL IN 11.70FC5
IC94194 TIMESERIES: UDR USING THE CLIP() FUNCTION ON A BIG TIMESERIE FAILS WITH (UTSCB) - INSUFFICIENT MEMORY, BYTES REQUESTED
IC94293 WHEN EXECUTING JAVA UDR WITH DB_LOCALE=EN_US.UTF8, (79784) - LOCALE NOT SUPPORTED RETURNED.
IC94740 LOGICAL LOGS ON HDR SECONDARY CAN LOSE BACKED UP FLAG LEADING TO PING TIMEOUTS AND INABILITY FOR SERVERS TO RECONNECT AND RESYNC
IC94858 POSSIBLE DATA CORRUPTION WHEN USING ONRESTOREPT AFTER AN ATTEMPTED CONVERSION WITH CONVERSION_GUARD SET TO 2
IC94930 CURSOR POSITION IS INCORRECT IN DBACCESS UNDER ALTER TABLE MENU AFTER PRESS SCREEN
IC94931 INITIAL SYNC FAILS IF REPLICATE IS CREATED FOR TABLE WITH COMPOSITE UNIQUE INDEX AND -U OPTION IS USED
IC95092 MIRRORPATH USAGE MUST BE DOCUMENTED CLEARLY FOR A SITUATION WHEN MIRRORING IS TURNED OFF AND ON AGAIN
IC95265 UPGRADE TO 12.10 FAILS WITH SANE_CHOPEN:CHECSUM 0XD0C1 != CHECKSUM 0XD0E1
IC95634 SERVER CAN CRASH IN LDDBLNULL() IF A SUB-QUERY REFERENCES, IN AN AGGREGATE, A COLUMN FROM THE MAIN QUERY
IC95780 ALERTCLEANUP FUNCTION SHOULD EXECUTE DELETE STATEMENTS IN MULTIPLE SMALL TRANSACTIONS TO AVOID LONG TX TO OCCUR
IC95783 THE APPLY FUNCTION CALLED FROM STORED PROCEDURE FOR 2 TIMESERIES CREATED BY CLIP() FUNCTION CAN FAIL WITH -9791 OR RETURN INCORR
IC95784 THE AGGREGATERANGE() FUNCTION FAILS WITH (UTSEW) - TOO MANY EXPRESSIONS IN THE AGGREGATION LIST ON EVERY SECOND CALL
IC95787 SQL EXPRESSIONS PASSED TO APPLY() FUNCTION DO NOT SUPPORT THE SIMPLE ARITHMETIC EXPRESSIONS NOR THE CONSTANTS
IC95968 NON-ROOT(PRIVATE) INSTALLED SERVER IS NOT WRITING SHARED MEMORY DUMP WHEN ASSERT FAIL OCCURS
IC95990 DIFFERENT QUERY PLAN AND QUERY RESULT FOR A QUERY ON 11.70.XC7 AND 12.10.XC1 AND HIGHER
IC96158 AFS POSSIBLE IN RETRIEVE_CACHE(), UDR_GETBYID_UID() OR UDRLM_UNLOAD_ROUTINE() WHEN CACHE UNDER STRESS
IC96717 QUERIES WITH ANSI JOINS RUN SIGNIFICANTLY SLOWER IN 12.10 THAN IN 11.70
IC96719 ONSMSYNC FAILS TO EXPIRE A BACKUP AFTER THE BACKUP IS TAKEN AND RESTORED
IC96795 POOR PERFORMANCE FROM A QUERY THAT INVOLVES VIEWS AND CORRELATED SUBQUERIES
IC96918 NEGATIVE VALUES POSSIBLE FOR REFERENCE COUNT IN RESOLVED ROUTINE CACHE
IC97027 WRONG RESULTS POSSIBLE WHEN ANSI HASH JOIN PATH IS USED
IC97105 EDITION RELEASE NOTES SHOULD INCLUDE DESCRIPTIONS OF PRODUCT RESTRICTIONS
IC97110 A SIMPLE QUERY FROM A BIG TIMESERIES (9 MILLIONS OF ELEMENTS) CAN CONSUME GIGABYTES OF MEMORY IN RTN.. POOL
IC97113 ERROR MESSAGE READING CHMOD WHEN USING IFXDEPLOY ON WINDOWS
IC97164 PREPARED STATEMENT OF TABLE WITH BLOB COLUMNS CAN FAIL WITH ERROR -710 EVEN WITH AUTO_REPREPARE ENABLED
IC97253 CREATION OF IBM INFORMIX DYNAMIC SERVER SETUP IMAGE WITH USER INITIATED RPM BUILD FAILS WITH MISSING FILE ERRORS
IC97294 WHEN SELECTING CREATING AN INSTANCE DURING CUSTOM INSTALLATION ON WINDOWS, THE SERVICES ARE NOT CREATED
IC97295 TIMESERIES CLIP FUNCTION FAILS WITH CERTAIN FLAGS
IC97367 ONSMSYNC -I FAILS WITH COMPRESSION OR GZIP FROM PRIMARY STORAGE MANAGER (PSM)
IC97370 BUILT-IN FUNCTIONS LEAST() AND GREATEST() CONSUME A LOT OF RALLOC MEMORY
IC97426 SELECT * FROM TABLE ORDER BY MIN/MAX(COLUMN) CRASHES ENGINE
IC97429 SQLEXEC THREADS HANG ON CPU VP CONSUMING HIGH CPU TIME PREVENTING OTHER THREADS FROM RUNNING
IC97431 USING THE ON EXCEPTION IN SPL CAUSES THE SPL TO LOSE THE ABILITY TO RETURN MEANINGFUL TIMESERIES ERRORS ONLY GET 937 ERROR
IC97557 TRUNCATE OF THE CALENDARTABLE WITH ENTRIES IN USE RUNS WITHOUT ANY ERROR
IC97562 SIZE OF DATABASE SHARED MEMORY IS DISPLAYED INCORRECTLY IN ONSTAT - HEADER OUTPUT.
IC97674 AFTER USING ONMODE -P START TO DYNAMICALLY START A NEW LISTEN THREAD, UNABLE TO CONNECT TO THE NEW DBSERVERALIAS
IC97685 MEMORY LEAK OCCURS WHEN TRYING TO LOAD AN EXTERNAL TABLE FROM A TABLE WITH EXTENDED TYPE
IC97853 ONBAR BACKUP CAN FAIL WITH ERROR -132 IN VERSION 12.10.XC2
IC97898 AUTOMATIC LOGICAL LOG BACKUP FAILS BECAUSE WE ALLOW ENGINE TO START IF INFORMIXSERVER IS INCORRECTLY SET
IC97910 CAF - NUMBER OF NODES INTERNAL COUNTER DOES NOT GET CORRECTLY UPDATED
IC97923 SYSMASTER QUERY USING TABLES SYSPAGHDR, SYSBUFHDR, SYSTABNAMES, SYSPTNHDR CRASHES SERVER IN PRBUFHDR() WITH AF
IC97992 SELECT USING MULTI INDEX SCAN FAILS WITH ASSERT FAILED: NODE->POS == NODE->KID[0].POS
IC97997 IFXDEPLOY FAILS WITH ERROR FAILED DEPLOYING USER AND GROUP WHEN BEING RUN ON A MEMBER SERVER IN A DOMAIN
IC98187 PROBLEM WITH DBMONEY AND EXTERNAL TABLES
IC98188 INCORRECTLY BUILT VIEW ON TABLE WITH TIMESERIES DATA FIELD
IC98190 CORE DUMP OF DBACCESS IN INTERACTIVE MODE WHEN TRYING TO CREATE AN EXISTING MART AGAIN
IC98191 DWA: OFFLOAD OF QUERY INCLUDING CASE EXPRESSION WITH GROUP BY CAN FAIL WITH ERROR -26402
IC98192 DWA: OFFLOADING OF QUERY WITH UNARY MINUS BEFORE AGGREGATE FUNCTION FAILS WITH ERROR -26402
IC98193 TIMESERIES RELATED UDRS ALLOCATE A LOT OF MEMORY WHEN CALLED REPEATEDLY FROM CURSOR
IC98267 SELECT MAX() CHOOSES QUERY PLAN WITH LOWER ESTIMATED COSTS, BUT LONGER RUN TIME
IC98299 LOCK MODE WAIT IS BROKEN IN LAST COMMITTED ISOLATION IN 12.10.XC2
IC98302 ASSERT FAILED IN TS_GET_AM_PTR() WHEN SERVER RUNS OUT OF MEMORY
IC98303 30% MORE VIRTUAL SHARED MEMORY CONSUMPTION WITH 12.10
IC98308 NO DOCUMENTATION FOUND ON NON-ROOT(PRIVATE) INSTALL FOR THIS PARTICULAR SCENARIO
IC98327 -202 GENERATED WHEN INSERT, DELETE AND SELECT OF UTF8 CHARACTERS IN A STRESSED ENVIRONMENT
IC98370 DWA: QUERY WITH UNION ALL AND SELECT FROM A REMOTE TABLE ACCESS MAY GET WRONG RESULTS
IC98404 DWA: UNEXPECTED TERMINATION OF DWA_CM WITH SEGMENTATION VIOLATION IN MEMSET CALLED BY CONCATENATEFKE()
IC98459 INSERT INTO VIRTUAL TABLE USING TIMESERIES CAUSES 12803 ERROR
IC98614 IWA QUERY MATCHING CAN FAIL IF THE SAME FACT TABLE COLUMN IS JOINED WITH TWO DIFFERENT DIMENSION TABLES
IC98663 SELECT USING INDEX DOES NOT RETURN ROWS BASED ON ORDER OF THE INDEX
IC98732 ONSTAT -G MEM TRUNCATES MEMORY POOL NAMES IF SESSION ID/THREAD ID IS HIGH
IC98735 HIGH NUMBER OF ALLOCATED SHARED MEMORY SEGMENTS CAN LEAD TO TWO INSTANCES WRITING INTO THE SAME CHUNKS
IC98753 WITH SILENT INSTALL, THE SETTING OF INFORMIXDIR WILL OVERWRITE ANY ATTEMPTS TO DEFINE THE INSTALLATION DIR VIA USER_INSTALL_DIR
IC98778 VIRTUAL SEGMENTS MARKED AS RESIDENT EVEN IF RESIDENT IS SET TO 1
IC98810 RUNNING A PROCEDURE WITH QUERY WITH SUB-QUERY AND VIEW ON TABLE FROM ANOTHER DATABASE GIVES ERROR -5849 OR 640 WITH NO_SUBQF SET
IC98837 SUBQUERIES OPERATING ON GENERATED MULTISETS WITH SUBSTR AND REPLACE BUILTIN UDRS CAN FAIL IN NUMEROUS FASHIONS
IC98869 ONMODE -F (FREE UNUSED MEMORY SEGMENTS) CAN CRASH SERVER IN RSFREEBLK()
IC98946 MISLEADING MESSAGE IN ONLINE.LOG DURING CONVERSION FROM 11.50 TO 12.10: VPCLASS/BUFFERPOOL VALUE IS MODIFIED
IC98947 JAVA/JDBC PROGRAM EXECUTING SPL WHICH TAKES A SET ARGUMENT ASSERT FAILS (SIGSEGV) IN UDRLM_EXEC_ROUTINE()
IC99010 ENTERPRISE REPLICATION TARGET APPLY THREADS CAN HANG IN DEFERRED CONSTRAINT CHECKING
IC99057 RUNNING A QUERY ON A TIMESERIES VTI TABLE WITH PDQ FAILS WITH INTERNAL ERROR: TSVTAM.C AND -23197 WHEN DB_LOCALE IS NOT DEFAULT
IC99091 ERROR 1277: INPUT DOES NOT MATCH FORMAT SPECIFICATION, USING DATETIME FORMAT
IC99133 INTERNAL ERROR -768 HAPPENS IF YOU RUN SELECT STATEMENT WITH SEVERAL AND AND OR FILTERS AND USING A MULTI-INDEX SCAN
IC99152 USING COMMITTED READ LAST COMMITTED ISOLATION LEVEL AND BATCHEDREAD_TABLE CAN RESULT IN INCORRECT LOCKING ERRORS, LIKE ISAM 113
IC99187 ONBAR RESTORE AND BACKUP VERIFICATION FAILED WHEN A DBSPACE BACK IS SPLIT ACROSS MULTIPLE DEVICES
IC99247 CDR SYNC REPLICATE CRASHES IF FOREIGN KEY REFERRING TO THE SAME TABLE
IC99303 SELECT FROM A TABLE WITH TEXT COLUMN USING DB2 .NET PROVIDER (DRDA) LEADS TO ASSERT FAILURE
IC99523 NO LOCKS ARE SET ON TABLE IF BATCHEDREAD_INDEX IS SET TO 1 AND SELECT FOR UPDATE
IC99524 INFORMIX SOFTWARE BUNDLE PRODUCT INSTALLATION REPORTING ERROR ABOUT MISSING SOFTWARE TAG (SWTAG) FILE
IP23682 CONNECTION MANAGER GETS -27001 ERROR WITH ONSOCSSL DBSERVERALIAS SERVICE NAME