IBM Support

Fix list for Informix Server 12.10.xC14

Release Notes


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 versions 12.10.xC14. 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 Pack 12.10.xC14

Fix release date: 12th March 2020

Status: Recommended

Download information

APAR

ABSTRACT

IT22084

OPTION WHEN GENERATED IN RESPONSE UNIX_INSTALLTYPE_SELECT=LEGACY NOT TAKEN WHEN RESPONSE FILE USED WITH SILENT INSTALL RESULTING IN RUNASROOT.INSTALL SERVER SCRIPIT BEING REMOVED

IT26765

AFTER SYSPURGE() EXECUTES IN 12.10.XC12, THE NEXT NEW FRAGMENT IN A ROLLING WINDOW IS CREATED IN THE FIRST DBSPACE OF THE STORE IN() CLAUSE

IT28302

ONSMSYNC DOES NOT INCLUDE NEEDED LOGICAL LOG FILE IN EXPORT OBJECTS AND FAILS

IT28328

ONSTAT -G SES / -G SQL ON A SESSION CAN LOOP ENDLESSLY WHEN PRINTING OUT 'CURRENT SQL STATEMENT (#) IN PROCEDURE'

IT28345

INFORMIX LOADER DOMAIN FILE /VAR/ADM/IFX_LOADER_DOMAIN IS NOT GETTING CREATED AUTOMATICALLY

IT28378

RPM INSTALL DOES NOT CREATE $INFORMIXDIR/TMP DIRECTORY

IT28753

MGM MUTEX CONTENTION IN NON PDQ ENVIRONMENTS

IT28941

SELECTING SBLOB BSON DATA CAN RETURN -937 ERROR BSON_TO_CHAR: MI_LO_TO_BUFFER RETURNED XXX, BUT THE UDT HAD YYY BYTES

IT28948

MOVING A HDR SECONDARY TO BECOME A PRIMARY CAN SHOW VERY LARGE OR NEGATIVE VALUES IN COMMITED AND ROLLEDBACK

IT28963

ERROR -212/-21522 TRYING TO USE CREATE INDEX ONLINE WHEN ONE OF THE KEYS OF THE INDEX IS OF TYPE BOOLEAN

IT28967

USER GRANTED DBA PRIVILEGE CANNOT GRANT / REVOKE INDIVIDUAL TABLE LEVEL PRIVILEGE WITH ERROR -302

IT29067

A QUERY WITH MANY JOINS CAN POTENTIALLY RUN FOR MANY SECONDS WITHOUT YIELDING

IT29092

BSON_OBJECT_TO_JSON - ERROR=-1263 FOR DATETIMES BEFORE 1969

IT29095

DBACCESS MAY THROW ERROR "34389 ILLEGAL CHARACTER" EVEN IF ALL CHARACTERS ARE VALID

IT29102

IF XYUNITS IN A SPATIAL REFERENCE SYSTEM IS INCREASED WHEN DATA DISTRIBUTIONS EXIST, OPTIMIZER MAY FAVOR SPATIAL INDEX TOO MUCH

IT29118

RUNNING A QUERY AGAINST A SYNONYM CREATED ON A REMOTE TABLE FAILS WITH ERROR -1218 IF DBDATE OF LOCAL AND REMOTE INSTANCE DOES NOT MATCH

IT29164

AN INSERT HANGS WHEN USING EXTERNAL TABLES WHICH USE PIPES AND THERE ARE NOT ENOUGH FIFO THREADS EXISTING

IT29185

INSERT/DELETE MIX ON COMPRESSED INDEX CAN CAUSE "OFFSET >= CS->BC_KEYSIZE && OFFSET <= CS->BC_SLOTLEN" MESSAGES

IT29198

710 ERROR ON RENAME DBSPACE IN PARALLEL WITH INSERTS ON TABLE WITH TRIGGER

IT29229

CONNECTION MANAGER MAY DISCONNECT FROM DATABASE SERVER WHILE ARCHIVE IS RUNNING

IT29239

SPURIOUS AND PERMANENT ERROR -106 (NON-EXCLUSIVE ACCESS) POSSIBLE

IT29319

ONPERF MAY FAIL TO START CORRECTLY ON AIX

IT29330

ROLLFORWARD OF DEFRAG LOGICAL LOG ENTRIES CAN CAUSE ERROR 104 IN REPLAYING DFEND ENTRY

IT29376

SET ENCRYPTION PASSWORD AND CALLING ENCRYPT_AES IN PROCEDURE FROM TRIGGER STORED PROCEDURE CAN ASSERT

IT29437

PRIMARY STORAGE MANAGER (PSM) ONSMSYNC EXPIRING BACKUP OBJECTS FAIL WITH XBSA ERROR: (BSAQUERYOBJECT)

IT29448

