IBM Support

Fix list for Informix Server 11.70.xC9

Product Documentation


Abstract

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.

Content








Fix release date: 28 Apr 2017
Status: Recommended

Download information




APAR
Description
IC82742EXECUTING QUERY HAVING MULTIPLE JOINS, WITH STMT_CACHE ENABLED GIVES ERROR 640: QPLAN SANITY FAILURE
IC91410WRONG COMPUTATION FOR THE LOG SPACE USED IN ONSTAT -G HIS
IC92085AN UPDATABLE_SECONDARY HAS NO WAY TO INHERIT EXCLUSIVE LOCKS FROM THE PRIMARY AND CAN LEAD TO DR OUTAGES
IC92235MISLEADING ERROR -952 REPORTED TO ONLINE.LOG FOR PROXIED CONNECTIONS AND SECURITY_LOCALCONNECTION > 0
IC92314QUERY EXECUTES WITH GOOD PERFORMANCE WITH IDS 10 BUT 11.70 REQUIRES OPTIMIZER DIRECTIVES TO GET BETTER PERFORMANCE
IC92651ASSERT FAILS ON SECONDARY SERVER WHEN SELECTING FROM A TABLE AND A DELETE IS OCCURRING ON THE SAME TABLE ON THE PRIMARY
IC93172ATTEMPT TO CONNECT VIA DRDA TO AN INSTANCE IN SINGLE-USER MODE WILL UNEXPECTEDLY TERMINATE THE INSTANCE
IC94346USING TIMESERIES AS A VARIABLE IN A STORED PROCEDURE GIVES AN ASSERT FAILED DURING CREATE PROCEDURE
IC94738IFX_ROW_ID UNDOCUMENTED FEATURE IS DOING SEQUENTIAL SCAN INSTEAD OF READING DIRECTLY IN THE APPROPRIATE PAGE
IC94894ONSTAT -X DISPLAYS DIFFERENT OUTPUT THAN IDS V10.00
IC94980ONSTAT -U MAY RETURN CHANGING DATA STRUCTURE, FORCED COMMAND TERMINATION. AFTER AN ONBAR BACKUP FAILED WITH XBSA ERROR.
IC95749READAHEAD MUTEX CAN BECOME POINT OF CONTENTION ON LARGER SYSTEMS WHEN THE NUMBER OF READAHEAD THREADS INCREASES
IC95781GENONCFG FAILS WITH AN INEXPRESSIVE ERROR MESSAGE
IC95782GENXMLELEM() IS CAUSING MEMORY CORRUPTION
IC96167INSERT 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
IC96581REMOTE QUERY RETURNS 244/151 WITH A VARCHAR COLUMN
IC96671EFFECT OF MQIPOLICY.RCV_WAIT_INTRVL FOR A SELECT ON A VTI MQ TABLE SHOULD BE CHANGED
IC97019SERVER CAN CRASH IN LDDBLNULL() IF A SUB-QUERY REFERENCES, IN AN AGGREGATE, A COLUMN FROM THE MAIN QUERY
IC97021HAVING A SYMBOLIC LINK POINTING TO ONCONFIG ON ANOTHER FILESYSTEM WILL BE REMOVED RUNNING ONMODE -WF
IC97350ESTIMATED COSTS FOR INDEX PATH IS HIGHER THAN SEQUENTIAL SCAN AND INDEX-SKIP-SCAN
IC97427LOG_PUT( OLDRSAM:73, 271666488): NOT IN CRITICAL SECTION MESSAGE REPORTS BAD LEN
IC97459BTSCANNER THREAD DOING LEAF SCAN DOING TOO MUCH WORK WITHOUT YIELDING TYING UP CPU VP PREVENTING OTHER THREADS FROM RUNNING
IC97462AF IN SRTNEXT:((BUF->SB_NROWS < SR->SR_IOROWS) ... WHEN FETCHING THE RECORDS IS INTERRUPTED BY CTRL+C AND THEN CONTINUES
IC97539CREATE BTS INDEX FAILS WITH ASSERT WHEN SMARTBLOBSPACE IS FULL
IC97643WINDOWS: LONG SQL/SPL STATEMENT TRUNCATED WHEN LOADED INTO DBACCESS MULTIPLE TIMES
IC97672DROP INDEX ONLINE ON AN ATTACHED (IN TABLE) INDEX WOULD LOCK THE TABLE FOR ITS ENTIRE DURATION
IC97674AFTER USING ONMODE -P START TO DYNAMICALLY START A NEW LISTEN THREAD, UNABLE TO CONNECT TO THE NEW DBSERVERALIAS
IC97898AUTOMATIC LOGICAL LOG BACKUP FAILS BECAUSE WE ALLOW ENGINE TO START IF INFORMIXSERVER IS INCORRECTLY SET
IC97972ONCHECK 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
IC98247SQ_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
IC98342THE COMPRESSION ESTIMATE DOES NOT TAKE INTO ACCOUNT THE MAXIMUM NUMBER OF SLOTS PER PAGE WHEN COMPUTING THE GAIN
IC98345DOCUMENTATION ON TRUSTED CONTEXT UNIQUENESS ACROSS DATABASES SHOULD BE MORE ACCURATE
IC98384-874 FROM FIND_MATCHING_IDXSCAN
IC98400REPLICATED LVARCHAR COLUMNS WITH DIFFERENT SOURCE/TARGET LENGTHS CAN LEAD TO MEMORY CORRUPTION
IC98403CASE EXPRESSION WITH TEXT OR BYTE COLUMN RETURNS 615 ERROR
IC98433OPTIMIZER CHOOSED SEQUENTIAL SCAN FOR QUERY WITH LVARCHAR, WITH VARCHAR OPTIMIZER CHOOSES INDEX PATH
IC98435SQLCODE:-243 ISAM:-154 AFTER SHUTTING DOWN AND RESTARTING PRIMARY
IC98458AN INCREASING NUMBER OF CHUNKS CAN INCREASE THE DURATION OF AN ONMODE -C BLOCK
IC98474ER DATA SYNC THREADS TRYING TO WRITE LOGICAL LOG RECORDS OUTSIDE OF CRITICAL SECTION CAN CRASH THE SERVER
IC98519A UDR WHICH REPEATEDLY OPENS A CURSOR AGAINST A VIEW WITH UNION ALL IS VERY SLOW AND MEMORY CONSUMING WHEN RUN WITH PDQ
IC98529THE 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
IC98549ONLINELOG CAN CONTAIN DUPLICATE VP AFFINITY MESSAGES
IC98569KILLING A SESSION WAITING ON A LOCK WILL NOT BE DESTROYED UNTIL THE LOCK IS RELEASED BY THE OTHER SESSION
IC98570SELECT FIRST X.... ORDER BY X DESC GIVES WRONG RESULTS
IC98589ONSTAT -L CAN SHOW INVALID PAGES / IO RESULTS FOR THE PHYSICAL LOG BUFFER STATISTICS
IC98649SERVER EXCEPTION IN RELEASE_NAMETABLE WHILE CLEANUP SAPI MEMORY
IC98710SIMULTANEOUS CREATION OF TWO EXTERNAL TABLES WITH THE SAME NAME IN ONE DATABASE CAN CAUSE A ROLLBACK ERROR 126 AND A CRASH
IC98711RECOVERY OF LOGGED INDEX PAGES CAN CORRUPT THE INDEX
IC98713RVDB (REVOKE DATABASE ACCESS) AUDIT-EVENT MNEMONIC DESCRIPTION IS MISSING BEGINNING WITH 11.50 DOCUMENTATION
IC98716MEMORY LEAK IN GLOBAL MEMORY POOL CAUSED BY CONNECTION COMING FROM CONNECTION MANAGER IN PROXY MODE
IC98720MIRROR CHUNK IS MARKED DOWN ON HDR SECONDARY AFTER ADDING CHUNK ON PRIMARY
IC98729ODBC SQLGECOLUMNS RETURNS NOTHING WHEN THE DATABASE IS CREATED WITH GL_USEGLU SET AND TABLE NAME CONTAINS AN _ CHARACTER
IC98730ERROR 79784 LOCALE NOT SUPPORTED WHEN LOADING A JAR WITH PL_PL.PC-LATIN-2 LOCALE
IC98731SIMPLE QUERY WITH GROUP BY RETURNS WRONG RESULT IF MULTI INDEX SCAN IS USED
IC98843CDC API ERROR 9810/83792 SNOOPING TABLE WITH VARCHAR COLUMN USING COMPRESSION IF CHECKPOINT HAPPENS WHEN FORWARDING HOME ROW
IC98944THE OUTPUT OF ONSTAT -G CMCM SOMETIMES SHOWS TWO ENTRIES FOR THE SAME CLUSTER
IC98947JAVA/JDBC PROGRAM EXECUTING SPL WHICH TAKES A SET ARGUMENT ASSERT FAILS (SIGSEGV) IN UDRLM_EXEC_ROUTINE()
IC99034SLOW INSERT PERFORMANCE WITH CONCURRENT INSERT OPERATIONS AND BITMAPS ARE NOT PRESENT IN BUFFER POOL
IC99058CDR CHECK WITH REPAIR CAN CORE DUMP WITH A UTF8 TARGET DATABASE
IC99091ERROR 1277: INPUT DOES NOT MATCH FORMAT SPECIFICATION, USING DATETIME FORMAT
IC99178SERVER CRASHED WHILE RUNNING MULTIPLE TRUNCATE STATEMENTS
IC99180IN A NON-LOGGING DATABASE LOCKS ON SYSPROCPLAN ARE HELD TOO LONG WHEN TRIGGER REFERENCES ARE USED
IC99184PARTITION PROFILE INFORMATION IN SMI TABLES IS SOMETIMES NOT ACCURATE
IC99190A SIMPLE INSERT INTO FRAGMENTED TABLE WITH ROWIDS CAN TAKE MANY MINUTES WHEN YOU EXCEED 2147483647 ROWS
IC99247CDR SYNC REPLICATE CRASHES IF FOREIGN KEY REFERRING TO THE SAME TABLE
IC99248STACK OVERFLOW POSSIBLE IN DWA_PROBEDELIVE
IC99329CONNECTIONS COMING FROM CONNECTION MANAGER IN PROXY MODE CAN LEAVE ORPHANED SESSIONS IN THE ENGINE IF INFORMIXCONTIME=1
IC99356SERVER AUTOMATICALLY GRANTS GRANT SELECT PRIVILEGE ON A VIEW WHEN IT IS CREATED.
IC99362ERROR -873 OBSERVED WHILE INSERTING INTO A FRAGMENTED TABLE THAT HAS BEEN RENAMED
IC99364LACK OF CHECKS ON RELOCKABLE MUTEX LOCK COUNT COULD LEAD TO NEGATIVE VALUES AND AN INDEFINITE WAIT
IC99440ONDBSPACEDOWN DEFAULT SETTING OF 2 INCORRECTLY APPLIES TO TEMPORARY DBSPACES
IC99526ASSERT FAIL AND CRASH POSSIBLE IN SEND_ROW_TO_CONSUMER OR PK_PUTFREE WHEN RUNNING QUERY WITH PDQ
IC995499791 ASSERT FAILURE ON DELRANGE WHEN BEGIN_STAMP OR END_STAMP ARGUMENT PASSED IN IS NULL
IC99560FEA: PAM AUTHENTICATION SUPPORT TO DRDA CLIENTS
IC99561ASF ECHO-THREAD SERVER: ... MESSAGE USED TOO WIDELY AND NOT HELPFUL AT ALL OR MISLEADING EVEN
IC99564THE RENAME COLUMN ON A TABLE WITH A DEFINED TRIGGER ABENDS THE INFORMIX DATABASE SERVER IN COLNMFIND()
IC99565CDCAPI CALLING CDC_STARTCAPTURE ON TABLE ALTERED TO RANGE/INTERVAL EXPRESSION CRASHES SERVER IF RESULT TABLE HAS ONLY 1 FRAGMENT
IC99687WHEN NODEFDAC IS SET AND A ROLE GRANTS SELECT ON A TABLE, IT PREVENTS DBSCHEMA TO WORK AS EXPECTED AND RETURNS UNEXPECTED -999 O
IC99716ASSERT FAILURE AND CRASH IN OPLOOKSUBQ DURING PREPARE OF QUERY USING STATEMENT CACHE WHEN BATCHEDREAD_TABLE IS CHANGED
IC99717THE 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
IC99756REPLICATING LVARCHAR COLUMN FROM EN_US.819 TO EN_US.UTF8 CAN LEAD TO MEMORY CORRUPTION
IC99867ONLY VERBOSE MODE OF ONSTAT -G RSS SHOWS LOG TRANSMISSION BEING BLOCKED
IC99877RCV THREAD GOT UNEXPECTED MSG 99 WHEN SETTING UP PRIMARY AND RSS PAIR OF DIFFERENT VERSIONS
IC99879USING SEQUENCES EXTENSIVELY THE SERVER MAY REPORT INVALID MUTEX TYPE IN GET_NEXTVAL
IC99882WHERE IN IS SLOW AND CONSUMING A CPU VP
IC99895ONMODE -WF DUMPSHMEM=0 CLEARS ONCONFIG FILE
IC99955IDLE THREAD CAN ABEND SERVER IN MT_MEMSYNC_SCAN()
IT00264SELECT STATEMENTS USING OLAP MAY RUN INTO A -768 ERROR IN OLAP_TEMPTAB_WRITE
IT00329AUTHENTICATION OF MAPPED USER ON SECONDARY SERVER FAILS WITH ERROR -951
IT00353RALLOC BLOCKS MEMORY LEAK IN A SESSION CAUSED BY EXECUTE IMMEDIATE PREPARED MERGE STATEMENT
IT00356OPTIMIZER TRACE CODE ON STORED PRODURE MAY FAIL IN TRACE_EXPR_PRE FUNCTION
IT00357BLD REF CONSTRAINT MUTEX CAN BECOME A PERF. BOTTLENECK ON SYSTEMS WHERE HIGH NUMBER OF SPL STATEMENTS NEED TO BE RE-PREPARED
IT00549CDR REPAIR GOT -23197 ERROR WHILE REPLICATE INVOLVES UTF8 CONVERSION
IT00550SELECT USING COMPOSITE INDEX DOES NOT RETURN ROWS WHEN IS NULL FILTER IS USED AS INDEX KEY
IT00587PRIMARY SERVER CAN BLOCK WAITING ON NEXT LOG FILE TO BE FREED IF THE SECONDARY HAS FAILED DURING LOG CATCHUP PHASE
IT00600USING A BAD INDEX IN QUERY A CAN LEAD TO AN ASSERTION IN QUERY B IN FMFTOPEN()
IT00620COMPLICATED QUERY USING TABLE EXPRESSIONS AND ANSI JOINS CAN CAUSE EXCEPTION IN AJ_ATTFL
IT00678POTENTIAL FOR HANG ON BLD REF CONSTRAINT MUTEX OR MODIFICATION OF MEMORY UNRELATED TO DICTIONARY CACHE
IT00703QUERY RETURNS INCORRECT RESULTS WITH PDQ ENABLED, OPTOFC=1, FRAGMENTED INDEX SCAN AND SUBQUERY IN MULTIPLE EXECUTIONS
IT00771DBIMPORT CAN CREATE TABLES WITH TOO LARGE FIRST EXTENT SIZE AND CAN EXHAUST DBSPACE FREE SPACE HEREBY
IT00781EVEN WITH THE FIXES FOR IC98053 AND IC98529 THE ONCHECK -CD CAN REPORT WARNING: DATA PAGE APPEARS TO BE MORE OR LESS FULL
IT00802ASSERTION FAILURE CRASH IN MT_PRTCBLST POSSIBLY WHEN RUNNING SYSMASTER QUERY AGAINST SYSTCBLST
IT00825AF IN TS_AM_PUT_NTH_ELEM_INMEM() ON WINDOWS WHEN VIRTUAL MEMORY SEGMENT USES AN ADDRESS > MAX VALUE STORED IN 4 BYTE INT
IT00899RSS HIT SEGMENTATION FAULT IN PROXYWRITEPOSTXACNTL WHEN SMX CONNECTION IS LOST
IT01019VP PRIVATE MEMORY CACHE IS NOT DRAINED DURING FAST RECOVERY WHICH MAY LEAD TO EXCESSIVE MEMORY USAGE
IT01049ASSERT FAILURE AND CRASH FOLLOWING FAILURE TO ALLOCATE A TRANSACTION
IT01051THE LOWER FUNCTION IN A QUERY AGAINST A UTF8 DATABASE CAN FAIL WITH ERROR -941 WHEN ANOTHER ESQL/C PROGRAM IS ACCESSING THE DATA
IT01074AN UPDATE TRIGGER CALLING A STORED PROCEDURE THAT DOES AN INSERT INTO ANOTHER TABLE CORRUPTS DATA ON SDS SECONDARY
IT01128PDQ QUERY HANGS ON MUTEX FREE_LOCK
IT01131AUTO_CKPT DOES NOT PRINT AN ADVISORY MESSAGE WHEN IT TRIGGERS A CHECKPOINT
IT01154OUTER JOIN RETURNS INCORRECT RESULTS
IT01261IT MUST BE DOCUMENTED THAT VPCACHE OPERATING IN DYNAMIC MODE CAN GROW QUITE LARGE ON BUSY SYSTEMS
IT01329QUERY USING JOIN, GROUP BY AND COUNT(*) RETURNS BAD RESULTS WHEN DS_NONPDQ_QUERY_MEM SET TOO LOW
IT01420UPDATE STATISTICS COMMAND DOES NOT UPDATE STATISTICS FOR PROCEDURES AS STATED
IT01467IWA: ERROR MESSAGE 22283 RETURNED FROM OFFLOADED QUERY
IT01468AF IN XTF_COPY_DATA() POSSIBLE WHEN XTRACE USED ON WINDOWS AND MULTIPLE CPU VPS ARE CONFIGURED
IT01478ROLLBACK OF A GLOBAL (XA) TRANSACTION CAN GENERATE ASSERTION WARNING FREEING TRANSACTION ENTRY THAT STILL HOLDS LOCKS!
IT01524IWA: ACCESS TO FREED MEMORY POSSIBLE WHEN OFFLOADING A QUERY AND IN PARALLEL A MART IS DROPPED
IT01539THE SERVER CAN CRASH IN FM_FINDINFO() WHILE CLOSING INDEX FRAGMENTS.
IT01646QUERY ON SYSSQEXPLAIN DOES NOT RETURN ANY VALUES FOR SQX_BUFREADS, SQX_PAGEREADS, SQX_BUFWRITES, SQX_PAGEWRITES, SQX_TOTSORTS
IT01657USING GL_USEGLU WITH NCHAR DATA TYPE CAN RESULT IN BAD INDEX
IT01676GSK ERROR GSK_ERROR_SOCKET_CLOSED AND SSL CONNECTION HANG UNDER STRESS
IT01681MEMORY LEAK IN PRP.. POOL WHEN SPL PROCEDURE EXECUTED VIA INSERT TRIGGER ON A VIEW
IT01696ONBAR FAILS TO DISPLAY CONTENTS OF A LOGICAL LOG WHEN THERE IS A PROBLEM IN THE IXBAR FILE FOR A LOG THAT FOLLOWS IN SEQUENCE
IT01697ERROR CODE PATH IN MGM_GETMEM CAN LEAVE THE MGM MUTEX LOCKED
IT01702UDR REMOVAL FROM SESSION CACHE CAN CAUSE PREMATURE TRANSACTION COMMIT AND ERROR -124 ON COMMIT OR ROLLBACK
IT01703DBSCHEMA WILL NOT DISPLAY OWNER NAME ON PROCEDURE WHEN PROCEDURE WAS CREATED WITH ENVIRONMENT VARIABLE NODEFDAC SET TO YES
IT01716ASSERT FAILURE WHILE CREATING ONLINE INDEX DURING DATA LOAD
IT01750VIEW OF ALTERED TABLE RETURNS TRUNCATED RESULTS ON HDR SECONDARY
IT01811IFX_RET_TYPES() COULD FAIL WITH -9791 WHEN STORED PROCEDURE RETURNS A DATETIME YEAR TO FRACTION
IT01840WITH NON-ZERO PDQPRIORITY OPTIMIZER ASSIGNS LOWER COST TO SEQUENTIAL SCAN WHILE INDEX PATH IS FASTER
IT01900INSERT INTO A FRAGMENTED TABLE WITH REFERENTIAL CONSTRAINT CAN RESULT IN ERROR 682/111 WHEN CONCURRENT DELETES ARE GOING ON
IT01902ENGINE CAN RETURN -259 ERROR ON FETCH OF CURSOR WITH HOLD IF AUTO_REPREPARE IS ENABLED AND STATEMENT GETS REPREPARED
IT02015CREATING MULTIPLE ATTACHED INDEXES ON SAME FIELD WITH ASC/DESC DIFFERENTIATOR RETURNS ERROR 350/108
IT02017QUERY USING AND OR CLAUSE ON ROWID EXPRESSION AND A POSSIBLE INDEX SCAN FILTER CAUSES ASSERT FAILURE IN INDEX_INFO
IT02028INSTANCE CAN GET BLOCKED IN CHECKPOINT IF MAX_FILL_DATA_PAGES SET TO 1 AND CONCURRENT INSERTS OF LONG ROWS OCCUR
IT02129ERRATIC VALUES WHEN RUNNING SPL WITH VIEW, YOU MIGHT GET -1260 ,-1201, -9791 OR JUST RETURN NO DATA
IT02130UNEXPECTED DBSPACE FULL MESSAGE WHEN ARCHIVE HAS EXHAUSTED UNRELATED TEMPORARY DBSPACES
IT02182THE ONMODE COMMAND CANNOT CLEAN UP XA TRANSACTIONS WHEN IFX_XA_UNIQUEXID_IN_DATABASE IS ENABLED.
IT02187ASSERT FAILURE AND CRASH ON PROMOTION OF HDR SECONDARY TO PRIMARY WITH HEURISTICALLY COMPLETED XA TRANSACTION.
IT02190IWA QUERY PROBING FAILS IF EQUALITY JOINS BETWEEN COLUMNS ARE ACTING AS FILTERS
IT02293DISTRIBUTED QUERY CAN GET ERROR -934/-217 ERROR
IT02349AF OR CRASH ON EXECUTION OF INSERT FROM SELECT INTO A FRAGMENTED TABLE WITH PDQ ENABLED
IT02350HDRMKPRI.SH SCRIPT MAY FAIL TO CHANGE HDR SECONDARY SERVER TYPE TO PRIMARY
IT02390IFXCOLLECT APPEARS TO IGNORE THE -D OPTION AND COLLECTIONS TAKE LONG SLEEP TIMES BETWEEN ONSTAT SUB-COLLECTIONS
IT02561CDR REALIZE TEMPLATE FAILS WITH -208 MEMORY ALLOCATION ERROR WHEN TEMPLATE IS ON DATABASE WITH MORE THAN 32767 TABLES
IT02608SOME SELECTS REPORT AN ERROR 294 (NEED A GROUP BY) BUT THE QUERY ASSERT FAILS IF GROUP BY IS ADDED
IT02615SELECT WITH SUBSTRING CAN GENERATE BAD QUERY PLAN WITH FILTER WITH SUBSTRING IS IN CLAUSE WITH SUBSELECT
IT02647ENGINE CRASHES DURING AUTO INDEX BUILD IF SHMTOTAL IS HIT AND IF TEMPORARY DBSPACE USES NONDEFAULT PAGESIZE
IT02679UPDATE STATISTICS HIGH ON A FRAGMENTED TABLE LEADS TO ERROR MESSAGE 9810
IT02680WRONG RESULTS USING IFX_FOLDVIEW
IT02904SECONDARY SERVER CAN ABEND IN CREATE_OPEN_PARTITION_TXN_LIST DURING LOG ROLLFORWARD
IT02905RELSDBMEM DOES NOT NULL OUT SD_STMTSTATS AFTER FREEING THE HEAP IT WAS ALLOCATED FROM, COULD LEAD TO MEMORY CORRUPTION
IT03031OPENTABLE MEMORY OF A SESSION CAN GROW AND CAN LEAD TO OVERLY LARGER MEMORY CONSUMPTION AND POSSIBLY TO MEMORY FRAGMENTATION
IT03032LATCH COUNT NON-ZERO CHECK CAN TURN NON-FATAL INTO FATAL ASSERTION
IT03033DBSCHEMA OR DBEXPORT ABORTING IF UNIQUE INDEX USED BY PRIMARY KEY CONSTRAINT WAS DROPPED
IT03043MERGE STATEMENT WITH OPTIMIZER DIRECTIVE EXECUTED WITH PDQ RETURNS 230/101
IT03266USE OF CURRENT IN WHERE CLAUSE OF A REMOTE QUERY RETURNS INCORRECT VALUES
IT03426POTENTIAL MEMORY CORRUPTION ASSOCIATED WITH TEMPORARY DBSPACE NAMES USED FOR SELECT INTO STATEMENT
IT03434PTALT_BUILD_OPERLIST: ERROR READING FIRST ALTER-DESC MESSAGE IS UNHELPFUL
IT03456ONBAR ABENDS IN BSAGETENVIRONMENT CALL USING EMC NETWORKER STORAGE MANAGER
IT03463UNHANDLED ERROR -648 IN A UDR CAN CAUSE AN ASSERTION FAILURE AND INSTANCE CRASH IN DO_PUTS() IF THE TRACING IS ON
IT03486WHERE EXISTS QUERY USES SEQUENTIAL SCAN IF RTREE INDEX EXISTS ON INNER TABLE
IT03528DISTRIBUTED QUERY CAN CAUSE THE IMPLICIT SSL CONNECTIONS TO HANG
IT03547CDR VIEW APPLY COMMAND WILL CHECK THE FILES IN ATS OR RIS DIRECTORY IN NESTED WAY
IT03570ASSERT WARNING TRYING TO FREE EXTENT FOLLOWING FAIL-OVER AND FAIL-BACK OF HDR PAIR WITH INTERRUPTED DEFRAGMENT OPERATION
IT03618CDR COMMAND CORE DUMPS IN CHECKACTIVEREPLICATE()
IT03643AFTER ROLLBACK OF TRANSACTION WITH SEVERAL ALTER TABLE STATEMENTS ERRORS -242/-106 MIGHT BE RETURNED TRYING TO ACCESS THAT TABLE
IT03740PDQ QUERY CHOOSES INDEX INSTEAD OF SCAN AND IS SLOWER THEN SAME QUERY ON 11.50. OPT_SEEK_FACTOR MAKES NO DIFFERENCE.
IT03769FAST CACHE PROBLEM WHEN DROPPING TABLE OR DATABASE CAN ASSERT CRASH WITH BAD BLOCK HEADER MT_SHM_FREE 1
IT03860INCORRECTLY CLOSED SOCKET NETWORK CONNECTIONS WITH 25580 ERRORS DUE TO ERROR HANDLING CODE IN SENDSOCKET()
IT03862SYSTABLES INDEX IS CORRUPTED DURING ROLLBACK OF A CREATE TABLE
IT03925LOADING A BLOB INTO AN EXTERNAL TABLE FROM A DIRECTORY WITH EITHER A _ OR , IN THE NAME RETURNS PERMISSION DENIED ERROR 13
IT04055ENABLING XTF_CDR_DBX AND DEFINING AN ER SERVER WILL CRASH THE ENGINE
IT04091IWA AF IN CONV_OBJNAME POSSIBLE WHEN OFFLOADING A QUERY
IT04184THE 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
IT04190AIX IPCSHM CLIENTS CAN CAUSE ERRNO=34, SHM SEMAPHORE FAILURE ASSERTION FAILURES
IT04296ENDLESS LOOP OF AF EXCEPTIONS POSSIBLE WHEN EXECUTING UDR AND STACK MEMORY IS CORRUPTED
IT04459BFFAIL OR BUFFCHECK FAILURE FROM SAMPLESTATS RUNNING UPDATE STATS LOW WHILE DELETES OCCURRING
IT04475SMALL BAD BLOCK HEADER OR BAD FREE BLOCK ASSERT FAILURE FILES PRODUCED WHEN WE FAIL TO REPAIR THE POOL.
IT04537ASSERT CRASH IN VALLOAD WHEN SELECT STATEMENT IS SELECTING AN AGGREGATE AND GROUP BY IS MISSING THIS COLUMN
IT04540SQL ERROR -9810 ISAM -140 WHEN TRYING TO RUN JAVA UDR ON READ ONLY SECONDARIES
IT04556THE OS_MEM_FREE COLUMN FROM SYSMASTER:SYSMACHINEINFO IS MISLEADING ON AIX
IT04585ONAUDIT FAILS WITH SEGMENTATION FAULT IN STRTOLL() WHEN ADTMODE (PARAMETER -L) IS SET WITHOUT A VALUE
IT04601ERROR 1213 WHEN OPTIMIZER ATTEMPTS A HASH JOIN METHOD ON AN OUTER JOIN
IT04610POTENTIAL MEMORY LEAK PROBLEM IN SESSION OPENTAB USING A WORKING SET OF MORE THAN 128 TABLES IN A SESSION
IT04652SQL STATEMENT WITH A LENGTHY STRING OF APOSTROPHES CAN LEAD TO M NY DIFFERENT ASSERTIONS RESULTING FROM 0X27272727 OVERWRITE PAT
IT04673GENONCFG ABORTS INSTEAD OF CREATING AN ONCONFIG FILE
IT04675GROUP BY? WITH AN ALIASED COLUMN RETURNS MULTIPLE ROWS
IT04708WITH BATCHEDREAD_INDEX = 0 AND A NON-LOGGED DATABASE, CERTAIN INDEX CORRUPTION COULD MAKE A SQLEXEC THREAD RUN IN A TIGHT LOOP
IT04757THE SQL OPTIMIZER PREFERS AN INDEX SCAN TO A SEQUENTIAL SCAN EVEN THOUGH IT IS 3 TIMES SLOWER
IT04783SUCCESSIVE UPDATE STATISTICS HIGH .... ON A TABLE WITH STATLEVEL FRAGMENT FILLS THE SBSPACE WHEN RUN IN ONE SESSION
IT04795ON WINDOWS, XML UDR FAILS WITH -9791 IF VIRTUAL EXTENSION MEMORY SEGMENT HAS AN ADDRESS LARGER THAN 0XFFFFFFFF
IT04819LEVEL 0 ARCHIVE STARTED IN 11.70.FC8W1 CAN CRASH THE SERVER IN THE ONTAPE THREAD
IT04849REMOTE QUERY USING VIEWS RETURNS INCOMPLETE RESULTS
IT05187SQL ERROR -710 ISAM -12234 CAN HAPPEN WHEN CONCURRENT SELECTS AND ALTER FRAGMENT ONLINE DETACH PARTITION ARE EXECUTED
IT05195MERGE INTO TARGET_TABLE IS LEAKING OPEN FILES AND POSSIBLY MEMORY
IT05220AN INDEX SCAN OF AN INDEX OVER NCHAR/NVARCHAR COLUMN CAN GENERATE MUCH MORE IOS THEN SIMILAR SCAN OF AN INDEX OVER (VAR)CHAR
IT05222PUT IN CLAUSE (FOR BLOB/CLOB STORAGE) GETS IGNORED WHEN USING DRDA AND DB2JCC DRIVER
IT05262RSAM POOL GROWS LARGE AFTER DBSCHEMA OR SYSMASTER QUERY WHEN AN INSTANCE HAS MANY DATABASES, TABLES, AND INDEXES
IT05383STACK AND MEMORY CORRUPTION RESULTING FROM SELECT STATEMENT WITH LARGE UNION ALL TABLE EXPRESSION
IT05463FRAGMENT BASED UPDATE STATS HIGH CONSUMES A HUGE AMOUNT OF SBLOBSPACE
IT05467SYSTEM GENERATED TEMP TABLES ARE ALLOCATED IN ROOTDBS WHEN TEMP SPACES ARE TOO SMALL
IT05481PO_FREETOTAL & PO_USEDTOTAL ARE INCORRECT AFTER BAD BLOCK DETECTED AND CAUSES MULTIPLE ASSERTIONS IN MT_CHECKPOOL2()
IT05499PARALLEL REPLICATE SET CHECK JOB MAY USE CDR_ESETOUTOFSYNC(213, WARNING) AS EXIT CODE EVEN THOUGH SOME OF THE REPLICATE J
IT05551DBACCESS CAN CORE DUMP ON EXIT AFTER THE ERROR -801 HAS OCCURRED
IT05672IFXCLONE FAILS WITH A VERSION MISMATCH ERROR WHEN THE VERSION NUMBER OF IDS IS GREATER THAN 12 CHARACTERS
IT05702USING -VERBOSE:GC IN JVPARGS ONCONFIG PARAMETER
IT05834CONNECT BY QUERY CREATES UNIQUE UNNAMED ROW TYPES AND STORES THEM IN SYSTEM CATALOG AND THEY ARE NEVER REMOVED
IT05846AUTO READAHEAD INCORRECTLY COUNTS INDEX-DATA READ AHEADS AS INDEX READ AHEADS
IT05921IDS_INSTALL RETURNS FALSE RETURN CODE 1
IT05924INSTANCE WITH SMALL DATA DICT. CACHE MAY CRASH IN FRLUPDATETABPARTITION() WHEN RUNNING THE CDC_SET_FULLROWLOGGING() FUNCTION
IT06088ERROR 874 AND AF (NO ENGINE CRASH) CAN RESULT WITH AN IMPLICIT CAST ON A JOIN WITH A SERIAL ON A REMOTE TABLE
IT06095USERS CANNOT BE CONNECTED TO IDS ON WINDOWS WITHOUT PROVIDING USER NAME AND PASSWORD
IT06134SQSCB MEMORY IS NOT RELEASED WHEN USING DYNAMIC SQL AND DRDA PROTOCOL WITH DB2JCC DRIVER
IT06138IFX_INTERNAL_SET RETURNS ERROR 37 IF THE GROUP ID/NAME IS CHANGED IN SQLHOSTS
IT06139MEMORY LEAK IN CONNECTION MANAGER IF NO SERVER CAN BE REACHED
IT06149QUERY GIVES DIFFERENT RESULTS FROM SYSINDICES AND SYSINDEXES AFTER UPGRADE FROM 10.00.FC11
IT06245CREATE INDEX IS VERY SLOW IF TABLE CONTAINS PARTITION BLOBS
IT06246CDR CLEANSTART COMMAND NOT PURGING TRG_SEND_SREP TABLE
IT06333DEFINING A REPLICATE ON A TABLE WITH A HUGE NUMBER OF COLUMNS FAILS
IT06371USING THE SKIP OPTION IN SUBQUERY CRASHES ENGINE IN RDATAVALCHAR()
IT06403THE OPTIMIZER CAN CHOOSE A POOR QUERY PATH DUE TO THE ORDER IN WHICH TABLES ARE LISTED IN THE FROM CLAUSE OF THE SQL
IT06430ONCHECK -CC FAILS WITH ERROR: NO TABLE FOUND FOR SYSAMS RECORD
IT06431ADDING NEW STATEMENTS TO THE STATEMENT CACHE UPON REACHING STMT_CACHE_HITS CAN CAUSE VARIOUS FAILURES
IT06440INSTANCE HANG WHEN DOING ONMODE -D SET SDS PRIMARY WHILE INSTANCE IS BLOCKED VIA ONMODE -C BLOCK
IT06473MISSING MESSAGE FILE IN CSDK INSTALLATION WHEN USING DBACCESS
IT06520CDR SYNC OF A REPLICATE ON A TABLE WITH A HUGE NUMBER OF COLUMNS CRASHES
IT06523INSERT CALLED FROM A STORED PROCEDURE BY AN INSERT TRIGGER FAILS EVEN THOUGH THE PROCEDURE OWNER HAS INSERT PRIVILEGES
IT06530EXTERNAL RESTORE FAILING WITH DBSPACE XYZ NOT RECOVERED FROM SAME ARCHIVE BACKUP AS DBSPACE ROOTDBS WHEN NO LOGICAL RESTORE IS
IT06547MEMORY LEAK IN RALLOC ON REMOTE SERVER WHEN RUNNING SELECT WITH LEFT JOIN
IT06556ERROR 768:INTERNAL ERROR IN ROUTINE MINDEXP: MISSING RANGE FILTER; WHEN WE USE MULTI-INDEX SCAN AND SET MULTI-BYTE LOCALE
IT06624EXTERNAL RESTORE FAILING WITH DBSPACE XYZ NOT RECOVERED FROM SAME ARCHIVE BACKUP AS DBSPACE ROOTDBS WHEN NO LOGICAL RESTORE IS
IT06644SLOW QUERY RESPONSE AND HIGH BUFFER READS ON EMPTY TABLE
IT06679REMOTE SELECT ON A VIEW WITH OUTER JOIN AND CONCATENATED COLUMN WITH FUNCTION RETURNS -393
IT06726ASSERT WARNING INVALID INDEX STATISTICS FOUND WHEN USING STATISTICS SAMPLING WITH INDEX HAVING MANY DELETED ITEMS
IT06767UPDATE STATISTICS HIGH ON TABLE BIGGER THAN 1.1 BIO ROWS CAN CAUSE EXCEPTION IN SRTQUICK
IT06865THREAD LOOPS WHEN INSERTING ROW INTO TABLE MARKED FOR UPDATE-ANYWHERE REPL WITH CDR_SERIAL IN EFFECT AND CURRENT SERIAL AT MAX
IT06883SEGV CALLING BYCOPY() IN CHKPARENT() WHEN INSERTING IN SEVERAL TABLES AND WITH SHORTAGE OF MEMORY
IT06929PERSISTING LOG FILE FLAG 0X100 PREVENTS BACKUP OF LOGICAL LOG
IT07078ASSERT FAILURE IN DECRREFCOUNT POSSIBLE WHEN REFERENCING CLEANED UP DICTIONARY CACHE ENTRY
IT07191RSAM MEMORY POOL BLOCK HEADER CORRUPTION WHEN USING MULTI-LEVEL SAVEPOINTS
IT07292NESTED SELECT RETURNS 294: THE COLUMN COLUMN-NAME MUST BE IN THE GROUP BY LIST EVEN THOUGH THE COLUMN IS LISTED IN GROUP BY LIST
IT07378WHEN USING CHANGE DATA CAPTURE (CDC) TO SNIFF LOGS, THERE ARE INCONSISTENCIES WHEN INSERTING AND OR UPDATING A PRIMARY KEY
IT07388STALL POSSIBLE BETWEEN ALTER FRAGMENT ONLINE DETACH AND THREAD CLEARING DICTIONARY CACHE ENTRY
IT07391FUNCTION ADMIN(DROP CHUNK, SBSPACE, ...) IGNORING ANY METADATA EXTENTS OR EVEN USER DATA STILL RESIDING IN CHUNK TO DROP
IT07548WITH CM RUNNING CONTINUOUSLY, BRINGING DOWN IDS TO CHANGE DBSERVERNAME, ALIAS OR HA_ALIAS CAN RESULT IN CM FAILING TO REDIRECT
IT07599DR_PRPING THREAD MAY BECOME STUCK IN RUNNING STATE FOLLOWING HDR CONNECTION FAILURE
IT07678CDC CAUSES AF SNOOPING ROWS ON A NEW FRAGMENT
IT07920PARTITION BY SYNTAX OF OLAP WINDOW AGGREGATE RETURNS -25855 ERROR WITH 11.70.FC7W2 AND REMOTE SYNONYM
IT07946CDRGEVAL GROUPER THREADS DEAD-LOCKING WITH APPLICATION DML
IT08011ASSERT FAILURE CRASH IN POLL THREAD DURING INITIALIZATION
IT08052SECOND REMOTE SELECT IN A SESSION TO A DIFFERENT SERVERNAME FAILS WITH ERROR -908 -27001
IT08203UNITIALIZED VALUE_T IN INSONE_NEXT CAN CAUSE ASSERTION FAILURE AFTER UNEXPECTED CALL TO EXECUTE_BLOB_ASSIGN
IT08223THREAD SUSPENSION NOT CORRECTLY ABORTING SERVER IF THREAD IS REPORTED AS BEING NOT ABLE TO BE SUSPENDED
IT08258DUPLICATE ROWS CAN BE INSERTED INTO A TABLE WITH UNIQUE INDEX DEFINED
IT08274ERROR (USE21) - GEOMETRY INTEGRITY ERROR IN FUNCTION GEOMETRYDEEPCOPY CAN OCCUR
IT08447ONMODE -P STOP HANGS IF THE LISTENER THREAD USES THE DRSOCTCP PROTOCOL
IT08510DATETIME RETURNED FOR UTC CALCULATION DOES NOT WORK AS EXPECTED WHEN INVOKED AS A SENSOR
IT08544EXTERNAL RESTORE FAILING WITH DBSPACE XYZ NOT RECOVERED FROM SAME ARCHIVE BACKUP AS DBSPACE ROOTDBS WHEN NO LOGICAL RESTORE IS
IT08559SELECT STATEMENT WITH A HOST VARIABLE IN A STORED PROCEDURE USES SEQUENTIAL SCAN WHEN DATA DISTRIBUTION IS AVAILABLE
IT08629DEADLOCK ON CLONETIMER MUTEX CAUSING CHECKPOINT/IO HANGS
IT08630ON WINDOWS ONSPACES WILL ALLOW ADDING A CHUNK TO A DIRECTORY
IT08679PDQ QUERY HANGS ON MUTEX FREE_LOCK
IT08700INCOMPLETELY INITIALIZED TEMP PARTITIONS CAN CAUSE PERSISTENT ERRORS OCCURRED WHILE CLEANING DBSPACE WARNING ASSERTIONS
IT08747DROPPING LOGICAL LOGFILES WHICH CAUSES A DECREASE IN EXTENDED RESERVE PAGE USAGE CAN RESULT IN DUPLICATE LOG FILE NUMBER ERRORS
IT08812TURNING ON THE AUDITING LEVEL 1 ADDS AN UNNECESSARY DELAY TO ONSTAT & ONMODE COMMANDS
IT08813TIMESERIES VT QUERY WITH SMALL READ AHEAD PAGES LIKE AUTO_READAHEAD 1,4 CAN RETURN (UTSD6) - INTERNAL ERROR: TSAM.C: 2867
IT08896SELECT QUERY WITH NESTED SUBQUERIES MAKES THE ENGINE CRASH WITH SQL ERROR -272 NO MATTER WHAT THE PERMISSIONS ON TABLES
IT08904DBSCHEMA -SS -SI NOT REMOVING IN CLAUSE OF INDEXES
IT08923HAVING UPDATABLE SECONDARY SIGNIFICANTLY SUPPRESSES PERFORMANCE
IT09007BAD INDEX ON HDR SECONDARY IN A COMBINED ER PRIMARY TARGET SYSTEM WITH ATTACHED HDR
IT09078DOCUMENTATION IS VAGUE ON HOW TO SET A DATETIME DATATYPE WITH THE DEFAULT CLAUSE.
IT09190SPL PROCEDURES WITH DEFAULT PARAMETERS OF TYPE LIST CAN SEGV ASSERT IN VALSTORE WHEN EXECUTING PREPARED EXECUTE PROCEDURE MULT
IT09217THE APPLY FUNCTION CALLED FROM STORED PROCEDURE FOR 2 TIMESERIESCREATED BY CLIP() FUNCTION CAN FAIL WITH -9791 OR RETURN INCORR
IT09256PARALLEL BACKUPS OF DBSPACES CAN FAIL WITH 143 (DEADLOCK) ERRORS
IT09290SERIAL COLUMN WRAP-AROUND MAY INSERT THE VALUE ZERO INTO A ROW
IT09440EXCESSIVE -25580/-25582 ERROR DUE TO SEND()/RECV() FAILURE ON AIX
IT09544ONSTAT -G SES REPORTS SESSION POOL OPENTABLE MEMORY LEAK WHEN RUNNING QUERIES WHICH REQUIRE AUTO-INDEX PATH QUERY PLANS
IT09586QUERY USING ROWIDS BY A MULTIINDEX SCAN CAN CAUSE BLOCK HEADER CORRUPTION
IT09608ONCLEAN CAN REMOVE RESOURCES OF ANOTHER INSTANCE AND ACCIDENTALLY BRING THIS WRONG INSTANCE DOWN
IT09687UPDATE 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
IT09891TOO MANY -25582 ERRORS MESSAGES IN ONLINE.LOG
IT09892TOO MANY -22580 ERROR MESSAGES IN THE ONLINE.LOG
IT10285WHEN A PARTITION IS DROPPED AND ADDED BACK USING THE BEFORE KEYWORD, THE SERIAL VALUE RESETS BACK TO 1
IT10301TEMP TABLE CONSTRAINTS CAN EXHAUST SYSCONSTRAINTS SERIAL
IT10306WITH THREAD SUSPENSION ENABLED, CERTAIN MEMORY CORRUPTION CAN CAUSE THREAD SUSPENSION CODE TO INFINITELY LOOP ASSERT FAILING
IT10335ASSERT FAILED: INVALID MUTEX TYPE IN MT_NXTSCB
IT10339ONMODE -C BLOCK CAN LEAVE THE RSS BLOCKED AFTER A NETWORK ERROR WAS RESOLVED IF DELAY_APPLY IS SET
IT10352MEMORY LEAK IN DATA DICTIONARY WHEN ENTRIES FOR TABLES WITH FOREIGN KEYS ARE RECREATED
IT10354PTMAP ASSERT FROM BTPOSITION WHEN ONE THREAD SELECT MAX USING IN -TABLE INDEX WHILE ANOTHER THREAD DELETE HIGHEST MAX VALUES IN A
IT10493CSM PASSWORD ENCRYPTION (SPWDCSM) FAILS SPORADICALLY ON SOLARIS 10 WITH LISTENER ERRORS -14565 AND -5000
IT10545LINUX: WITH THE FIX FOR APAR IT06767 AN UPDATE STATISTICS HIGH ON TABLE BIGGER THAN 1.1 BILLION OF ROWS CAN CRASH THE ENGINE
IT10603HDR PAIR NOT AUTO-RECONNECTING IF PRIMARY RESTARTED WHILE NETWORK DOWN
IT10693ERROR -1204 RETURNED WHEN RIGHT HAND DATE VALUE OF EQUALITY EXPRESSION CONTAINS DECEMBER 31ST, 9999
IT10742DIRTY READ SKIP SCAN INDEX READ AGAINST TABLE WITH ROWS CONSTANTLY INSERTED AND DELETED CAN ASSERT LAST_PAGE <= *RET_PAGE
IT10878ANSI JOIN WITH ROW EXPRESSION SEGVS IN CHECKEXPR
IT10943ASSERT FAIL BAD BLOCK POINTER MAY OCCUR DURING A CONNECTION ERROR WHEN USING CSM AND PAM
IT10957INVALID XML CREATED BY GENXMLQUERYHDR(), GENXMLQUERYHDRCLOB() AND GENXMLSCHEMA()/GENXMLSCHEMACLOB() FUNCTIONS
IT11123CANNOT VIEW BAR_ACT_LOG/BAR_DEBUG_LOG AS USER WITH EFFECTIVE GROUP ID SET TO BARGROUP
IT11141ASSERT FAILURE AND ROLL-FORWARD ERRORS ON CREATING SECONDARY SERVER
IT11260UNCLEAR AND FAULTY DEPENDENCY OF NON-PDQ QUERY PLAN ON DS_TOTAL_MEMORY / DS_MAX_QUERIES
IT11265WHERE CLAUSE SELECTION BEHAVIOR IN TRIGGER IS INCORRECT
IT11269ER SHOULD STARTUP AUTOMATICALLY AFTER FAILOVER TO HDR SECONDARY SERVER
IT11370SELECT STATEMENT WITH A CORRELATED SUBQUERY WITH GROUP BY ROWID CRASHES THE ENGINE
IT11585TABLE LEVEL RESTORE: AFTER BSA_RC_NO_MORE_DATA IS REACHED, ARCHECKER TRIES TO GET MORE DATA.
IT11586ILLEGAL POSSIBILITY TO SWITCH FROM RECOVERY MODE TO SINGLE-USER MODE
IT11853AUS EVALUATOR DOES NOT KEEP THE DISTRIBUTION TO MEDIUM
IT11858RSAM MEMORY POOL BLOCK HEADER CORRUPTION WHEN USING MULTI-LEVEL SAVEPOINTS
IT11909ON HDR SECONDARY, SELECT INTO TEMP WITH NO LOG ON BLOB COLUMN OF LENGTH 0 (BUT IS NOT SET TO NULL) RETURNS -618 AND -140
IT11910LOG ROLLFORWARD ERROR 126 ON HINSERT INTO A TABLE ON SECONDARY AFTER TABLE HAS BEEN TRUNCATED
IT11930POSSIBLE ROLLBACK FAILURE FOR PBDELTE ON TEMP PARTITION
IT11952MEMORY CORRUPTION AND OTHER ERRORS POSSIBLE WHEN USING CDC
IT11956QUERYING DATA COMPLETELY CACHED HAVING A LARGE NUMBER OF ITEMS IN AN IN CLAUSE CAN CAUSE SQLEXEC THREAD TO YIELD IMPROPERLY
IT12041874 ERROR/SEGV IN OPSELEC AFTER FIX FOR APAR IT10693 WHEN USING EXPRESSION NOT EQUAL ( <> ) ON DATE DECEMBER 31ST, 9999
IT12065REFERENCING THE SAME COLUMN REPEATEDLY IN THE GROUP BY CLAUSE USING ITS ALIAS NAME CRASHES THE ENGINE
IT12184QUERY WITH MULTIPLE FULL OUTER JOINS CRASHES THE SERVER
IT12202DEADLOCK BETWEEN LISTENER AND LOWMEMORYMGR CAN CAUSE THE INSTANCE TO GET STUCK IN WAITING FOR THE SESSION MUTEX
IT12203REPLICATION OF INSERT/UPDATE FROM EN_US.UTF8 TO EN_US.819 CORRUPTS INDEX
IT12508IPL THROTTLING ON SYSTEMS WITH LARGE LOGICAL LOG SPACE CAN SEE THE IPL THREAD YIELD FOR LONG PERIODS OF TIME
IT12541WITH THE FIX OF IT10301 THE ENGINE CAN FALSELY REPORT ERROR -692 WHILE DELETING FROM A TEMP TABLE WITH UNIQUE OR PK CONSTRAINT
IT12785ONMODE -C BLOCK WILL MARK CHUNKS DOWN WITH IO ERRORS IF INSTANCE HAS OVER 32 CHUNKS THAT ARE MIRRORED
IT12813SERIAL COLUMN GOES OUT OF SEQUENCE WHEN ALTERED FROM SERIAL TO SERIAL8 AND SERIAL HAS WRAPPED
IT12823CDR LIST SERVER COMMAND RETURNS : ERROR RETURNED FROM CDR_ADJUST_INFORMIXSERVER: SELECT GROUPNAME SQLCODE -245 ISAM -144
IT12919ASSERTION FAILURE: CONDITION FAILED (RW_MUTEX->RW_SLOCK > 0), IN (MT_RW_UNLOCK)
IT12920ASSERT FAILURE POSSIBLE DURING CLEANUP OF CDC SESSION
IT12945WHEN A SECONDARY IS PROMOTED UNDER CERTAIN CIRCUMSTANCES THE BTSCANNER THREAD DOES NOT START LEADING TO ASSERTION FAILIURES
IT13088CHECKPOINT DURATION IN ONSTAT -G CKP/SYSCHECKPOINT CAN BE DIFFERENT FROM INSTANCE MESSAGE LOG
IT13219QUERY USING 2 ANSI JOINS AND THE BTS_CONTAINS() FUNCTION WITH SCORE ARGUMENT FAILS WITH ERROR 874 AND AF IN SQSLV_RESOLVE()
IT13251WHEN AN ERROR OCCURS IN AN SPL WITH A SELECT, A -285 IS GENERATED INTERNALLY BY THE SERVER WHICH WILL BLOCK ANY CURSORS FROM BEI
IT13481CDR DELETE REPLICATE CAN CAUSE SEGV ASSERTION FAILURE IN CDRCPARSE THREAD
IT13536POSSIBLE ENDLESS LOOP IN CASE OF BROKEN REMOTE CONNECTION
IT13537DUBIOUS OR EXCESS SYSCOLAUTH ENTRIES FOR VIEW CONTAINING MATH EXPRESSIONS, FUNCTIONS OR ORDER BY
IT13718ASSERT FAILURE IN MT_FREE/DECRLKCOUNT USING STORED PROCEDURE REFERENCING A TEMP TABLE THAT WAS DROPPED AND ROLLED BACK IN TRANS
IT13817ROLLBACK ERROR 101 AFTER ONLINE FRAGMENT DETACH FOLLOWED BY A DROP OF THE DETACHED FRAGMENT
IT13846IDS CRASHES IN EVALCOLS() SELECTING FROM A VIEW AND A TEMP TABLE IF PDQPRIORITY IS SET
IT13890MEMORY LEAK IN CSM VP WHEN OPENING AND CLOSING PASSWORD ENCRYPTED CONNECTIONS
IT13968CDR ERRNO 49 (MAXIMUM NUMBER OF REPLICATES EXCEEDED) EVEN AFTER REPLICATES DELETED
IT14144768: INTERNAL ERROR IN ROUTINE OPJOIN() WITH MULTIPLE JOINS AND LEFT OUTER JOIN
IT14183RSS SECONDARY ASSERT LOGICAL LOG REPLAY ERROR ON CHALLOC WHEN ROLLFORWARD INSERTS AFTER A TRUNCATE TABLE
IT14217VARIOUS MEMORY CORRUPTIONS WHEN RUNNING HUGE SELECT UNION WITH GLS
IT14438768: INTERNAL ERROR IN ROUTINE OPJOIN() WHEN RUNNING SELECT QUERY AFTER UPDATE STATS AND IFX_FOLDVIEW ENABLED
IT14444A QUERY USING XPS API AND INDEX ACCESS CAN RETURN INCOMPLETE RESULTS IF THE INDEX IS UPDATED BY A CONCURRENT THREAD
IT14465ASSERT FAILED: INVALID MUTEX TYPE WHEN INTERRUPT RECEIVED WHILE BUILDING A HASH TABLE
IT14485ASSERT FAILURE AND CRASH POSSIBLE DURING CSM VP INITIALIZATION WHEN MULTIPLE CPU VPS ARE CONFIGURED
IT14675OPTIMIZER ASSERT FAIL AND ERROR -874 WHEN REOPENING A CURSOR DEFINED WITH HOST VARIABLES THAT SELECTS FROM A VIEW WITH SUBQUERY
IT14736INTERMITTENT NETWORK CONNECTIVITY MAY LEAD TO RSS SERVER SHUTDOWN
IT14781HUGE DELAYS WHEN REPLICATING BLOBSPACE BLOBS, EXPONENTIALLY INCREASING WITH BLOB SIZE
IT14852SELECT QUERY USING CONNECT BY CLAUSE WITH PRIOR APPLIED TO VARCHAR RETURNS 26079
IT14870ASSERT FAILED TRYING TO DETACH A FRAGMENT USING FORCE_DDL_EXEC AND OTHER CONCURRENT THREADS HAVING TO GROW THEIR OPENTAB
IT14933FRAGMENTATION ELIMINATION NOT USED WHEN USING HOST VARIABLES
IT14971ESQL/C PROGRAM RETURNS -259 AFTER ROLLBACK
IT15229VARIOUS ASSERT FAIL AND WARNINGS WHEN LONG TRANSACTION ROLLBACKS OCCUR THAT INVOLVE REMOTE CONNECTIONS
IT15404MEMORY LEAK IN SQOPUTIL.C:GET_DIST()
IT15405ALTER TABLE ADD/MODIFY (WITH DEFAULT VALUE) DOES NOT WORK AS EXPECTED
IT15515SLOWER PERFORMANCE WHEN PDQPRIORITY IS ENABLED WITH MORE THAN 180 FRAGMENTS
IT15608WHEN A TABLE HAS MUTLIPLE UPDATE TRIGGERS ON MUTLIPLE COLUMNS, THOSE TRIGGERS WILL FIRE ONCE PER COLUMN UPDATED PER TRIGGER
IT16010ENGINE CRASH IN SSC_LINK WHEN STATEMENT CACHE IS ENABLED
IT16026IMPROVE THE PERFORMANCE OF THE SQL STATEMENT CACHE
IT16184HDR SETUP USING ONTAPE ...-T STDIO -F MAY HANG HDR LATER
IT16206ASSERTION CONDITION FAILED (CACHE_ELM->MT_CACHE_ELEM_LOADER == NULL), IN (MT_CACHE_DONE)
IT16466CASTING A VERY LONG COLLECTION VALUE TO LIST OR MULTISET CAN HOG A CPU VP
IT16468QUERY DOES NOT RETURN IN 11.70.FC8W1, BUT RAN QUICKLY IN 11.70.FC4
IT16522WRONG RESULTS IN QUERY WITH SUBQUERY WITH CASE WHICH INCLUDES SUBQUERY AND WHERE CLAUSE ON CASE COLUMN IF ORDER BY IS USED OR NO
IT16670HIGH CONTENTION ON SESSION MUTEX WHEN LOTS OF SESSIONS SELECT DATA FROM SYSMASTER:SYSSESSIONS
IT16717WITH ROOT CHUNK VERY FULL DYNAMIC_LOGS CAN EAT ALL AVAILABLE SPACE WITHOUT ADDING MORE LOG FILES
IT16756INAPPROPRIATE CALL TO DESTROY_SESSION AND AF MAY RESULT FROM LOSS OF REMOTE CONNECTION DURING QUERY PROCESSING
IT16963ASSERT FAILURE IN STLONG POSSIBLE WHEN RUNNING STORED PROCEDURE
IT17207INTERRUPTING A DEFRAGMENT OPERATION ON A LARGE FRAGMENTED TABLE DOES NOT CLEAN FRAG IN PROGRESS FLAGS ALL THE TIME
IT17322ONLOG WITH -D OPTION WITH DIRECTORY DEVICES WILL NOT DISPLAY A RANGE OF LOG FILES
IT17447ASSERT FAILURE IN SQSCB_CLEANUP AFTER A LISTENER THREAD ERROR
IT17539--SERIAL REPLICATE OPTION POTENTIALLY CAUSING CRASHES IN INSERTHASHINTOTXN()
IT17633LPAD() FUNCTION RETURNS INCORRECT STRING IN MULTI-BYTE ENVIROMENT
IT17636ENGINE CRASHES AND MEMORY CORRUPTION WHEN DOING DML STATEMENTS AND UPDATE STATISTICS AGAINST TABLES THAT HAVE REFERENTIAL CONSTR
IT17796RSS SERVER MAY NOT RECONNECT FOLLOWING A RESTART OF THE PRIMARY SERVER
IT17853MEMORY LEAK ON REMOTE SERVER WHEN RUNNING SELECT WITH LEFT JOIN
IT18233ASSERT FAILED: MEMORY FREED TWICE WHEN DRDA_PREPARE CALLS MT_FREE AND SQL ERROR -23103 IS RETURNED TO CLIENT
IT18236ASSERT FAILURE MESSAGE ATTEMPTING TO ALLOCATE SLOT ON IN-USE OLD VERSION PAGE IS UNHELPFUL
IT18280CONCURRENT READERS AND ALTER FRAGMENT ONLINE STATEMENTS CAN LEAD TO PERSISTENT ISAM -135 ERRORS
IT18723MEMORY CORRUPTION IN CDR POOL
IT18741SELECT FROM SHOWS ALL COLUMNS, EVEN IF ONLY ACCESS TO ONE COLUMN IS PERMITTED
IT18764MEMORY LEAK IN AIO POOL WHEN USING REMOTE_USERS_CFG
IT19040ENGINE HANGS IN RVALSTRING
IT19042SELECT INTO A TEMPORARY TABLE WITH PDQ COULD FAIL WITH -264/-770
IT19898MAIN_LOOP DEADLOCKING WITH ITSELF IN WAIT_4_CKPT_2_COMPLETE() WHEN JUST DYNAMICALLY ADDING NEW LOG FILE




[{"Product":{"code":"SSGU8G","label":"Informix Servers"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF022","label":"OS X"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"11.7;11.70","Edition":"Developer;Growth;Innovator;Ultimate","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
17 June 2018

UID

swg27049414