Fix list for Informix 11.70.xC7 and PIDs 11.70.xC7W1, 11.70.xC7W2 and 11.70.xC7W3
Informix provides periodic fixes for release 11.70. The following list is the most recent report of fixes for customer-reported defects in Version 11.70.xC7 and PIDs 11.70.xC7W1, W2 and W3. This report combines both Windows- and UNIX-specific defect fixes.
NOTE: some detail links below have been disabled as they are no longer available.
|
W3 APARs
|
Description
|
| IC85696 | ASSERT WARNING: (PART <= SPTR->NUM_LPARTS) POSSIBLE DURING QUERY EXECUTION |
| IC86642 | WITH PDQPRIORITY SET, THREADS SHOULD NOT BE LEFT IN AN AWAIT_MC STATE AFTER STORED PROCEDURE COMPLETION |
| IC88205 | INSTALLATION ABORTED WHEN UPDATING FROM PREVIOUS IDS RELEASE |
| IC89389 | TABLE LEVEL RESTORE TO EXTERNAL TABLE LOSING FLOAT PRECISION RIGHT OF THE THE DECIMAL POINT |
| IC90419 | UPDATE OF SPATIAL COLUMN SETS ROW LOCKS FOR TABLES WITH LOCK MODE PAGE |
| IC90796 | ALTER TABLE MODIFY FAILS WITH -366. VIEW SEEMS TO CONTAIN INVALID CAST WHICH WAS NOT THERE ON CREATION |
| IC90829 | ON SOLARIS TASK DEFRAGMENT PARTNUM ALWAYS RETURNS ERROR |
| IC90889 | ADDITION OF SHARED MEMORY SEGMENTS USING LARGE PAGES CAN BE SLOW AND MAY BLOCK USER ACTIVITY |
| IC91339 | MULTI-INDEX SCAN ACCESS METHOD REQUIRES 10 TIMES MORE MEMORY THAN FOR USUAL INDEX PATH |
| IC91341 | COUPLING OF INFORMIX WAREHOUSE ACCELERATOR WITH INFORMIX SERVER (SETUPDWA) CAN FAIL WITH ERRNO 18 |
| IC91655 | SQL ERROR 789 OR 208 POSSIBLE FOR STAR JOIN QUERY ON RANGE PARTITIONED TABLE |
| IC91678 | INFORMIX OPTIMISER VULNERABLE TO POOR QUERY RESPONSE TIMES ON INCREMENTING COLUMNS |
| IC91981 | SYSDBOPEN PROCEDURE WILL NOT RUN AS DBA ON HDR SECONDARY |
| IC92020 | ONBAR CAN SILENTLY FAIL TO FORK PROCESSES IF TWO OR MORE COMPLETE AT THE EXACT SAME TIME |
| IC92084 | SERVER CAN CRASH IN NEW_EVAL() WHEN USING STATEMENT CACHE |
| IC92182 | ROLLBACK A DISTRIBUTED TX WITH TEMP TABLES ON TOP OF A COMMIT CAN LEAD TO LOSING CONTROL ABOUT THE TEMP TABLE PARTITIONS |
| IC92232 | THE ALARMPROGRAM IS NOT TRIGGERED WHEN DYNAMICALLY ADDING A SHARED MEMORY SEGMENT |
| IC92487 | METADATA INFORMATION RETRIEVAL OF JDBC DRIVER MAKES ENGINE CRASH BECAUSE OF BUILT-IN FUNCTION GET_DEFAULT_VALUE() |
| IC92520 | RUNNING HPL QUERY GIVES -1266 ERROR WITH VERSION 11.70.FC5 OR 11.70.FC7W1 ON AIX |
| IC92598 | DBEXPORT DOES NOT VALIDATE THE VALUES ENTERED IN OPTION -NO-DATA-TABLES-ACCESSMETHODS |
| IC92606 | SINGLE SIGN-ON (SSO) CONNECTION CAN LEAK MEMORY IN THE GLOBAL POOL |
| IC92632 | ENABLE TASK IN PH_TASK DOES NOT FIRE THE TRIGGER PH_TASK_TRIG_UPDATE_EXEC_TIME AUTOMATICALLY |
| IC92641 | ERROR 768:INTERNAL ERROR IN ROUTINE MINDEXP: MISSING RANGE FILTER; WHEN USING A NULL VALUE IN A BETWEEN CLAUSE USED AS A FILTER WITH A COMPOSITE INDEX |
| IC92717 | SQL MEMORY LEAK WHEN CONCAT STRING OPERATION USES NULL |
| IC92739 | SELECT THAT USES MULTIPLE CONCAT IN SINGLE EXPRESSION CAN MEMORY LEAK AND RETURN BAD RESULTS |
| IC92919 | PAGE CHECK ERROR IN BFPUT, PG_FRPTR > SLOTBEG WHEN ROLLING BACK SOME DELETES ON A LOGGED TEMPORARY TABLE INDEX |
| IC92926 | ARCHECKER -DX DOES NOT CLEANUP ALL TABLES AS IT SHOULD |
| IC92934 | INDEX MAY NOT BE USED ON SECONDARY SERVERS FOLLOWING TABLE ALTER |
| IC92960 | ASSERT FAILED EXCEPTION CAUGHT IN OPJINIT ON 11.70.FC7W1 |
| IC93116 | PERFORMANCE PROBLEM WHEN AN INDEX SELF JOIN IS BEING CHOSEN OVER NON INDEX SELF JOIN QUERY PLAN |
| IC93133 | IN THE DATABASES WITHOUT LOGGING LOCKS GET LOST WHEN THE INSERT TRIGGER INVOKES SPL CONTAINING A SUBSTR() FUNCTION. |
| IC93136 | ONTAPE RENAMED EXTERNAL RESTORE FAILING, IF EXTENDED RESERVED PAGE RESIDES IN A NON ROOT CHUNK. |
| IC93227 | DROP OF A CHUNK OF A TEMPORARY DBSPACE DOES NOT CLOSE FILEDESCRIPTOR ON THE RSS SECONDARY |
| IC93307 | QUERY WITH MULTIPLE JOINS DOES NOT COMPLETE AND THE ESTIMATED COST OF THE QUERY IS VERY HIGH |
| IC93309 | TRIGGER PROCEDURE WILL CRASH THE SERVER WHEN SET EXPLAIN ON IS SET |
| IC93505 | CDR CHECK REPLSET USING --PROCESS OPTION FOR PARALLEL CHECKING CAN RESULT IN MISSING OUTPUT INFORMATION AND LEFTOVER $INFORMIXDIR/tmp/tfil_* files |
| IC93542 | QUERY PERFORMING SEQUENTIAL SCAN INSTEAD OF A KEY ONLY SCAN |
| IC93646 | INSTANCE FAILS TO START WITH MIRROR CHUNKS IF PRIMARY CHUNK CONTAINING EXTENTED RESERVED PAGES IS LOST |
| IC93740 | USER PRIVILEGES IN HDR SECONDARY CACHE ARE NOT REFRESHED |
| IC93839 | BLOCKED CHECKPOINT WHEN BTSCANNER AND SQLEXEC THREADS YIELD WAITING ON A BUFFER WITHOUT LEAVING A CRITICAL SECTION CAUSING A DEADLOCK |
| IC93942 | ERROR 202 WHEN EXECUTEINSERT?UPDATE?DELETE?SELECT STATEMENT WITH WHERE CONDITION THAT CONSISTS OF PLANE0, PLANE2, PLANE15 |
| IC93948 | ASSERT FAILED: INVALID MUTEX TYPE POSSIBLE DURING RSS RECONNECTION ATTEMPT WHEN DELAY_APPLY IS USED |
| IC93965 | AFCRASH DURING ONCHECK -PE OR -CE IN MT_FREE CALLED FROM RS_RELEASEEXTMAPMEMORY |
| IC93967 | SINGLE SIGN-ON (SSO) CONNECTION CAN LEAK MEMORY IN THE GLOBAL POOL |
| IC94007 | UNABLE TO REDIRECT THE OUTPUT OF ONPLOAD BY USING (>> SCRIPTNAME.OUT) COULD DO THIS IN EARLIER VERSION OF THE ENGINE |
| IC94008 | PARALLEL PUT AND GET ACTIVITY ON BUFFER FAST CACHE CAN CAUSE ABORT IN BT_FAST_BUFFGET/BUFFGET FUNCTION |
| IC94064 | ROLLBACK OF DEFRAGMENT OPERATION CAN LEAD TO UNEXPECTED INSTANCE TERMINATION IN BUFFCLEAR() CALLED VIA DEFRAG_PGMOVE_FUN() |
| IC94098 | SETTING SECURITY_LOCALCONNECTION=2 ON SOLARIS AND CONNECTING VIA TLITCP FAILS WITH -951/-952 ERRORS RUNNING ONTAPE |
| IC94226 | (-9791)ERROR:ROUTINE EXECUTION TRAP-PROCNAME= REASON:MEM WHILE TRYING TO GET VISUAL QUERY PLAN FROM DATA STUDIO |
| IC94380 | ONMODE -F CRASHES ENGINE IN TXFREEBLK |
| IC94740 | LOGICAL LOGS ON HDR SECONDARY CAN LOSE BACKED UP FLAG LEADING TO PING TIMEOUTS AND INABILITY FOR SERVERS TO RECONNECT AND RESYNC |
| IC94982 | HPL FAILPOINTS 11620/16134, SQL -349 WHEN UNLOADING UDT BIG ENOUGH TO RESIDE IN SBLOB |
| IC95034 | OPTIMIZER PROCESSES QUERY IN DIFFERENT ORDER THAN ON V10 WHICH SIGNIFICANTLY IMPACTS EXECUTION TIME |
| IC95145 | SELECT MAX() CHOOSES QUERY PLAN WITH LOWER ESTIMATED COSTS BUT LONGER RUN TIME |
| IC95604 | EXTENSIVE MEMORY USAGE WHEN USING FRAGMENT LEVEL STATISTICS AND UPDATE STATISTICS HIGH |
| IC95692 | DUPLICATE ROWS IN TABLE WITH UNIQUE INDEX WHEN ROWS RESULT FROM INSERT TRIGGERS ON ER-REPLICATED TABLES. |
| IC95693 | REPACK COMMAND FAILS ON SYSTEM CATALOGS |
| IC95780 | FEA: ALERTCLEANUP FUNCTION SHOULD EXECUTE DELETE STATEMENTS IN MULTIPLE SMALL TRANSACTIONS TO AVOID LONG TX TO OCCUR |
| IC95984 | CRASH IN HASHFULLNAME DUE TO CONTINUED USE OF MEMORY WHICH MAY HAVE BEEN FREED OR REUSED. |
| IC95989 | CRASH IN HASHFULLNAME DUE TO CONTINUED USE OF MEMORY WHICH MAY HAVE BEEN FREED OR REUSED. |
| IC96230 | DEADLOCK ON NSF.0LOCK MUTEX POSSIBLE WHEN USING STREAM PIPES |
| IP23572 | CONNECTION MANAGER DOES NOT SUPPORT MULTIPLE LISTENER THREADS ON A SINGLE DBSERVERNAME OR DBSERVERALIASES PORT |
|
xC7W2 APARs
|
Description
|
| IC69419 | FRACTION OF SECOND IN GL_DATETIME %F DID NOT DISPLAY AS EXPECTED |
| IC87342 | WARNING! AVOID_EXECUTE HAS BEEN SET SHOULD BE PRINTED WHEN AVOID_EXECUTE IS ON AND QUERY IS RUN |
| IC89273 | CHAR VALUES WITH MORE THAN ONE ZERO BYTE NOT FOUND BY IS NULL/IS NOT NULL CLAUSES WHEN INDEX PATH IS USED |
| IC89276 | ASSERTION FAILURE POSSIBLE IN RESET_ARCINFO() WHEN BOTH ARCHIVE RESERVED PAGES ARE DAMAGED |
| IC89549 | AUTOMATIC INSTANCE CREATION DURING CUSTOM INSTALLATION CAN FAIL WITH ERROR REFERRING TO SQLHOSTS ISSUE |
| IC89728 | APPLICATIONS MIGHT HIT ERROR -710 ALTHOUGH AUTO_REPREPARE IS ENABLED |
| IC90449 | UPDATE STATEMENT AFTER AN ALTER TABLE CAUSING ASSERTION FAILURE WITH BUFFER MODIFIED IN INCONSISTENT CHUNK |
| IC90599 | SERVER ALLOCATES LOTS OF MEMORY WHEN DROPPING DATABASE WITH TABLES HAVING COLLECTION DATA TYPES DEFINED |
| IC90792 | DIFFERENCE IN BEHAVIOUR BETWEEN PLATFORMS REGARDING EXPIRED/LOCKED PASSWORD VALIDATION |
| IC90887 | HOSTNAME FIELD FROM SYSSESSIONS WHEN QUERIED IN SYSDBOPEN() THROUGH DRDA IS INCORRECTLY RETURNED |
| IC90901 | PID FIELD FROM ONAUDIT OUTPUT WAS RETURNING 0 OR -1 ON CERTAIN PLATFORMS THROUGH JDBC CONNECTION AND IS NOW RANDOM |
| IC90943 | MEMORY LEAK IN GLOBAL POOL OF TYPE RDAHEAD (OR MID_RA) WHEN USING AUTO_READAHEAD |
| IC90981 | GENONCFG CAN FAIL WITH INAPPLICABLE ERRORS OR GENERATE UNUSABLE ONCONFIG |
| IC90982 | ONSTAT -G HIS SHOWS WRONG LOG SPACE VALUE |
| IC91121 | 768: INTERNAL ERROR IN ROUTINE OPJOIN() WITH MULTIPLE JOINS |
| IC91338 | SELECT COUNT(*) CAN LEAD TO AF IN LDDBLNULL WHEN USING NESTED SUBQUERIES AND AN INDEXED DATE COLUMN |
| IC91342 | SQL ERROR -272 WHEN CREATING A DATA MART |
| IC91389 | RENAMED RESTORE FORCES NEW CHUNK PAGE SIZE TO BE MULTIPLE OF DBSPACE PAGE SIZE WHEREAS CHUNK ADDITION DOES NOT |
| IC91412 | SERVER CAN CRASH WHEN EXECUTING SELECT FROM SYSSQEXPLAIN |
| IC91601 | CDR CHECK CAN HANG IN FUNCTION GETPKCOLS() |
| IC91605 | QUERY WILL HANG WHEN USING SYSMASTER TABLE SYSLCKTAB WITH FILTER ON INDX COLUMN GREATER THAN OR EQUAL TO SIZE OF LOCK TABLE |
| IC91606 | IF SETORIGIN MODIFIES ORIGIN AND NEW ITEMS ARE INSERTED PRIOR TO ORIGINAL ORIGIN, SELECT FROM VTI TABLE RETURNS NO ROWS FOUND |
| IC91961 | DBSCHEMA AND DBEXPORT RETURNS A WARNING MESSAGE WHEN TABLE NAME, PROCEDURE NAME OR COLUMN NAME HAS MULTI BYTE CHARACTER A TO Z |
| IC92005 | CONTINUAL MEMORY LEAK IN CONNECTION MANAGER WHEN A SERVER PORT IS INACESSIBLE |
| IC92019 | VIEW WITH JOIN ON SMI TABLES AND AGGREGATE COLUMNS RESULTS IN MEMORY CORRUPTION THAT LEADS TO DIFFERENT ASSERT FAILURES |
| IC92087 | PREPARED STATEMENT CAN CAUSE A CRASH IN SQRETTYPE() IF RUN AGAINST A RE-CREATED TABLE WITH LVARCHAR COLUMN |
| IC92116 | READAHEAD THREAD CAUSES HDR SECONDARY TO ABORT USING TEMP TABLES WITH BLOBS |
| IC92117 | QUERY CAN ASSERT IN SQOPTIM() IF SYSINDICES ENTRY HAS NULL VALUE IN CLUST COLUMN |
| IC92213 | VALUES IN THE SYSMASTER:SYSRSTCB.IOWAITTIME COLUMN CAN BE INCORRECT |
| IC92503 | POPULATING FOT INDEX MAY END UP WITH ASSERT FAILURE IN PTMAP IF THE TABLE WAS TRUNCATED BEFORE THE DATA LOADING |
|
xC7W1 APARs
|
Description
|
| IC78379 | [WINDOWS] USER INFORMIX AND GROUP INFORMIX-ADMIN EXIST AFTER CUSTOM INSTALL SPECIFYING LOCAL SYSTEM ACCOUNT |
| IC81331 | MESSAGE ASSERT WARNING: LOGPUTX(EXTEND_CHUNK) - RSBEGIN() NEVER CALLED SEEN WHEN EXTENDING PHYSICAL LOG CHUNK SIZE |
| IC81894 | ONMONITOR PRODUCES 25582 ERROR ON EXIT |
| IC83706 | CONFUSING NUMBERS IN COLUMN QUEUE IN CDR LIST SERV OUTPUT |
| IC83955 | THREADS STARTED WITH FORK_BE_SESSION END UP WITH RSTCB->TID THAT DOES NOT MATCH TCB->THREAD_ID SO THREAD ID OUTPUT IN ONSTATS DO |
| IC83985 | FUNCTIONALITY AND DESCRIPTION OF SYSTEM VALUES IN IFXDEPLOY.CONF FILE IS UNCLEAR |
| IC85085 | RUNNING UPDATE STATISTICS ON A TABLE WITH FRAGMENT LEVEL STATS RETURNS AN INCORRECT MESSAGE RELATED TO SBSPACENAME |
| IC85171 | SYSADMIN:ALERTCLEANUP FUNCTION MUST BE RECREATED DURING MIGRATION/CONVERSION |
| IC85487 | CDR_SERIAL DOES NOT WORK PROPERLY IF YOU ADD A BIG NUMBER BEFORE |
| IC85636 | ONCHECK CANNOT BFGET BUFFER FOR PARTNUM BECAUSE OF NEGATIVE PAGENUM |
| IC85882 | ONSTAT -G DBG CAN STOP WITH CHANGING DATA STRUCTURE FORCED COMMAND TERMINATION. |
| IC85883 | ASSERTION FAILURE IN UNCOMPRESS_ROW() MISSES TO GIVE PRECISE REASON FOR WHY IT HAPPENED |
| IC85935 | MESSAGE FAILPOINT: 14100 IN LOAD JOB LOG FILE WHEN LOADING FROM EMPTY FILE AND TABLE CONTAINS LVARCHAR |
| IC86023 | IDS FAILS IN MT_AIO_WAIT() WITH CIO AND MULTIPLE CHUNKS IN A SINGLE COOKED FILE |
| IC86077 | LINUX: WHEN USING HUGE MEMORY AND RESIDENT SET TO -1, SERVER IS UNABLE TO ADD V SEGMENTS AFTER THE INITIAL V ALLOCATIONS |
| IC86189 | REMOTE SUB-QUERY HAS INCORRECT QUERY PATH WITH VERY LOW PERFORMANCE |
| IC86329 | A STORED PROCEDURE IN SOME CASES INSTEAD OF RETURNING ONLY -9791, CAN ASSERT FAIL OR EVEN CRASH |
| IC86365 | RESTORING AN INSTANCE WHEN USERMAPPING IS ON WILL MAKE ENGINE CRASH |
| IC86369 | ONSTAT -G IDXSCAN DOES NOT WORK ANYMORE AND THEREFORE ONSTAT USAGE SHOULD NOT MENTION IT |
| IC86442 | ERROR 768 IN OPEXPRRG WHEN THERE IS AN INDEX ON NCHAR COLUMN AND THERE ARE DIFFERENT LOCALES. |
| IC86443 | SELECT WITH WHERE CLAUSE CONTAINING MATCHES CONDITION WITH MULTIPLE WILDCARDS RETURNS WRONG RESULTS WITH CUSTOMIZED LOCALE |
| IC86445 | A QUERY CALLED FROM JAVA UDR MAY RETURN CORRUPTED VALUES DEPENDING ON PREDICATE ORDER |
| IC86490 | SUPPLIED KRAKATOA HAS OUTDATED TZ INFO |
| IC86493 | MISLEADING ERROR MESSAGE, UNEXPECTED RSS AUTHENTICATION FAILURE WHEN HA_ALIAS IS NOT SET |
| IC86500 | HDR SECONDARY DOES NOT PING TIMEOUT AFTER PRIMARY LOSES CONNECTION AND TRIES TO RECONNECT TO SECONDARY |
| IC86784 | AN ASSERT FAILURE IN INIT_TERM_PER_VALUE IS POSSIBLE WHEN MULTI INDEX SCAN IS USED |
| IC86822 | OPTIMIZER PREFERS INDEX PATH OVER SKIP SCAN WHICH RESULTS IN LONGER EXECUTION TIME |
| IC86848 | IDS CRASHES ON ROLLBACK OF LONG TRANSACTIONS |
| IC86933 | IPCSTRPOLL THREAD CAN ASSERT FAIL ON RARE OCCASIONS WHEN THERE ARE MULTIPLE IPCSTR OR SOCTCP/TLITCP POLL THREADS |
| IC86951 | USAGE OF MENU DRIVEN TABLE MODIFICATION CHANGED BETWEEN 11.50 AND 11.70 AND HAS PROBLEMS |
| IC86952 | POSSIBILITY OF ERKEY (IFX_ERKEY_2 COLUMN) CORRUPTION |
| IC86993 | CDR CHECK REPLICATESET IFX_INTERNAL_SET RETURNS SQL FAILURE 195 WHEN THERE IS NETWORK DELAY BETWEEN SOURCE AND TARGET |
| IC87024 | ASSERT FAILURE OR CRASH WITH LEFT JOIN SQL WHEN TABLES HAVE MANY INDEXES |
| IC87060 | DBSCHEMA REPORTS WRONG SIZE OF EXTENT AND NEXT SIZE WHEN INDEX IS CREATED WITH EXTENT SIZE OPTION |
| IC87066 | CDR THREADS NAMES ARE NOT CLEANED UP FROM SYSMASTER:SYSTHREADS TABLES EVEN THOUGH THREADS ARE NO LONGER PRESENT ON THE SERVER. |
| IC87067 | SETTING UP A REPLICATE BETWEEN IDS 10.00 AND 11.70 CAN FAIL WITH DIFFERENT SYMPTOMS |
| IC87069 | MORE MEMORY CONSUMED THAN CONFIGURED WHEN HIGH AMOUNT OF BUFFERS AND VIRTSIZE |
| IC87248 | EXECUTING ONMODE -L WHILE RUNNING ONTAPE -A CAUSES CORRUPTED LOGICAL LOG FILE |
| IC87250 | WRONG RESULTS FOR SQL WITH MULTIPLE COUNT(DISTINCT) POSSIBLE WHEN QUERY RUNS WITH PDQ AND MANY CPU VPS CONFIGURED |
| IC87251 | RUNNING A SIMPLE QUERY THAT PERFORMS A HASH JOIN WITH PDQ ENABLED TAKES LONGER IN 11.70 THAN 11.50 |
| IC87252 | SQL -604 AND ISAM -164 ON DELETE FROM TABLE WITH LIST FIELD |
| IC87257 | CDR DEFINE SERVER RETURNS ERROR 123 DURING INTERNAL REPLICATE DEFINE FOR GLOBAL CATALOG SYNC IN A MULTI NODE CLUSTER |
| IC87310 | INDEX ON CDR_DELTAB_* IS CREATED WITH EXTENT AND NEXT SIZE WHEN BASE TABLE HAS AN INDEX (PRIMARY KEY) DEFINED WITH EXTENT AND NE |
| IC87311 | SERVER CAN CRASH IN LDDBLNULL() INSTEAD OF REPORTING ERROR 321 OR 595 IF AN AGGREGATED COLUMN IS USED IN A JOIN WITH GROUP BY |
| IC87341 | IFXCLONE FAILS WITH ERROR SMX FAILED TO CREATE PIPES FOR CLONE RESTORE ON SOLARIS WHEN PROTOCOL/INTERFACE IS SET TO TLITCP |
| IC87375 | BTSCANNER THREAD CAN ASSERT FAIL WHEN BUFFER MODIFIED IN INCONSISTENT CHUNK WHEN CLEANING EN_US.UTF8 NVARCHAR INDEX |
| IC87399 | CDR CHECK REPL --TIMESTAMP WITH REPLCHECK DEFINED SELECTS ALL THE COLUMNS MOST OF TIME THAN INDEX DEFINED ON IFX_REPLCHECK |
| IC87444 | INFORMIX USER/GROUP CREATION ERROR DURING INSTALLATION WITH ROLE SEPARATION |
| IC87489 | SYSCDR:REPLCHECK_STAT.REPLCHECK_STATUS IS NOT SHOWING THE CORRECT STATUS FOR REPLICATES THAT FAILED REPAIR |
| IC87490 | ASSERT FAILURE DUE TO MEMORY CORRUPTION DOES NOT PROPERLY SET RESULTS: STRING IN ASSERT FAILURE MESSAGE |
| IC87587 | WITH BATCHEDREAD_INDEX ENABLED, A QUERY THAT FILTERS ON A DECIMAL INDEX WILL RETURN NO ROWS |
| IC87589 | SERVER CAN ABEND WHEN DOING SELECTS FROM SYSCDRSEND_BUF WHILE PUTTING LOTS OF LOAD ON THIS TABLE |
| IC87644 | COMPLEX QUERY WITH A NESTED VIRTUAL TABLE CAUSES A CRASH |
| IC87681 | SERVER TERMINATES UNEXPECTEDLY WHEN EXECUTING A QUERY WITH SUBQUERY AND STATEMENT CACHE IS ON |
| IC87682 | IFXCLONE ON LINUX FAILS WITH ERROR WARNING: MT_AIO_WAIT: ERRNO == EINVAL USING RAW DEVICES. IT WORKS FINE WITH COOKED FILES. |
| IC87771 | DROP SPECIFIC FUNCTION IF EXISTS SPECIFIC_NAME; FAILS WITH 201: SYNTAX ERROR |
| IC87814 | BTS OUT OF MEMORY ERROR POSSIBLE AND CAUSING A MEMORY CORRUPTION WHEN OCCURRING |
| IC88153 | THE EXAMPLE GIVEN TO CREATE A COMPOSITE BTS INDEX SHOWS THE INCORRECT KEYWORD DEFAULT_QUERY_FIELD |
| IC88170 | AUTO_CRSD() SHRINK THRESHOLD DOES NOT CONSIDER EMPTY TABLES |
| IC88171 | EMPTY LIST TYPE COLLECTION IN EXPLICIT CASTING CAUSES ASSERT FAILED |
| IC88172 | ALTER TABLE MODIFY DOES NOT MODIFY THE COLUMN WHEN THERE ARE FRAGMENT LEVEL STATISTICS FOR THIS COLUMN |
| IC88201 | AFTER ALL THE MEMBERS IN CLUSTER HAVE BEEN RESTARTED EXCEPT CM, ONSTAT -G CMSM DOES NOT DISPLAY A STATUS OF FAILOVER ARBITRATOR |
| IC88202 | CM DOES NOT IDENTIFY THE TYPE OF SECONDARY INSTANCE IF THE INSTANCE WAS BROUGHT UP BEFORE THE PRIMARY |
| IC88203 | CONNECTION MANAGER DOES NOT NOTICE THAT RSS IS BACK ONLINE IF IT WAS RESTARTED TWO TIMES IN A ROW |
| IC88219 | FAST RECOVERY CAN FAIL WITH TRANSACTION STILL OPEN BECAUSE OF COMITTED TRANSACTION IN CHECKPOINT RECORD |
| IC88260 | PROBLEM WITH DBACCESS AND ALTER TABLES HANDLING |
| IC88265 | TIMESTAMP BASED REPAIR (CDR CHECK REPLSET --TIMESTAMP --REPAIR), REPAIRS DATA INCORRECTLY |
| IC88289 | DBIMPORT FAILS WITH -201 SYNTAX ERROR FOR DATABASES WITH UTF8 AND SQL_LOGICAL_CHAR AND DATABLADES REGISTERED |
| IC88393 | FUNCTION NEXT_PAGE_CALLBACK() MAKES A CALL TO MACRO DREQUIRE WITH THE REQUEST TO EV_AFCRASH, BUT END MACRO REGARDLESS CALLS AFWARN_INTERFACE() |
| IC88543 | ASSERTION FAILURE POSSIBLE IN SETCDRALTMODE() WHEN UNIQUE CONSTRAINT IS DROPPED ON A REPLICATED TABLE WHILE ER IS STOPPED |
| IC88586 | ONPLOAD THROWS ASSERT FAILURE ON WINDOWS-7 64-BIT |
| IC88590 | MESSAGES: ERROR IFKNOWNCREATE() LOOKUP FAILED, NAME IS EMPTY IN THE ONLINE LOG FILE. |
| IC88699 | RUNNING A CORRELATED NESTED QUERY GENERATES AF WITH MEMORY BLOCK HEADER CORRUPTION DETECTED IN MT_SHM_MALLOC_SEGID 6 |
| IC88746 | INSERT ON UPDATABLE RSS WITH XA TRANSACTION ALLOWS DUPLICATES IN COLUMN WITH A PRIMARY KEY OR A UNIQUE CONSTRAINT |
| IC88810 | DBIMPORT DOES NOT DETECT INVALID SYNTAX IN CREATE PROCEDURE STATEMENT LEADING TO UNEXPECTED INCOMPLETE DATABASE IMPORT |
| IC88812 | DBSCHEMA STORAGE SPACE STATEMENT OUTPUT ORDER CAN BE WRONG |
| IC88911 | IF VIEW BASED ON REMOTE TABLE IS QUERIED WITH REVOKED SELECT PRIVILEGE THEN THE QUERY TO VIEW WILL ALWAYS BE GIVING ERROR -583 |
| IC88916 | ON VERY LARGE SYSTEMS (MANY SESSIONS, MANY CPU VPS) WITH LOTS OF TEMP TABLES, THERE MAY BE A BOTTLENECK ON THE RSAM POOL |
| IC88998 | AUTO READAHEAD IS NOT PERFORMING INDEX-DATA READ AHEAD WITH OLD-STYLE ATTACHED INDEXES WHICH CAN LEAD TO A PERFORMANCE PROBLEM |
| IC88999 | ASSERT FAILURE WHEN EXECUTE FUNCTION ADMIN (CREATE GLFILES) IS RUN |
| IC89002 | PRIMARY OR SOURCE SERVER CAN ASSERT FAIL WHILE DECRYPTING DATA USING IBM GLOBAL SECURITY KIT (GSKIT) |
| IC89003 | A INSTANCE CREATED WITH THE IFXCLONE UTILITY CAN FAIL TO START WITH THE ERROR DUPLICATE VPCLASS |
| IC89007 | SELECT STATEMENT USING A VIEW RETURNS -640 WHEN EXECUTED FROM NESTED PROCEDURES |
| IC89041 | SELECT WITH UPPER AND LIKE RETURNS NO RESULTS IN IDS 11.70 WITH DB_LOCALE=DE_DE |
| IC89125 | QUERY USING SEQUENTIAL SCAN ON A TABLE WITH VARCHAR GIVES TRUNCATED STRING BUT USING INDEX GIVES CORRECT STRING |
| IC89127 | POOR QUERY PLAN WITH FILTERS ON NON-INDEXED CHAR(1) FIELDS |
| IC89282 | LOGICAL RECOVERY ROLLFORWARD ERRORS ON SDS NODES WHEN PRIMARY NODE IS PERFORMING LRU (FOREGROUND POSSIBLY) WRITES |
| IC89299 | DROPPARTMART CAN FAIL WITH ASSERTION ACTIVEROWS == EXPECTEDROWS FAILED |
| IC89302 | UPGRADING TO 11.70.XC7 USING ONINIT -VW DOES NOT RETURN TO COMMAND PROMPT |
| IC89310 | ASSERT FAIL, CRASH OR SESSION HANG POSSIBLE FOLLOWING LONG TRANSACTION ROLLBACK INVOLVING REMOTE SERVER |
| IC89314 | SANITY CHECKS IN SQ_HOLD COULD HELP RETURN 408 ERROR RATHER THAN ASSERT FAIL AND ENGINE CRASH |
| IC89317 | ONLOG STOPS TO READ PAGES FROM A LOGICAL LOG ON TAPE AFTER 8192 PAGES |
| IC89426 | HANDLING OF DATA TYPES BASED ON A DECIMAL REPRESENTATION WITH INVALID DATA MAY RESULT IN MEMORY CORRUPTION |
| IC89427 | CDR LIST SERVER -C HANGS WHEN CONNECTING TO A REMOTE INSTANCE RUNNING AN OLDER VERSION |
| IC89465 | TRUSTED CONTEXT CANNOT BE RE-CREATED IF DATABASE HAS NON-DEFAULT LOCALE |
| IC89479 | COUNT (*) VS ACTUAL SELECT * RETURNS DIFFERENT RESULTS |
| IC89497 | ONMODE -X S (TO DUMP A STACK TRACE) CAN CRASH SERVER WHEN RUN AGAINST NAMED VP CLASS WHERE IDLE_THREAD IS RUNNING |
| IC89547 | ERROR : TRUSTED HOST FILE (/ETC/HOSTS.EQUIV) CACHE MARKED INVALID IN ONLINE.LOG |
| IC89576 | A NESTED CURSOR USING HASH JOIN OF 2 FRAGMENTED TABLES CAN RETURN BAD RESULTS IF PDQ IS ON |
| IC89585 | RUNNING CONCDR.SH SCRIPT AFTER MIGRATION CAN LEAD TO MISSING VIEWS IN SYSCDR, THUS PREVENTING CDR DEFINE TEMPLATE |
| IC89597 | USING LITERAL CURRENT IN INSERT VIA SYNONYM INTO A REMOTE TABLE CAN GARBLE COLUMN VALUES |
| IC89618 | DBSCHEDULER AND WORKER THREADS FAIL TO START WHEN SYSADMIN IS MOVED TO ITS OWN DBSPACE USING TASK(RESET SYSADMIN) FUNCTION |
| IC89645 | TURNING ON THE AUDITING LEVEL 1 ADDS AN UNNECESSARY DELAY TO ONSTAT AND ONMODE COMMANDS |
| IC89646 | EXCESSIVE MEMORY USE AND CRASH POSSIBLE WHEN USING TIMESERIES PUTSET FUNCTION |
| IC89648 | ASSERT WARNING: ATTEMPT TO WAKE A NON-EXISTENT THREAD EVERY TIME WHEN A LISTENER THREAD FAILS TO START |
| IC89650 | PERFORMANCE ISSUE WITH A CORRELATED SUBQUERY THAT USES A COMPLEX VIEW USED IN A NOT EXISTS CLAUSE |
| IC89663 | ASSERTION FAILURE IN RDATAVALVCHAR -- QUERY INVOLVES A LARGE NUMBER OF TABLES WITH NESTED LOOP AND HASH JOINS |
| IC89665 | RSS NODE CAN FAIL TO RECONNECT |
| IC89790 | HAVING COUNT(*) = 0 RETURNS ROW WHEN IT SHOULD RETURN NO ROWS |
| IC89810 | EXTENDABLE CHUNKS FEATURE IS NOT WORKING WHEN ER TRIES TO CREATE SHADOW(DELTAB) TABLES |
| IC89849 | ONINIT -W HANGS AND NEVER RETURNS IF AN ONMODE -KY IS ISSUED WHILE ENGINE IS STILL INITALIZING. |
| IC89875 | BTS DATABLADE RETURNS 0 ROWS |
| IC89892 | SELECT FROM VIEW RETURNS ERROR 366 |
| IC89898 | BOTTLENECK ON EXTENDED TYPE NAME CACHE WHEN MULTIPLE SESSIONS DISCONNECT AT ONCE |
| IC89921 | EXCESSIVE WAITS ON PLOGPL IMPACTS THE PERFORMANCE OF A CHECKPOINT |
| IC89941 | DBINFO(GET_TZ) RETURNS A WRONG RESULT WHEN STMT_CACHE IS SET |
| IC89943 | CALCULATION OF SIZE OF A CRITICAL FILE FOR ONBAR BACKUP IS WRONG |
| IC89946 | READAHEAD: THREAD EXITED WITH BUFFERS HELD |
| IC90186 | CRASH OF ONCMSM IN SQLI_CURS_CLOSE_TCB(), POSSIBLY DUE TO CM REPEATEDLY SWITCHING PRIMARY TO HDR THEN BACK TO PRIMARY. |
| IC90212 | USING THE LOWER() FUNCTION WITH GL_GLU TAKES EXCESSIVE TIME |
| IC90284 | QUERY RETURNS 874 AND AF IS GENERATED BUT ENGINE DOES NOT CRASH |
| IC90312 | AUTO_CRSD TASK SHOULD NOT RUN AGAINST TABLES IN THE FOLLOWING SYSTEM DATABASES (SYSMASTER, SYSUTILS, SYSUSER, SYSCDR AND SO ON) |
| IC90345 | CDR_MONITOR THREAD CAUSES MEMORY LEAK |
| IC90447 | ONSTAT -G CMSM SHOWS THAT CONNECTION MANAGER INCORRECTLY CONSIDERS THE PRIMARY TO BE DOWN |
| IC90493 | SETTING NON-EXISTENT SQLIDEBUG ON WINDOWS CRASHES ONMODE/ONSTAT AND MAY PROVOKE ENGINE TO ASSERT FAIL |
| IC90494 | RE-USING PREPARED STATEMENTS INCLUDING MULTISETS CAN RESULT IN MEMORY CORRUPTION |
| IC90497 | USING DBACCESS TO ALTER A COLUMN NAME WILL FAIL WITH -201 AND THEN WILL DROP THE TABLE |
| IC90597 | SCHEDULER DOES NOT START AUTOMATICALLY WHEN CONVERSION IS COMPLETED AND IT CANNOT BE STARTED MANUALLY. INSTANCE HAS TO BE RESTARTED |
| IC90609 | ABORTING A PLOAD JOB WITH A PREMATURELY EXITED PL_MASTER ABORTS THE SERVER IN PJT_POST_GLOBALERROR |
| IC90643 | ERROR -999 POSSIBLE WHEN DOING A SELECT FROM VIEW |
| IC90645 | CONTENTION ON SHARED MEMORY MUTEX SH_LOCK POSSIBLE WHEN MANY SESSIONS DISCONNECT SIMULTANEOUSLY AND VP PRIVATE CACHE IS FULL |
| IC90694 | READAHEAD MEMORY POOL CAN GROW AND CAN EVENTUALLY LEAD TO OUT OF BOUNDS MEMORY CONSUMPTION |
| IC90730 | DEADLOCK BETWEEN CDRACCEPT THREAD AND GCREQ THREAD INVOLVING THE PERMNIFG MUTEX AND CDR_GC CONDITION |
| IC90827 | DBEXPORT ON UPDATABLE RSS COULD READ UNCOMMITTED DATA EVEN USELASTCOMMITTED SET TO ALL |
| IC90862 | ONSTAT -Z ON RSS DURING FAST RECOVERY PHASE LEADS TO ENGINE CRASH |
| IC90943 | MEMORY LEAK IN GLOBAL POOL OF TYPE RDAHEAD (OR MID_RA) WHEN USING AUTO_READAHEAD |
| IC90959 | HIGH CPU UTILIZATION AND CONTENTION ON SYSDBPROC CACHE SEEN DURING LARGE-SCALE SESSION CONNECT OR DISCONNECT |
| IC90980 | OAT SHOWS NEGATIVE VALUES FOR NUMBER OF TABLES NEEDING STATISTICS REFRESH AFTER REFRESH IS COMPLETED |
| IC91340 | THE GREATEST AND LEAST BUILT-IN FUNCTIONS CAUSE INSTANCE TO CRASH |
|
xC6/xC7 APARs
|
Description
|
| IC77771 | INFORMATION ABOUT MAX. CONCURRENT SESSIONS IN SYSSHMVALS:SH_OVLMAXCONS AND SYSLICENSEINFO:MAX_CONNS IS NOT CONSISTENT |
| IC78544 | ONSTAT -G NTU / NTT DO NOT REPORT CORRECT INFORMATION FOR DBSCHEDULER THREADS |
| IC79310 | CREATING AN INDEX ON A FRAGMENTED TEMP TABLE THROWS -212/-113 AS DOES CREATING A FRAGMENTED INDEX ON A TEMP TABLE |
| IC79807 | VIEW FOR REMOTE TABLE IS NOT WORKING PROPERLY WHEN THE REMOTE TABLE IS RECREATED/ALTERED |
| IC80634 | DB_LOCALE MAY BE SET INCORRECTLY IN INIT_SQSCB FOR THE SESSION WITH MULTIPLE REMOTE QUERIES |
| IC80652 | THE PRINT FILE INFO ARGUMENT WITH THE TASK() FUNCTION DOES NOT WORK. |
| IC81901 | FAILING TO CREATE AN RPM IMAGE DUE TO MISSING UNINSTALL.LOG |
| IC81902 | WARNING USER DOES NOT EXIST - USING ROOT WHEN INSTALLING RPM PACKAGE |
| IC81903 | WHEN BUILDING RPM PACKAGE THE DEFAULT PATH /OPT/IBM/INFORMIX IS USED EVEN IF DIFFERENT PATH IS SPECIFIED |
| IC82084 | SELECT FROM SYSENVSES CAN LEAD TO AN ASSERTION FAILURE IN PRENVSESVAR |
| IC82171 | INSTANCE ABORT POSSIBLE WHEN INDEX KEY DESCRIPTOR ON PARTITION PAGE IS CORRUPTED |
| IC82240 | DBSPACE IS FULL ALARM EVENT 44 IS NOT FIRED WHEN ERROR 264/131 RETURNED TO THE SESSION |
| IC82597 | REVERSION INDICATED AS SUCCESSFUL BUT NOT ALL DATABASES WERE REVERTED |
| IC82645 | SKIP SCAN CAN BADLY SUFFER FROM LIGHT SCANS |
| IC82658 | UNABLE TO GET LOCALIZED ERROR MESSAGES FROM A DRDA CLIENT |
| IC82659 | ENGINE DROPS ASSERT WARNING: NET_SEND_LOCAL_ON FOUND NON-NULLSCB->PLSCB ON TASK() CALL |
| IC82685 | SERVER COULD ASSERT FAIL WHEN QUERIES INVOLVING SYSCONBLOCK LOOK AT CONBLOCKS FOR STATEMENTS USING CONNECT BY SYNTAX |
| IC82784 | QUERY WITH CORRELATED SUBQUERY USING BOTH IS NULL AND IS NOT NULL ORED CONDITIONS FOR THE SAME COLUMN CAN BE VERY SLOW |
| IC82786 | HIERARCHICAL QUERY ACCEPTS DATA WITH MULTIPLE ROOT NODES |
| IC82990 | FUNCTIONAL INDEX SCAN OF REMOTE TABLE MIGHT NOT WORK CORRECTLY IN A CROSS-DATABASE QUERY |
| IC82992 | DRDA: SERVER MIGHT TERMINATE WHEN A STORED PROCEDURE WHICH IS EXECUTED IN A TRANSACTION FAILS WITH ERROR -535 |
| IC83016 | STARTUP OF DWA FAILS WITH ASSERTION STR.TELLG > 0 FAILED WHEN SEND_QUEUE_SIZE IS NOT EXPLICITLY SPECIFIED IN THE NODE CONFIG |
| IC83018 | CDRSCN_ THREAD COULD ASSERT FAIL IF A CDR STOP REPL COMMAND IS USED TO STOP THE REPLICATE WHILE THE CDR SYNC REPLICATE IS RUN |
| IC83074 | ONSTAT -G IOA GENERATES OUTPUT WHICH INCLUDES -G IOF OUTPUT BUT DOCUMENTATION DOES NOT DESCRIBE IT CORRECTLY |
| IC83075 | -768 SQL ERROR: INTERNAL ERROR IN ROUTINE READRIDS(): SC_NONSEQ MODE NOT SUPPORTED. |
| IC83182 | DBACCESS: SCREEN MENU IN ALTER TABLE OPTION DOES NOT SHOW ADDITIONAL PAGES FOR TABLE WITH HIGH NUMBERS OF COLUMNS |
| IC83253 | FOR A SELECT INVOLVING A FILTER WITH SUBQUERY A MORE EXPENSIVE QUERY PLAN MIGHT BE CHOSEN WHEN DISTRIBUTIONS EXIST |
| IC83254 | POSSIBLE SQLEXEC THREAD ASSERT FAILS IN SEQ_PUTROW WITH BATCHREAD_TABLE ENABLED |
| IC83255 | CRASH SEGV IN FUNCTION RA_PAGE_ALREADY_READ ON READAHEAD (READ AHEAD) THREAD WHEN MEMORY IS LOW |
| IC83257 | NO ERROR IS DETECTED IF THE ONCONFIG PARAMETER SBSPACENAME IS SET WHICH SHOULD BE UNIQUE TO MULTIPLE SPACES |
| IC83332 | SQL ERROR 240 ISAM ERROR 103 WHEN TRYING TO DELETE FROM A TABLE WITH A FIX OF ATTACHED AND DETACHED INDEXES AND DELETE USES KEY |
| IC83388 | LONG TRANSACTION ROLLBACK HANG POSSIBLE WHEN USING REMOTE DATABASE QUERIES IF REMOTE CONNECTION ATTEMPT HANGS |
| IC83390 | ONMODE -P -1 JVP CRASHES THE DATABASE SERVER |
| IC83410 | CM PRINTS A WARNING MESSAGE WHICH REFERENCES CLUSTER NAME AND INFORMIX ALIAS IN WRONG ORDER |
| IC83411 | CREATE PROCEDURE STATEMENT ABEND IDS SERVER IN OP_JOIN(). |
| IC83412 | CONCAT() FUNCTION DOES NOT WORK CORRECTLY FOR AN LVARCHAR TYPE WHICH IS CASTED FROM AN HTML TYPE |
| IC83539 | ONRESTOREPT REPORTS ERROR FAILED TO PROCESS THE RESERVE PAGES IF $ONCONFIG IS NOT SET IN ENV. |
| IC83541 | UPDATE STATISTICS FOR PROCEDURE AFTER MIGRATION SHOULD NOT RETURN -721 BUT -26060 |
| IC83542 | CDC ERROR -83800 CAUSED BY LOG PAGE READER READING A POSITION IS CLOSE TO THE WRITE POSITION |
| IC83702 | NCHAR/NVARCHAR COLLATION WRONG WITH ESTONIAN LOCALE (ET_EE.UTF8) |
| IC83704 | DDL_LOGPROCESS_ROUTINECACHE() MESSAGE IF YOU RECREATE A STORED PROCEDURE ON AN UPDATABLE RSS SECONDARY |
| IC83756 | SQL SYNTAX MANUAL DOES NOT CLARIFY TIME DEFINITION IN SQL EXPLAIN.OUT |
| IC83757 | EXECUTING A REMOTE PROCEDURE DOES NOT WORK VIA DRDA |
| IC83759 | DBEXPORT AND DBSCHEMA GENERATE WRONG SYNTAX FOR FUNCTIONAL INDEX WITH DESC OPTION |
| IC83760 | INTERMITTENT PERFORMANCE PROBLEM USING RSAM BATCH SEQUENTIAL SCANS DUE TO EXCESSIVE LOCK CHECKING ACTIVITY |
| IC83764 | SMI TABLE SYSPTNTAB IS CAPABLE TO DISPLAY ONLY VALUES IN INTEGER RANGE INSTEAD OF BIGINT RANGE |
| IC83765 | ASSERT FAILED: SLOT ALLOCATION ERROR IN ONLINE.LOG; AF FILE SHOWS ALLOCSLOT: ATTEMPTING TO ALLOCATE SLOT ON OLD (0) VERSION PAGE |
| IC83768 | IWA: IF A SESSION STARTS SEVERAL QUERIES WITH MULTIPLE OPEN CURSORS THE SECOND QUERY GETS AN ERROR AND WILL NOT BE ACCELERATED |
| IC83770 | CM - FAILOVER MIGHT NOT WORK PROPERLY IF THERE ARE MORE CMS CONNECTED TO MACH11 CLUSTER AND ONE OF THEM HAS FOC SET TO DISABLED |
| IC83780 | EXECUTING STORED PROCEDURES WHILE UPDATING STATISTICS ON THE PROCEDURES FAILS WITH LOCKING ERRORS 211/144 312 211/107 |
| IC83882 | START MENU ENTRY FOR 32-BIT AND 64-BIT VERSION OF CSDK AND ICONNECT SHOULD BE DIFFERENT |
| IC83885 | WHEN DBACCESS LOAD FAILS WITH 847: ERROR IN LOAD FILE, IT CAN GIVE AN INCORRECT LINE NUMBER |
| IC83886 | ERRORS 25572 AND 8 WHEN BRINGING THE SERVER ONLINE USING TLITCP AND AN IP ADDRESS IN THE SQLHOSTS FILE |
| IC83887 | HDR REPLICATION SLOWDOWN DUE TO SYNCHRONOUS CONFIGURATION (DRINTERVAL -1) |
| IC83921 | ONSTAT -U ERRONEOUSLY SHOWS THREADS WAITING ON BUFFERS |
| IC83922 | RA_PAGES DESCRIPTION IS MISLEADING |
| IC83924 | AUTO_READAHEAD DOES NOT WORK AS DESCRIBED IN DOC |
| IC83930 | SELECT * FROM SYSSQEXPLAIN RETURNS SQX_ISCURRENT N WHERE THE VALUE WAS Y ON 11.50 |
| IC83941 | EXECUTION OF TASK() FOR DBSPACE CREATION RETURNS WRONG ERROR WHEN DBSPACE_NAME PARAMETER CONTAINS EXTRA SPACE |
| IC83942 | MISSING SPACE DBSPACE_NAME ADDED. MESSAGE IN THE ONLINE.LOG AFTER TASK() FUNCTION EXECUTION FOR DBSPACE CREATION |
| IC83943 | CM MUST LOG SERVER TYPE CHANGE |
| IC83944 | OPTIMIZER CHOOSES SEQUENTIAL SCAN WITH HIGH COST FOR A QUERY AGAINST 11.70.XC5. THIS BEHAVIOR IS DIFFERENT FROM 11.50.XC6 AND 9.40 |
| IC83945 | DISCREPANCY IN DESCRIPTION WHERE TEMP TABLES ARE STORED |
| IC83948 | DECRYPT_CHAR() FAILS WITH ERROR 26012: THE INTERNAL BASE64 DECODING FUNCTION FAILED |
| IC83967 | CDC RESTART MAY CAUSE LOSS OF REPLICATED DATA |
| IC83969 | AFTER TRYING TO START CM TWICE AND THEN STOP CM WHERE ARBITRATOR IS ACTIVE, ARBITRATOR IS LOST |
| IC83984 | REMOTE TRUSTED CONNECTIONS HIT AUTHENTICATION BOTTLENECK ON HOSTS.EQUIV |
| IC84007 | SKIP SCAN ACCESS METHOD IS NOT DESCRIBED CLEARLY |
| IC84028 | ENGINE CRASHED IN LDDECIMAL RDATAVALDEC VALLOAD |
| IC84029 | HA_ALIAS DOCUMENTATION DOES NOT SPECIFICALLY SPECIFY CONNECTION MANAGER BEHAVIOR |
| IC84031 | DML COMMANDS MAY REPORT ERRORS -206/-111 FOR AN EXISTING TABLE IN DATABASE WITH NON-DEFAULT LOCALES |
| IC84053 | ASSERT FAILS IN _RLT_UDR_EXEC() WHILE RUNNING UPDATES/INSERTS/DELETES ON TABLES USING SPATIAL BLADE (RTREE INDEX) |
| IC84065 | CM REPORTS ATTEMPT OF CHANGING PRIMARY ON STARTUP BUT THE MESSAGE IS ESSENTIALLY ABOUT ONE PRIMARY INSTANCE |
| IC84066 | CONNECTION MANAGER (CM) TRIES TO REFERENCE IPC ALIAS |
| IC84069 | SQL SYNTAX FOR BETWEEN CONDITION REQUIRES TWO ARGUMENTS ON THE RIGHT IN ASCENDING ORDER |
| IC84092 | MIGRATION FROM IDS 7.31 TO 11.70 MAY FAIL IF A TABLE DOES NOT HAVE SUFFICIENT SPACE IN PARTITION HEADER PAGE |
| IC84093 | BFCHECK: BAD PAGE: BUFFER PAGE HAS WRONG PAGE SIZE ASSERTION POSSIBLE WHEN TRYING TO ALLOCATE NEW CHUNK FREE LIST PAGE |
| IC84094 | SKIP SCAN ACCESS TO A COMPRESSED TABLE CAN RETURN BAD RESULTS, GENERATE (TPOS >= START) ASSERT WARNING OR AN AF IN PTMAP |
| IC84100 | ONSTAT -P STATISTIC LOGREC-RA IS NOT DESCRIBED IN MANUALS |
| IC84102 | SET EXPLAIN CAN YIELD THE SERVER TO ABEND IN OPEXPLAIN |
| IC84227 | RENAME COLUMN OF REPLICATED TABLE CAN LEAD TO ASSERTION FAILURE IN CDRDDLUPDATESYSCDRAFTERRENAME_INT() |
| IC84229 | ASSERTIONS MAY OCCUR WHEN COLLECTION VARIABLES ARE USED AS GLOBAL VARIABLES |
| IC84367 | SPATIAL DATABLADE GETTING ASSERT FAILURE FILE WITH GENPG_BFRELEASE STORED BUFFER NOT FOUND |
| IC84408 | DRDA: SQLCA.SQLERRD2 CONTAINS NUMBER OF ROWS FROM PREVIOUS STATEMENT |
| IC84415 | CDR STOP AND INSTANCE SHUTDOWN CAN HANG IN RESYNCCB_DTOR() CALLED BY RESYNCSHUTDOWN() |
| IC84421 | EXECUTING STORED PROCEDURES WHILE UPDATING STATISTICS ON THE PROCEDURES FAILS WITH ERROR 312 ON SYSPROCPLAN |
| IC84723 | FATAL ASSERTION CRASH (SEGV) IN FUNCTION TABINEXPR WHEN LEFT JOIN USED |
| IC84727 | NO MATCHING RECORD FOUND FOR CURRENT SESSION FROM SYSOPENDB |
| IC84802 | ERROR -696 VARIABLE (G_TASK_ID) HAS UNDEFINED VALUE RUNNING THE SCHEDULER TASK AUTO_CRSD |
| IC84803 | MEMORY BLOCK HEADER CORRUPTION WITH 0X20202020 PATTERN OVER WRITE WITH INSERT TRIGGER ACCESSING VIEW IN ANOTHER DATABASE |
| IC84804 | UPDATE STATISTICS BEHAVIOR IS INCONSISTENT RIGHT AFTER UPGRADE TO 11.70 USING DEFAULT SETTINGS OF AUTO_STAT_MODE AND STATCHANGE |
| IC84819 | CREATING AN SPL CAN HANG IN FUNCTION OPEXPRRG AND MATCH_KEY |
| IC84822 | MIGRATION ISSUE: IT IS ALLOWED TO CONVERT AN INSTANCE WITH MISSING CHUNKS BUT NOT ALLOWED TO REVERT IT BACK |
| IC84847 | WITH BATCHREAD_INDEX USING A PREPARED STATEMENT, IF LOCK ERRORS ARE ENCOUNTERED, IT CAN CAUSE READ_RECORD: DELETED ROWID ASSERTI |
| IC84849 | WINDOWS CSDK UNINSTALL FAILS IF INSTALLED IN A NON DEFAULT DIRECTORY |
| IC84851 | SHMGET: [1]: KEY <...>: OPERATING SYSTEM ERROR WITH HUGE PAGES ENABLED ON LINUX |
| IC84876 | AF CRASH SELECTING FROM A TEMP TABLE WHILE A CONCURRENT SESSION IS SELECTING FROM SYSMASTER SYSTABNAMES, SYSPTNTAB |
| IC84878 | ENGINE CRASHED WITH BF_ONWTLIST: ALREADY BUFFER OWNER DURING DATABASE CREATION IN NEWLY ADDED DBSPACE BY TASK() |
| IC84892 | IT IS NOT DOCUMENTED THAT TABLES WITH NEWLY ADDED EXPRESSION FRAGMENTS CANNOT BE REVERTED |
| IC84923 | A MULTI TABLE JOIN DOES NOT USE THE MOST EFFICIENT PLAN AFTER UPDATE STATISTICS HIGH IS RUN |
| IC84924 | DRDA: SERIAL FIELDS COMING FROM OUTER JOINS AND CONTAINING NO DATA ARE NOT SET TO NULL |
| IC84926 | ONTAPE ARCHIVE WITH TAPEDEV SET TO A REMOTE HOST CAN FAIL REMOTE TAPE DEVICE PROCESS TERMINATED DUE TO SIGNAL 100 ERRNO 10 |
| IC84927 | SWITCHING OFF RSS_FLOW_CONTROL DOES NOT TAKE EFFECT IMMEDIATELY |
| IC84973 | ERROR 19995 WHEN ATTEMPTING TO RENAME A COLUMN OF A TABLE WHICH IS INCLUDED IN AN EXCLUSIVE TEMPLATE |
| IC84974 | DRIDXAUTO INDEX REPLICATION NO LONGER WORKING |
| IC84975 | UPDATE STATISTICS HIGH OR MEDIUM RETURNS -768 ERROR IF TABLE WAS CREATED WITH STATLEVEL FRAGMENT |
| IC84977 | UNKNOWN ERROR MESSAGE 52222869 APPEARS WHEN LOADING NUMERIC DATA IN A FORMAT NOT MATCHING THE LOCALE SET AND DBMONEY IS NOT SET |
| IC85042 | EXECUTING A REMOTE PROCEDURE ON 11.70.XC3 OR HIGHER FROM 7.31 RETURNS 674 |
| IC85043 | UDR CACHE IN NEED OF URGENT PERFORMANCE IMPROVEMENTS - IN PARTICULAR FOR SPLS WITH GLOBALS |
| IC85086 | SPORADIC HPL FAILPOINT 18006 POSSIBLE DURING TABLE LOAD OPERATIONS |
| IC85089 | SELECT MAX() CHOOSES QUERYPLAN WITH HIGHER ESTIMATED COSTS |
| IC85111 | PARALLEL ADD AND DROP OF DBSPACES OR CHUNKS CAN LEAD TO UNEXPECTED INSTANCE ABORT |
| IC85112 | THE IMPLICIT CAST BETWEEN CHAR AND DECIMAL IN UNION ALL SELECT WITH BINARY OPERATION PLUS 0 RETURNS ERROR -308 |
| IC85122 | INFORMIX DRDA DOES NOT SET SQLCA.SQLWARN CORRECTLY FOR NON-ANSI DATABASES |
| IC85123 | CDR START REPL WITH SYNCDATASOURCE IN BACKGROUND MODE CAN SHOW 691 ERROR |
| IC85148 | SEGV IN FMFTOPEN_WITH_CHILD AFTER SKIPPING INDEX |
| IC85174 | ONSTAT OUTPUT CONTAINS UNREADABLE INFORMATION IN TTY AND HOSTNAME COLUMNS |
| IC85175 | ROLLFORWARD ERROR ON RSS AFTER FAILOVER |
| IC85179 | ERROR 9602 ILLEGAL ATTEMPT TO CONVERT A COLLECTION TYPE OCCURS UNDER SPECIFIC CONDITIONS WHEN USING SPL FUNCTION |
| IC85187 | AFTER HDR PING TIMEOUT, PRIMARY CANNOT RECONNECT, ERROR RECEIVED CONNECTION REQUEST FROM REMOTE SERVER WHEN DR ISNT OFF |
| IC85212 | SELECT COUNT(*) WITH ORDER BY CAN LEAD TO AF IN LDDBLNULL WHEN INDEX SKIP SCAN PATH IS CHOSEN BY THE OPTIMIZER |
| IC85223 | DISTRIBUTIONS QUICKLY GROW STALE ON AUS_COMMAND TABLE AND SLOWS AUS_REFRESH TASK |
| IC85262 | AF IN COMP_UDR WHEN EXECUTING A PREPARED SQL STATEMENT THAT CONTAINS DATE DATA TYPE, MANY HOST VARIABLES AND STMT_CACHE SET TO 2 |
| IC85326 | ASSERT FAILURE WHEN SELECTING PARAMTYPES FROM SYSPROCEDURES |
| IC85328 | GET A -243 ERROR RUNNING A PDQ QUERY ON AN RTREE |
| IC85334 | NO ERROR MESSAGE IS RETURNED WHEN EXECUTING TRUNCATE TABLE FOR A TEMP TABLE ON AN HDR SECONDARY |
| IC85364 | NO DESCRIPTION ABOUT THE MAXIMUM NUMBER OF OPEN TRANSACTIONS ON LIMITATION LIST |
| IC85365 | ERROR 674/111 FOR UPGRADE_PH_TASK.SQL AT LINE 46 APPEARS IN THE ONLINE.LOG AFTER MIGRATION FROM 11.50 TO 11.70 |
| IC85389 | ASSERTION FAILURE ON A SECONDARY SERVER PG_FRPTR 3798 < SIZEOF(IFX_PAGE_T) 24 OR > SLOTBEG 3796 WHEN INSERTING ROWS INTO A TABLE WITH NCHAR COLUMNS USED AS INDEX. |
| IC85390 | SQLEXEC THREADS BOUND FOREVER TO CPU VPS |
| IC85392 | EXECUTE FUNCTION ADMIN(RESET SYSADMIN) ALWAYS CREATES SYSADMIN IN DBSPACE |
| IC85493 | CMSM FAILOVER IS NOT HONORING HA_ALIAS |
| IC85500 | COMPLEX QUERY USING A PLAN WITH A HASH JOIN CHOSEN BY THE OPTIMIZER MUCH SLOWER THAN A PLAN WITH A NESTED LOOP JOIN |
| IC85511 | SERVER ASSERT WHILE DOING ENCRYPTION AND DECRYPTION WITH ENCRYPT_CDR SET TO 1 |
| IC85518 | PTMAP ASSERTION FAILURE POSSIBLE WHEN ACCESSING TABLE WITH FOREST OF TREES INDEX FOLLOWING TRUNCATE TABLE OPERATION |
| IC85521 | ASSERT FAILURE MEMORY POINTER FREED TWICE POSSIBLE WHEN EXECUTING MULTI INDEX SCAN |
| IC85522 | CONNECTION MANAGER LEAKS MEMORY WHEN ONE OR MORE OF THE MACH11 NODES ARE NOT ACCESSIBLE |
| IC85523 | BTSCANNER THREADS DO NOT START ON HDR SECONDARY AFTER INSTANCE RESTART |
| IC85529 | SIMPLE DRDA CONNECTION CAUSES AF ON WINDOWS 64-BIT |
| IC85545 | CHUNKNUM AND SEQNUM CAN BE SET TO ZERO DURING SBLOB INSERT WITHIN SBA_LOHEADER_CREATE_WLOCK |
| IC85546 | ONSTAG -G CPU DISPLAYS NEGATIVE VALUES IN SCHEDS COLUMN |
| IC85549 | CONNECTION MANAGER CAN ALLOCATE ALL THE AVAILABLE MEMORY AND EVENTUALLY GET KILLED BY THE OS |
| IC85583 | ONMODE -WF/-WM HA_ALIAS DOES NOT WORK ON HDR SECONDARIES |
| IC85586 | ONMODE_MON THREAD CAN HANG IN DR_MODE() WITH DR_PRSEND THREAD WAITING ON NEXT BUFFER AFTER ONMODE -D STANDARD |
| IC85634 | MIGRATION STOPS WITH AN ASSERT FAILURE AND CRASH ON THE READAHEAD_0 THREAD WITHIN FUNCTION PTHDRGETX() |
| IC85664 | ASSERTION FAILURE POSSIBLE IN OLAPTMP_CALLB |
| IC85665 | ASSERTION FAILURE POSSIBLE IN GET_COLLATION_STRENGTH() DURING MIGRATION WHEN SYSTEM DATABASES ARE CREATED WITH NLS |
| IC85688 | DBEXPORT CONVERTS ALTER TABLE DISABLE INDEX TO INVALID SYNTAX CAUSES DBIMPORT TO FAIL WITH -201 ERROR |
| IC85690 | DOCUMENTED BEHAVIOR OF RESET SYSADMIN WITHOUT SPECIFYING TARGET DBSPACE IS INCORRECT. |
| IC85693 | DBIMPORT FAILS WITH PREPARE SQLOBJ -201 ERROR |
| IC85755 | MIGRATION FROM OLD VERSION CAN FAIL TO START WITH NO ERROR OUTPUT IF MIRROR IS SET TO 1 |
| IC85782 | ASSERTION FAILURE POSSIBLE IN SEND_ROW_TO_CONSUMER WHEN QUERY RUNS WITH PDQ |
| IC85846 | ERROR -201 FROM QUERIES RUNNING ON 11.70 AND ACCESSING REMOTE OBJECTS FROM 7.31 |
| IC85913 | MEMORY CORRUPTION AF DUE TO ONE-BYTE OVERFLOW WHEN USING DRDA PROTOCOL WITH DBPATH SET |
| IC85939 | HUGE MEMORY CONSUMPTION ON INSERT INTO LIST |
| IC86113 | THE OPTIMIZER CHOOSES A TABLE SCAN OVER AN INDEX SCAN WHEN A FUNCTIONAL INDEX WITH PLACE HOLDER VALUE IS USED |
| IC86188 | EXTRACT THE PRODUCT FILES (-DLEGACY OPTION) PERFORMING A REGULAR INSTALLATION AND REMOVING THE RUNASROOT.* FILE |
| IC86228 | DATA SERVER CLIENT THROWS ERROR SQL30061N SQLSTATE=08004 ON CONNECTION, IF AN INVALID DB_LOCALE IS SET ON CLIENT |
| IC86235 | SERVER MIGHT TERMINATE DURING ROLLBACK OF XA TRANSACTION WITH LOGGED TEMP TABLE |
| IC86268 | REMOTE QUERY FAILS WITH ERRORS -245/-103. ONCHECK -CDI DOES NOT REPORT ANY ERROR |
| IC86349 | SECONDARY SHUTDOWN CAN HANG IF CONNECTION MANAGER IS CONNECTED |
| IC86368 | FOR CONNECTION MANAGER OF VERSION 11.70.XC5/3.70.XC5 IT MAY BE NECESSARY TO SET LOCAL_IP |
| IC86370 | CDR REPAIR ATS/RIS CAN RUN INTO ERROR -958 TEMP TABLE TTEMP ALREADY EXISTS IN SESSION |
| IC86371 | DEFINE A REPLICATE CAN CRASH THE SERVER IF A PARTICIPANT TABLE HAS A PRIMARY KEY THAT CONTAINS USER-DEFINED TYPES (UDT) |
| IC86389 | CREATING A USER FAILS WITH ISAM 103 IF CONNECTING A DATABASE WHICH WAS CREATED WITH NON DEFAULT LOCALE |
| IC86394 | A JOIN ON NCHAR COLUMNS IN DATABASE WITH CS_CZ.8859-2@SIS LOCALE RETURNS NO ROWS EVEN IF IT SHOULD |
| IC86475 | ERROR 19828 WHEN PROJECTION LIST DOES NOT INCLUDE EXPRESSION FROM ORDER BY CLAUSE AND GROUP BY CLAUSE IS PRESENT |
| IC86705 | DOC: ONUNLOAD/ONLOAD DOCUMENTATION NEEDS CLARIFICATION REGARDING SMART-BLOB DATA TYPES |
| IC86706 | DELETE STATEMENT DOES NOT REMOVE ALL OF THE CORRECT ROWS WHEN OPTIMIZER SELECTS MULTI INDEX PATH |
| IC86730 | LOGICAL LOG REPLAY ERROR ON HDR SECONDARY WHEN PRIMARY DATA PAGES NUMBER OF SLOTS GETS OUT OF SYNC WITH SAME PAGE ON SECONDARY |
| IC86761 | AFTER UPGRADE FROM 11.50.FC8 TO 11.70.FC5, EXECUTING A PROCEDURE GIVES ERROR 674: ROUTINE CANNOT BE RESOLVED |