ONCHECK -PT ON A NON EXISTING TBLSPACE IN A TEMP DBSPACE THROWS AN ASSERT FAILURE

IT29479

A SELECT OF A VARCHAR(255) COLUMN WHICH USES CASE AND CONCAT WILL FAIL WITH ERROR 9628: TYPE (VARIABLE UDT, XID = 0) NOT FOUND

IT29510

MASSIVE RALLOC MEMORY GROWTH WHEN EXECUTING IMMEDIATE BUFFER WITH MANY INSERTS ON TABLE WITH INSERT CURSOR

IT29512

-710 CAN STILL OCCUR WITH PREPARED SPL CALLS WHEN ALTERING A TABLE HAS FAILED

IT29532

SYSMASTER:SYSSESSION RECORD MISSING

IT29534

CHECKPOINT MAY HANG FOREVER WITH CONCURRENT PARALLEL INDEX BUILD

IT29584

959/172 WITH ASSERT FAILURE WHEN CREATING A STORED PROCEDURE

IT29597

SHUTTING DOWN AN INSTANCE USING INFORMIXSERVER DIFFERENT FROM THE ONE USED FOR STARTUP WILL LEAVE SHARED MEMORY SEGMENTS BEHIND

IT29724

RSS HANGS ON CALL TO INVOKE_DEBUGGER()

IT29732

USING BOOLEAN VARIABLE IN SPL CODE MIGHT LEAD TO 2 THREADS TRYING TO ALLOCATE FROM THE SAME HEAP

IT29754

ERROR 254 WHEN RUNNING A PARAMETERIZED QUERY

IT29761

ERROR: SQLCODE: -872 ISAM:0 WHEN CREATING A TABLE WITH RANGE FRAGMENTATION USING GRID

IT29845

SERVER RETURNS CASE AS A LVARCHAR INSTEAD OF CHAR

IT29860

SMARTTRIGGER: PUSH DATA STOPPED WHEN A CERTAIN TRANSACTION SET HAPPENED

IT29861

CHECKPOINT DECISION IS BASED ON PEAK VALUES WHICH LEAD TO CHECKPOINTS AT LOG SWITCHES WHICH DO NOT NEED TO BE

IT29886

ONPLOAD LOADING EMPTY FILE NOW RUNNING ONTO FAILPOINT 14112, STILL CONTINUING LOAD AND RETURNING SUCCESS

IT29905

ASSERT CRASH SEEN IN SBT_DEACTIVATE_BEGIN OR SNOOPSESS_DTOR, MT_CLEAR_MUTEX WHEN RUNNING CDC AND CHANGING TO SINGLE USER MODE

IT29960

INDEX BUILD CAN HAVE BUFFERS X LOCKED FOR A LONG TIME, INCREASING FLUSH DURATION OF NON-BLOCKING INTERVAL CHECKPOINTS

IT29968

WINDOWS: CRASH WHEN DOING A TRUSTED CONNECTION

IT30008

XML QUERY ERRORS ON AIX PLATFORM

IT30021

EXECUTE QUERY THAT CREATES AN AUTO FUNCTIONAL INDEX IN A TRANSACTION THAT IT HAS NOT PREPARED WILL SEGV IN IS_MULTIROW_UDR

IT30026

UNLOADING A BLOB WHICH EXCEEDS FILE SIZE LIMITS FAILS WITH -408

IT30028

SEGV AND -172 INSERTING NULL INTO BSON FIELD INDEXED BY FUNCTIONAL BSON INDEX USING BSON_GET()

IT30035

HARD TO INTERREPT "ONSTAT -G HIS" FOR TRIGGERS AND STORED PROCEDURES (SPL) AS WE JUST SEE "COMPILED STATEMENT" & "EXEC PROCEDURE"

IT30226

SERVER ASSERT FAIL IN UDTLOAD RUNNING QUERY WITH GETELEM AND NESTED TSROLLUP

IT30280

-324 AMBIGUOUS COLUMN IN ORDER BY NOT USING ALIAS FROM PROJECTION LIST OF DERIVED TABLE

IT30297

TIMESERIES DATA USING ROLLING WINDOW CONTAINERS: QUERY NOT RETURNING CORRECT RESULTS UNDER CERTAIN CONDITIONS

IT30314

DBIMPORT CAN FAIL WITH “537 - CONSTRAINT COLUMN IFX_REPLCHECK NOT FOUND” WHEN TABLE HAS IFX_REPLCHECK COLUMN

IT30339

FIRST CLAUSE USED IN QUERY TO INSERT ROWS IN EXTERNAL TABLE WORKS ABNORMALLY

IT30342

MEMORY BLOCK HEADER CORRUPTION MAY OCCUR WHEN A SELECT CURSOR IS RE-OPENED

IT30359

WITH USELASTCOMMITTED SET TO "ALL" ONSTAT -K SHOW LOCKS WITH OWNER '0'

