Fix list for Informix Server 11.70.xC9
Informix Server 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.xC9. This report combines both Windows- and UNIX-specific defect fixes, and is more current than the defect information included in the product release.
|
APAR
|
Description
|
| IC82742 | EXECUTING QUERY HAVING MULTIPLE JOINS, WITH STMT_CACHE ENABLED GIVES ERROR 640: QPLAN SANITY FAILURE |
| IC91410 | WRONG COMPUTATION FOR THE LOG SPACE USED IN ONSTAT -G HIS |
| IC92085 | AN UPDATABLE_SECONDARY HAS NO WAY TO INHERIT EXCLUSIVE LOCKS FROM THE PRIMARY AND CAN LEAD TO DR OUTAGES |
| IC92235 | MISLEADING ERROR -952 REPORTED TO ONLINE.LOG FOR PROXIED CONNECTIONS AND SECURITY_LOCALCONNECTION > 0 |
| IC92314 | QUERY EXECUTES WITH GOOD PERFORMANCE WITH IDS 10 BUT 11.70 REQUIRES OPTIMIZER DIRECTIVES TO GET BETTER PERFORMANCE |
| IC92651 | ASSERT FAILS ON SECONDARY SERVER WHEN SELECTING FROM A TABLE AND A DELETE IS OCCURRING ON THE SAME TABLE ON THE PRIMARY |
| IC93172 | ATTEMPT TO CONNECT VIA DRDA TO AN INSTANCE IN SINGLE-USER MODE WILL UNEXPECTEDLY TERMINATE THE INSTANCE |
| IC94346 | USING TIMESERIES AS A VARIABLE IN A STORED PROCEDURE GIVES AN ASSERT FAILED DURING CREATE PROCEDURE |
| IC94738 | IFX_ROW_ID UNDOCUMENTED FEATURE IS DOING SEQUENTIAL SCAN INSTEAD OF READING DIRECTLY IN THE APPROPRIATE PAGE |
| IC94894 | ONSTAT -X DISPLAYS DIFFERENT OUTPUT THAN IDS V10.00 |
| IC94980 | ONSTAT -U MAY RETURN CHANGING DATA STRUCTURE, FORCED COMMAND TERMINATION. AFTER AN ONBAR BACKUP FAILED WITH XBSA ERROR. |
| IC95749 | READAHEAD MUTEX CAN BECOME POINT OF CONTENTION ON LARGER SYSTEMS WHEN THE NUMBER OF READAHEAD THREADS INCREASES |
| IC95781 | GENONCFG FAILS WITH AN INEXPRESSIVE ERROR MESSAGE |
| IC95782 | GENXMLELEM() IS CAUSING MEMORY CORRUPTION |
| IC96167 | INSERT INTO MQ VIRTUAL TABLE FAILS WITH -9262 AT COMMIT IF YOU HAVE CONCURRENT ACCESS TO THIS TABLE |
| IC96168 | -9262 AT COMMIT BECAUSE OF AN ERROR WITH THE MQ DATABLADE DOESNOT ROLLBACK INSERT INTO NORMAL DATABASE TABLE |
| IC96581 | REMOTE QUERY RETURNS 244/151 WITH A VARCHAR COLUMN |
| IC96671 | EFFECT OF MQIPOLICY.RCV_WAIT_INTRVL FOR A SELECT ON A VTI MQ TABLE SHOULD BE CHANGED |
| IC97019 | SERVER CAN CRASH IN LDDBLNULL() IF A SUB-QUERY REFERENCES, IN AN AGGREGATE, A COLUMN FROM THE MAIN QUERY |
| IC97021 | HAVING A SYMBOLIC LINK POINTING TO ONCONFIG ON ANOTHER FILESYSTEM WILL BE REMOVED RUNNING ONMODE -WF |
| IC97350 | ESTIMATED COSTS FOR INDEX PATH IS HIGHER THAN SEQUENTIAL SCAN AND INDEX-SKIP-SCAN |
| IC97427 | LOG_PUT( OLDRSAM:73, 271666488): NOT IN CRITICAL SECTION MESSAGE REPORTS BAD LEN |
| IC97459 | BTSCANNER THREAD DOING LEAF SCAN DOING TOO MUCH WORK WITHOUT YIELDING TYING UP CPU VP PREVENTING OTHER THREADS FROM RUNNING |
| IC97462 | AF IN SRTNEXT:((BUF->SB_NROWS < SR->SR_IOROWS) ... WHEN FETCHING THE RECORDS IS INTERRUPTED BY CTRL+C AND THEN CONTINUES |
| IC97539 | CREATE BTS INDEX FAILS WITH ASSERT WHEN SMARTBLOBSPACE IS FULL |
| IC97643 | WINDOWS: LONG SQL/SPL STATEMENT TRUNCATED WHEN LOADED INTO DBACCESS MULTIPLE TIMES |
| IC97672 | DROP INDEX ONLINE ON AN ATTACHED (IN TABLE) INDEX WOULD LOCK THE TABLE FOR ITS ENTIRE DURATION |
| IC97674 | AFTER USING ONMODE -P START TO DYNAMICALLY START A NEW LISTEN THREAD, UNABLE TO CONNECT TO THE NEW DBSERVERALIAS |
| IC97898 | AUTOMATIC LOGICAL LOG BACKUP FAILS BECAUSE WE ALLOW ENGINE TO START IF INFORMIXSERVER IS INCORRECTLY SET |
| IC97972 | ONCHECK FAILS TO VALIDATE A FRAGMENTED TABLE WITH ROWID IF IT CONTAINS AN EXTENDED TYPE COLUMN |
| IC98194 | -302 ERROR WHEN DOING A GRANT SELECT ON A VIEW |
| IC98247 | SQ_SGKTUPLE IS MISSING SOMETIMES WITH SQ_INSERTDONE WHEN INSERTING FROM JDBC WITH RETURNGENERATEDKEY ENABLED |
| IC98327 | -202 GENERATED WHEN INSERT, DELETE AND SELECT OF UTF8 CHARACTERS IN A STRESSED ENVIRONMENT |
| IC98342 | THE COMPRESSION ESTIMATE DOES NOT TAKE INTO ACCOUNT THE MAXIMUM NUMBER OF SLOTS PER PAGE WHEN COMPUTING THE GAIN |
| IC98345 | DOCUMENTATION ON TRUSTED CONTEXT UNIQUENESS ACROSS DATABASES SHOULD BE MORE ACCURATE |
| IC98384 | -874 FROM FIND_MATCHING_IDXSCAN |
| IC98400 | REPLICATED LVARCHAR COLUMNS WITH DIFFERENT SOURCE/TARGET LENGTHS CAN LEAD TO MEMORY CORRUPTION |
| IC98403 | CASE EXPRESSION WITH TEXT OR BYTE COLUMN RETURNS 615 ERROR |
| IC98433 | OPTIMIZER CHOOSED SEQUENTIAL SCAN FOR QUERY WITH LVARCHAR, WITH VARCHAR OPTIMIZER CHOOSES INDEX PATH |
| IC98435 | SQLCODE:-243 ISAM:-154 AFTER SHUTTING DOWN AND RESTARTING PRIMARY |
| IC98458 | AN INCREASING NUMBER OF CHUNKS CAN INCREASE THE DURATION OF AN ONMODE -C BLOCK |
| IC98474 | ER DATA SYNC THREADS TRYING TO WRITE LOGICAL LOG RECORDS OUTSIDE OF CRITICAL SECTION CAN CRASH THE SERVER |
| IC98519 | A UDR WHICH REPEATEDLY OPENS A CURSOR AGAINST A VIEW WITH UNION ALL IS VERY SLOW AND MEMORY CONSUMING WHEN RUN WITH PDQ |
| IC98529 | THE ONCHECK -CD CAN REPORT WARNING: DATA PAGE APPEARS TO BE MORE OR LESS FULL ... IF MAX_FILL_DATA_PAGES SET TO 1 IN 11.70.XC8 |
| IC98549 | ONLINELOG CAN CONTAIN DUPLICATE VP AFFINITY MESSAGES |
| IC98569 | KILLING A SESSION WAITING ON A LOCK WILL NOT BE DESTROYED UNTIL THE LOCK IS RELEASED BY THE OTHER SESSION |
| IC98570 | SELECT FIRST X.... ORDER BY X DESC GIVES WRONG RESULTS |
| IC98589 | ONSTAT -L CAN SHOW INVALID PAGES / IO RESULTS FOR THE PHYSICAL LOG BUFFER STATISTICS |
| IC98649 | SERVER EXCEPTION IN RELEASE_NAMETABLE WHILE CLEANUP SAPI MEMORY |
| IC98710 | SIMULTANEOUS CREATION OF TWO EXTERNAL TABLES WITH THE SAME NAME IN ONE DATABASE CAN CAUSE A ROLLBACK ERROR 126 AND A CRASH |
| IC98711 | RECOVERY OF LOGGED INDEX PAGES CAN CORRUPT THE INDEX |
| IC98713 | RVDB (REVOKE DATABASE ACCESS) AUDIT-EVENT MNEMONIC DESCRIPTION IS MISSING BEGINNING WITH 11.50 DOCUMENTATION |
| IC98716 | MEMORY LEAK IN GLOBAL MEMORY POOL CAUSED BY CONNECTION COMING FROM CONNECTION MANAGER IN PROXY MODE |
| IC98720 | MIRROR CHUNK IS MARKED DOWN ON HDR SECONDARY AFTER ADDING CHUNK ON PRIMARY |
| IC98729 | ODBC SQLGECOLUMNS RETURNS NOTHING WHEN THE DATABASE IS CREATED WITH GL_USEGLU SET AND TABLE NAME CONTAINS AN _ CHARACTER |
| IC98730 | ERROR 79784 LOCALE NOT SUPPORTED WHEN LOADING A JAR WITH PL_PL.PC-LATIN-2 LOCALE |
| IC98731 | SIMPLE QUERY WITH GROUP BY RETURNS WRONG RESULT IF MULTI INDEX SCAN IS USED |
| IC98843 | CDC API ERROR 9810/83792 SNOOPING TABLE WITH VARCHAR COLUMN USING COMPRESSION IF CHECKPOINT HAPPENS WHEN FORWARDING HOME ROW |
| IC98944 | THE OUTPUT OF ONSTAT -G CMCM SOMETIMES SHOWS TWO ENTRIES FOR THE SAME CLUSTER |
| IC98947 | JAVA/JDBC PROGRAM EXECUTING SPL WHICH TAKES A SET ARGUMENT ASSERT FAILS (SIGSEGV) IN UDRLM_EXEC_ROUTINE() |
| IC99034 | SLOW INSERT PERFORMANCE WITH CONCURRENT INSERT OPERATIONS AND BITMAPS ARE NOT PRESENT IN BUFFER POOL |
| IC99058 | CDR CHECK WITH REPAIR CAN CORE DUMP WITH A UTF8 TARGET DATABASE |
| IC99091 | ERROR 1277: INPUT DOES NOT MATCH FORMAT SPECIFICATION, USING DATETIME FORMAT |
| IC99178 | SERVER CRASHED WHILE RUNNING MULTIPLE TRUNCATE STATEMENTS |
| IC99180 | IN A NON-LOGGING DATABASE LOCKS ON SYSPROCPLAN ARE HELD TOO LONG WHEN TRIGGER REFERENCES ARE USED |
| IC99184 | PARTITION PROFILE INFORMATION IN SMI TABLES IS SOMETIMES NOT ACCURATE |
| IC99190 | A SIMPLE INSERT INTO FRAGMENTED TABLE WITH ROWIDS CAN TAKE MANY MINUTES WHEN YOU EXCEED 2147483647 ROWS |
| IC99247 | CDR SYNC REPLICATE CRASHES IF FOREIGN KEY REFERRING TO THE SAME TABLE |
| IC99248 | STACK OVERFLOW POSSIBLE IN DWA_PROBEDELIVE |
| IC99329 | CONNECTIONS COMING FROM CONNECTION MANAGER IN PROXY MODE CAN LEAVE ORPHANED SESSIONS IN THE ENGINE IF INFORMIXCONTIME=1 |
| IC99356 | SERVER AUTOMATICALLY GRANTS GRANT SELECT PRIVILEGE ON A VIEW WHEN IT IS CREATED. |
| IC99362 | ERROR -873 OBSERVED WHILE INSERTING INTO A FRAGMENTED TABLE THAT HAS BEEN RENAMED |
| IC99364 | LACK OF CHECKS ON RELOCKABLE MUTEX LOCK COUNT COULD LEAD TO NEGATIVE VALUES AND AN INDEFINITE WAIT |
| IC99440 | ONDBSPACEDOWN DEFAULT SETTING OF 2 INCORRECTLY APPLIES TO TEMPORARY DBSPACES |
| IC99526 | ASSERT FAIL AND CRASH POSSIBLE IN SEND_ROW_TO_CONSUMER OR PK_PUTFREE WHEN RUNNING QUERY WITH PDQ |
| IC99549 | 9791 ASSERT FAILURE ON DELRANGE WHEN BEGIN_STAMP OR END_STAMP ARGUMENT PASSED IN IS NULL |
| IC99560 | FEA: PAM AUTHENTICATION SUPPORT TO DRDA CLIENTS |
| IC99561 | ASF ECHO-THREAD SERVER: ... MESSAGE USED TOO WIDELY AND NOT HELPFUL AT ALL OR MISLEADING EVEN |
| IC99564 | THE RENAME COLUMN ON A TABLE WITH A DEFINED TRIGGER ABENDS THE INFORMIX DATABASE SERVER IN COLNMFIND() |
| IC99565 | CDCAPI CALLING CDC_STARTCAPTURE ON TABLE ALTERED TO RANGE/INTERVAL EXPRESSION CRASHES SERVER IF RESULT TABLE HAS ONLY 1 FRAGMENT |
| IC99687 | WHEN NODEFDAC IS SET AND A ROLE GRANTS SELECT ON A TABLE, IT PREVENTS DBSCHEMA TO WORK AS EXPECTED AND RETURNS UNEXPECTED -999 O |
| IC99716 | ASSERT FAILURE AND CRASH IN OPLOOKSUBQ DURING PREPARE OF QUERY USING STATEMENT CACHE WHEN BATCHEDREAD_TABLE IS CHANGED |
| IC99717 | THE AUS_CMD_RUNTIME COLUMN IN THE TABLE SYSADMIN:AUS_COMMAND IS NOT DOCUMENTED |
| IC99720 | (BTS22) - BTS_CONTAINS REQUIRES AN INDEX ON THE SEARCH COLUMN - RETURNED IF BTS_CONTAINS() REFERENCES A CONCAT() WITH A BOUND PA |
| IC99756 | REPLICATING LVARCHAR COLUMN FROM EN_US.819 TO EN_US.UTF8 CAN LEAD TO MEMORY CORRUPTION |
| IC99867 | ONLY VERBOSE MODE OF ONSTAT -G RSS SHOWS LOG TRANSMISSION BEING BLOCKED |
| IC99877 | RCV THREAD GOT UNEXPECTED MSG 99 WHEN SETTING UP PRIMARY AND RSS PAIR OF DIFFERENT VERSIONS |
| IC99879 | USING SEQUENCES EXTENSIVELY THE SERVER MAY REPORT INVALID MUTEX TYPE IN GET_NEXTVAL |
| IC99882 | WHERE IN IS SLOW AND CONSUMING A CPU VP |
| IC99895 | ONMODE -WF DUMPSHMEM=0 CLEARS ONCONFIG FILE |
| IC99955 | IDLE THREAD CAN ABEND SERVER IN MT_MEMSYNC_SCAN() |
| IT00264 | SELECT STATEMENTS USING OLAP MAY RUN INTO A -768 ERROR IN OLAP_TEMPTAB_WRITE |
| IT00329 | AUTHENTICATION OF MAPPED USER ON SECONDARY SERVER FAILS WITH ERROR -951 |
| IT00353 | RALLOC BLOCKS MEMORY LEAK IN A SESSION CAUSED BY EXECUTE IMMEDIATE PREPARED MERGE STATEMENT |
| IT00356 | OPTIMIZER TRACE CODE ON STORED PRODURE MAY FAIL IN TRACE_EXPR_PRE FUNCTION |
| IT00357 | BLD REF CONSTRAINT MUTEX CAN BECOME A PERF. BOTTLENECK ON SYSTEMS WHERE HIGH NUMBER OF SPL STATEMENTS NEED TO BE RE-PREPARED |
| IT00549 | CDR REPAIR GOT -23197 ERROR WHILE REPLICATE INVOLVES UTF8 CONVERSION |
| IT00550 | SELECT USING COMPOSITE INDEX DOES NOT RETURN ROWS WHEN IS NULL FILTER IS USED AS INDEX KEY |
| IT00587 | PRIMARY SERVER CAN BLOCK WAITING ON NEXT LOG FILE TO BE FREED IF THE SECONDARY HAS FAILED DURING LOG CATCHUP PHASE |
| IT00600 | USING A BAD INDEX IN QUERY A CAN LEAD TO AN ASSERTION IN QUERY B IN FMFTOPEN() |
| IT00620 | COMPLICATED QUERY USING TABLE EXPRESSIONS AND ANSI JOINS CAN CAUSE EXCEPTION IN AJ_ATTFL |
| IT00678 | POTENTIAL FOR HANG ON BLD REF CONSTRAINT MUTEX OR MODIFICATION OF MEMORY UNRELATED TO DICTIONARY CACHE |
| IT00703 | QUERY RETURNS INCORRECT RESULTS WITH PDQ ENABLED, OPTOFC=1, FRAGMENTED INDEX SCAN AND SUBQUERY IN MULTIPLE EXECUTIONS |
| IT00771 | DBIMPORT CAN CREATE TABLES WITH TOO LARGE FIRST EXTENT SIZE AND CAN EXHAUST DBSPACE FREE SPACE HEREBY |
| IT00781 | EVEN WITH THE FIXES FOR IC98053 AND IC98529 THE ONCHECK -CD CAN REPORT WARNING: DATA PAGE APPEARS TO BE MORE OR LESS FULL |
| IT00802 | ASSERTION FAILURE CRASH IN MT_PRTCBLST POSSIBLY WHEN RUNNING SYSMASTER QUERY AGAINST SYSTCBLST |
| IT00825 | AF IN TS_AM_PUT_NTH_ELEM_INMEM() ON WINDOWS WHEN VIRTUAL MEMORY SEGMENT USES AN ADDRESS > MAX VALUE STORED IN 4 BYTE INT |
| IT00899 | RSS HIT SEGMENTATION FAULT IN PROXYWRITEPOSTXACNTL WHEN SMX CONNECTION IS LOST |
| IT01019 | VP PRIVATE MEMORY CACHE IS NOT DRAINED DURING FAST RECOVERY WHICH MAY LEAD TO EXCESSIVE MEMORY USAGE |
| IT01049 | ASSERT FAILURE AND CRASH FOLLOWING FAILURE TO ALLOCATE A TRANSACTION |
| IT01051 | THE LOWER FUNCTION IN A QUERY AGAINST A UTF8 DATABASE CAN FAIL WITH ERROR -941 WHEN ANOTHER ESQL/C PROGRAM IS ACCESSING THE DATA |
| IT01074 | AN UPDATE TRIGGER CALLING A STORED PROCEDURE THAT DOES AN INSERT INTO ANOTHER TABLE CORRUPTS DATA ON SDS SECONDARY |
| IT01128 | PDQ QUERY HANGS ON MUTEX FREE_LOCK |
| IT01131 | AUTO_CKPT DOES NOT PRINT AN ADVISORY MESSAGE WHEN IT TRIGGERS A CHECKPOINT |
| IT01154 | OUTER JOIN RETURNS INCORRECT RESULTS |
| IT01261 | IT MUST BE DOCUMENTED THAT VPCACHE OPERATING IN DYNAMIC MODE CAN GROW QUITE LARGE ON BUSY SYSTEMS |
| IT01329 | QUERY USING JOIN, GROUP BY AND COUNT(*) RETURNS BAD RESULTS WHEN DS_NONPDQ_QUERY_MEM SET TOO LOW |
| IT01420 | UPDATE STATISTICS COMMAND DOES NOT UPDATE STATISTICS FOR PROCEDURES AS STATED |
| IT01467 | IWA: ERROR MESSAGE 22283 RETURNED FROM OFFLOADED QUERY |
| IT01468 | AF IN XTF_COPY_DATA() POSSIBLE WHEN XTRACE USED ON WINDOWS AND MULTIPLE CPU VPS ARE CONFIGURED |
| IT01478 | ROLLBACK OF A GLOBAL (XA) TRANSACTION CAN GENERATE ASSERTION WARNING FREEING TRANSACTION ENTRY THAT STILL HOLDS LOCKS! |
| IT01524 | IWA: ACCESS TO FREED MEMORY POSSIBLE WHEN OFFLOADING A QUERY AND IN PARALLEL A MART IS DROPPED |
| IT01539 | THE SERVER CAN CRASH IN FM_FINDINFO() WHILE CLOSING INDEX FRAGMENTS. |
| IT01646 | QUERY ON SYSSQEXPLAIN DOES NOT RETURN ANY VALUES FOR SQX_BUFREADS, SQX_PAGEREADS, SQX_BUFWRITES, SQX_PAGEWRITES, SQX_TOTSORTS |
| IT01657 | USING GL_USEGLU WITH NCHAR DATA TYPE CAN RESULT IN BAD INDEX |
| IT01676 | GSK ERROR GSK_ERROR_SOCKET_CLOSED AND SSL CONNECTION HANG UNDER STRESS |
| IT01681 | MEMORY LEAK IN PRP.. POOL WHEN SPL PROCEDURE EXECUTED VIA INSERT TRIGGER ON A VIEW |
| IT01696 | ONBAR FAILS TO DISPLAY CONTENTS OF A LOGICAL LOG WHEN THERE IS A PROBLEM IN THE IXBAR FILE FOR A LOG THAT FOLLOWS IN SEQUENCE |
| IT01697 | ERROR CODE PATH IN MGM_GETMEM CAN LEAVE THE MGM MUTEX LOCKED |
| IT01702 | UDR REMOVAL FROM SESSION CACHE CAN CAUSE PREMATURE TRANSACTION COMMIT AND ERROR -124 ON COMMIT OR ROLLBACK |
| IT01703 | DBSCHEMA WILL NOT DISPLAY OWNER NAME ON PROCEDURE WHEN PROCEDURE WAS CREATED WITH ENVIRONMENT VARIABLE NODEFDAC SET TO YES |
| IT01716 | ASSERT FAILURE WHILE CREATING ONLINE INDEX DURING DATA LOAD |
| IT01750 | VIEW OF ALTERED TABLE RETURNS TRUNCATED RESULTS ON HDR SECONDARY |
| IT01811 | IFX_RET_TYPES() COULD FAIL WITH -9791 WHEN STORED PROCEDURE RETURNS A DATETIME YEAR TO FRACTION |
| IT01840 | WITH NON-ZERO PDQPRIORITY OPTIMIZER ASSIGNS LOWER COST TO SEQUENTIAL SCAN WHILE INDEX PATH IS FASTER |
| IT01900 | INSERT INTO A FRAGMENTED TABLE WITH REFERENTIAL CONSTRAINT CAN RESULT IN ERROR 682/111 WHEN CONCURRENT DELETES ARE GOING ON |
| IT01902 | ENGINE CAN RETURN -259 ERROR ON FETCH OF CURSOR WITH HOLD IF AUTO_REPREPARE IS ENABLED AND STATEMENT GETS REPREPARED |
| IT02015 | CREATING MULTIPLE ATTACHED INDEXES ON SAME FIELD WITH ASC/DESC DIFFERENTIATOR RETURNS ERROR 350/108 |
| IT02017 | QUERY USING AND OR CLAUSE ON ROWID EXPRESSION AND A POSSIBLE INDEX SCAN FILTER CAUSES ASSERT FAILURE IN INDEX_INFO |
| IT02028 | INSTANCE CAN GET BLOCKED IN CHECKPOINT IF MAX_FILL_DATA_PAGES SET TO 1 AND CONCURRENT INSERTS OF LONG ROWS OCCUR |
| IT02129 | ERRATIC VALUES WHEN RUNNING SPL WITH VIEW, YOU MIGHT GET -1260 ,-1201, -9791 OR JUST RETURN NO DATA |
| IT02130 | UNEXPECTED DBSPACE FULL MESSAGE WHEN ARCHIVE HAS EXHAUSTED UNRELATED TEMPORARY DBSPACES |
| IT02182 | THE ONMODE COMMAND CANNOT CLEAN UP XA TRANSACTIONS WHEN IFX_XA_UNIQUEXID_IN_DATABASE IS ENABLED. |
| IT02187 | ASSERT FAILURE AND CRASH ON PROMOTION OF HDR SECONDARY TO PRIMARY WITH HEURISTICALLY COMPLETED XA TRANSACTION. |
| IT02190 | IWA QUERY PROBING FAILS IF EQUALITY JOINS BETWEEN COLUMNS ARE ACTING AS FILTERS |
| IT02293 | DISTRIBUTED QUERY CAN GET ERROR -934/-217 ERROR |
| IT02349 | AF OR CRASH ON EXECUTION OF INSERT FROM SELECT INTO A FRAGMENTED TABLE WITH PDQ ENABLED |
| IT02350 | HDRMKPRI.SH SCRIPT MAY FAIL TO CHANGE HDR SECONDARY SERVER TYPE TO PRIMARY |
| IT02390 | IFXCOLLECT APPEARS TO IGNORE THE -D OPTION AND COLLECTIONS TAKE LONG SLEEP TIMES BETWEEN ONSTAT SUB-COLLECTIONS |
| IT02561 | CDR REALIZE TEMPLATE FAILS WITH -208 MEMORY ALLOCATION ERROR WHEN TEMPLATE IS ON DATABASE WITH MORE THAN 32767 TABLES |
| IT02608 | SOME SELECTS REPORT AN ERROR 294 (NEED A GROUP BY) BUT THE QUERY ASSERT FAILS IF GROUP BY IS ADDED |
| IT02615 | SELECT WITH SUBSTRING CAN GENERATE BAD QUERY PLAN WITH FILTER WITH SUBSTRING IS IN CLAUSE WITH SUBSELECT |
| IT02647 | ENGINE CRASHES DURING AUTO INDEX BUILD IF SHMTOTAL IS HIT AND IF TEMPORARY DBSPACE USES NONDEFAULT PAGESIZE |
| IT02679 | UPDATE STATISTICS HIGH ON A FRAGMENTED TABLE LEADS TO ERROR MESSAGE 9810 |
| IT02680 | WRONG RESULTS USING IFX_FOLDVIEW |
| IT02904 | SECONDARY SERVER CAN ABEND IN CREATE_OPEN_PARTITION_TXN_LIST DURING LOG ROLLFORWARD |
| IT02905 | RELSDBMEM DOES NOT NULL OUT SD_STMTSTATS AFTER FREEING THE HEAP IT WAS ALLOCATED FROM, COULD LEAD TO MEMORY CORRUPTION |
| IT03031 | OPENTABLE MEMORY OF A SESSION CAN GROW AND CAN LEAD TO OVERLY LARGER MEMORY CONSUMPTION AND POSSIBLY TO MEMORY FRAGMENTATION |
| IT03032 | LATCH COUNT NON-ZERO CHECK CAN TURN NON-FATAL INTO FATAL ASSERTION |
| IT03033 | DBSCHEMA OR DBEXPORT ABORTING IF UNIQUE INDEX USED BY PRIMARY KEY CONSTRAINT WAS DROPPED |
| IT03043 | MERGE STATEMENT WITH OPTIMIZER DIRECTIVE EXECUTED WITH PDQ RETURNS 230/101 |
| IT03266 | USE OF CURRENT IN WHERE CLAUSE OF A REMOTE QUERY RETURNS INCORRECT VALUES |
| IT03426 | POTENTIAL MEMORY CORRUPTION ASSOCIATED WITH TEMPORARY DBSPACE NAMES USED FOR SELECT INTO STATEMENT |
| IT03434 | PTALT_BUILD_OPERLIST: ERROR READING FIRST ALTER-DESC MESSAGE IS UNHELPFUL |
| IT03456 | ONBAR ABENDS IN BSAGETENVIRONMENT CALL USING EMC NETWORKER STORAGE MANAGER |
| IT03463 | UNHANDLED ERROR -648 IN A UDR CAN CAUSE AN ASSERTION FAILURE AND INSTANCE CRASH IN DO_PUTS() IF THE TRACING IS ON |
| IT03486 | WHERE EXISTS QUERY USES SEQUENTIAL SCAN IF RTREE INDEX EXISTS ON INNER TABLE |
| IT03528 | DISTRIBUTED QUERY CAN CAUSE THE IMPLICIT SSL CONNECTIONS TO HANG |
| IT03547 | CDR VIEW APPLY COMMAND WILL CHECK THE FILES IN ATS OR RIS DIRECTORY IN NESTED WAY |
| IT03570 | ASSERT WARNING TRYING TO FREE EXTENT FOLLOWING FAIL-OVER AND FAIL-BACK OF HDR PAIR WITH INTERRUPTED DEFRAGMENT OPERATION |
| IT03618 | CDR COMMAND CORE DUMPS IN CHECKACTIVEREPLICATE() |
| IT03643 | AFTER ROLLBACK OF TRANSACTION WITH SEVERAL ALTER TABLE STATEMENTS ERRORS -242/-106 MIGHT BE RETURNED TRYING TO ACCESS THAT TABLE |
| IT03740 | PDQ QUERY CHOOSES INDEX INSTEAD OF SCAN AND IS SLOWER THEN SAME QUERY ON 11.50. OPT_SEEK_FACTOR MAKES NO DIFFERENCE. |
| IT03769 | FAST CACHE PROBLEM WHEN DROPPING TABLE OR DATABASE CAN ASSERT CRASH WITH BAD BLOCK HEADER MT_SHM_FREE 1 |
| IT03860 | INCORRECTLY CLOSED SOCKET NETWORK CONNECTIONS WITH 25580 ERRORS DUE TO ERROR HANDLING CODE IN SENDSOCKET() |
| IT03862 | SYSTABLES INDEX IS CORRUPTED DURING ROLLBACK OF A CREATE TABLE |
| IT03925 | LOADING A BLOB INTO AN EXTERNAL TABLE FROM A DIRECTORY WITH EITHER A _ OR , IN THE NAME RETURNS PERMISSION DENIED ERROR 13 |
| IT04055 | ENABLING XTF_CDR_DBX AND DEFINING AN ER SERVER WILL CRASH THE ENGINE |
| IT04091 | IWA AF IN CONV_OBJNAME POSSIBLE WHEN OFFLOADING A QUERY |
| IT04184 | THE OPTIMIZER CHOOSES A BAD QUERY PLAN WHEN DATA DISTRIBUTION IS AVAILABLE FOR THE COLUMN. |
| IT04188 | -206 / -111 WHILE USING DBACCESS -> TABLE -> INFO -> STATUS ,ETC IF DELIMIDENT IS SET AND NOT OWNER OF OBJECT |
| IT04190 | AIX IPCSHM CLIENTS CAN CAUSE ERRNO=34, SHM SEMAPHORE FAILURE ASSERTION FAILURES |
| IT04296 | ENDLESS LOOP OF AF EXCEPTIONS POSSIBLE WHEN EXECUTING UDR AND STACK MEMORY IS CORRUPTED |
| IT04459 | BFFAIL OR BUFFCHECK FAILURE FROM SAMPLESTATS RUNNING UPDATE STATS LOW WHILE DELETES OCCURRING |
| IT04475 | SMALL BAD BLOCK HEADER OR BAD FREE BLOCK ASSERT FAILURE FILES PRODUCED WHEN WE FAIL TO REPAIR THE POOL. |
| IT04537 | ASSERT CRASH IN VALLOAD WHEN SELECT STATEMENT IS SELECTING AN AGGREGATE AND GROUP BY IS MISSING THIS COLUMN |
| IT04540 | SQL ERROR -9810 ISAM -140 WHEN TRYING TO RUN JAVA UDR ON READ ONLY SECONDARIES |
| IT04556 | THE OS_MEM_FREE COLUMN FROM SYSMASTER:SYSMACHINEINFO IS MISLEADING ON AIX |
| IT04585 | ONAUDIT FAILS WITH SEGMENTATION FAULT IN STRTOLL() WHEN ADTMODE (PARAMETER -L) IS SET WITHOUT A VALUE |
| IT04601 | ERROR 1213 WHEN OPTIMIZER ATTEMPTS A HASH JOIN METHOD ON AN OUTER JOIN |
| IT04610 | POTENTIAL MEMORY LEAK PROBLEM IN SESSION OPENTAB USING A WORKING SET OF MORE THAN 128 TABLES IN A SESSION |
| IT04652 | SQL STATEMENT WITH A LENGTHY STRING OF APOSTROPHES CAN LEAD TO M NY DIFFERENT ASSERTIONS RESULTING FROM 0X27272727 OVERWRITE PAT |
| IT04673 | GENONCFG ABORTS INSTEAD OF CREATING AN ONCONFIG FILE |
| IT04675 | GROUP BY? WITH AN ALIASED COLUMN RETURNS MULTIPLE ROWS |
| IT04708 | WITH BATCHEDREAD_INDEX = 0 AND A NON-LOGGED DATABASE, CERTAIN INDEX CORRUPTION COULD MAKE A SQLEXEC THREAD RUN IN A TIGHT LOOP |
| IT04757 | THE SQL OPTIMIZER PREFERS AN INDEX SCAN TO A SEQUENTIAL SCAN EVEN THOUGH IT IS 3 TIMES SLOWER |
| IT04783 | SUCCESSIVE UPDATE STATISTICS HIGH .... ON A TABLE WITH STATLEVEL FRAGMENT FILLS THE SBSPACE WHEN RUN IN ONE SESSION |
| IT04795 | ON WINDOWS, XML UDR FAILS WITH -9791 IF VIRTUAL EXTENSION MEMORY SEGMENT HAS AN ADDRESS LARGER THAN 0XFFFFFFFF |
| IT04819 | LEVEL 0 ARCHIVE STARTED IN 11.70.FC8W1 CAN CRASH THE SERVER IN THE ONTAPE THREAD |
| IT04849 | REMOTE QUERY USING VIEWS RETURNS INCOMPLETE RESULTS |
| IT05187 | SQL ERROR -710 ISAM -12234 CAN HAPPEN WHEN CONCURRENT SELECTS AND ALTER FRAGMENT ONLINE DETACH PARTITION ARE EXECUTED |
| IT05195 | MERGE INTO TARGET_TABLE IS LEAKING OPEN FILES AND POSSIBLY MEMORY |
| IT05220 | AN INDEX SCAN OF AN INDEX OVER NCHAR/NVARCHAR COLUMN CAN GENERATE MUCH MORE IOS THEN SIMILAR SCAN OF AN INDEX OVER (VAR)CHAR |
| IT05222 | PUT IN CLAUSE (FOR BLOB/CLOB STORAGE) GETS IGNORED WHEN USING DRDA AND DB2JCC DRIVER |
| IT05262 | RSAM POOL GROWS LARGE AFTER DBSCHEMA OR SYSMASTER QUERY WHEN AN INSTANCE HAS MANY DATABASES, TABLES, AND INDEXES |
| IT05383 | STACK AND MEMORY CORRUPTION RESULTING FROM SELECT STATEMENT WITH LARGE UNION ALL TABLE EXPRESSION |
| IT05463 | FRAGMENT BASED UPDATE STATS HIGH CONSUMES A HUGE AMOUNT OF SBLOBSPACE |
| IT05467 | SYSTEM GENERATED TEMP TABLES ARE ALLOCATED IN ROOTDBS WHEN TEMP SPACES ARE TOO SMALL |
| IT05481 | PO_FREETOTAL & PO_USEDTOTAL ARE INCORRECT AFTER BAD BLOCK DETECTED AND CAUSES MULTIPLE ASSERTIONS IN MT_CHECKPOOL2() |
| IT05499 | PARALLEL REPLICATE SET CHECK JOB MAY USE CDR_ESETOUTOFSYNC(213, WARNING) AS EXIT CODE EVEN THOUGH SOME OF THE REPLICATE J |
| IT05551 | DBACCESS CAN CORE DUMP ON EXIT AFTER THE ERROR -801 HAS OCCURRED |
| IT05672 | IFXCLONE FAILS WITH A VERSION MISMATCH ERROR WHEN THE VERSION NUMBER OF IDS IS GREATER THAN 12 CHARACTERS |
| IT05702 | USING -VERBOSE:GC IN JVPARGS ONCONFIG PARAMETER |
| IT05834 | CONNECT BY QUERY CREATES UNIQUE UNNAMED ROW TYPES AND STORES THEM IN SYSTEM CATALOG AND THEY ARE NEVER REMOVED |
| IT05846 | AUTO READAHEAD INCORRECTLY COUNTS INDEX-DATA READ AHEADS AS INDEX READ AHEADS |
| IT05921 | IDS_INSTALL RETURNS FALSE RETURN CODE 1 |
| IT05924 | INSTANCE WITH SMALL DATA DICT. CACHE MAY CRASH IN FRLUPDATETABPARTITION() WHEN RUNNING THE CDC_SET_FULLROWLOGGING() FUNCTION |
| IT06088 | ERROR 874 AND AF (NO ENGINE CRASH) CAN RESULT WITH AN IMPLICIT CAST ON A JOIN WITH A SERIAL ON A REMOTE TABLE |
| IT06095 | USERS CANNOT BE CONNECTED TO IDS ON WINDOWS WITHOUT PROVIDING USER NAME AND PASSWORD |
| IT06134 | SQSCB MEMORY IS NOT RELEASED WHEN USING DYNAMIC SQL AND DRDA PROTOCOL WITH DB2JCC DRIVER |
| IT06138 | IFX_INTERNAL_SET RETURNS ERROR 37 IF THE GROUP ID/NAME IS CHANGED IN SQLHOSTS |
| IT06139 | MEMORY LEAK IN CONNECTION MANAGER IF NO SERVER CAN BE REACHED |
| IT06149 | QUERY GIVES DIFFERENT RESULTS FROM SYSINDICES AND SYSINDEXES AFTER UPGRADE FROM 10.00.FC11 |
| IT06245 | CREATE INDEX IS VERY SLOW IF TABLE CONTAINS PARTITION BLOBS |
| IT06246 | CDR CLEANSTART COMMAND NOT PURGING TRG_SEND_SREP TABLE |
| IT06333 | DEFINING A REPLICATE ON A TABLE WITH A HUGE NUMBER OF COLUMNS FAILS |
| IT06371 | USING THE SKIP OPTION IN SUBQUERY CRASHES ENGINE IN RDATAVALCHAR() |
| IT06403 | THE OPTIMIZER CAN CHOOSE A POOR QUERY PATH DUE TO THE ORDER IN WHICH TABLES ARE LISTED IN THE FROM CLAUSE OF THE SQL |
| IT06430 | ONCHECK -CC FAILS WITH ERROR: NO TABLE FOUND FOR SYSAMS RECORD |
| IT06431 | ADDING NEW STATEMENTS TO THE STATEMENT CACHE UPON REACHING STMT_CACHE_HITS CAN CAUSE VARIOUS FAILURES |
| IT06440 | INSTANCE HANG WHEN DOING ONMODE -D SET SDS PRIMARY WHILE INSTANCE IS BLOCKED VIA ONMODE -C BLOCK |
| IT06473 | MISSING MESSAGE FILE IN CSDK INSTALLATION WHEN USING DBACCESS |
| IT06520 | CDR SYNC OF A REPLICATE ON A TABLE WITH A HUGE NUMBER OF COLUMNS CRASHES |
| IT06523 | INSERT CALLED FROM A STORED PROCEDURE BY AN INSERT TRIGGER FAILS EVEN THOUGH THE PROCEDURE OWNER HAS INSERT PRIVILEGES |
| IT06530 | EXTERNAL RESTORE FAILING WITH DBSPACE XYZ NOT RECOVERED FROM SAME ARCHIVE BACKUP AS DBSPACE ROOTDBS WHEN NO LOGICAL RESTORE IS |
| IT06547 | MEMORY LEAK IN RALLOC ON REMOTE SERVER WHEN RUNNING SELECT WITH LEFT JOIN |
| IT06556 | ERROR 768:INTERNAL ERROR IN ROUTINE MINDEXP: MISSING RANGE FILTER; WHEN WE USE MULTI-INDEX SCAN AND SET MULTI-BYTE LOCALE |
| IT06624 | EXTERNAL RESTORE FAILING WITH DBSPACE XYZ NOT RECOVERED FROM SAME ARCHIVE BACKUP AS DBSPACE ROOTDBS WHEN NO LOGICAL RESTORE IS |
| IT06644 | SLOW QUERY RESPONSE AND HIGH BUFFER READS ON EMPTY TABLE |
| IT06679 | REMOTE SELECT ON A VIEW WITH OUTER JOIN AND CONCATENATED COLUMN WITH FUNCTION RETURNS -393 |
| IT06726 | ASSERT WARNING INVALID INDEX STATISTICS FOUND WHEN USING STATISTICS SAMPLING WITH INDEX HAVING MANY DELETED ITEMS |
| IT06767 | UPDATE STATISTICS HIGH ON TABLE BIGGER THAN 1.1 BIO ROWS CAN CAUSE EXCEPTION IN SRTQUICK |
| IT06865 | THREAD LOOPS WHEN INSERTING ROW INTO TABLE MARKED FOR UPDATE-ANYWHERE REPL WITH CDR_SERIAL IN EFFECT AND CURRENT SERIAL AT MAX |
| IT06883 | SEGV CALLING BYCOPY() IN CHKPARENT() WHEN INSERTING IN SEVERAL TABLES AND WITH SHORTAGE OF MEMORY |
| IT06929 | PERSISTING LOG FILE FLAG 0X100 PREVENTS BACKUP OF LOGICAL LOG |
| IT07078 | ASSERT FAILURE IN DECRREFCOUNT POSSIBLE WHEN REFERENCING CLEANED UP DICTIONARY CACHE ENTRY |
| IT07191 | RSAM MEMORY POOL BLOCK HEADER CORRUPTION WHEN USING MULTI-LEVEL SAVEPOINTS |
| IT07292 | NESTED SELECT RETURNS 294: THE COLUMN COLUMN-NAME MUST BE IN THE GROUP BY LIST EVEN THOUGH THE COLUMN IS LISTED IN GROUP BY LIST |
| IT07378 | WHEN USING CHANGE DATA CAPTURE (CDC) TO SNIFF LOGS, THERE ARE INCONSISTENCIES WHEN INSERTING AND OR UPDATING A PRIMARY KEY |
| IT07388 | STALL POSSIBLE BETWEEN ALTER FRAGMENT ONLINE DETACH AND THREAD CLEARING DICTIONARY CACHE ENTRY |
| IT07391 | FUNCTION ADMIN(DROP CHUNK, SBSPACE, ...) IGNORING ANY METADATA EXTENTS OR EVEN USER DATA STILL RESIDING IN CHUNK TO DROP |
| IT07548 | WITH CM RUNNING CONTINUOUSLY, BRINGING DOWN IDS TO CHANGE DBSERVERNAME, ALIAS OR HA_ALIAS CAN RESULT IN CM FAILING TO REDIRECT |
| IT07599 | DR_PRPING THREAD MAY BECOME STUCK IN RUNNING STATE FOLLOWING HDR CONNECTION FAILURE |
| IT07678 | CDC CAUSES AF SNOOPING ROWS ON A NEW FRAGMENT |
| IT07920 | PARTITION BY SYNTAX OF OLAP WINDOW AGGREGATE RETURNS -25855 ERROR WITH 11.70.FC7W2 AND REMOTE SYNONYM |
| IT07946 | CDRGEVAL GROUPER THREADS DEAD-LOCKING WITH APPLICATION DML |
| IT08011 | ASSERT FAILURE CRASH IN POLL THREAD DURING INITIALIZATION |
| IT08052 | SECOND REMOTE SELECT IN A SESSION TO A DIFFERENT SERVERNAME FAILS WITH ERROR -908 -27001 |
| IT08203 | UNITIALIZED VALUE_T IN INSONE_NEXT CAN CAUSE ASSERTION FAILURE AFTER UNEXPECTED CALL TO EXECUTE_BLOB_ASSIGN |
| IT08223 | THREAD SUSPENSION NOT CORRECTLY ABORTING SERVER IF THREAD IS REPORTED AS BEING NOT ABLE TO BE SUSPENDED |
| IT08258 | DUPLICATE ROWS CAN BE INSERTED INTO A TABLE WITH UNIQUE INDEX DEFINED |
| IT08274 | ERROR (USE21) - GEOMETRY INTEGRITY ERROR IN FUNCTION GEOMETRYDEEPCOPY CAN OCCUR |
| IT08447 | ONMODE -P STOP HANGS IF THE LISTENER THREAD USES THE DRSOCTCP PROTOCOL |
| IT08510 | DATETIME RETURNED FOR UTC CALCULATION DOES NOT WORK AS EXPECTED WHEN INVOKED AS A SENSOR |
| IT08544 | EXTERNAL RESTORE FAILING WITH DBSPACE XYZ NOT RECOVERED FROM SAME ARCHIVE BACKUP AS DBSPACE ROOTDBS WHEN NO LOGICAL RESTORE IS |
| IT08559 | SELECT STATEMENT WITH A HOST VARIABLE IN A STORED PROCEDURE USES SEQUENTIAL SCAN WHEN DATA DISTRIBUTION IS AVAILABLE |
| IT08629 | DEADLOCK ON CLONETIMER MUTEX CAUSING CHECKPOINT/IO HANGS |
| IT08630 | ON WINDOWS ONSPACES WILL ALLOW ADDING A CHUNK TO A DIRECTORY |
| IT08679 | PDQ QUERY HANGS ON MUTEX FREE_LOCK |
| IT08700 | INCOMPLETELY INITIALIZED TEMP PARTITIONS CAN CAUSE PERSISTENT ERRORS OCCURRED WHILE CLEANING DBSPACE WARNING ASSERTIONS |
| IT08747 | DROPPING LOGICAL LOGFILES WHICH CAUSES A DECREASE IN EXTENDED RESERVE PAGE USAGE CAN RESULT IN DUPLICATE LOG FILE NUMBER ERRORS |
| IT08812 | TURNING ON THE AUDITING LEVEL 1 ADDS AN UNNECESSARY DELAY TO ONSTAT & ONMODE COMMANDS |
| IT08813 | TIMESERIES VT QUERY WITH SMALL READ AHEAD PAGES LIKE AUTO_READAHEAD 1,4 CAN RETURN (UTSD6) - INTERNAL ERROR: TSAM.C: 2867 |
| IT08896 | SELECT QUERY WITH NESTED SUBQUERIES MAKES THE ENGINE CRASH WITH SQL ERROR -272 NO MATTER WHAT THE PERMISSIONS ON TABLES |
| IT08904 | DBSCHEMA -SS -SI NOT REMOVING IN CLAUSE OF INDEXES |
| IT08923 | HAVING UPDATABLE SECONDARY SIGNIFICANTLY SUPPRESSES PERFORMANCE |
| IT09007 | BAD INDEX ON HDR SECONDARY IN A COMBINED ER PRIMARY TARGET SYSTEM WITH ATTACHED HDR |
| IT09078 | DOCUMENTATION IS VAGUE ON HOW TO SET A DATETIME DATATYPE WITH THE DEFAULT CLAUSE. |
| IT09190 | SPL PROCEDURES WITH DEFAULT PARAMETERS OF TYPE LIST CAN SEGV ASSERT IN VALSTORE WHEN EXECUTING PREPARED EXECUTE PROCEDURE MULT |
| IT09217 | THE APPLY FUNCTION CALLED FROM STORED PROCEDURE FOR 2 TIMESERIESCREATED BY CLIP() FUNCTION CAN FAIL WITH -9791 OR RETURN INCORR |
| IT09256 | PARALLEL BACKUPS OF DBSPACES CAN FAIL WITH 143 (DEADLOCK) ERRORS |
| IT09290 | SERIAL COLUMN WRAP-AROUND MAY INSERT THE VALUE ZERO INTO A ROW |
| IT09440 | EXCESSIVE -25580/-25582 ERROR DUE TO SEND()/RECV() FAILURE ON AIX |
| IT09544 | ONSTAT -G SES REPORTS SESSION POOL OPENTABLE MEMORY LEAK WHEN RUNNING QUERIES WHICH REQUIRE AUTO-INDEX PATH QUERY PLANS |
| IT09586 | QUERY USING ROWIDS BY A MULTIINDEX SCAN CAN CAUSE BLOCK HEADER CORRUPTION |
| IT09608 | ONCLEAN CAN REMOVE RESOURCES OF ANOTHER INSTANCE AND ACCIDENTALLY BRING THIS WRONG INSTANCE DOWN |
| IT09687 | UPDATE STATISTICS MAY RESULT IN ASSERT FAILURE IN HASHFULLNAME WHEN REFERENCING FREED DATA DICTIONARY ENTRY FOR TABLES USING REF |
| IT09751 | -346 ERROR ON MERGE IF IFX_REPLCHECK COLUMN IS INDEXED |
| IT09891 | TOO MANY -25582 ERRORS MESSAGES IN ONLINE.LOG |
| IT09892 | TOO MANY -22580 ERROR MESSAGES IN THE ONLINE.LOG |
| IT10285 | WHEN A PARTITION IS DROPPED AND ADDED BACK USING THE BEFORE KEYWORD, THE SERIAL VALUE RESETS BACK TO 1 |
| IT10301 | TEMP TABLE CONSTRAINTS CAN EXHAUST SYSCONSTRAINTS SERIAL |
| IT10306 | WITH THREAD SUSPENSION ENABLED, CERTAIN MEMORY CORRUPTION CAN CAUSE THREAD SUSPENSION CODE TO INFINITELY LOOP ASSERT FAILING |
| IT10335 | ASSERT FAILED: INVALID MUTEX TYPE IN MT_NXTSCB |
| IT10339 | ONMODE -C BLOCK CAN LEAVE THE RSS BLOCKED AFTER A NETWORK ERROR WAS RESOLVED IF DELAY_APPLY IS SET |
| IT10352 | MEMORY LEAK IN DATA DICTIONARY WHEN ENTRIES FOR TABLES WITH FOREIGN KEYS ARE RECREATED |
| IT10354 | PTMAP ASSERT FROM BTPOSITION WHEN ONE THREAD SELECT MAX USING IN -TABLE INDEX WHILE ANOTHER THREAD DELETE HIGHEST MAX VALUES IN A |
| IT10493 | CSM PASSWORD ENCRYPTION (SPWDCSM) FAILS SPORADICALLY ON SOLARIS 10 WITH LISTENER ERRORS -14565 AND -5000 |
| IT10545 | LINUX: WITH THE FIX FOR APAR IT06767 AN UPDATE STATISTICS HIGH ON TABLE BIGGER THAN 1.1 BILLION OF ROWS CAN CRASH THE ENGINE |
| IT10603 | HDR PAIR NOT AUTO-RECONNECTING IF PRIMARY RESTARTED WHILE NETWORK DOWN |
| IT10693 | ERROR -1204 RETURNED WHEN RIGHT HAND DATE VALUE OF EQUALITY EXPRESSION CONTAINS DECEMBER 31ST, 9999 |
| IT10742 | DIRTY READ SKIP SCAN INDEX READ AGAINST TABLE WITH ROWS CONSTANTLY INSERTED AND DELETED CAN ASSERT LAST_PAGE <= *RET_PAGE |
| IT10878 | ANSI JOIN WITH ROW EXPRESSION SEGVS IN CHECKEXPR |
| IT10943 | ASSERT FAIL BAD BLOCK POINTER MAY OCCUR DURING A CONNECTION ERROR WHEN USING CSM AND PAM |
| IT10957 | INVALID XML CREATED BY GENXMLQUERYHDR(), GENXMLQUERYHDRCLOB() AND GENXMLSCHEMA()/GENXMLSCHEMACLOB() FUNCTIONS |
| IT11123 | CANNOT VIEW BAR_ACT_LOG/BAR_DEBUG_LOG AS USER WITH EFFECTIVE GROUP ID SET TO BARGROUP |
| IT11141 | ASSERT FAILURE AND ROLL-FORWARD ERRORS ON CREATING SECONDARY SERVER |
| IT11260 | UNCLEAR AND FAULTY DEPENDENCY OF NON-PDQ QUERY PLAN ON DS_TOTAL_MEMORY / DS_MAX_QUERIES |
| IT11265 | WHERE CLAUSE SELECTION BEHAVIOR IN TRIGGER IS INCORRECT |
| IT11269 | ER SHOULD STARTUP AUTOMATICALLY AFTER FAILOVER TO HDR SECONDARY SERVER |
| IT11370 | SELECT STATEMENT WITH A CORRELATED SUBQUERY WITH GROUP BY ROWID CRASHES THE ENGINE |
| IT11585 | TABLE LEVEL RESTORE: AFTER BSA_RC_NO_MORE_DATA IS REACHED, ARCHECKER TRIES TO GET MORE DATA. |
| IT11586 | ILLEGAL POSSIBILITY TO SWITCH FROM RECOVERY MODE TO SINGLE-USER MODE |
| IT11853 | AUS EVALUATOR DOES NOT KEEP THE DISTRIBUTION TO MEDIUM |
| IT11858 | RSAM MEMORY POOL BLOCK HEADER CORRUPTION WHEN USING MULTI-LEVEL SAVEPOINTS |
| IT11909 | ON HDR SECONDARY, SELECT INTO TEMP WITH NO LOG ON BLOB COLUMN OF LENGTH 0 (BUT IS NOT SET TO NULL) RETURNS -618 AND -140 |
| IT11910 | LOG ROLLFORWARD ERROR 126 ON HINSERT INTO A TABLE ON SECONDARY AFTER TABLE HAS BEEN TRUNCATED |
| IT11930 | POSSIBLE ROLLBACK FAILURE FOR PBDELTE ON TEMP PARTITION |
| IT11952 | MEMORY CORRUPTION AND OTHER ERRORS POSSIBLE WHEN USING CDC |
| IT11956 | QUERYING DATA COMPLETELY CACHED HAVING A LARGE NUMBER OF ITEMS IN AN IN CLAUSE CAN CAUSE SQLEXEC THREAD TO YIELD IMPROPERLY |
| IT12041 | 874 ERROR/SEGV IN OPSELEC AFTER FIX FOR APAR IT10693 WHEN USING EXPRESSION NOT EQUAL ( <> ) ON DATE DECEMBER 31ST, 9999 |
| IT12065 | REFERENCING THE SAME COLUMN REPEATEDLY IN THE GROUP BY CLAUSE USING ITS ALIAS NAME CRASHES THE ENGINE |
| IT12184 | QUERY WITH MULTIPLE FULL OUTER JOINS CRASHES THE SERVER |
| IT12202 | DEADLOCK BETWEEN LISTENER AND LOWMEMORYMGR CAN CAUSE THE INSTANCE TO GET STUCK IN WAITING FOR THE SESSION MUTEX |
| IT12203 | REPLICATION OF INSERT/UPDATE FROM EN_US.UTF8 TO EN_US.819 CORRUPTS INDEX |
| IT12508 | IPL THROTTLING ON SYSTEMS WITH LARGE LOGICAL LOG SPACE CAN SEE THE IPL THREAD YIELD FOR LONG PERIODS OF TIME |
| IT12541 | WITH THE FIX OF IT10301 THE ENGINE CAN FALSELY REPORT ERROR -692 WHILE DELETING FROM A TEMP TABLE WITH UNIQUE OR PK CONSTRAINT |
| IT12785 | ONMODE -C BLOCK WILL MARK CHUNKS DOWN WITH IO ERRORS IF INSTANCE HAS OVER 32 CHUNKS THAT ARE MIRRORED |
| IT12813 | SERIAL COLUMN GOES OUT OF SEQUENCE WHEN ALTERED FROM SERIAL TO SERIAL8 AND SERIAL HAS WRAPPED |
| IT12823 | CDR LIST SERVER COMMAND RETURNS : ERROR RETURNED FROM CDR_ADJUST_INFORMIXSERVER: SELECT GROUPNAME SQLCODE -245 ISAM -144 |
| IT12919 | ASSERTION FAILURE: CONDITION FAILED (RW_MUTEX->RW_SLOCK > 0), IN (MT_RW_UNLOCK) |
| IT12920 | ASSERT FAILURE POSSIBLE DURING CLEANUP OF CDC SESSION |
| IT12945 | WHEN A SECONDARY IS PROMOTED UNDER CERTAIN CIRCUMSTANCES THE BTSCANNER THREAD DOES NOT START LEADING TO ASSERTION FAILIURES |
| IT13088 | CHECKPOINT DURATION IN ONSTAT -G CKP/SYSCHECKPOINT CAN BE DIFFERENT FROM INSTANCE MESSAGE LOG |
| IT13219 | QUERY USING 2 ANSI JOINS AND THE BTS_CONTAINS() FUNCTION WITH SCORE ARGUMENT FAILS WITH ERROR 874 AND AF IN SQSLV_RESOLVE() |
| IT13251 | WHEN AN ERROR OCCURS IN AN SPL WITH A SELECT, A -285 IS GENERATED INTERNALLY BY THE SERVER WHICH WILL BLOCK ANY CURSORS FROM BEI |
| IT13481 | CDR DELETE REPLICATE CAN CAUSE SEGV ASSERTION FAILURE IN CDRCPARSE THREAD |
| IT13536 | POSSIBLE ENDLESS LOOP IN CASE OF BROKEN REMOTE CONNECTION |
| IT13537 | DUBIOUS OR EXCESS SYSCOLAUTH ENTRIES FOR VIEW CONTAINING MATH EXPRESSIONS, FUNCTIONS OR ORDER BY |
| IT13718 | ASSERT FAILURE IN MT_FREE/DECRLKCOUNT USING STORED PROCEDURE REFERENCING A TEMP TABLE THAT WAS DROPPED AND ROLLED BACK IN TRANS |
| IT13817 | ROLLBACK ERROR 101 AFTER ONLINE FRAGMENT DETACH FOLLOWED BY A DROP OF THE DETACHED FRAGMENT |
| IT13846 | IDS CRASHES IN EVALCOLS() SELECTING FROM A VIEW AND A TEMP TABLE IF PDQPRIORITY IS SET |
| IT13890 | MEMORY LEAK IN CSM VP WHEN OPENING AND CLOSING PASSWORD ENCRYPTED CONNECTIONS |
| IT13968 | CDR ERRNO 49 (MAXIMUM NUMBER OF REPLICATES EXCEEDED) EVEN AFTER REPLICATES DELETED |
| IT14144 | 768: INTERNAL ERROR IN ROUTINE OPJOIN() WITH MULTIPLE JOINS AND LEFT OUTER JOIN |
| IT14183 | RSS SECONDARY ASSERT LOGICAL LOG REPLAY ERROR ON CHALLOC WHEN ROLLFORWARD INSERTS AFTER A TRUNCATE TABLE |
| IT14217 | VARIOUS MEMORY CORRUPTIONS WHEN RUNNING HUGE SELECT UNION WITH GLS |
| IT14438 | 768: INTERNAL ERROR IN ROUTINE OPJOIN() WHEN RUNNING SELECT QUERY AFTER UPDATE STATS AND IFX_FOLDVIEW ENABLED |
| IT14444 | A QUERY USING XPS API AND INDEX ACCESS CAN RETURN INCOMPLETE RESULTS IF THE INDEX IS UPDATED BY A CONCURRENT THREAD |
| IT14465 | ASSERT FAILED: INVALID MUTEX TYPE WHEN INTERRUPT RECEIVED WHILE BUILDING A HASH TABLE |
| IT14485 | ASSERT FAILURE AND CRASH POSSIBLE DURING CSM VP INITIALIZATION WHEN MULTIPLE CPU VPS ARE CONFIGURED |
| IT14675 | OPTIMIZER ASSERT FAIL AND ERROR -874 WHEN REOPENING A CURSOR DEFINED WITH HOST VARIABLES THAT SELECTS FROM A VIEW WITH SUBQUERY |
| IT14736 | INTERMITTENT NETWORK CONNECTIVITY MAY LEAD TO RSS SERVER SHUTDOWN |
| IT14781 | HUGE DELAYS WHEN REPLICATING BLOBSPACE BLOBS, EXPONENTIALLY INCREASING WITH BLOB SIZE |
| IT14852 | SELECT QUERY USING CONNECT BY CLAUSE WITH PRIOR APPLIED TO VARCHAR RETURNS 26079 |
| IT14870 | ASSERT FAILED TRYING TO DETACH A FRAGMENT USING FORCE_DDL_EXEC AND OTHER CONCURRENT THREADS HAVING TO GROW THEIR OPENTAB |
| IT14933 | FRAGMENTATION ELIMINATION NOT USED WHEN USING HOST VARIABLES |
| IT14971 | ESQL/C PROGRAM RETURNS -259 AFTER ROLLBACK |
| IT15229 | VARIOUS ASSERT FAIL AND WARNINGS WHEN LONG TRANSACTION ROLLBACKS OCCUR THAT INVOLVE REMOTE CONNECTIONS |
| IT15404 | MEMORY LEAK IN SQOPUTIL.C:GET_DIST() |
| IT15405 | ALTER TABLE ADD/MODIFY (WITH DEFAULT VALUE) DOES NOT WORK AS EXPECTED |
| IT15515 | SLOWER PERFORMANCE WHEN PDQPRIORITY IS ENABLED WITH MORE THAN 180 FRAGMENTS |
| IT15608 | WHEN A TABLE HAS MUTLIPLE UPDATE TRIGGERS ON MUTLIPLE COLUMNS, THOSE TRIGGERS WILL FIRE ONCE PER COLUMN UPDATED PER TRIGGER |
| IT16010 | ENGINE CRASH IN SSC_LINK WHEN STATEMENT CACHE IS ENABLED |
| IT16026 | IMPROVE THE PERFORMANCE OF THE SQL STATEMENT CACHE |
| IT16184 | HDR SETUP USING ONTAPE ...-T STDIO -F MAY HANG HDR LATER |
| IT16206 | ASSERTION CONDITION FAILED (CACHE_ELM->MT_CACHE_ELEM_LOADER == NULL), IN (MT_CACHE_DONE) |
| IT16466 | CASTING A VERY LONG COLLECTION VALUE TO LIST OR MULTISET CAN HOG A CPU VP |
| IT16468 | QUERY DOES NOT RETURN IN 11.70.FC8W1, BUT RAN QUICKLY IN 11.70.FC4 |
| IT16522 | WRONG RESULTS IN QUERY WITH SUBQUERY WITH CASE WHICH INCLUDES SUBQUERY AND WHERE CLAUSE ON CASE COLUMN IF ORDER BY IS USED OR NO |
| IT16670 | HIGH CONTENTION ON SESSION MUTEX WHEN LOTS OF SESSIONS SELECT DATA FROM SYSMASTER:SYSSESSIONS |
| IT16717 | WITH ROOT CHUNK VERY FULL DYNAMIC_LOGS CAN EAT ALL AVAILABLE SPACE WITHOUT ADDING MORE LOG FILES |
| IT16756 | INAPPROPRIATE CALL TO DESTROY_SESSION AND AF MAY RESULT FROM LOSS OF REMOTE CONNECTION DURING QUERY PROCESSING |
| IT16963 | ASSERT FAILURE IN STLONG POSSIBLE WHEN RUNNING STORED PROCEDURE |
| IT17207 | INTERRUPTING A DEFRAGMENT OPERATION ON A LARGE FRAGMENTED TABLE DOES NOT CLEAN FRAG IN PROGRESS FLAGS ALL THE TIME |
| IT17322 | ONLOG WITH -D OPTION WITH DIRECTORY DEVICES WILL NOT DISPLAY A RANGE OF LOG FILES |
| IT17447 | ASSERT FAILURE IN SQSCB_CLEANUP AFTER A LISTENER THREAD ERROR |
| IT17539 | --SERIAL REPLICATE OPTION POTENTIALLY CAUSING CRASHES IN INSERTHASHINTOTXN() |
| IT17633 | LPAD() FUNCTION RETURNS INCORRECT STRING IN MULTI-BYTE ENVIROMENT |
| IT17636 | ENGINE CRASHES AND MEMORY CORRUPTION WHEN DOING DML STATEMENTS AND UPDATE STATISTICS AGAINST TABLES THAT HAVE REFERENTIAL CONSTR |
| IT17796 | RSS SERVER MAY NOT RECONNECT FOLLOWING A RESTART OF THE PRIMARY SERVER |
| IT17853 | MEMORY LEAK ON REMOTE SERVER WHEN RUNNING SELECT WITH LEFT JOIN |
| IT18233 | ASSERT FAILED: MEMORY FREED TWICE WHEN DRDA_PREPARE CALLS MT_FREE AND SQL ERROR -23103 IS RETURNED TO CLIENT |
| IT18236 | ASSERT FAILURE MESSAGE ATTEMPTING TO ALLOCATE SLOT ON IN-USE OLD VERSION PAGE IS UNHELPFUL |
| IT18280 | CONCURRENT READERS AND ALTER FRAGMENT ONLINE STATEMENTS CAN LEAD TO PERSISTENT ISAM -135 ERRORS |
| IT18723 | MEMORY CORRUPTION IN CDR POOL |
| IT18741 | SELECT FROM SHOWS ALL COLUMNS, EVEN IF ONLY ACCESS TO ONE COLUMN IS PERMITTED |
| IT18764 | MEMORY LEAK IN AIO POOL WHEN USING REMOTE_USERS_CFG |
| IT19040 | ENGINE HANGS IN RVALSTRING |
| IT19042 | SELECT INTO A TEMPORARY TABLE WITH PDQ COULD FAIL WITH -264/-770 |
| IT19898 | MAIN_LOOP DEADLOCKING WITH ITSELF IN WAIT_4_CKPT_2_COMPLETE() WHEN JUST DYNAMICALLY ADDING NEW LOG FILE |