| APAR ID |
Abstract |
| IT38039 |
CDR VIEW RISDIR -R ON EXISTING RIS FILES REPORT "PARSE INPUT FILE FAILED:"/"ATS OR RIS FILE FORMAT ERROR" MESSAGE |
| IT38813 |
INFORMIX HQ - SQL EDITOR IS NOT ALLOWING TO RUN MULTIPLE SQL STATEMENTS AT A TIME |
| IT40417 |
COMPRESSION CREATES THOUSANDS OF BACKGROUND TASKS IN PH_TASK |
| IT42994 |
IMPROVE HQ WHEN INFORMIX SERVER IS HANGING IN BLOCKED:LAST_LOG_RESERVED4BACKUP |
| IT41190 |
IWA HAS DEPENDENCY ON LIBXERCES-C-3.1.SO BUT RED HAT 8.5 COMES WITH LIBXERCES-C-3.2.SO |
| IT41511 |
IDS AND CSDK INSTALLERS THROW EXCEPTION ON WINDOWS 2019 OR NEWER |
| IT42080 |
UPDATE STATISTICS CAN FAIL WITH -567/-179 ERROR EVEN WITH PLENTY OF FREE SPACE IN THE TEMP DBSPACE |
| IT42302 |
SERVER CAN ASSERT IN STMP_CHOOSEDBS_INTERNAL IF DBSPACETEMP CONTAINS NON TEMP DBSPACES |
| IT42405 |
EXTENT-LESS PARTITIONS BLOCK THE DROP OF A SEEMINGLY EMPTY DBSPACE |
| IT42519 |
WINDOWS INTERMITTENT MAPVIEWOFFILEEX ERROR, NOT ABLE TO ATTACH TO SHM FROM UTILITIES IE. ONSTAT, ONCHECK DUE TO WINDOWS ASLR |
| IT42662 |
HQ SERVER SHOULD SHOW STORAGE - SPACES - STATUS AS ENCRYPTED WHEN THE DBSPACE IS ENCRYPTED |
| IT30618 |
SQEXPLAIN QUERY STATISTICS LESS THAN HELPFUL AND INCORRECT WITH RE-EXECUTED PREPARED STATEMENTS |
| IT42892 |
SLOW BLOBSPACE BLOB CREATION WITH LARGE NUMBER OF UNCOMMITTED FREED BLOBPAGES |
| IT35313 |
SESSIONS MIGHT SHOW BUFFER AND LOG BUFFER WAITS WHEN A HDR SECONDARY IS STARTING |
| IT43214 |
HQ SERVER DISPLAYS A MISLEADING ERROR MESSAGE AFTER A CONNECTION ERROR |
| IT43213 |
INFORMIX HQ Agent CAN THROW NULLPOINTER EXCEPTIONS |
| IT43028 |
UPDATE STATISTICS CAN FAIL WITH -567/-172 AND ASSERT WARNING: SORT FAILED: TOO MANY ROWS FIT INTO SORT MEMORY |
| IT45223 |
ALTER TABLE REMOVES ROW-LEVEL AUDITING |
| IT43100 |
CREATE BTS INDEX IN PARALLEL CAUSES "BTS: MUTEXES BEING HELD TO END_SESSION CALLBACK" MESSAGES OR INFINITE MUTEX WAITS |
| IT43143 |
SYSTEM SEARCHES EVERY FEW SECONDS FOR A CONNECTION MANAGER AND "MAKES ALARM" ON THE HQ SCREEN |
| IT43185 |
REPLICATION->HIGH AVAILABILITY->CLUSTER TOPOLOGY DOES NOT REFLECT "UPDATABLE" PROPERLY |
| IT43211 |
CREATE INDEX ON TEMPORARY TABLE FAILS WITH 517 ERROR WHEN RUN ON SECONDARY SERVER WITH AUTOLOCATE ENABLED |
| IT43206 |
LAG() AND LEAD() OLAP RANKING FUNCTIONS CORRUPTING LARGER RESULT SETS WITH IGNORE NULLS |
| IT43235 |
INSERT STMT ON VIEW CAN FAIL WITH AF, WHEN RUN AFTER ALTER TABLE ON UNDERLYING TABLE DUE TO OLD COLUMN TYPE IN DATA DICTIONARY |
| IT43242 |
AF RAISED AFTER NEW FRAGMENT ADDED TO A TABLE WHILE RUNNING UPDATE STATISTICS WITH PDQ. |
| IT42809 |
CDR AND SPOOL PROCESSING CAN HALT WITH WAITERS ON CDRGSERIAL MUTEX WHEN ANY CDR STOP REPLICATE |
| IT43290 |
"ARCHECKER FAILED! ERRNO = 3." VERIFYING A BACKUP OF A NON-DEFAULT PAGE SIZE DBSPACE WITH MANY CHUNKS |
| IT43291 |
USING ****** FOR USER AND PASSWORD WILL THROW ASSERT WARNING: WARNING: MT_AIO_WAIT: ERRNO == EINVAL ON AIX |
| IT43293 |
.NET CORE: CALLING GETSTRING() PRIOR TO CALLING GETDATETIME() THROWS INVALIDCASTEXCEPTION |
| IT43306 |
ONSTAT -G BPA CAN BE HUGE, SHOULD BE EXCLUDED FROM BOTH ONSTAT -A AND -G ALL |
| IT43299 |
ALTER FRAGMENT DETACH DOES NOT DELETE INDEX FRAGMENT AND IS ALSO RECREATING THE INDEX WHEN INDEX IS FUNCTIONAL INDEX |
| IT43357 |
DELETE A LARGE AMOUNT OF ROWS FROM AN BTS INDEX IS ALLOCATING A LOT OF VX MEMORY |
| IT43328 |
CDR REPAIR THROWS ERROR IF THE ABORTED TRANSACTION CONTAINS NEWLINE (\N) CHARACTER. |
| IT43422 |
SELECT CHOOSING SLOWER QUERYPLAN IN 14.10. THAN IN 11.50 - RELATED TO MULTI INDEX SCAN |
| IT43426 |
INFORMIXHQ: OPERATING SYSTEM DISK I/O SENSOR ON AIX CRASHES AGENT |
| IT43435 |
ERROR -937 WHEN USING UNLOAD/LOAD ON A TABLE WITH BLOB > 2GB |
| IT43446 |
SQLEXEC CAN HANG USING UPPER() WITH TURKISH SPECIAL CHARACTER |
| IT43478 |
ONSMSYNC CAN FAIL WITH "-535 ALREADY IN TRANSACTION" AFTER A RESTORE |
| IT43492 |
HQ SERVER SYSTEM REPORTS -> TABLE ACTIVITY IS NOT SHOWING USER TABLES |
| IT43499 |
CONNECTING A JAVA PROGRAM TO IDS USING SSL CAN FAIL WITH ERROR "UNSUPPORTED PROCTOCL TLS" WHEN USING IBM SEMERU 11 OR 17 |
| IT43516 |
USE OF GLOBAL SQL TRACE MAY LEAD TO REDUCED PERFORMANCE |
| IT43578 |
AF IN OPLOOKSUBQ DURING PREPARE OF MULTIPLE SQL STATEMENT WHICH INCLUDES SET ENVIRONMENT AND SSC IS ENABLED |
| IT43642 |
CTE SIMPLE SELECT BASED ON AN EXPRESSION BASED TABLE WITH MORE THAN 100 FRAGMENTS GETS STUCK IN TLGETCOLLTAB |
| IT43653 |
VAGUE EXTENT CHECKING ERROR AND EMPTY CHUNK OR DBSPACE "NOT EMPTY" BECAUSE ADMIN API ALLOWS CHUNK SIZE UNALIGNED WITH PAGE SIZE |
| IT43666 |
IDS_INSTALL EXECUTED WITH ROOT FAILS WITH MSG "INSTALLER RUNNING AS INCORRECT USER" IF THE INFORMIXDIR ALREADY HAS IDS INSTALLED |
| IT43676 |
RESTORE POINT AF WITH BAD ALLOCATION SIZE (-268435456) FOR POOL 'RSTPOINT' (0XXXX)), IN (MT_SHM_MALLOC_SEGID) IF A CHUNK IS 4 TB |
| IT43684 |
WRONG OR MISSING INDEX ON CR SHADOW TABLE IF TABLE REPLICATED VIA UNIQUE INDEX RATHER THAN PRIMARY KEY |
| IT43686 |
INSERT MAY RAISE -874 WITH TRIGGER CALLING A STORED PROCEDURE WHICH WILL START ANOTHER TRIGGER |
| IT43688 |
DELETE ON AN EMPTY TABLE CAN FAIL WITH -244/-111 WHEN TABLE IS CREATED WITH AN EXTENT SIZE |
| IT43711 |
SMART TRIGGER EVENT RETURNS ONLY 256 CHARACTERS FOR A LVARCHAR(32000) COLUMN |
| IT43744 |
RESTORE USING CHUNK RENAME OPTION AND RENAMED ROOT CHUNK INCORRECTLY UPDATES ROOTOFFSET |
| IT43752 |
9952 - AGGREGATE WITHIN A ROW IN A SELECT PROJECTION LIST IS NOT ALLOWED |
| IT43830 |
768: INTERNAL ERROR IN ROUTINE WRTMBDIST() WHEN DOING UPDATE STATISTICS BY USER HAVING RESOURCE PRIVILEGE. |
| IT43562 |
A THREAD CAN CONSUME 100% CPU UTILIZATION IN A SOCKET BACK FLOW SCENARIO LOOPING SEND() CALLS |
| IT43844 |
QUERY_TIMEOUT CONSTRAINT GETTING BYPASSED EXECUTING A PLAN-BASED QUERY IN KEY-ONLY AND/OR PARTITIONED MODE |
| IT43898 |
AN ALTER FRAGMENT INIT STATEMENT ON A PRIMARY WILL ALLOCATE LOTS OF LOCKS ON AN UPDATEABLE SDS INSTANCE, CAN LEAD TO A CRASH. |
| IT43904 |
USING THE OLAP LAG FUNCTION WITH A COLUMN NAME AS THE DEFAULT VALUE WILL LEAD TO A 959 ERROR |
| IT43906 |
SELECT WITH A SUB-QUERY GENERATES ASSERT FAILURE ALONG WITH ERROR 874: GENERAL EXCEPTION ERROR HAS OCCURRED IN THE OPTIMIZER |
| IT43728 |
SESSIONS ABLE TO CONNECT DURING FAST RECOVERY MAY CAUSE ASSERT FAILURE |
| IT43984 |
ADD A LIMIT TO THE NUMBER OF ATTEMPTS TO LINK A STATEMENT TO THE SHARED STATEMENT CACHE |
| IT41337 |
SETTING SESSION_LIMIT_TEMPSPACE LIMIT KILLS INFORMIX/DBSA USER SESSION |
| IT44033 |
SMX_PING_INTERVAL SETTING PING MECHANISM CAN BE VERY CPU EXPENSIVE WHEN ELAPSED TIME REACHED CAUSING PERFORMANCE SPIKES |
| IT44034 |
VARIOUS MEMORY CORRUPTION WITH STMT_CACHE AND EXT_DIRECTIVES ARE ENABLED |
| IT44047 |
PERFORMANCE IMPROVEMENTS TO REDUCE WAITS RELATING TO PARTITION OR DBSPACE MUTEX |
| IT44068 |
ER STARTUP FAILURE DUE TO BAD CDR_QDATA_SBSPACE CONFIGURATION POTENTIALLY LEADING TO ASSERTIONS |
| IT44146 |
LONG LASTING PUSH DATA SESSIONS CAN ACCUMULATE LARGE AMOUNTS OF MEMORY EVEN IF CONFIGURED TO DISCARD MOST RECORDS |
| IT44064 |
CREATING OR EXECUTING SOME STORED PROCEDURES CAN ASSERT IN CMPREXPRTREE2 WITHIN SQOPTIM |
| IT44087 |
ROWS RETURNED BY A QUERY WITH MULTISET AND A CONNECT BY - STOPS SOMETIMES CAN ASSERT AND SHOWS AN ERROR |
| IT44076 |
ONCHECK -PE ON TEMP DBSPACES CAN OCCASIONALLY REPORT ERROR:CHUNK FREE PAGES: ###, EXTEND FREE PAGES: ####. |
| IT44113 |
GRANT ADMIN TO USER THAT HAS "-" OR "." RAISES ERROR "FAILED TO ADD USER IDS-USER2 AS AN ADMIN USER" |
| IT44118 |
AN ENCRYPT THREAD CAN LOOP FOREVER IN A RUNNING STATE WHEN ERRNO IS 11 |
| IT44133 |
SET ENVIRONMENT IFX_FOLDVIEW DEFAULT NO LONGER FUNCTIONAL |
| IT44137 |
HQ STORAGE DBSPACE USAGE GRAPHICAL REPRESENTATION IS OVERPOPULATED |
| IT44199 |
EXT_DIRECTIVES ONCONFIG PARAMETER CHANGE IS NOT REFLECTED IN ONLINE.LOG |
| IT44299 |
QUERY RETURNS 768: INTERNAL ERROR IN ROUTINE OPJOIN() WHEN IFX_FOLDVIEW=1 |
| IT44239 |
THE ERROR "SENSOR NOT FOUND" SHOULD ALSO GIVE THE NAME OF THAT SENSOR. |
| IT44264 |
LONG LASTING PUSH DATA SESSIONS CAN ACCUMULATE LARGE AMOUNTS OF MEMORY EVEN IF CONFIGURED TO DISCARD MOST RECORDS |
| IT44348 |
STORAGE -> TABLES & INDEXES: SELECTION OF A DBSPACE IS IGNORED AFTER "UPDATE INFORMATION" |
| IT44376 |
AUS REFRESH REPORTS ERROR 206 FOR ANSI DATABASE TABLE WITH TABLE OWNER IN LOWERCASE LETTERS |
| IT44369 |
.NET CORE: COMMUNICATION LINK FAILURE AFTER DATABASE IS BROUGHT DOWN AND BACK ONLINE |
| IT44371 |
INFORMIXHQ: H2DB EXCEPTION "VALUE TOO LONG FOR COLUMN" WHEN SAVING DASHBOARD |
| IT44867 |
REDUCE CONTENTION ON DDH CHAIN MUTEX FOR OPERATIONS ON SAME DATABASE TABLE |
| IT44460 |
REPLICATESET COMMANDS ASSERT CRASH IN DAC_MODIFY_REPL WHEN SET DEFINED AS EXCLUSIVE. |
| IT44485 |
CDR START' CAN GENERATE ASSERT FAILED: YIELD_PROCESSOR: CONDITIONAL LATCH COUNT NON-ZERO IN THREAD. |
| IT44565 |
ASSERT FAILURE IN SMX PIPE CREATIONS DURING ER STARTUP. |
| IT44604 |
POST COMMIT TRIGGER (ER2SPL): MULTIPLE PROBLEMS WITH ALTER SUPPORT, REMASTER AND (LIFTED) PRIMARY KEY REQUIREMENT |
| IT44609 |
ONSTAT -G SCH CAN CORE DUMP WHILE STARTING THE SERVER. |
| IT44711 |
SOMETIMES THE NUMBER OF ALERTS IN THE ROOT GROUP DOES NOT MATCH THE NUMBERS SHOWN FOR INDIVIDUAL SERVERS |
| IT44715 |
MEMORY LEAK IN RITEM (RSBTREE.C:3914) |
| IT44734 |
TASK 'MODIFY CHUNK EXTENDABLE' MAY RETURN ERROR 'FAILED: STORAGE PROVISIONING - INVALID ARGUMENT' FOR VALID CHUNK NUMBER |
| IT44815 |
CREATING AN INDEX USING UDT COLUMNS LIMITS THE SIZE OF THE INDEX TO 16,775,134 DATA PAGES PER FRAGMENT |
| IT45433 |
A COUNTER IN THE BUFFERPOOL MAY NEGATIVELY AFFECT PERFORMANCE EVEN WHEN BUFFERPOOL IS NOT MARKED AS EXTENDABLE |
| IT44928 |
LIBNCURSES.5 IS NOT LONGER SUPPORTED ON RHEL9 |
| IT44925 |
COLLECTION SUBQUERY RETURNING A LVARCHAR CAN THROW ASSERT FAILED IN CHECK_SUBQUERY_REMAKE |
| IT44934 |
VARIOUS ASSERTION FAILURES SEEN IN FUNCTION STCMPRI WHEN RUNNING A STORED PROCEDURE MORE THAN ONCE |
| IT44984 |
MEMORY CORRUPTION WITH CERTAIN QUERIES CONTAINING SPL THAT UTILIZE LVARCHARS AND FUNCTIONAL INDICIES |
| IT44960 |
ONSTAT -A CORE DUMPS OCCASIONALLY AND CORE FILE DOESN'T SHOW ANY USEFUL BACK TRACE. |
| IT44996 |
SMX4ER PROBLEMS IN LOW FOOTPRINT ENVIRONMENTS |
| IT45029 |
DELETING ROWS FROM TABLE WITH PRIMARY KEY ON 2 VARCHAR COLUMNS LEAKS RITEM POOL MEMORY WHEN DTC CLEANER RUNS |
| IT45048 |
CONTINUAL UPDATE OF SYSPROCPLAN ENTRIES FOR STORED PROCEDURES QUERYING TABLES WITH PARTIAL INDEXES |
| IT45122 |
LOOPBACK PSEUDO SERVER DEFINITION FAILS IF ER SERVER IS A NON-ROOT |
| IT45169 |
ERROR -665 WHEN USING "CREATE OR REPLACE" PROCEDURE ON AN UPDATABLE SECONDARY. |
| IT45250 |
TABLES & INDEXES PAGE IN HQ WHEN ALL DATABASES IS SELECTED IS OPENING MULTIPLE JDBC CONNECTIONS |
| IT45269 |
SPORADIC -908 FROM CONNECTION MANAGER WITH SERVERS PROVIDING LISTENERS FOR DIFFERENT PROTOCOLS |
| IT45391 |
ASSERT FAILURE WHEN USING HASH INDEX AND SPL |
| IT45318 |
POTENTIAL FOR DATA LOSS OR INDEX PROBLEMS IN TABLES LOCATED IN ROOT DBSPACE WHEN EXTENDED RESERVED PAGES ARE IN USE |
| IT45385 |
OR A DRDA CONNECTION, THE IP ADDRESS SHOULD NOT BE RETURNED TO THE CLIENT |
| IT45397 |
SERVER STATUS IS INCONSISTENT IN IHQ |
| IT45413 |
A PRIMARY & RSS CAN STOP TRANSMITTING DATA AND STATUS SHOWS BLOCKED OR BLOCKLOGXMIT |
| IT45420 |
ONSTAT -G CFG SHOWS SEC_LOGREC_MAXBUFS AS DYNAMIC (TUNABLE =*) BUT IT NEEDS RESTART TO TAKE EFFECT. |
| IT45509 |
DBSCHEMA IS STUCK IN "WITH SYSPROCAUTH_CTE..." QUERY APPARENTLY TRYING TO DETERMINE THE STORED PROCEDURE PERMISSIONS STATEMENTS |
| IT45632 |
NEW ER NIF CONNECTION OVER SMX MIGHT HANG IN 'CONNECTING' STATE WITH UNRELIABLE NETWORK |
| IT45626 |
MEMORY LEAK OF OSMUTEX BLOCKS IN GLOBAL POOL WHEN USING REMOTE QUERY WITH PAM ENABLED. |
| IT45593 |
QUERY FAILING WITH -959/-172 IN EV_NULL_FUDT |
| IT45640 |
POTENTIAL PARTITION CORRUPTION WHEN TRUNCATING A TABLE AFTER ALTERING ITS EXTENT SIZE |
| IT45641 |
ASSERT FAILURE POSSIBLE DURING INSERT OPERATION INTO A TABLE WITH AN ACTIVE CREATE INDEX ONLINE OPERATION |
| IT45676 |
A DBSCHEMA OR DBEXPORT WILL HANG IF THE THE DATABASE IS CREATED WITH 8859-2 CODE SET AND CLIENT_LOCALE IS SET TO UTF8. |
| IT45693 |
DBIMPORT IS RETURNING 201 ERROR WHILE IMPORTING A PROCEDURE/FUNCTION WITH CREATE OR REPLACE SYNTAX |
| IT45782 |
GRANTS ON STORED PROCEDURE IS MISSING IN DBSCHEMA OUTPUT |
| IT45843 |
.NET CORE: CONNECTION POOLING IS NOT TAKING INTO ACCOUNT IDLE CONNECTIONS |
| IT45859 |
REPLICATION -> HIGH AVAILABILITY -> SMX INFO IS SHOWING SAME INFORMATION FOR SECONDARY AND PRIMARY |
| IT45985 |
GET_PRODUCT_INDEX() POTENTIALLY CAUSING UNDETECTED STACK OVERFLOW AND MEMORY CORRUPTION |
| IT46185 |
HUGE MEMORY CONSUMPTION USING AN LVARCHAR WITH A LIKE WITHIN A STORED PROCEDURE IN A UTF8 DATABASE |
Informix Enterprise Replication is a powerful way to replicate data assets across distributed installations and keep them consistent.
Customized use of the Admin-Scout thanks to the new role concept
With the ONCONFIG Explorer, Admin-Scout 3.2 offers a completely new module for managing ONCONFIG variables.
The entire storage administration clearly arranged in one module!
Admin Scout 3.2 offers a long-awaited feature: easy comparison of the databases' structures in different instances.
Development
Revised user interface
We asked the question, which areas of an Informix database system have to be administered manually and where is it possible to set up an automated administration? The goal is to achieve increasing automation and independent optimization of the system through an interaction of sensors and tasks.
Already in the last versions many improvements were introduced for the security of the Admin Scout. It was very important for us that during a login no more passwords are transferred between Admin-Scout and the browser.
Important features for cluster configuration and better analysis of instances in a group
The Admins-Scout Dashboard is an extremely powerful and informative tool that gives you an overview of the state of your Informix servers
An Admin-Scout feature for fast analysis of DBSpaces