IT30385

INSERT A TEXT BLOB FROM AN EMPTY FILE INTO A COMPRESSED TABLE RETURNS -605/102

IT30414

AFTER UPGRADING TO SOLARIS 11.4 ONPLOAD FAILS RANDOMLY WITH -25590 DUE TO SIGALRM FROM CONNECTION TIME-OUT

IT30441

ASSERT FAILURE IN READAHEAD THREAD ON SECONDARY SERVER FOLLOWING TRUNCATE TABLE OPERATION

IT30460

SYNTAX ERROR -201 FOR REMOTE SQL CONTAINING DECODE/CASE EXPRESSION WITH PROJECTION/HOST VARIABLE REFERENCE

IT30468

QUERY RUN IN SPL IS MUCH SLOWER COMPARED TO QUERY RUN IN DBACCESS

IT30544

INSERT INTO A COLLATION IN A STORED PROCEDURE LEADS TO WRONG ROWSIZE CALCULATION AND AN ALLOCATION OF MEMORY IN 4GB RANGE

IT30593

EXECUTING SUBSTR WITH LENGTH ARGUMENT EVALUATING TO 0 INSIDE SPL RESULTS IN INTERNAL ERROR -1812

IT30622

PTMAP ASSERT CAN OCCUR ON TH_TMP_PREIMAGE WITH LOW TEMP SPACE DURING ARCHIVE AND SMART BLOB UPDATES

IT30685

QUERY AGAINST VTI TABLE USING TODAY KEYWORD WITH PLUS OR MINUS CAUSES ASSERT FAILURE

IT30686

CLOUD: A SECOND ATTEMPT TO BACKUP TO AMAZON S3 WITH BACKUP OBJECT > 5 GB FAILS.

IT30687

ASSERT FAILURE / -874 : GENERAL EXCEPTION ERROR HAS OCCURRED IN THE OPTIMIZER WHEN EXISTS CLAUSE USED WITH TIMESERIES VTI TABLE

IT30688

12.10 CHOOSES SEQUENTIAL SCAN OVER INDEX AS IN 11.70 IF DS_TOTAL_MEMORY / DS_MAX_QUERIES QUANTUM < 3700KB ON NON-PDQ QUERY

IT30714

JVM EMBEDDED VERSION ON INFORMIX 12.FC12W1 BEING TAGGED OUT-OF-DATEI

IT30736

STORAGE PROVISIONING MIGHT SKIP STORAGE POOL ENTRIES DEPENDING ON SIZES AND VALUE STORED IN SP_THRESHOLD

IT30737

392: SYSTEM ERROR - UNEXPECTED NULL POINTER ENCOUNTERED.

IT30876

DEADLOCK BETWEEN RSS_SEND AND DR_PRSEND THREADS USING DRCB_NODE_COUNT_LOCK AND RELIABLECV_T CONDITION

IT30877

UPDATE STATS LOW USING SAMPLING CAN CAUSE -NAN VALUES IN SYSFRAGMENTS AND SYSINDEXES IN INDEX WITH FOT

IT30893

WHEN CALLING BTS IN SPL, IT THROWS ERROR --(BTS22) - BTS ERROR - BTS_CONTAINS REQUIRES AN INDEX ON THE SEARCH COLUMN

IT30915

RUNNING BUILTIN UDR EXPLAIN_SQL CAN ASSERT IN VARIOUS XML ROUTINES WITH LARGER WHERE IN CLAUSE

IT30917

SLOW-ALTERING A TABLE WHOSE INTERNAL SERIAL COUNTER WENT NEGATIVE WILL RESET THE SERIAL COUNTER TO 1

IT30932

INTERRUPTION OF A LIGHT APPEND CAN CAUSE SEGV IN LA_DEALLOC() DURING CLEANUP DUE TO WRONG OR NULL PARTP

IT30983

ON LINUX X86-64, SERVER CAN ASSERT INITIALIZING KAIO WITH -22 EINVAL FROM IO_QUEUE_INIT

IT30993

QUERY CAN CAUSE SEGV ASSERT IN FIXCOLEXPRS DURING OPTIMIZATION

IT31010

BITMAP CHANGES FROM PAGE ALTERS ARE NOT RECOVERABLE AND WOULD ALSO NOT MAKE IT TO SECONDARIES

IT31056

CLUSTER RELATED ONSTATS MISSING OR CONFUSING HDR_TXN_SCOPE SETTINGS

IT31090

SIMPLE EVALUATION ERRORS ON A SINGLE REPLICATE CAN FORCE ALL OF ER TO SHUT DOWN

IT31106

SPL + ROW TYPE = ODD BEHAVIOR

IT31170

-7470 WHEN USING GENXMLELEMCLOB() AND GROUP BY

IT31174

