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


Translate this page: