IBM Support

Fix list for Informix Server 12.10.xC9

Product Documentation


Abstract

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.

Content







Fix release date: 06 July 2017
Status: Recommended

Download information




APAR
Description
IT09405LONG CONNECTION TIME POSSIBLE WHEN LARGE GROUP LIST HAS TO BE SCANNED TO FIND OUT IF USER IS DBSA USER
IT10306WITH THREAD SUSPENSION ENABLED, CERTAIN MEMORY CORRUPTION CAN CAUSE THREAD SUSPENSION CODE TO INFINITELY LOOP ASSERT FAILING
IT12385SPATIAL: ST_UNION MAY RETURN WRONG RESULT
IT13967STORED PROCEDURE QUERYING SYSONLINELOG LEAKS AIO FILE HANDLES
IT14829SHOULD ALLOW FULL RANGE OF 64K REPLICATES PER SERVER
IT16966EXCESSIVE READS ON SYSUSERS SYSTEM CATALOG
IT16967EXCESSIVE READS ON SYSXTDYPEAUTH SYSTEM CATALOG
IT16971USING TEMP TABLES AND STORED PROCEDURES BY PREPARED STATEMENTS OR 4GL PCODE MAY LEAD TO SQL LAYER GETTING OUT OF SYNC WITH RSAM
IT17019AUDITING DOESNT TRACK A CREATE TABLE TAB_NEW AS SELECT * FROM TAB AS CRTB
IT17265SYNTAX ERROR -201 IF RUN INSERT INTO WITH THE OWNER IDENTIFIER OF THE RESULT TABLE
IT17533BFCHECK ERROR AFTER PGCOMPRESS / PAGE_REORG TO MAKE ROOM FOR AN INSERT OR A LARGER UPDATED SLOT
IT17540CREATE A FORIEGN KEY INDEX ON FOT PRIMARY KEY INDEXES CAUSES ERROR -245/105
IT17634IFXCLONE UTILIZING ALL AVAILABLE MEMORY THEN CRASHING WHEN ATTEMPTING TO SET UP HDR
IT17762IPLOAD/ONPLADM FAIL AT FAILPOINT 16144 AFTER 12.10.FC7 INSTALL ON HP-UX IA64
IT17763ST_POINT() COULD FAIL WITH ASSERT FAILED: CONDITION FAILED (BAD POOL POINTER) WHEN PDQ IS USED
IT17797PROXYBTCLEAN THREADS CAN BE MISTAKENLY STARTED ON A STANDALONE SERVER
IT17814MERGE STATEMENT INSERT VALUES CAN FAIL WITH -271/-151 AFTER ALTER TABLE ADD COL ON TABLE WITH VERCOLS
IT17834TABLE LEVEL RESTORE POINT IN TIME FAILS FOR UNICODE DB
IT17852SEGVS AND MEMORY CORRUPTION USING SELECT FROM TABLE INTO STANDARD TABLE FEATURE
IT17943RUNNING SYSPURGE() ON A NONFRAGMENTED TABLE CAUSES SIGSEGV
IT17944SELECT FROM VIEW AND SUBQUERY RUNS MUCH SLOWER THAN A SELECT FROM THE UNDERLYING TABLES
IT18059CREATE TABLE COMPRESSED AS SELECT DOES NOT COMPRESS THE TABLE
IT18092DBSCHEMA DOES NOT FINISH IF THERE IS AN INDEX OWNER
IT18141TABLE CREATION WITH CAPITAL LETTERS IN NAME RESULTS IN A TABLE THAT CANNOT BE DROPPED/ALTERED/QUERIED
IT18142CREATION OF INDEX ON SDS PRIMARY CAN HANG IN IPL THREAD EVEN WHEN LOG_INDEX_BUILDS IS NOT ACTIVE
IT18143COUNT(*) ON SUBQUERY RESULTS USING IN CLAUSE AND CHAR VALUES WITH DIFFERENT LENGTH DEFINITION RETURN WRONG RESULTS
IT18144PDQ INSERT WHEN SELECT FROM AN EXTERNAL TABLE WITH WRONG DELIMITER CAN ASSERT AN XLCNV THREAD
IT18155PTHDRPAGE:PTALLOC:BAD PARTN PAGE ASSERTIONS POSSIBLE RUNNING PURGE_DICTIONARY TASK
IT18223QUERY THAT USED TO RUN FINE IN 11.50 NOW ALLOCATES SO MUCH MEMORY THAT THE INSTANCE RUNS OUT
IT18234ONMODE_MON THREAD IN PRIMARY CAN LOOP IN DR_MODE IF PROMOTE AN IFXCLONE RSS CREATION TOO QUICKLY TO AN HDR SERVER
IT18235IDS_INSTALL TO CREATE CLIENT RPMS FAILS BECAUSE IT CAN NOT FIND THE $INFORMIXDIR/EXTEND DIRECTORY
IT18273CONNECT BY IN A STORED PROCEDURE WITH MULTIPLE TEMP SPACES CAUSES 243/102 IN THE SECOND EXECUTION
IT18274LOW MEMORY MANAGER: LOWMEMORYRECONFIG USES THE WRONG VALUE FOR SHMTOTAL
IT18275REPACK_OFFLINE DOES NOT SWITCH TO REPACK
IT18280CONCURRENT READERS AND ALTER FRAGMENT ONLINE STATEMENTS CAN LEAD TO PERSISTENT ISAM -135 ERRORS
IT18294A SELECT ON A TABLE COULD MISS ROWS WHEN REPACK IS RUN IN PARALLEL
IT18295OPEN DATABASE HAS REDUNDANT DBSA CHECKING AND SHOULD LEVERAGE NS_CACHE GROUP CACHE IF ADMIN_USER_MODE_WITH_DBSA SET TO 1
IT18318CURSOR ON DYNAMIC SQL RETURNED -661 INSTEAD OF -26053
IT18331CDR_MONITOR THREAD HANGS
IT18403INDEX PAGES MAY NOT BE CLEANED ON SECONDARY SERVERS
IT18417HPUX-IA64 EXCESSIVE SPINLOCK CONTENTION CAN SLOW DOWN LOADING FROM EXTERNAL TABLES
IT18418ASSERT FAILURE IN GL_FULL_MBSCHR WHEN USING A LOCALE LIKE ZH_TW.57352
IT18419UPGRADE OF SECONDARY SERVERS TO 12.10.XC8 FAILS
IT18480CONVERT THREAD HANGS WAITING FOR SQLUP CONVERTING TO 12.10.FC8 WHEN THERE IS A TENANT DATABASE
IT18533PN_SYSCATLOG FLAG MISSING FOR CERTAIN SYSTEM TABLES AFTER MIGRATING FROM 11.50/11.70 TO 12.10.FC8
IT18549CLIP() RETURNS WRONG RESULTS WHEN READ AHEAD IS TURNED OFF (AUTO_READAHEAD=0)
IT18604ASSERT SEGV OR -768 ERROR CAN OCCUR ON QUERY AFTER RUNNING UPDATE STATISTICS ON THE LOCAL TABLES
IT18612ROLLFORWARD OF LOG RECORD FAILS WITH ISERRNO 101 AND IS SEEN IN HDR SECONDARY WHEN THE STAMP OF PNTORSFD HITS A NEGATIVE VALUE
IT18613NETWORK COMMUNICATION FAILURE DURING SDS CONNECTION TO PRIMARY MAY LEAD TO CHECKPOINT HANG
IT18719SELECTING FROM TIMESERIES VTI WITH COLUMN TIMESTAMP IN THE WHERE CLAUSE RETURNS A WRONG RESULT
IT18723MEMORY CORRUPTION IN CDR POOL
IT18724ARCHIVE RESTORE FAILS VERY EARLY WITH PHYSICAL RESTORE FAILED
IT18739SEGV IN RA_DO_ROLLBACK_REQ
IT18740PARALLEL SHARD QUERY WHEN RUN FROM SECONDARY SERVER FAILS WITH ERROR CODE CLIXNOTACTIVE WHEN CONNECTING TO THE LOCAL SERVER
IT18741SELECT FROM SHOWS ALL COLUMNS, EVEN IF ONLY ACCESS TO ONE COLUMN IS PERMITTED
IT18792ALTER TABLE ADD ROWIDS FOR A TABLE FRAGMENTED BY ROWIDS GIVES ERROR : 212/100
IT18894HDR SECONDARY XCHG THREAD CAN LOOP ENDLESSLY OR SEGV IN IXRFIND
IT18895WHEN BASE TABLE PRIVILEGES ARE REMOVED FOR USERS, ACTIONS ON THE TIMESERIES VIRTUAL TABLES RETURN UNINFORMITIVE ERROR MESSAGES
IT18945IFXCLONE ALLOWS NON-MATCHING ROOTPATH VALUES WHICH LEADS TO SPLIT ROOT-CHUNKS ON SECONDARY LEADING TO CORRUPTION
IT18958EXPANDING AN EXTENDABLE CHUNK FAILS AFTER A CERTAIN NUMBER OF EXPANDS
IT18960ERROR 408 SEEN WHEN SELECTING A TEXT FIELD WHICH CONTAINS MULTI BYTE DATA
IT18978SELECT INTO A TEMPORARY TABLE WITH PDQ COULD FAIL WITH -264/-770
IT18980INSERT OF BSON DATA INTO EXTERNAL TABLE DOES NOT WORK WHEN DATABASE IS UTF8
IT18982JAVA UDR THAT DELETES/INSERTS/SELECT AND RETURNS CLOB CAN CAUSE OOM OUTOFMEMORY ERRORS RUNNING ON JVP AND CRASH SERVER
IT19075UNABLE TO CREATE XA TRANSACTIONS WITH IBM DATA SERVER CLIENTS (VERSION 11.1)
IT19106UNDULY SENDING NEW INDEX ON RAW TABLE VIA IPL OR DRIDXAUTO
IT19131ONCHECK -PT DBNAME:TABNAME IS NOT REPORTING DETACHED INDEX FRAGMENT INFORMATION WHEN TABLE HAS FOREIGN KEY CONSTRAINTS
IT19140A PROXYTH THREAD CAN BE LEFT ORPHANED HOLDING LOCKS ON THE PRIMARY SERVER WHEN A PROXY DISPATCH THREAD FAILS
IT19178ONSMSYNC -E -P BASED ON PSM RETURNS THE LOCK CATALOG TABLE IS NOT OPEN ERROR
IT19199QUERY CAN RETURN 243/770 ERRORS WHEN TABLE IN ANOTHER DATABASE HAS DISABLED CONSTRAINTS AND FUNCTIONAL INDEXES
IT19200ERROR 9700 ROUTINE AMBIGUOUS: MORE THAN ONE ROUTINE RESOLVES TO GIVEN SIGNATURE WHEN EXECUTING A DATABASE ROUTINE FROM JDBC
IT19259EXECUTING A REMOTE PROCEDURE INVOLVING FOREACH .. SELECT FAILS WITH ERROR 556
IT19260THE FUNCTION CREATED WITH RESUME CLAUSE RETURNS ERROR 1 NOT USER
IT19276ONPSM -C EXPORT RETURNS ERROR MESSAGE: ERROR -88186: A DEFECT IN THE PROGRAM WAS FOUND
IT19277QUERY WITH CORRELATION IN SELECT LIST RETURNS -294 BEGINNING WITH 12.10.FC8
IT19278CDR GC: OPERATION OPEN ON TABLE USER TABLE FAILED (ISAM ERROR-135). MOVING FROM 12.10 PRE-XC7 TO XC7 OR HIGHER
IT19310ASSERT FAILED: UNCOMPRESS_ROW: COLUMN DATA LENGTH EXCEEDS THE MAXIMUM LENGTH
IT19311DBSCHEMA DOES NOT SHOW THE NOT NULL CONSTRAINTS
IT19313TIMESERIES PROJECTEDCLIP SPECIFYING NO NULL COLUMNS WITH (NN) SYNTAX ASSERTS IN TS_CLIP_AND_PROJECT
IT19351AFTER ONMODE -KY, ONCLEAN -KY THROWS ERROR MESSAGES THE SEMCTL() FUNCTION ON ID = ?????? FAILED WITH ERROR NUMBER = 22
IT19353ASSERT FAILED IN EXECUTE_UNION_NODE() OF A QUERY WITH UNION ALL
IT19359SPL: FETCH INTO GLOBAL ROW TYPE VARIABLE ASSIGNS RANDOM GARBAGE
IT19360QUERY LOOPS IN OPLOOKSUBQ, WILL RESULST IN STACK OVERFLOW OR HANG
IT19376ASSERT FAILURE POSSIBLE ON SECONDARY SERVERS AFTER INDEX COMPRESSION AND FAILOVER
IT19415ERROR COMPRESSION OPERATION ALREADY IN PROGRESS ... WHEN PARALLEL INSERTS SIMULTANEOUSLY CROSS COMPRESSION THRESHOLD
IT19416MEMORY CORRUPTION ASSERTION FAILURE IN CRYPTO THREAD WHEN USING SSL BETWEEN A PRIMARY AND A RSS NODE
IT19490SPL CALLING A REMOTE STORED PROCEDURE REQUIRING CONVERSIONS OF DATATYPES TO A LVARCHAR CAUSES ENDLESS LOOP
IT19538MEMORY BLOCK HEADER CORRUPTION FOLLOWED BY SEGV AFTER MANY RECURSIVE CALLS TO ORIDXCLAUSECOST
IT19557CONCURRENT READ ACTIVITY WHILE ALSO PERFORMING ALTER FRAGMENT COMMAND CAN CAUSE SEGV ASSERTION FAILURE
IT19611PTMAP: BAD PAGENUM ASSERTION FROM RSTALLBLOBS/BLOBABORT WHEN ROLLING BACK WORK ON UNLOGGED TABLE WITH PARTITION BLOB COLUMN
IT19702TRANSACTION MIX WITH LOGGED TEMP TABS ROLLBACKS AND SQLEXIT CALLS CAN CAUSE RECOVERY ERRORS
IT19760IFXCLONE CAN CAUSE AN SMX PBACKUP THREAD TO ASSERT FAIL AND BRING THE PRIMARY DOWN
IT19806SELECT BSON_GET(DATA,ID)::JSON FROM TABNAME CAUSES ASSERTION FAILURE WHEN RUN AGAINST A COLLECTION TABLE
IT19869HUGE MEMORY LEAK IN MT POOL AT MTMUTEX
IT19870JDBC CLIENT THAT RETRIEVES AUTO GENERATED KEYS FOR INSERT INTO ... SELECT FROM ... STATEMENT LEAKS OPENTABLE MEMORY AND OPEN TAB
IT19896ASSERT FAILED WITH MEMORY BLOCK HEADER CORRUPTION IF THE SELECT QUERY USES TEMPSPACES WHERE THE NON PRIMARY CHUNK IS BAD
IT19897ERROR 9634 NO CAST FROM TYPE-NAME WHEN USING INSERT CURSORS AND SOME BUILT-IN FUNCTIONS
IT19989INSERT INTO REMOTE TABLE WITH FUNCTIONAL INDEX FAILS WITH -9753
IT20024NEWLY ADDED FRAGMENTS IN RANGE PARTIONED TABLE CONTAIN THE WRONG DB NAME IN PARTION WHEN ADDED BY REMOTE INSERT
IT20026TRANSACTION COMMIT MAY BE DELAYED WHEN USING BUFFERED LOG DATABASE WITH HDR
IT20074CREATE TABLE AFTER A MERGE OF REMOTE TABLES COULD FAIL WITH -312/-101
IT20075RSS PRIMARY SERVER CAN HANG/LOCK UP WITH RSS_SEND/RSS_RECV THREADS SPINNING ON THE BACKLOGWAITLOCK SPIN LOCK
IT20133A LISTENER THREAD ERROR IN SSL CAN CAUSE HIGH CPU UTILIZATION BY THE SSL POLL THREAD
IT20166SHARED LOCK HELD ON BLD REF ### WHEN DDL INSERT ON TABLE WITH REFERENTIAL CONSTRAINT WAITS ON LOCK HELD BY PARENT TABLE
IT20356ERROR CREATING THE RPM INSTALLER IN 32-BIT PRODUCT
IT20358AUTO_CRSD TASK TRIES TO COMPRESS ENTERPRISE REPLICATION DELTABS AND RETURNS ERROR 102
IT20370HPL ONPLOAD LOAD JOB DOES NOT LOAD ALL ROWS INTO TABLE AND FAILS WITH ERROR HPL FAILPOINT 14100
IT20428SOCSSLLST THREAD CAN BLOCK FOREVER DURING ACCEPT OF CLIENT CONNECTION, WAITING FOR RESPONSE FROM CLIENT
IT20482A SELECT STATEMENT USING LEFT JOIN, NVL AND OPTCOMPIND 2 IS SLOW AND LARGE VALUES ARE SHOWN IN SQEXPLAIN.OUT ESTIMATES
IT20484SERIAL VALUE GENERATION BROKEN FOR TEMP TABLES ON SECONDARY SERVERS
IT20525WHEN MULTIPLEX CLIENTS CONNECT USING ONSQLMUX PROTOCOL, 4 BYTES OF CORRUPTION CAN CORRUPT MEMORY YIELDING RANDOM SERVER FAILURES
IT20536ERROR 32504 REMOTE OPERATION NOT ALLOWED WHEN DOING A REMOTE QUERY AFTER ANOTHER SESSION CHANGED INDENTITIES
IT20537QUERY PLAN CHANGED AFTER UPGRADE FROM IDS 12.10.FC4 TO 12.10.FC7
IT20579ONMODE -K HANGING, THEN ONCLEAN -K AND RESTART WOULD LEAD TO SAME INSTANCE RUNNING TWICE
IT20684MUTEX RELATED MEMORY LEAK IN MT POOL





Related Information

[{"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":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"12.1","Edition":"Enterprise","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
17 June 2018

UID

swg27049826