ONSTAT -L DOES NOT SHOW LF_ARCHIVED AND DOES NOT SHOW AR_PROTECT_LOG

IT31201

INDEX PAGE LOGGING (IPL) - ASSERT FAILED: NO EXCEPTION HANDLER

IT31222

EXCESSIVE MEMORY CAN BE ALLOCATED BEYOND SHMTOTAL WHEN LOW_MEMORY_MGR IS SET

IT31226

USING DETACHABLE SMARTTRIGGER ACCESSED BY MULTIPLE SESSIONS IN PARALLEL MAY CAUSE ASSERTION IN CDRPUSH_DEREGISTERSESSION_INT

IT31252

RSS SERVER UNABLE TO CONNECT AFTER RESTART OF THE PRIMARY SERVER WITH MESSAGE "SERVER IS NOT DEFINED AS AN RSS NODE." IN THE ONLINE.LOG

IT31293

ASSERT FAILURE AND CRASH MAY OCCUR WHEN HANDLING INVALID CHARACTERS IN MULTI-BYTE LOCALES

IT31417

HASH JOINS LEADING TO VARIOUS FAILURES

IT31418

READAHEAD POOLS (RA_REQ_TID_REQID) MIGHT REMAIN AFTER RUNNING "AUTO UPDATE STATISTICS EVALUATION"

IT31495

SHARED MEMORY SEGMENTS LEFT BEHIND IF SECONDARY GOES DOWN BECAUSE OF CONFIG MISMATCH WITH PAIRED SERVER

IT31499

EXECUTING AN EXPRESSION WITH SUBQUERY IN AN UPDATE TRIGGER ON LBAC TABLE CAUSES -768 MISSING LBACENFORCE

IT31506

RUNNING A SPECIFIC QUERY RETURNING IN MEMORY CORRUPTIONS, INVALID MUTEX TYPES OR AN EXCEPTION IN GROUPCOPYFUNC

IT31594

SELECT WITH GROUP BY AND AGGREGATE CONTAINING DECODE() FUNCTION FAILS WITH -294

IT31630

AIOCB_MAX SHOULD BE INCREASED.

IT31632

INSTALLING IDS 12.10.FC13WE FAILS WITH THE ERROR MESSAGE: "BRAND.EXE DOES NOT WORK ANYMORE"

IT31642

SEGV ASSERTION ON UPDATABLE SECONDARY IN PROXYWRITEPOSTDDL AFTER "CANNOT INITIALIZE LINEARIZATION MODULE" IN MSGPATH FILE

IT31658

OPENING VERY LARGE INDEX PARTITION CAN CRASH IN KYSTATS_ALLOC()

IT31694

ON WINDOWS, LOSING TRACK OF A CPU VP'S NUM_READY_THREADS CAN BURN 100 CPU CYCLES ON OTHERWISE IDLE SYSTEM

IT31709

SESSION MEMORY GROWTH IN RALLOC WHEN RUNNING INSERTS WITH CASE EXPR IN A LOOP INSIDE OF A SP/TRIGGER ENVIRONMENT

IT31726

EXECUTE FUNCTION (...) INTO <COLUMN>, WITHIN A TRIGGER ACTION, BROKEN IF MEDIUM OR HIGH LEVEL SQL TRACING IS ON

IT31743

ONTAPE RESTORE WILL FAIL IF BEING DONE USING A FILE OR VIA STDIO, IF NOT DONE BY THE INFORMIX USER

IT31744

ASSERTION CRASH WITH STATEMENT CACHE ENABLED IN NEW_EVAL AND FOLLOWED BY VARIOUS OTHER ASSERTIONS AND BAD BLOCKS OR POOLS

IT31807

EXCESSIVE MEMORY USAGE DURING ARCHIVE WHEN CHUNK CONTAINS 0X7FFFFFFF PAGES

IT31851

A CHUNK CAN BE EXTENDED PAST MAX_CHK_SIZE_KB (E.G. CURRENTLY 4 TB ON LINUX), AT WHICH TIME CH_SIZE GOES NEGATIVE AND ALL HECK BREAKS LOOSE.

IT31865

PERIODIC THREAD CAN SEGV CALLING MT_FAST_CLOCK IN BFFINDFREE WHEN LRUS ARE NOT SPECIFIED IN BUFFERPOOL ONCONFIG PARAM

IT31884

ONBAR IS CRASHING WHILE WORKING WITH AMAZON AWS S3 FOR TEMPORARY REDIRECTION ERROR 307

IT31903

WHEN LRU MIN/MAX VALUES ARE CONFIGURED TO VALUES < 1 ON HDR SECONDARIES THEY ARE INCORRECTLY INCREASED TO 1 WHICH GREATLY AFFECTS PAGE CLEANING

Original Publication Date

12 March 2020

Related Information

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","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:
10 March 2020

UID

ibm12801283