Fix list for Informix Server 12.10.xC16

APAR

Abstract

IT38980

FINDERR.EXE DOES NOT WORK; THROWS APPLICATION FAULT IN WINDOWS EVENT VIEWER

IT42279

ODBC HANGS WHEN FETCHING MULTIBYTE TEXT DATA IF THE ROW IS LOCKED

IT28348

SETTING BAR_DEBUG_LEVEL TO 8 OR HIGHER CAN CAUSE BACKUP TO FAIL

IT30618

SQEXPLAIN QUERY STATISTICS LESS THAN HELPFUL AND INCORRECT WITH RE-EXECUTED PREPARED STATEMENTS

IT32566

DBEXPORT & DBSCHEMA WILL HANG ON AN UPDATABLE RSS NODE CONTAINING SEQUENCES WITHOUT RESTART VALUES AND STOP_APPLY IS ENABLED

IT32917

EXCEPTION THROWN WHEN QUERY WITH NESTED MULTISET COLLECTION IS EXECUTED

IT33161

RESTART LISTEN THREAD AFTER MODIFIED SQLHOSTS CAN ASSERT SERVER DURING REMOTE QUERY

IT33847

ADDING A NEW LARGE CHUNK IN A HDR PAIR WITH EAR DEFINED ON LEADS TO TIMEOUTS AND ROLE SWITCH

IT34407

WINDOWS: "STAT() FAILED FOR CHUNK FILE..." MESSAGES WHILE CREATING A CHUNK LARGER THAN 2GB

IT34812

COMBINATION OF KEYWORD AND SEMICOLON INSIDE RETURN STATEMENT GIVING SYNTAX ERROR

IT35205

SELECT USING "FIRST N" SYNTAX DOESN'T SEEM TO HAVE ESTIMATED COST ADJUSTED CONSISTENTLY POSSIBLY LEADING TO WORSE QUERY PLANS

IT35847

AGGREGATE EXPRESSIONS INCONSISTENCY I.E. MIN(), MAX() WITH UNION

IT36267

IT IS POSSIBLE FOR AN RSS OR HDR SECONDARY TO ASSERT WITH BAD PAGE WHEN UPDATING INDEX PAGE

IT36979

AN ADMIN CKPT IS INITIATED DURING A LEVEL 0 ARCHIVE FOR EACH LOGICAL LOG DROPPED CAUSING HIGH CONTENTION IN ACTIVE ENVIRONMENT

IT37120

CONCURRENT QUERIES USING REVERSE SCAN OF INDEX WITH MANY DELETED ENTRIES MAY ENCOUNTER POOR PERFORMANCE

IT37233

ROLLBACK OF A PAGE ALTER POTENTIALLY CORRUPTING THE PAGE'S SLOT TABLE IF VARCHAR CHANGE INVOLVED

IT37430

CREATE SP WITH A AUTOREG REQUEST TO THE SCHEDULER BLOCK CALLER SESSION AND SCHEDULER BY A LOCK DEADLOCK

IT37790

SELF JOIN WITH COMMITTED READ CAN RETURN WRONG ROWS (TOO MANY) WHEN INSERTS ARE HAPPENING ON TABLE

IT37805

SELECT FOR TABLE CONTAINING BLOBS FAILS AFTER COMPRESSED

IT37866

VARIOUS ASSERTIONS SEEN IN RESTOREROW() ON A NON-LOGGED COMPRESSED INTERVAL ROLLING WINDOW TABLE DURING A ROLL BACK OF WORK

IT37886

ADDING A PRIMARY KEY CONSTRAINT AGAINST AN EXISTING NOT NULL SERIAL UNIQUE INDEX INCORRECTLY PERFORMS INTEGRITY CHECKING

IT38192

ONAUDIT -O -Y DOESN'T SHOW MASKS AFTER SERVER IS UPGRADED FROM 11.50.XC6 TO 12.10.XC13

IT38239

CDR REPORTS NO INSERT WITH FMDELETE FOR ROW WHEN REPLICATING UPDATES ON FRAGMENTED TABLES WHICH MOVE THE ROW BETWEEN PARTITIONS

IT38317

TRUSTED CONTEXT USER IS NOT ABLE TO CONNECT WITHOUT AUTHENTICATION

IT38357

THREADS CAN REMAIN IN CRITICAL SECTIONS FOR EXTREMELY LONG TIMES DURING LOADS INTO UNLOGGED COMPRESSED TABLES

IT38445

CHANGING SIZE OF A VARCHAR COLUMN USING ALTER TABLE TRIMS TRAILING SPACE CHARACTER

IT38546

SEGV AND CORE DUMPED IN ARCHECKER TLR WITH COMMVAULT ON AIX AFTER SUCH NUMBER OF STAGED LOGICAL LOGS

IT38548

