Fix list for Informix Server 12.10.xC14

APAR

ABSTRACT

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

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

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

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

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

RPM INSTALL DOES NOT CREATE $INFORMIXDIR/TMP DIRECTORY

MGM MUTEX CONTENTION IN NON PDQ ENVIRONMENTS

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

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

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

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

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

BSON_OBJECT_TO_JSON - ERROR=-1263 FOR DATETIMES BEFORE 1969

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

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

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

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

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

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

CONNECTION MANAGER MAY DISCONNECT FROM DATABASE SERVER WHILE ARCHIVE IS RUNNING

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

ONPERF MAY FAIL TO START CORRECTLY ON AIX

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

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

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

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

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

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

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

SYSMASTER:SYSSESSION RECORD MISSING

CHECKPOINT MAY HANG FOREVER WITH CONCURRENT PARALLEL INDEX BUILD

959/172 WITH ASSERT FAILURE WHEN CREATING A STORED PROCEDURE

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

RSS HANGS ON CALL TO INVOKE_DEBUGGER()

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

ERROR 254 WHEN RUNNING A PARAMETERIZED QUERY

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

SERVER RETURNS CASE AS A LVARCHAR INSTEAD OF CHAR

SMARTTRIGGER: PUSH DATA STOPPED WHEN A CERTAIN TRANSACTION SET HAPPENED

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

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

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

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

WINDOWS: CRASH WHEN DOING A TRUSTED CONNECTION

XML QUERY ERRORS ON AIX PLATFORM

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

392: SYSTEM ERROR - UNEXPECTED NULL POINTER ENCOUNTERED.

DEADLOCK BETWEEN RSS_SEND AND DR_PRSEND THREADS USING DRCB_NODE_COUNT_LOCK AND RELIABLECV_T CONDITION

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

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

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

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

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

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

QUERY CAN CAUSE SEGV ASSERT IN FIXCOLEXPRS DURING OPTIMIZATION

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

CLUSTER RELATED ONSTATS MISSING OR CONFUSING HDR_TXN_SCOPE SETTINGS

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

SPL + ROW TYPE = ODD BEHAVIOR

-7470 WHEN USING GENXMLELEMCLOB() AND GROUP BY

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

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

EXCESSIVE MEMORY CAN BE ALLOCATED BEYOND SHMTOTAL WHEN LOW_MEMORY_MGR IS SET

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

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

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

HASH JOINS LEADING TO VARIOUS FAILURES

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

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

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

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

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

AIOCB_MAX SHOULD BE INCREASED.

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

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

OPENING VERY LARGE INDEX PARTITION CAN CRASH IN KYSTATS_ALLOC()

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

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

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

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

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

EXCESSIVE MEMORY USAGE DURING ARCHIVE WHEN CHUNK CONTAINS 0X7FFFFFFF PAGES

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.

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

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

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