Fix list for Informix Server 12.10.xC9

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.xC9. 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
IT09405 LONG CONNECTION TIME POSSIBLE WHEN LARGE GROUP LIST HAS TO BE SCANNED TO FIND OUT IF USER IS DBSA USER
IT10306 WITH THREAD SUSPENSION ENABLED, CERTAIN MEMORY CORRUPTION CAN CAUSE THREAD SUSPENSION CODE TO INFINITELY LOOP ASSERT FAILING
IT12385 SPATIAL: ST_UNION MAY RETURN WRONG RESULT
IT13967 STORED PROCEDURE QUERYING SYSONLINELOG LEAKS AIO FILE HANDLES
IT14829 SHOULD ALLOW FULL RANGE OF 64K REPLICATES PER SERVER
IT16966 EXCESSIVE READS ON SYSUSERS SYSTEM CATALOG
IT16967 EXCESSIVE READS ON SYSXTDYPEAUTH SYSTEM CATALOG
IT16971 USING TEMP TABLES AND STORED PROCEDURES BY PREPARED STATEMENTS OR 4GL PCODE MAY LEAD TO SQL LAYER GETTING OUT OF SYNC WITH RSAM
IT17019 AUDITING DOESNT TRACK A CREATE TABLE TAB_NEW AS SELECT * FROM TAB AS CRTB
IT17265 SYNTAX ERROR -201 IF RUN INSERT INTO WITH THE OWNER IDENTIFIER OF THE RESULT TABLE
IT17533 BFCHECK ERROR AFTER PGCOMPRESS / PAGE_REORG TO MAKE ROOM FOR AN INSERT OR A LARGER UPDATED SLOT
IT17540 CREATE A FORIEGN KEY INDEX ON FOT PRIMARY KEY INDEXES CAUSES ERROR -245/105
IT17634 IFXCLONE UTILIZING ALL AVAILABLE MEMORY THEN CRASHING WHEN ATTEMPTING TO SET UP HDR
IT17762 IPLOAD/ONPLADM FAIL AT FAILPOINT 16144 AFTER 12.10.FC7 INSTALL ON HP-UX IA64
IT17763 ST_POINT() COULD FAIL WITH ASSERT FAILED: CONDITION FAILED (BAD POOL POINTER) WHEN PDQ IS USED
IT17797 PROXYBTCLEAN THREADS CAN BE MISTAKENLY STARTED ON A STANDALONE SERVER
IT17814 MERGE STATEMENT INSERT VALUES CAN FAIL WITH -271/-151 AFTER ALTER TABLE ADD COL ON TABLE WITH VERCOLS
IT17834 TABLE LEVEL RESTORE POINT IN TIME FAILS FOR UNICODE DB
IT17852 SEGVS AND MEMORY CORRUPTION USING SELECT FROM TABLE INTO STANDARD TABLE FEATURE
IT17943 RUNNING SYSPURGE() ON A NONFRAGMENTED TABLE CAUSES SIGSEGV
IT17944 SELECT FROM VIEW AND SUBQUERY RUNS MUCH SLOWER THAN A SELECT FROM THE UNDERLYING TABLES
IT18059 CREATE TABLE COMPRESSED AS SELECT DOES NOT COMPRESS THE TABLE
IT18092 DBSCHEMA DOES NOT FINISH IF THERE IS AN INDEX OWNER
IT18141 TABLE CREATION WITH CAPITAL LETTERS IN NAME RESULTS IN A TABLE THAT CANNOT BE DROPPED/ALTERED/QUERIED
IT18142 CREATION OF INDEX ON SDS PRIMARY CAN HANG IN IPL THREAD EVEN WHEN LOG_INDEX_BUILDS IS NOT ACTIVE
IT18143 COUNT(*) ON SUBQUERY RESULTS USING IN CLAUSE AND CHAR VALUES WITH DIFFERENT LENGTH DEFINITION RETURN WRONG RESULTS
IT18144 PDQ INSERT WHEN SELECT FROM AN EXTERNAL TABLE WITH WRONG DELIMITER CAN ASSERT AN XLCNV THREAD
IT18155 PTHDRPAGE:PTALLOC:BAD PARTN PAGE ASSERTIONS POSSIBLE RUNNING PURGE_DICTIONARY TASK
IT18223 QUERY THAT USED TO RUN FINE IN 11.50 NOW ALLOCATES SO MUCH MEMORY THAT THE INSTANCE RUNS OUT
IT18234 ONMODE_MON THREAD IN PRIMARY CAN LOOP IN DR_MODE IF PROMOTE AN IFXCLONE RSS CREATION TOO QUICKLY TO AN HDR SERVER
IT18235 IDS_INSTALL TO CREATE CLIENT RPMS FAILS BECAUSE IT CAN NOT FIND THE $INFORMIXDIR/EXTEND DIRECTORY
IT18273 CONNECT BY IN A STORED PROCEDURE WITH MULTIPLE TEMP SPACES CAUSES 243/102 IN THE SECOND EXECUTION
IT18274 LOW MEMORY MANAGER: LOWMEMORYRECONFIG USES THE WRONG VALUE FOR SHMTOTAL
IT18275 REPACK_OFFLINE DOES NOT SWITCH TO REPACK
IT18280 CONCURRENT READERS AND ALTER FRAGMENT ONLINE STATEMENTS CAN LEAD TO PERSISTENT ISAM -135 ERRORS
IT18294 A SELECT ON A TABLE COULD MISS ROWS WHEN REPACK IS RUN IN PARALLEL
IT18295 OPEN DATABASE HAS REDUNDANT DBSA CHECKING AND SHOULD LEVERAGE NS_CACHE GROUP CACHE IF ADMIN_USER_MODE_WITH_DBSA SET TO 1
IT18318 CURSOR ON DYNAMIC SQL RETURNED -661 INSTEAD OF -26053
IT18331 CDR_MONITOR THREAD HANGS
IT18403 INDEX PAGES MAY NOT BE CLEANED ON SECONDARY SERVERS
IT18417 HPUX-IA64 EXCESSIVE SPINLOCK CONTENTION CAN SLOW DOWN LOADING FROM EXTERNAL TABLES
IT18418 ASSERT FAILURE IN GL_FULL_MBSCHR WHEN USING A LOCALE LIKE ZH_TW.57352
IT18419 UPGRADE OF SECONDARY SERVERS TO 12.10.XC8 FAILS
IT18480 CONVERT THREAD HANGS WAITING FOR SQLUP CONVERTING TO 12.10.FC8 WHEN THERE IS A TENANT DATABASE
IT18533 PN_SYSCATLOG FLAG MISSING FOR CERTAIN SYSTEM TABLES AFTER MIGRATING FROM 11.50/11.70 TO 12.10.FC8
IT18549 CLIP() RETURNS WRONG RESULTS WHEN READ AHEAD IS TURNED OFF (AUTO_READAHEAD=0)
IT18604 ASSERT SEGV OR -768 ERROR CAN OCCUR ON QUERY AFTER RUNNING UPDATE STATISTICS ON THE LOCAL TABLES
IT18612 ROLLFORWARD OF LOG RECORD FAILS WITH ISERRNO 101 AND IS SEEN IN HDR SECONDARY WHEN THE STAMP OF PNTORSFD HITS A NEGATIVE VALUE
IT18613 NETWORK COMMUNICATION FAILURE DURING SDS CONNECTION TO PRIMARY MAY LEAD TO CHECKPOINT HANG
IT18719 SELECTING FROM TIMESERIES VTI WITH COLUMN TIMESTAMP IN THE WHERE CLAUSE RETURNS A WRONG RESULT
IT18723 MEMORY CORRUPTION IN CDR POOL
IT18724 ARCHIVE RESTORE FAILS VERY EARLY WITH PHYSICAL RESTORE FAILED
IT18739 SEGV IN RA_DO_ROLLBACK_REQ
IT18740 PARALLEL SHARD QUERY WHEN RUN FROM SECONDARY SERVER FAILS WITH ERROR CODE CLIXNOTACTIVE WHEN CONNECTING TO THE LOCAL SERVER
IT18741 SELECT  FROM  SHOWS ALL COLUMNS, EVEN IF ONLY ACCESS TO ONE COLUMN IS PERMITTED
IT18792 ALTER TABLE ADD ROWIDS FOR A TABLE FRAGMENTED BY ROWIDS GIVES ERROR : 212/100
IT18894 HDR SECONDARY XCHG THREAD CAN LOOP ENDLESSLY OR SEGV IN IXRFIND
IT18895 WHEN BASE TABLE PRIVILEGES ARE REMOVED FOR USERS, ACTIONS ON THE TIMESERIES VIRTUAL TABLES RETURN UNINFORMITIVE ERROR MESSAGES
IT18945 IFXCLONE ALLOWS NON-MATCHING ROOTPATH VALUES WHICH LEADS TO SPLIT ROOT-CHUNKS ON SECONDARY LEADING TO CORRUPTION
IT18958 EXPANDING AN EXTENDABLE CHUNK FAILS AFTER A CERTAIN NUMBER OF EXPANDS
IT18960 ERROR 408 SEEN WHEN SELECTING A TEXT FIELD WHICH CONTAINS MULTI BYTE DATA
IT18978 SELECT INTO A TEMPORARY TABLE WITH PDQ COULD FAIL WITH -264/-770
IT18980 INSERT OF BSON DATA INTO EXTERNAL TABLE DOES NOT WORK WHEN DATABASE IS UTF8
IT18982 JAVA UDR THAT DELETES/INSERTS/SELECT AND RETURNS CLOB CAN CAUSE OOM OUTOFMEMORY ERRORS RUNNING ON JVP AND CRASH SERVER
IT19075 UNABLE TO CREATE XA TRANSACTIONS WITH IBM DATA SERVER CLIENTS (VERSION 11.1)
IT19106 UNDULY SENDING NEW INDEX ON RAW TABLE VIA IPL OR DRIDXAUTO
IT19131 ONCHECK -PT DBNAME:TABNAME IS NOT REPORTING DETACHED INDEX FRAGMENT INFORMATION WHEN TABLE HAS FOREIGN KEY CONSTRAINTS
IT19140 A PROXYTH THREAD CAN BE LEFT ORPHANED HOLDING LOCKS ON THE PRIMARY SERVER WHEN A PROXY DISPATCH THREAD FAILS
IT19178 ONSMSYNC -E -P BASED ON PSM RETURNS THE LOCK CATALOG TABLE IS NOT OPEN ERROR
IT19199 QUERY CAN RETURN 243/770 ERRORS WHEN TABLE IN ANOTHER DATABASE HAS DISABLED CONSTRAINTS AND FUNCTIONAL INDEXES
IT19200 ERROR 9700 ROUTINE AMBIGUOUS: MORE THAN ONE ROUTINE RESOLVES TO GIVEN SIGNATURE WHEN EXECUTING A DATABASE ROUTINE FROM JDBC
IT19259 EXECUTING A REMOTE PROCEDURE INVOLVING FOREACH .. SELECT FAILS WITH ERROR 556
IT19260 THE FUNCTION CREATED WITH RESUME CLAUSE RETURNS ERROR 1 NOT USER
IT19276 ONPSM -C EXPORT RETURNS ERROR MESSAGE: ERROR -88186: A DEFECT IN THE PROGRAM WAS FOUND
IT19277 QUERY WITH CORRELATION IN SELECT LIST RETURNS -294 BEGINNING WITH 12.10.FC8
IT19278 CDR GC: OPERATION OPEN ON TABLE USER TABLE FAILED (ISAM ERROR-135). MOVING FROM 12.10 PRE-XC7 TO XC7 OR HIGHER
IT19310 ASSERT FAILED: UNCOMPRESS_ROW: COLUMN DATA LENGTH EXCEEDS THE MAXIMUM LENGTH
IT19311 DBSCHEMA DOES NOT SHOW THE NOT NULL CONSTRAINTS
IT19313 TIMESERIES PROJECTEDCLIP SPECIFYING NO NULL COLUMNS WITH (NN) SYNTAX ASSERTS IN TS_CLIP_AND_PROJECT
IT19351 AFTER ONMODE -KY, ONCLEAN -KY THROWS ERROR MESSAGES THE SEMCTL() FUNCTION ON ID = ?????? FAILED WITH ERROR NUMBER = 22
IT19353 ASSERT FAILED IN EXECUTE_UNION_NODE() OF A QUERY WITH UNION ALL
IT19359 SPL: FETCH INTO GLOBAL ROW TYPE VARIABLE ASSIGNS RANDOM GARBAGE
IT19360 QUERY LOOPS IN OPLOOKSUBQ, WILL RESULST IN STACK OVERFLOW OR HANG
IT19376 ASSERT FAILURE POSSIBLE ON SECONDARY SERVERS AFTER INDEX COMPRESSION AND FAILOVER
IT19415 ERROR COMPRESSION OPERATION ALREADY IN PROGRESS ... WHEN PARALLEL INSERTS SIMULTANEOUSLY CROSS COMPRESSION THRESHOLD
IT19416 MEMORY CORRUPTION ASSERTION FAILURE IN CRYPTO THREAD WHEN USING SSL BETWEEN A PRIMARY AND A RSS NODE
IT19490 SPL CALLING A REMOTE STORED PROCEDURE REQUIRING CONVERSIONS OF DATATYPES TO A LVARCHAR CAUSES ENDLESS LOOP
IT19538 MEMORY BLOCK HEADER CORRUPTION FOLLOWED BY SEGV AFTER MANY RECURSIVE CALLS TO ORIDXCLAUSECOST
IT19557 CONCURRENT READ ACTIVITY WHILE ALSO PERFORMING ALTER FRAGMENT COMMAND CAN CAUSE SEGV ASSERTION FAILURE
IT19611 PTMAP: BAD PAGENUM ASSERTION FROM RSTALLBLOBS/BLOBABORT WHEN ROLLING BACK WORK ON UNLOGGED TABLE WITH PARTITION BLOB COLUMN
IT19702 TRANSACTION MIX WITH LOGGED TEMP TABS ROLLBACKS AND SQLEXIT CALLS CAN CAUSE RECOVERY ERRORS
IT19760 IFXCLONE CAN CAUSE AN SMX PBACKUP THREAD TO ASSERT FAIL AND BRING THE PRIMARY DOWN
IT19806 SELECT BSON_GET(DATA,ID)::JSON FROM TABNAME CAUSES ASSERTION FAILURE WHEN RUN AGAINST A COLLECTION TABLE
IT19869 HUGE MEMORY LEAK IN MT POOL AT MTMUTEX
IT19870 JDBC CLIENT THAT RETRIEVES AUTO GENERATED KEYS FOR INSERT INTO ... SELECT FROM ... STATEMENT LEAKS OPENTABLE MEMORY AND OPEN TAB
IT19896 ASSERT FAILED WITH MEMORY BLOCK HEADER CORRUPTION IF THE SELECT QUERY USES TEMPSPACES WHERE THE NON PRIMARY CHUNK IS BAD
IT19897 ERROR 9634 NO CAST FROM TYPE-NAME WHEN USING INSERT CURSORS AND SOME BUILT-IN FUNCTIONS
IT19989 INSERT INTO REMOTE TABLE WITH FUNCTIONAL INDEX FAILS WITH -9753
IT20024 NEWLY ADDED FRAGMENTS IN RANGE PARTIONED TABLE CONTAIN THE WRONG DB NAME IN PARTION WHEN ADDED BY REMOTE INSERT
IT20026 TRANSACTION COMMIT MAY BE DELAYED WHEN USING BUFFERED LOG DATABASE WITH HDR
IT20074 CREATE TABLE AFTER A MERGE OF REMOTE TABLES COULD FAIL WITH -312/-101
IT20075 RSS PRIMARY SERVER CAN HANG/LOCK UP WITH RSS_SEND/RSS_RECV THREADS SPINNING ON THE BACKLOGWAITLOCK SPIN LOCK
IT20133 A LISTENER THREAD ERROR IN SSL CAN CAUSE HIGH CPU UTILIZATION BY THE SSL POLL THREAD
IT20166 SHARED LOCK HELD ON BLD REF ### WHEN DDL INSERT ON TABLE WITH REFERENTIAL CONSTRAINT WAITS ON LOCK HELD BY PARENT TABLE
IT20356 ERROR CREATING THE RPM INSTALLER IN 32-BIT PRODUCT
IT20358 AUTO_CRSD TASK TRIES TO COMPRESS ENTERPRISE REPLICATION DELTABS AND RETURNS ERROR 102
IT20370 HPL ONPLOAD LOAD JOB DOES NOT LOAD ALL ROWS INTO TABLE AND FAILS WITH ERROR HPL FAILPOINT 14100
IT20428 SOCSSLLST THREAD CAN BLOCK FOREVER DURING ACCEPT OF CLIENT CONNECTION, WAITING FOR RESPONSE FROM CLIENT
IT20482 A SELECT STATEMENT USING LEFT JOIN, NVL AND OPTCOMPIND 2 IS SLOW AND LARGE VALUES ARE SHOWN IN SQEXPLAIN.OUT ESTIMATES
IT20484 SERIAL VALUE GENERATION BROKEN FOR TEMP TABLES ON SECONDARY SERVERS
IT20525 WHEN MULTIPLEX CLIENTS CONNECT USING ONSQLMUX PROTOCOL, 4 BYTES OF CORRUPTION CAN CORRUPT MEMORY YIELDING RANDOM SERVER FAILURES
IT20536 ERROR 32504 REMOTE OPERATION NOT ALLOWED WHEN DOING A REMOTE QUERY AFTER ANOTHER SESSION CHANGED INDENTITIES
IT20537 QUERY PLAN CHANGED AFTER UPGRADE FROM IDS 12.10.FC4 TO 12.10.FC7
IT20579 ONMODE -K HANGING, THEN ONCLEAN -K AND RESTART WOULD LEAD TO SAME INSTANCE RUNNING TWICE
IT20684 MUTEX RELATED MEMORY LEAK IN MT POOL


Translate this page: