Product Documentation
Abstract
Informix Server provides periodic fixes for release12.10. The following list is the most recent report of fixes for customer-reported defects in Version 12.10.xC6. This report combines both Windows- and UNIX-specific defect fixes, and is more current than the defect information included in the product release.
Content
| Fix release date: 24 Nov 2015 Last modified: 11 Dec 2015 Status: Recommended  Download information | |
APAR | Description |
| IC81342 | FUNCTION SE_DISSOLVE MIGHT RETURN (USE06) - UNKNOWN ESRI SHAPE LIBRARY ERROR (-2000) |
| IC99525 | DEBUG FILE FOR MAPPED USER IS NOT PRE-PENDED WITH THE USERNAME |
| IP23880 | REMOTE INSERT HAVING SUB-SELECT WITH TODAY, CURRENT HOUR TO SECOND ON REMOTE SERVER CRASHES THE REMOTE SERVER |
| IT01645 | GSKIT README FILE BUNDLED WITH 12.10 INSTALLERS ON LINUX LISTS THE GSKIT VERSION AS 7.0.4.X WHEN IT SHOULD BE 8.0.13.3 OR HIGHER |
| IT03175 | GENBSON EXCEPTIONS WITH NON-UTF8 CODE SETS |
| IT04793 | ERROR -208 RUNNING A UNION SELECT QUERY WITH ORDERED DIRECTIVE AND PDQ ON |
| IT05306 | PERFORMANCE OF A STORED PROCEDURE PROGRESSIVELY DECREASES WHEN RUN MANY TIMES, CAUSING A MEMORY LEAK IN RALLOC SESSION MEMORY |
| IT05468 | LINUX: ONSNMP DAEMON UTILIZES 100% CPU AFTER RUNNING SNMPWALK FOR THE SERVER MACHINE |
| IT05876 | CLONECALCULATELLOGPAGEDIFF() INVALID PARAMETERS APPEARING IN ONLINE.LOG |
| IT06589 | MIGRATION FROM 12.10.FC3 TO 12.10.FC4W1 COULD LEAD TO -9793 USER DEFINED ROUTINE (UPDATE) MODULE LOAD FAILED |
| IT06675 | STMT_CACHE_HITS VALUE CANNOT BE DECREASED WITH ONMODE -WF |
| IT06838 | ASSERTING THREAD BRINGING DOWN INSTANCE CAN HANG ON SPIN LOCK TRYING TO ALLOCATE MEMORY FROM GLOBAL POOL |
| IT06891 | COMPLEX QUERY WITH COUNT(DISTINCT ..) AND GROUP BY GENERATES A LOT OF TEMP TABLES/EXTENTS AND RETURNS -229 |
| IT06938 | ASSERT WARNING LOGPUTX(UNIQ8ID) RSBEGIN() NEVER CALLED IS POSSIBLE USING SEQUENCE |
| IT06992 | LEAF NODE HANGS IN NIFBLOCKNIFSENDTHREADS() RESULTING IN QUEUE BUILD UP |
| IT07079 | UPDATE STATISTICS LOW CAN FAIL TO UPDATE SYSINDICES WITH STATISTICS WHEN INDEX WAS DISABLED AND AUTO STAT MODE IS ACTIVE |
| IT07216 | MI_GET_RESULTS() RETURNS MI_DDL NOT MI_DML WHEN EXECUTING UPDATE STATISTICS |
| IT07336 | TRUNCATE TABLE WHILE CLIENTS CONTINUALLY INSERT CAN CAUSE ASSERTION FAILURE |
| IT07389 | USING XTRACE -C XTF_LC -F XTF_DEBUG CAN CAUSE A READ AHEAD THREAD TO ASSERT FAILURE SEGV IN RA_DO_LC_REQ() |
| IT07390 | ASSERTION FAILURE POSSIBLE WHEN ATTEMPTING A DEFRAGMENT OPERATION ON PARTITION NUMBER |
| IT07470 | DYNAMIC_LOGS CAN CREATE LOG. LOG GREATER THAN 1048575 PAGES LEADING TO LOGPOS OVERFLOW |
| IT07492 | CANNOT ADD CPU VPS IN WORKGROUP EDITION IF VPCLASS PARAMETER IS MISSING IN ONCONFIG |
| IT07503 | Q-EXCEED SHOWS NEGATIVE VALUES IN ONSTAT -G NTM, -G NTU AND -G NTA |
| IT07528 | CAST TO JSON HAS A PROBLEM WITH DATE OR DATETIME VALUES LOWER THAN 01/01/1970 |
| IT07598 | ASSERT FAILED OF MEMORY THREAD IN MT_PURGE_CPU_VP_CACHES |
| IT07599 | DR_PRPING THREAD MAY BECOME STUCK IN RUNNING STATE FOLLOWING HDR CONNECTION FAILURE |
| IT07600 | -1213 ERRORS RUNNING LOW MEMORY RECONFIG TASK |
| IT07644 | IWA: IDS CRASH DURING QUERY MATCHING IN FUNCTION DWA_MAPEXPR(). |
| IT07678 | CDC CAUSES AF SNOOPING ROWS ON A NEW FRAGMENT |
| IT07694 | ASSERT FAILURE AND CRASH ON A QUERY UTILIZING VIEW MATERIALIZATION IF IFX_FOLDVIEW IS ENABLED |
| IT07777 | ASSERT FAILED OF REPACK THREAD IN COMPRESS_INDEX() |
| IT07788 | MEMORY LEAK IN RALLOC (SQCACHE ALLOCATIONS) RUNNING A QUERY WITH A BSON FUNCTION |
| IT07789 | IWA: SELECT CAN MISS RESULT ROWS FROM DATA MARTS WITH A N:M CARDINALITY REFERENCE |
| IT07804 | SETTING IFX_FOLDVIEW TO 1 RETURNS WRONG RESULTS FOR SELECT COUNT(DISTINCT) |
| IT07833 | IWA: CUSTOMER NEEDS TO IDENTIFY WHICH QUERY IS CURRENTLY OFF-LOADED AND PROCESSED BY IWA |
| IT07901 | BSON_UPDATE() $SET OPERATOR NOT BEHAVING AS IT SHOULD |
| IT07918 | USING DRDA PROTOCOL A SELECT INVOLVING INTERVAL TYPE CAN SOMETIMES CORRUPT LARGE AMOUNTS OF MEMORY DUE TO UNEXPECTED DATA |
| IT07980 | TEMP TABLE ALLOWS NULL VALUE IN SERIAL COLUMN OF A TEMP TABLE IN 11.70 BUT NOT 12.10 |
| IT07982 | SQL COMMAND CAN TERMINATE WITH SQL ERROR -242 AND ISAM ERROR -104 WHEN VIOLATIONS AND DIAGNOSTICS TABLES ARE USED |
| IT08009 | ONTAPE BACKUP TO REMOTE DEVICE FAILS WITH COMBINATION OF REMOTE TAPEDEV AND TAPESIZE 0 IS NOT ALLOWED ALTHOUGH TAPESIZE IS NOT |
| IT08049 | IT IS NOT DOCUMENTED THAT IPLOAD AND ONPERF REQUIRE INFORMIXBROWSER ENVIRONMENT VARIABLE SET IN ORDER TO VIEW THE HELP TOPICS |
| IT08052 | SECOND REMOTE SELECT IN A SESSION TO A DIFFERENT SERVERNAME FAILS WITH ERROR -908 -27001 |
| IT08121 | INSUFFICIENT SPACE IN TEMPORARY DBSPACES MESSAGE IN ONLINELOG ALTHOUGH ENOUGH SPACE IS AVAILABLE FOR TEMP TABLES |
| IT08122 | ERROR 9791 EXECUTING A STORED PROCEDURE USING A BSON FUNCTIONAL INDEX |
| IT08183 | TURNING ON THE AUDITING LEVEL 1 ADDS AN UNNECESSARY DELAY TO ONSTAT & ONMODE COMMANDS |
| IT08204 | INTENSIVE ONSTAT + ONMODE COMMANDS CORRUPTING SHARED MEMORY |
| IT08226 | DRDA RETURNS A SERIAL AS A NOT NULLABLE INTEGER IN A COMPLEX TABLE JOIN |
| IT08259 | DBSCHEMA ABORTS WHEN IWA EXTERNAL TABLE EXISTS |
| IT08270 | ERROR PRIMARY KEY ALREADY EXISTS WHEN TS_SETNEWTS() IS USED TO CREATE NEW TIMESERIES FOR NEW PRIMARY KEYS |
| IT08275 | WHEN INSTALLING ONLY A BASE SERVER WITHOUT JSON, SOME SQL FILES ARE NOT CREATED |
| IT08316 | QUERY RETURNS WRONG RESULTS IF STATEMENT CACHE IS ENABLED AND QUERY CONTAINS SUBSTR FUNCTION AND GROUP BY |
| IT08390 | SERVER CRASHES USING ER, REFERENTIAL CONSTRAINTS, AND UPDATE STATISTICS |
| IT08395 | SERVICE INSTANCE MANAGER NOT WORKING AS EXPECTED DURING CUSTOM WINDOWS INSTALL |
| IT08429 | SELECT WITH CASE EXPRESSION AND OLAP RATIO_TO_REPORT FUNCTION CAUSES STACK OVERFLOW |
| IT08441 | LOCKING TEMPORARY TABLE CAUSES HDR PRIMARY TO CRASH |
| IT08448 | COGNOS QUERY THAT RAN IN SECONDS ON IDS 11.50 EATS A TON OF VIRTUAL MEMORY AND NEVER RETURNS IN IDS 12.10 |
| IT08467 | SEGV POSSIBLE IN DBS_TOTAL_SPACE WHEN CREATING OBJECT USING AUTOLOCATE FEATURE WHILE CONCURRENTLY ADDING A DBSPACE |
| IT08569 | DBSCHEMA -SS -SI NOT REMOVING IN CLAUSE OF INDEXES |
| IT08572 | DYNAMICALLY MODIFYING AUTO_TUNE AFFECTS THE SETTINGS OF OTHER AUTO_* CONFIG PARAMS, EVEN IF THEY WERE EXPLICITLY SET IN THE CONF |
| IT08621 | READAHEAD THREAD CAN RUN CONTINOUSLY BLOCKING A CPU VP HEREBY AND RESULTING IN HANG OF THE INSTANCE |
| IT08631 | INSERT WITH SUBQUERY GETS ZERO ROWS IF EXECUTED FROM AN UPDATABLE SECONDARY |
| IT08674 | UPGRADING IDS 11.50.FC3 TO 12.10.FC5WE ASSERT FAIL CONV/REV AFTER CALLING SCHAPI_CVR1210_CONVER |
| IT08724 | RECURSIVE EXCEPTION SELECTING ON A TIMESERIES VTI WITH TIMESERIES WHICH ARE MIGRATED FROM AN OLDER VERSION |
| IT08810 | NEED DOCUMENTATION THAT STATES THE SUPPORTED WAY OF CREATING BSON INDEXES |
| IT08866 | DBIMPORT OF A DATABASE WITH A BLADE WITH SQL_LOGICAL_CHAR=ON AND DB_LOCALE=EN_US.UTF8 FAILS |
| IT08868 | AFTER UPGRADE FROM IDS 10.00.FC10 TO 12.10.FC5 THE BUILD_SMI FAILS IN CONVERT THREAD |
| IT08890 | LOCK TABLE IN EXCLUSIVE MODE FOR TABLE IN UNLOGGED DATABASE ON PRIMARY SERVER CAN LEAD TO ASSERT WARNING RSBEGIN() NEVER CALLED |
| IT08892 | AFTER RENAMING A DATABASE AN ALTER TABLE FAILS WITH -597 OR -252 |
| IT08980 | ARCHIVE ALREADY ACTIVE ON SBSPACE ERROR AFTER A FAILED / ABORTED WHOLE SYSTEM BACKUP. ARCHIVE ERROR: INIT_ARCHIVE()/ALLOC_SB_PRE |
| IT09008 | ASSERTION MEMORY POINTER FREED TWICE POSSIBLE IN GLOBAL TRANSACTION XA CONTEXT |
| IT09043 | ENGINE THROWS -392 ERROR ON A JOIN WHEN EXECUTED WITHIN A 4GL APPLICATION |
| IT09044 | CHAR[INDEX] ARRAY ASSIGNMENT INTO GLOBAL VARIABLE CAN CAUSE MEMORY CORRUPTION ASSERTION FAILURE |
| IT09065 | SELECT QUERY AGAINST A REMOTE VIEW WHERE ANSI JOIN IS USED CAN RETURN A SYNTAX ERROR |
| IT09066 | THE EFFECT ON SETTING AUS_AUTO_RULES=0 IS NOT CLEARLY DESCRIBED IN THE DOCUMENTATION |
| IT09099 | WRONG RESULTS FOR SQL ANSI JOIN QUERY POSSIBLE WHEN IFX_FOLDVIEW IS ACTIVE |
| IT09130 | RATIO_TO_REPORT IN GROUP BY CLAUSE CRASHES ENGINE |
| IT09189 | IWA: ASSERTION FAILURE POSSIBLE IN PROBE2MART WHEN TRYING TO CREATE A MART DEFINITION WITH IFX_PROBE2MART() |
| IT09218 | TEXT OF RAISE EXCEPTION IN STORED PROCEDURE TRUNCATED AFTER 72 CHARACTERS AND CONTAINING UNEXPECTED CHARACTERS IN THE TRACE FILE |
| IT09280 | SDS SQLEXEC THREAD CAN ASSERT FAIL WITH MESSAGE THREAD EXITED WITH ## BUFFERS HELD AFTER UPDATE STATS RUN ON PRIMARY OF SDS P |
| IT09288 | IN A NON-LOGGING DATABASE LOCKS ON SYSPROCPLAN ARE HELD TOO LONG WHEN TRIGGER REFERENCES ARE USED AND A SPL CONTAINS A SELECT |
| IT09293 | DROPPING A TEMP TABLE IN NESTED SPL CAUSES AF - MEMORY POINTER FREED TWICE |
| IT09323 | RUNNING UPDATE STATS ON TABLES IN A REFERENTIAL CONSTRAINT PAIR CAN ASSERT CALLING CMPRSTR FROM FNDICCP REFERENCING FREED DATA D |
| IT09329 | PH_RUN TABLE IS NOT CORRECTLY CLEANED UP WHEN THERE IS NO MATCHING ROWS IN PH_ALERT |
| IT09355 | POSSIBLE ASSERT FAIL SEGV IN SYSBLDCLEANUPTABLES IF ROWS EXIST IN SYSBLDOBJECTS THAT HAVE STATE = D |
| IT09403 | FOR LVARCHARS GROUPER UNNECESSARILY LOCKS LOCAL ROW AND CAN CAUSE DEAD-LOCKING |
| IT09447 | WRONG RESULTS RETURNED BY A QUERY WITH DISTINCT AND LEFT JOIN |
| IT09482 | IWA: OFFLOADING OF A QUERY WITH IN CLAUSE CAN FAIL WITH ERROR CODES -904, 57011 |
| IT09485 | IWA: ASSERTION FLUSHEDBLOCKS >= EXPECTEDBLOCKS POSSIBLE WHEN REFRESH MART IS DONE |
| IT09486 | SERVER CRASHES WHEN BUFFERPOOL PARAMETER IS SET TOO HIGH AFTER UPGRADE TO 12.10 |
| IT09544 | ONSTAT -G SES REPORTS SESSION POOL OPENTABLE MEMORY LEAK WHEN RUNNING QUERIES WHICH REQUIRE AUTO-INDEX PATH QUERY PLANS |
| IT09585 | IWA: LOAD OF DATA MART CAN FAIL WITH ERROR AQT10205I WHEN VIEW REFERS TO MORE THAN ONE SERIAL COLUMN |
| IT09609 | RSAM MEMORY POOL CORRUPTION RUNNING UPDATE STATISTICS ON TABLE WITH USTLOW_SAMPLE ENABLED (SET TO 1) |
| IT09615 | MANY LONGTX CHECKPOINTS BEING SEEN WITH SMALL TRANSACTIONS COVERING ONLY A FEW LOGS WHEN THE WORK IS ROLLED BACK |
| IT09616 | UPDATEABLE RSS NODE CAN FAIL TO RECONNECT TO PRIMARY AFTER A NETWORK ISSUE |
| IT09620 | HASH JOIN ON A COMPLEX QUERY CAN YIELD TO MASSIVE PERFORMANCE PROBLEMS OR BLOCK THE ENGINE |
| IT09622 | SELECT ON SYSMASTER DATABASE IS MORE THAN 100 TIMES SLOWER AFTER UPGRADE TO 12.10 |
| IT09625 | GENBSON INCORRECTLY CONVERTING NON-ZERO FRACTION PART OF DATETIME |
| IT09626 | BSON_UPDATE() $SET NOT PROPERLY SUPPORTING NON-EXISTING KEYS |
| IT09751 | -346 ERROR ON MERGE IF IFX_REPLCHECK COLUMN IS INDEXED |
| IT09780 | AFTER FAILOVER INVOLVING PRIMARY, RSS AND CM... AN RSS SERVER PROMOTED TO HDR, THEN PRIMARY IS STILL REGISTERED AS AN HDR |
| IT09839 | ENGINE CRASH IN SSC_LINK WHEN STATEMENT CACHE IS ENABLED |
| IT09888 | INDEX REPACK CAN LOOP ON TWIG PAGES WITH VERY LARGE SETS OF DUPLICATE VALUES |
| IT09962 | INFORMIX UNABLE TO ACCEPT MORE THAN 32767 CONNECTIONS |
| IT09963 | LET STATEMENT CONCATING 2 GLOBAL SPL VARIABLES CAUSES PROCEDURE TO GENERATE ASSERTION FAILURE AND 9791 ERROR |
| IT10283 | ON WINDOWS SERVER 2008/2012, ROUTINE EXECUTION TRAP ON TSL_INSCONTAINERCACHE WHEN CALLING TSCONTAINERCREATE |
| IT10284 | DATETIME RETURNED FOR UTC CALCULATION DOES NOT WORK AS EXPECTED WHEN INVOKED AS A SENSOR |
| IT10305 | A CORRELATED SUBQUERY IS IGNORED WHEN RUN INSIDE A STORED PROCEDURE |
| IT10309 | THE UPDATE STATISTICS CAUSES WRONG RESULTS IN THE MULTIPLY-TABLE JOIN OF THE SELECT QUERY WITH MIN() OR MAX() AGGREGATES |
| IT10336 | DUPLICATES IN ROUTINE RESOLUTION CACHE POSSIBLE WHEN FUNCTIONS WITH THE SAME NAME IN DIFFERENT DATABASES ARE CONCURRENTLY RUN |
| IT10338 | SET INDEXES OR CONSTRAINTS ENABLED CAN FAIL WITH 242/106 (NON-EXCLUSIVE ACCESS) WHEN NO OTHER DATABASE ACTIVITY |
| IT10341 | ERROR -242/-135 RESULTS IN CORRUPTED CATALOG, TBLSPACE DOES NOT EXIST |
| IT10350 | STORAGE PROVISIONING ENABLED CAUSES UNNECESSARY CHUNK EXTENDS AND BLOATS CHUNKS WITH A LOT OF FREE SPACE |
| IT10384 | WITH AN LBAC PROTECTED TABLE SPL WHERE CLAUSE USING VARIABLE PARAMETER WILL TAKE SEQUENTIAL SCAN |
| IT10401 | ERROR 124 DURING LOGGING MODE CHANGE WHILE CHANGING LOG MODE TO ANSI AFTER ONLOAD OF DATABASE |
| IT10510 | RPM GENERATION WILL FAIL WITH FILE NOT FOUND ON INHERIT.GIF WHEN INSTALLING JDBC |
| IT10534 | SEGV IN ROUTINE_FIND_UE_ID()/ROUTINE_GETENV2() WITH FIX FOR APAR IT05505 |
| IT10546 | STATEMENT_CACHE DOES NOT WORK AS EXPECTED WHEN SET TO A LARGE SIZE |
| IT10605 | WRONG RESULT RETURNED IF LEFT OUTER JOIN ANSI SQL SYNTAX USED AND DEFAULT SQL_FEAT_CTRL 0X8000 BIT IS NOT SET |
| IT10690 | PROMOTING AN RSS SERVER TO PRIMARY MARKS REGULAR AND TEMP SMART BLOB SPACES SBSPACES OFFLINE |
| IT10728 | MAIN_LOOP ABENDING IN NEED_TO_CKPT() WITH AUTO_CKPTS ON AND RAS_PLOG_SPEED VERY LOW |
| IT10743 | UNION QUERY ON LVARCHAR OF DIFFERING SIZE FAILING WITH 486 OR 9832 OR ABENDING THE SERVER IN PUTCOLTYPE() |
| IT10779 | SELECT ON TIMESERIES ALLOCATES A LOT OF SESSION MEMORY IN SQOPVTI.C |
| IT10780 | WINDOWS: THREAD SUSPENSION CAN ABORT THE INSTANCE WITHOUT A SHARED MEMORY DUMP BEING WRITTEN |
| IT10785 | CREATING DBSPACE FROM A STORAGE POOL CRASHES SECONDARY SERVER |
| IT10787 | CANNOT CREATE NEW CHUNK OR DBSPACE FROM STORAGE POOL IF SECONDARY SERVER IS INACTIVE |
| IT10789 | WINDOWS: THE MON_COMPRESSION_ESTIMATES TASK CAN CAUSE A STORAGEMGR THREAD ASSERTION FAILURE IN PTMAPX() |
| IT10790 | INDEX REPACK WRITES ASSERT FAILURE EVEN IF IT SUCCEEDS |
| IT10793 | HDR SECONDARY WILL CRASH DURING LOGICAL RECOVERY IF A SBSPACE IS CREATED IN PRIMARY WHILE HDR SECONDARY IS DOWN |
| IT10925 | WRONG RESULTS POSSIBLE WITH QUERY ON A VIEW WITH UNION ALL AND IFX_FOLDVIEW ENABLED |
| IT11009 | ONCMSM ISSUE WITH DBSERVERNAME & DBSERVERALIAS |
| IT11087 | PSM: MEMORY LEAK CAN LEAD TO BACKUP EXPORT FAILURE DEPENDING ON THE NUMBER OF OBJECTS INVOLVED |
| IT11137 | IF AUS_AGE IS SET TO 0 AUS_EVALUATOR GENERATES WRONG UST HIGH SQL STATEMENTS FOR SYSADMIN DATABASE |
| IT11138 | WINDOWS: RUNNING TS_INIT CRASHES THE INSTANCE |
| IT11350 | VARIOUS FAILURES CAN OCCUR WHEN SELECT USING BSON_GET CAUSES CORRUPTION WHEN ROW NOT FOUND |
| IT11351 | ER DATASYNC THREAD LEAKS MEMORY IN CDRD POOL ON TARGET NODE WHEN A SINGLE TRANSACTION DELETES LARGE NUMBER OF ROWS |
| IT11369 | DBEXPORT OR UNLOAD OF TABLE CONTAINING SMART BLOB ( SBLOB ) DATA USES AN EXCESSIVE AMOUNT OF SESSION PARTN MEMORY |
| IT11530 | LISTENER THREAD MAY NOT BE ABLE TO BIND TO PORT WHEN USING IPV6 ADDRESSES |
| IT11576 | ERROR -1204 RETURNED WHEN RIGHT HAND DATE VALUE OF EQUALITY EXPRESSION CONTAINS DECEMBER 31ST, 9999 |
| IT11615 | INSTALLER CUSTOM INSTANCE CREATES HUGE SPACES SO IT TAKES TOO LONG TO BUILD SYSADMIN |
| IT11620 | REQUESTS TO ABORT READAHEAD OPERATIONS MAY NOT BE NOTICED BY THE READAHEAD DAEMON LEADING TO POTENTIAL FOR MEMORY CORRUPTION |
| IT11854 | BSON_VALUE ROUTINES USING SPL COMPOSED KEY NAMES RETURNING NULL (NOT FINDING TARGET FIELD?) |
[{"Product":{"code":"SSGU8G","label":"Informix Servers"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF022","label":"OS X"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"12.1","Edition":"Developer;Enterprise;Express;Innovator;Workgroup","Line of Business":{"code":"","label":""}}]
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg27046898