| APAR ID |
Abstract |
| DT417605 |
Query with 'set environment implicit_pdq 1' gives an error : 768: Internal error in routine compute_op_mem: operator not in phase. |
| DT418591 |
-21569 should be known for legacy clients |
| DT419064 |
update stats low on the same table in parallel can lead to an infinite block of the affected sessions |
| DT419719 |
Potential for instance hang when many ER data sync resolver threads are waiting for spin lock |
| DT420113 |
insert with a cast from character to clob writes into SBSPACENAME and not into the sbpace which is specified in the PUT clause |
| DT420192 |
Using the NO_SUBQF environment variable in an SPL environment is inconsistent. |
| DT420448 |
DRDA: In a DRDA session, the "Run Time" in onstat -g his always shows 0.0000 when the query needs to send rows back. |
| DT421275 |
Assert Failure from sysmaster query using sys_ra_act_daemons pseudo table |
| DT421298 |
WRONG NAME USED TO REGISTER THE 64-BIT ODBC DRIVER |
| DT421367 |
In the sch_tasks.sql file $INFORMIXDIR/etc/sysadmin/sch_tasks.sql, there is an error in the function definition. A threshold with name "REQUIRED LEVEL BACKUP" is (attempted to be) selected as "REQUIREDLEVEL BACKUP". |
| DT421545 |
JDBC 4.50 Driver fails with IDS 15.0 for DatabaseMetadata.getProductVersion() method. |
| DT421753 |
SERVER FAILS IN TLSETOBJ WHEN RENAMING CONSTRAINT INSIDE A PROCEDURE |
| DT423220 |
Potential for assert failure on remote secondary Server during connection establishment |
| DT423234 |
AF in conby_addcoltotab in CTE SQL using WITH session shows -522 |
| DT424520 |
WHEN RUNNING MULTIPLE STATEMENTS, A RECORD IS INSERTED INTO SYSTABAUTH FOR A TABLE THAT DOES NOT EXIST IN SYSTABLES |
| DT425325 |
A large, poorly written IN clause may cause memory corruption. |
| DT426148 |
Users other than informix or dbsa are still able to connect to the server in Single-User mode if ADMIN_USER_MODE_WITH_DBSA is set to 1. |
| DT426753 |
Assert Failed: Dropping wrong TBLSpace, requested 14904545 != actual 14904544 |
| DT435915 |
Windows: An ontape backup will hang after completion if the total number of characters for the names of the dbspaces is too large. |
| DT436445 |
Potential for Assert Failure from sysmaster query using sysnetworkio pseudo table |
| DT436660 |
Assert Failed in ASF_FreeSqlhOptions |
| DT436661 |
RSS_Recv thread on RSS server can assert while submitting the readahead request |
| DT437174 |
UPDATE STATISTICS HIGH ... FORCE on a fragmented table with an index and many rows, does not update distribution. |
| DT438133 |
The command "onstat -g prc -r 1" fails with "Unable to open input file '1'" |
| DT438197 |
Table with more than 63 sbspaces in the PUT clause can be created, but after it is created no DMLs/DDLs are allowed due to exceeding a limit of 63 sbspaces. |
| DT438564 |
Assert Fail while executing a query that includes MOD() and has an argument passed as a host variable. |
| DT439132 |
ODBC WITHOUT GL_USEGLU FAILS TO CONNECT WITH ERROR 'UNABLE TO LOAD TRANSLATION DLL' |
| IP24410 |
CLIENT HANGS WHEN USING OPENSSL CONNECTIONS IN PROXY MODE |
| IT33091 |
ONSTAT -G RSS COUNTERS OBSERVED TO WRAP BECOMING NEGATIVE VALUES |
| IT34595 |
IFXRESULTSETMETADATA.PARSETABLENAME() NOT PARSING COMMENTS PROPERLY |
| IT40709 |
SELECT FIRST MAY CHOOSE A BAD QUERY PLAN |
| IT40850 |
WITH CDR_MEM 2, VARYING ASSERTS AND MEMORY BLOCK HEADER CORRUPTION ON CDR TARGET |
| IT41108 |
HQ USER INTERFACE TRYING TO CONNECT TO HQ SERVER ON AIX VIA HTTPS CAN FAIL WITH SSL_ERROR_NO_CYPHER_OVERLAP |
| IT41512 |
PSM IGNORES VARIABLES IN PSM_ACT_LOG / BAR_DEBUG_LOG |
| IT41666 |
PSM_DBS_POOL & PSM_LOG_POOL ENV VARS NOT WORKING AS EXPECTED |
| IT41666 |
PSM_DBS_POOL & PSM_LOG_POOL ENV VARS NOT WORKING AS EXPECTED |
| IT41933 |
THE DIRECTORIES WHERE BTS_TRACEFILES CAN BE WRITTEN SHOULD BE EITHER CONFIGURABLE OR LIMITED TO SOME DIRECTORIES |
| IT42257 |
EW CHUNKS AND THEIR SPACES LOSE THEIR BIGCHUNK FLAGS ON INSTANCES NEWLY CREATED USING IFXCLONE |
| IT42679 |
SYSADMIN TASKS FAILING WITH SQL ERROR -217 |
| IT42925 |
ONLOG -D LTAPEDEV CAN FAIL WITH "COULD NOT LOCATE REQUESTED LOG UNIQID. PROGRAM TERMINATED." ON SOLARIS 11.4 |
| IT43052 |
HQ SHOULD PROVIDE DROP CONSTRAINT OPTION |
| IT43371 |
HQ USER INTERFACE SHOULD EXCLUDE STORED PROCEDURES FOR DATABLADES IN SCHEMA MANAGER-> STORED PROCEDURES |
| IT43659 |
RESTORE USING RESTORE_FILTER FAILS WITH SYSTEM ERROR 232. |
| IT44024 |
DBSCHEMA -SS DOES NOT SHOW NEW FRAGMENTS ADDED WITH ALTER FRAGMENT FOR AN INTERVAL FRAGMENTED TABLE |
| IT44167 |
TASKS FROM SYSADMIN DATABASE IN NON TENANT/TENANT WITH SESSION LIMITS MAY FAIL WITH EXCEEDING SESSION LIMITS FOR INFORMIX USER |
| IT44181 |
GETMETADATA().GETCOLUMNS IS RETURNING WRONG TYPE FOR COLLECTION TYPE LIST |
| IT44197 |
BATCH INSERT USING FET_BUF_SIZE HANGS OR CAUSES A SEGV |
| IT44233 |
REBUILD OF SYSMASTER DATABASE DURING INSTANCE STARTUP WHILST SESSIONS ARE CONNECTING MAY RESULT IN ASSERTION FAILURE |
| IT44328 |
"VIEW LAST" SHOULD BE HIDDEN WHILE LOOKING AT THE SERVERDATA TAB |
| IT44424 |
ONSMSYNC IS STOPPING AFTER "SKIPPING OBJECT DBSPACE1 AS ITS NOT FOUND INTO SYSDBSPACES" |
| IT44525 |
INCORRECT ENTRY IN SQLHOSTS FILE AFFECTING RUNNING ER NODES SETUP, AFTER INFORMIX RE-START. |
| IT44526 |
SQL ERROR: -26190 AND -236 ON INSERTING EXTERNAL TABLE FROM A 'TABLE HAVING VERCOLS' |
| IT44530 |
AFTER CREATING "TENANT DATABASE" CONNECTION ATTEMPT FROM "DBACCESS/JDBC" THROWS "-27001 ERROR" |
| IT44831 |
EXECUTING ANY SQL AFTER "CREATE PROCEDURE FROM", WHICH HAS AN ERROR, CAN CAUSE AN ASSERT FAILED IN PARSECMD |
| IT44886 |
CREATING AN EXTERNAL TABLE WILL IGNORE DBMONEY ON FIRST ROW OF OUTPUT |
| IT44896 |
ALTER FRAGMENT DETACH IS STILL RECREATING THE INDEX WHEN INDEX IS FUNCTIONAL INDEX |
| IT45120 |
IF AN INHERITED ALERT IS CLONED, THAT ALERT SHOULD BE AUTOMATICALLY DISABLED FOR THAT SERVER |
| IT45163 |
INSERT TRIGGERS THAT CALL MANY STORED PROCEDURES CAN BE SLOWER AFTER AUTO UPDATE STATISTICS REFRESH |
| IT45177 |
FETCHING THE RESULTS OF XML FOR ER THROWS A CHARACTER TO NUMERICCONVERSION PROCESS FAILED EXCEPTION |
| IT45187 |
INSTANCE RAISES ERROR 9791 OR HANG RUNNING SP ON PRIMARY NODE |
| IT45259 |
MIX OF DELETE/SELECT USING MULTIINDEX SCANS CAN CAUSE IS_EMPTY(&CB->RMCB_RESULT_BUF) MESSAGES |
| IT45303 |
OPTIMIZER CHOOSING A SLOWER QUERY PLAN WHEN JOINING SYSPAGHDR WITH OTHER SMI TABLES IF SYSPAGHDR IS BIG. |
| IT45490 |
TABLES & INDEXES INFORMATION WRITTEN INTO SEARCH BAR SHOULD BE KEPT WHEN "UPDATE INFORMATION" IS RUN |
| IT45492 |
RSCGETCOMPDICTROW: RSREAD FAILED. ISERRNO = 157. COMPRESSION DICTIONARY COULD NOT BE RETRIEVED. |
| IT45533 |
OPTIMIZER NOT USING THE INDEX PATH AND SELECT QUERY KEEPS ON RUNNING AND NEVER RETRIEVES RECORDS. |
| IT45555 |
CERTAIN QUERIES WITH VERY LARGE OR CLAUSE IN THE WHERE BLOCKS THE INSTANCE, CANNOT BE KILLED, MEMORY GROWS |
| IT45556 |
VERY SPECIFIC CONNECT BY QUERY RESULTS IN EXCEPTION IN MAKEIDXFUNC |
| IT45559 |
OVERALL CPU USAGE IN MONITORING GRAPHS SHOW BLUE STRIPES DUE TO USER% BEING GREATER THAN 100% |
| IT45633 |
SELECT GENBSON(TABNAME) FROM TABNAME GIVES ERROR "217: COLUMN () NOT FOUND IN ANY TABLE IN THE QUERY (OR SLV IS UNDEFINED)" |
| IT45635 |
AF IN OPTIMIZER DUE TO RANGE FILTER WITH CHAR COLUMN ON A TABLE PARTITIONED WITH ROUND ROBIN FASHION. |
| IT45733 |
SYSTEM REPORTS -> TABLE EXTENTS: INCLUDE FEATURE TO SHOW AND HIDE THE SYSTEM TABLES |
| IT45842 |
ONUNLOAD FAILURE WRITING TO OUTPUT DEVICE POTENTIALLY CRASHING THE SERVER |
| IT45969 |
IHQ DELETES DEFAULT ROLE WHEN SWITCHING PRIVILEGE FROM CONNECT TO RESOURCE |
| IT45997 |
ASSERT FAILURE IN COPYEXPR WHEN SSC IS ENABLED AND FIRST COLUMN IS ROWID AND ANOTHER COLUMN THAT IS NOT A BUILT-IN DATA TYPE |
| IT46136 |
UNLOAD AFTER 'MERGING BLOB DATA FROM TEMP TABLE' CAUSING ERROR: 9810 / 12097 |
| IT46158 |
RESERVED PAGE TIMESTAMP DISCREPANCY BETWEEN PRIMARY AND SECONDARY SERVER MAY RESULT IN FAST RECOVERY ERROR |
| IT46163 |
ASSERT FAIL WHILE EXECUTING INSERT STATEMENT IN DRDA_SQLCA_DATA |
| IT46173 |
PERFORMANCE -> SESSIONS IS CONFUSING WHEN A SESSIONS HAS MORE THREADS - FOR EXAMPLE BECAUSE OF PDQ |
| IT46179 |
THE OPTIMIZER CHOOSING A SLOWER QUERY PLAN WHEN DATA DISTRIBUTIONS ARE AVAILABLE. |
| IT46210 |
AUDIT EXSP FOR STORED PROCEDURE RUNNING QUERY AGAINST DERIVED TABLE REPORTS PROCID 0 FOR PROCEDURE IN DERIVED TABLE |
| IT46280 |
NEWLY UPGRADED HDR PRIMARY FORGETS ABOUT BEING PRIMARY IF RESTARTED BEFORE RE-CONNECTING TO SECONDARY |
| IT46395 |
MEMORY LEAK OF MTMUTEX BLOCKS IN THE MT POOL WHEN CASTING A ROW TYPE UPDATING A TIMESERIES TABLE. |
| IT46409 |
OS CPU INFO COLUMNS SYSTEM, IDLE AND WAIT SEEM TO BE ONE COLUMN OFF WHEN COMPARED TO THE OS COMMAND THAT IT RUNS |
| IT46441 |
STORAGE -> TABLES & INDEXES -> TASK STATUS -> CLEANUP DOES NOT CLEAN PH_TASK WHEN THERE IS NO MATCHING ENTRY IN COMMAND_HISTORY |
| IT46450 |
JDBC DOES NOT REDIRECT WHEN CONNECTING VIA A GROUP AND THROWS EXCEPTION -761 |
| IT46463 |
UPDATE STATISTICS FOR LARGE FRAGMENTED TABLES OR TABLES USING FRAGMENT LEVEL STATISTICS MAY RUN FOR EXTENDED PERIODS |
| IT46469 |
THERE NEEDS TO BE A MORE MEANINGFUL MESSSAGE GENERATED (INSTEAD OF AN AF FILE) WHEN ATTEMPTING TO ADD A CHUNK WITH A SIZE LARGER THAN THE RAW DEVICE |
| IT46540 |
GSKCRYPT64-8.0.60.1.LINUX.X86_64.DEB AND GSKSSL64-8.0.60.1.LINUX.X86_64.DEB FILES ARE MISSING |
| IT46542 |
SPL FAILS WITH ERROR -103/-346 AFTER UPGRADING TO 14.10.FC11 |
| IT46566 |
ONLINE.LOG SHOWS MESSAGE "FAILED TO OPEN DUMMY UPDATES SQL SCRIPT." AFTER UPGRADING TO 14.10.FC11 |
| IT46571 |
UPDATE STATS ON A SP USING REQEXP DATABLADE DEADLOCKS WITH AUTOREGEXE SCHEDULER TASK ON SP LOCKS |
| IT46575 |
ATTEMPT TO EXTEND A CHUNK WHICH BELONGS TO A TENANT MAY FAIL WHEN THE TENANT IS NOT IN THE CACHE |
| IT46626 |
ASSERT FAILURE IN GET_TRIGVARDATA |
| IT46645 |
AFTER ALTER FRAGMENT ATTACH OPERATION, INDEX FRAGMENT MOVED TO SAME DBSPACE AS TABLE FRAGMENT |
| IT46650 |
NULL VALUE OF JSON ROWDATA IN ASYNCHRONOUS POST COMMIT TRIGGER IS SHOWING A STRING "NULL"(INCLUDING QUOTES) |
| IT46671 |
IF MISSING PAGES CAN BE REPAIRED FOR A SMARTBLOB SPACE, A WARNING INSTEAD OF AN ERROR SHOULD BE REPORTED. |
| IT46679 |
JDBC DRIVER DOES NOT SHOW THE SAME ERROR MESSAGE AS SHOWN IN DBACCESS |
| IT46702 |
CORRUPTION IN GLOBAL MEMORY POOL DUE TO SQL GREATER THAN 16K SIZE COMING FROM DB2 CLIENTS AND IFX_NETBUF_SIZE SET TO 65536 |
| IT46721 |
WINDOWS: MULTITHREAD CONNECTIONS TO AN SSL ENABLED SERVER MAY FAIL WITH A GSK_INVALID_STATE ERROR OR A SEGV |
| IT46738 |
THE CHECK_VERSION SCRIPT THROWS SYNTAX ERROR ON SOLARIS |
| IT46799 |
DBEXPORT SOMETIMES DOES NOT PRINT SPACES, WHICH ARE NEEDED WHEN A CHECK CONSTRAINT IS PRINTED |
| IT46855 |
QUERY PERFORMS SLOWER WHEN OPT_GOAL IS SET TO 0 AS COMPARED TO WHEN OPT_GOAL IS SET TO -1 |
| IT46880 |
OPTIMIZER IS CHOOSING A LESS EFFECTIVE INDEX FILTER WITH 'OR' COMPARED TO 'IN' CONDITION. |
| IT46888 |
INVALID CIPHER USED TO COMMUNICATE WITH OLDER VERSION OF INFORMIX SERVER WITH ONSOCSSL |
| IT46961 |
JDBC THROWS -254 EXCEPTION WITH A UNION IF BOTH SELECTS CONTAIN A MATCHES AND AN ADDITIONAL PARAMETER IS IN THE STATEMENT |
| IT47017 |
CDR_SERIAL PARAMETER NOT ACCEPTED FROM ONCONFIG IN WINDOWS ENVIRONMENT |
| IT47037 |
GETGENERATEDKEYS() RUN INCREDIBLY LONG WHEN OBTAINING THE KEYS FOR A BATCHED INSERT |
| IT47053 |
DEPLOYING AGENT ON REMOTE SOLARIS HOST THROWS "TOO MANY OPEN FILES" EXCEPTION |
| IT47057 |
PERFORMANCE DEGRADATION WITH THREADS WAITING ON DBS_PARTN MUTEX |
| IT47064 |
[POWERPC] ASSERTION FAILURE IN OP_OPINIT WHEN RUNNING PARALLEL QUERIES ON SEVERAL DATABASES. |
| IT47072 |
creating an index on a temp table fails with errors -212/-101 when dbspace in DBSPACETEMP does not exist or can't be used |
| IT47074 |
INVALID CIPHER USED TO COMMUNICATE WITH OLDER VERSION OF INFORMIX SERVER WITH ONSOCSSL |
| IT47079 |
UPDATE OF A ROW AFTER ALTER TABLE CAN LEAD TO VARIOUS ASSERT FAILED WHEN VARCHAR IS INVOLVED |
| IT47084 |
QUERY ON A FRAGMENTED TABLE IS CHOOSING THE SEQUENTIAL SCAN VS INDEX SCAN DUE TO OVERFLOW IN COUNTING TOTAL PAGES IN OPTIMIZER |
| IT47096 |
DELETING TEMP TABLE DURING SESSION CLOSURE CAN LEAD TO A CRASH OF THE INSTANCE |
| IT47100 |
SELECT WITH CONNECT BY IN AN STORED PROCEDURE ENVIRONMENT RESULTS IN A MEMORY LEAK |
| IT47135 |
INDEX OPERATIONS ON A COMPRESSED INDEX/TABLE IN COMBINATION WITH READAHEAD CAN CAUSE MEMORY ISSUES |
| IT47148 |
REMOVE THE REQUIREMENT THAT THE OFFSET OF A CHUNK HAS TO BE A MULTIPLE OF THE DBSPACE PAGE SIZE |
| IT47152 |
A CTE WITHOUT UNION ALL LOOPS FOREVER. LEAKS MEMORY AND CANNOT BE INTERRUPTED. |
| IT47154 |
AFTER HDR SECONDARY IS PROMOTED TO RSS, SYSMASTER:SYSCLUSTER TABLE STILL SHOWS ENTRY FOR OLD HDR |
| IT47162 |
SYSINDICES - PAGESIZE COLUMN IS NOT GETTING UPDATED WHEN INDEX IS MOVED TO A DBSPACE WITH A DIFFERENT PAGE SIZE |
| IT47170 |
ERROR 972/142 WHEN ADDING VARCHAR COL ON PRIMARY CRASHING RSS SECONDARY NODE |
| IT47180 |
UPDATE STATISTICS HIGH FAILS WITH -768: INTERNAL ERROR IN ROUTINE MBMERGE2BIN(): (NSTREAMS 4 + NZEROFRAGS 0) != NFRAGS 2 |
| IT47209 |
ALTER TABLE CAN LEAD TO CORRUPTED DATA FOR THE NEXT SELECT WHEN VARCHAR IS INVOLVED |
| IT47230 |
JDBC: PASSING A NULL LVARCHAR IN A COMPLEX DATA TYPE CAN CAUSE ASERVER ASSERT FAILURE |
| IT47233 |
CDR CHECK REPLICATE -- REPAIR NOT REPAIRING ALL ROWS |
| IT47246 |
TALS.IEM' MESSAGE FILE REMOVED FROM THE MSGFILE GLOBAL STRUCTURE BREAKS COMPATIBITLIY WITH 4GL |