INSERT OF STRING W/ ILLEGAL CHARACTER INTO A UTF-8 DATABASE USING ENCRYPT_AES() WORKS, ERROR -202 SELECT WITH DECRYPT_CHAR()

IT38574

USCOLDIST MIGHT NOT YIELD WHICH CAN CAUSE SESSIONS TO HANG WHEN UPDATE STATISTICS HIGH (COL) IS RUN

IT38662

DBACCESS SHOWING MISLEADING WARNING MESSAGE WHILE CLOSING TRANSACTION IN INTERACTIVE MODE

IT38689

LOOPING "WARNING: MT_AIO_WAIT: ERRNO == EINVAL OPERATION = 3" MESSAGE WHEN ADDING RAW CHUNK WHEN SIZE+OFFSET IS TOO LARGE

IT38792

ON UPDATABLE SECONDARY - A SELECT FOR UPDATE DOESN'T EXCLUDE ANOTHER SELECT FOR UPDATE ON SAME TABLE

IT38830

COMPLEX QUERY WITH A MIX OF LEFT AND STANDARD JOINS CAUSE -768 IN OPJOIN

IT39101

UNLIKE ON BSON::JSON:LVARCHAR CAST RETURNS 788 UNKNOWN OPERATOR/TYPE IF CLIENT_LOCALE OR DB_LOCALE IS SET TO EN_US.UTF8

IT39149

SELECT WITH PDQ AND SUBQUERY CAN PRODUCE WRONG RESULTS

IT39150

CONNECTION MANAGER CAN FAIL TO CONNECT WHEN CONNECTING TO A SLA WITH SERVER GROUP DEFINTION AND TARGET HAS MULTIPLE NAMES

IT39202

874 GENERAL EXCEPTION ERROR HAS OCCURRED IN THE OPTIMIZER

IT39316

A CHUNK ADDED WITH STORAGE PROVISIONING IS NOT NOT ROLLED BACK ON THE SECONDARY WHEN IT WAS A LONG TRANSACTION

IT39508

QUERY WITH FUNCTIONAL PREDICATE WITH LIKE OPERATOR DOES NOT USE FUNCTIONAL INDEX AT ALL

IT39576

ASSERT FAILURE AND CRASH OF MSC VP ON SOLARIS 11 WHEN CONNECTINGVIA PAM WITH LDAP

IT39672

POTENTIAL PERFORMANCE PROBLEM WITH LARGE TRANSACTION BEING COPIED TO ER SEND QUEUE

IT39814

TABLE LEVEL RESTORE FAILURE ON TABLE WITH DIFFERING IN-PLACE ALTER HISTORY BETWEEN ITS FRAGMENTS

IT39943

THREAD ON PRIMARY OF HDR PAIR CAN HANG IN CDRLSQN_WAIT WHEN DRINTERVAL 0 AND HDR_TXN_SCOPE NEAR_SYNC

IT40113

SYSPROCPLAN MAY SEE HEAVY ACTIVITY

IT40137

MEMORY LEAK IN THE SCHEDULER ATTACHED EXE SAPI MEMORY POOLS WHEN THE USED STATEMENTS NEED TO BE REPREPARED

IT40280

SQL ERROR (-19819): AN ON CLAUSE HAS AN INVALID TABLE REFERENCE

IT40336

PERFORMANCE PROBLEM FOR PDQ QUERY USING A SUBQUERY

IT40469

STACK OVERFLOW POSSIBLE ADDING INDEX TO A TEMP TABLE DURING SUBQUERY OF QUERY WITH MANY UNIONS

IT40798

ROLLBACK OF DELETE WHEN TABLE IS ALTERED BEFORE WILL CORRUPT THE FUNCTIONAL INDEX

IT40805

AF ON RSS SERVER AFTER UPGRADE FROM 11.70 TO 14.10.FC6

IT40842

IF SHMTOTAL IS SET TOO SMALL, NO DEFAULT BUFFERPOOL SIZES WILL BE DECREASED, BUT NO MESSAGE EXPLAINS THIS

IT40848

UNIQUE INDEX BUILD CAN FAIL WITH -316 ERROR WHEN CREATE TABLE WITH ERKEY OR ALTER TABLE ADD ERKEY

IT40864

ERROR -768 ON TABLE WITH COUNT OF ROWS > MAXINT

IT40947

INCORRECT NEXT EXECUTION FOR A NEW SCHAPI ADMIN TASK

IT40986

ENHANCEMENT FOR CHECKPOINT PROCESSING

IT41196

DROPPING AN EXTERNAL TABLE IN A STORED PROCEDURE CAN FAIL WITH -214/-106 WHEN IT IS RUN WITH PDQ

IT41349

With DRINTERVAL 30 or more we get -242/-154 error in online.log when Auto Update Statistics Evaluation task is run.

IT41351

HASH JOINS REQUIRING OVERFLOW NOW FAILING WITH -208

IT41439

REPEATED CALLS ON SECONDARY SERVERS TO RETRIEVE NON-EXISTENT QUERY DEPENDENCY PLAN MAY LEAD TO REDUCED PERFORMANCE

IT41587

COMMAND "CDR LIST CATALOG -R" SHOULD INCLUDE OPTION "--ERKEY" IF THE REPLICATE WAS CREATED WITH THAT OPTION

IT41598

768: INTERNAL ERROR IN ROUTINE OPJOIN() WHEN USING OUTER JOINS

IT41844

ONSMSYNC EXITS WITH 0X3 (ABORTED) WHEN EXPORTING CLOUD (AWS) WITH SPLIT OBJECTS INTO MULTIPLE PIECES.

IT41880

SET ENVIRONMENT IFX_FOLDVIEW IS NOT SPECIFIC TO A SESSION

IT42122

IFXCLONE IS CHANGING DIRECT_IO WITHOUT FURTHER NOTICE

IT42151

COLLECTING BEFORE IMAGES DURING A BACKUP NOT PREPARED FOR BEFORE IMAGE PARTITION REACHING ITS MAXIMUM SIZE

IT42227

UPDATE OF TABLE WITH TEXT COLUMN FAILS WITH ERROR -346/-124 WHEN NUMBER OF ROWS UPDATED IS LARGER THAN 32767

IT42252

EXECUTING A PREPARED STATEMENT OF MANY INDIVIDUAL INSERTS HAVING INSERT TRIGGERS CAN ASSERT IN UDRLM_EXEC_ROUTINE

IT42269

SESSIONS MIGHT SLIP THROUGH SESSION_LIMIT_MEMORY CHECK AND GROW FURTHER WITHOUT BEING TERMINATED

IT42285

AF GENERATED WHEN USING GROUP BY FOR SELECT QUERY WITH GENBSON FUNCTION

IT42348

SESSION_LIMIT_MEMORY SESSION IS TERMINATED EVEN NOT REALLY REACHING DEFINED LIMIT IN A SIMPLE QUERY WITH GROUP

IT42379

ONMODE -D STANDARD ON A PRIMARY WITH AN INCORRECTLY DEFINED HDR SECONDARY HUNG FOREVER

IT42399

ASSERT WARNING RAISED DURING ROLL FORWARD OF BTSPLIT LOG RECORD

IT42699

MANY ATS/RIS FILES MIGHT GENERATED WHEN TABLE ARE CREATED WITH ERKEY AND WITH REPLCHECK

IT42728

SYNTAX ERROR RUNNING REMOTE QUERY WITH SYNONYMS AND FUNCTION NVL

IT42767

ASSERT FAILED: YIELD_PROCESSOR: CONDITIONAL LATCH COUNT NON-ZERO ERROR

IT42794

OPTIMIZING A STATEMENT NEXT AFTER A FAILED PREPARE OF A MULTI-STATEMENT INSERT FAILED IN OPINIT

IT42883

LBAC: ANSI JOIN WITH A TRIM ON BOTH SIDES ON THE ON CLAUSE EXECUTED AS HASH RETURN UNEXPECTED RESULT SETS

IT43206

LAG() AND LEAD() OLAP RANKING FUNCTIONS CORRUPTING LARGER RESULT SETS WITH IGNORE NULLS

IT43266

QUERY RUNS SLOW WHEN A FILTER ON A TABLE USES A HOST VARIABLE WITH A DATE FUNCTION OVER A DATETIME COLUMN IN STRING FORMAT

IT43294

INCREASE IN GLOBAL MEMORY POOL USAGE WHEN RECEIVING MANY FRAGMENTED NETWORK DATA PACKETS

IT43422

SELECT CHOOSING SLOWER QUERYPLAN IN 14.10. THEN IN 11.50 - RELATED TO MULTI INDEX SCAN

IT43446

SQLEXEC CAN HANG USING UPPER() WITH TURKISH SPECIAL CHARACTER

IT43466

A STORED PROCEDURE IN A VIEW'S QUERY WHERE-CLAUSE FILTER IS RE-OPTIMIZED FOR EACH ROW IN RESULT SET

IT43562

A THREAD CAN CONSUME 100% CPU UTILIZATION IN A SOCKET BACK FLOW SCENARIO LOOPING SEND() CALLS

IT43578

AF IN OPLOOKSUBQ DURING PREPARE OF MULTIPLE SQL STATEMENT WHICH INCLUDES SET ENVIRONMENT AND SSC IS ENABLED

IT43586

A THREAD CAN FAIL IN STMP_CHOOSEDBS_INTERNAL AFTER DROPPING A TEMP DBSPACE THAT EXISTS IN ENV DBSPACETEMP