Fix list for Informix Server 12.10.xC6

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.


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?)