IBM Support

Fix list for Informix 11.70.xC7 and PIDs 11.70.xC7W1, 11.70.xC7W2 and 11.70.xC7W3

Product Documentation


Abstract

Informix provides periodic fixes for release 11.70. The following list is the most recent report of fixes for customer-reported defects in Version 11.70.xC7 and PIDs 11.70.xC7W1, W2 and W3. This report combines both Windows- and UNIX-specific defect fixes.

Content








Fix release date: 28 Oct 2013
Last modified: 2 May 2016
Status: Recommended


NOTE: some detail links below have been disabled as they are no longer available.


W3 APARs
Description
IC85696 ASSERT WARNING: (PART <= SPTR->NUM_LPARTS) POSSIBLE DURING QUERY EXECUTION
IC86642 WITH PDQPRIORITY SET, THREADS SHOULD NOT BE LEFT IN AN AWAIT_MC STATE AFTER STORED PROCEDURE COMPLETION
IC88205 INSTALLATION ABORTED WHEN UPDATING FROM PREVIOUS IDS RELEASE
IC89389 TABLE LEVEL RESTORE TO EXTERNAL TABLE LOSING FLOAT PRECISION RIGHT OF THE THE DECIMAL POINT
IC90419 UPDATE OF SPATIAL COLUMN SETS ROW LOCKS FOR TABLES WITH LOCK MODE PAGE
IC90796 ALTER TABLE MODIFY FAILS WITH -366. VIEW SEEMS TO CONTAIN INVALID CAST WHICH WAS NOT THERE ON CREATION
IC90829 ON SOLARIS TASK DEFRAGMENT PARTNUM ALWAYS RETURNS ERROR
IC90889 ADDITION OF SHARED MEMORY SEGMENTS USING LARGE PAGES CAN BE SLOW AND MAY BLOCK USER ACTIVITY
IC91339 MULTI-INDEX SCAN ACCESS METHOD REQUIRES 10 TIMES MORE MEMORY THAN FOR USUAL INDEX PATH
IC91341 COUPLING OF INFORMIX WAREHOUSE ACCELERATOR WITH INFORMIX SERVER (SETUPDWA) CAN FAIL WITH ERRNO 18
IC91655 SQL ERROR 789 OR 208 POSSIBLE FOR STAR JOIN QUERY ON RANGE PARTITIONED TABLE
IC91678 INFORMIX OPTIMISER VULNERABLE TO POOR QUERY RESPONSE TIMES ON INCREMENTING COLUMNS
IC91981 SYSDBOPEN PROCEDURE WILL NOT RUN AS DBA ON HDR SECONDARY
IC92020 ONBAR CAN SILENTLY FAIL TO FORK PROCESSES IF TWO OR MORE COMPLETE AT THE EXACT SAME TIME
IC92084 SERVER CAN CRASH IN NEW_EVAL() WHEN USING STATEMENT CACHE
IC92182 ROLLBACK A DISTRIBUTED TX WITH TEMP TABLES ON TOP OF A COMMIT CAN LEAD TO LOSING CONTROL ABOUT THE TEMP TABLE PARTITIONS
IC92232 THE ALARMPROGRAM IS NOT TRIGGERED WHEN DYNAMICALLY ADDING A SHARED MEMORY SEGMENT
IC92487 METADATA INFORMATION RETRIEVAL OF JDBC DRIVER MAKES ENGINE CRASH BECAUSE OF BUILT-IN FUNCTION GET_DEFAULT_VALUE()
IC92520 RUNNING HPL QUERY GIVES -1266 ERROR WITH VERSION 11.70.FC5 OR 11.70.FC7W1 ON AIX
IC92598 DBEXPORT DOES NOT VALIDATE THE VALUES ENTERED IN OPTION -NO-DATA-TABLES-ACCESSMETHODS
IC92606 SINGLE SIGN-ON (SSO) CONNECTION CAN LEAK MEMORY IN THE GLOBAL POOL
IC92632 ENABLE TASK IN PH_TASK DOES NOT FIRE THE TRIGGER PH_TASK_TRIG_UPDATE_EXEC_TIME AUTOMATICALLY
IC92641 ERROR 768:INTERNAL ERROR IN ROUTINE MINDEXP: MISSING RANGE FILTER; WHEN USING A NULL VALUE IN A BETWEEN CLAUSE USED AS A FILTER WITH A COMPOSITE INDEX
IC92717 SQL MEMORY LEAK WHEN CONCAT STRING OPERATION USES NULL
IC92739 SELECT THAT USES MULTIPLE CONCAT IN SINGLE EXPRESSION CAN MEMORY LEAK AND RETURN BAD RESULTS
IC92919 PAGE CHECK ERROR IN BFPUT, PG_FRPTR > SLOTBEG WHEN ROLLING BACK SOME DELETES ON A LOGGED TEMPORARY TABLE INDEX
IC92926 ARCHECKER -DX DOES NOT CLEANUP ALL TABLES AS IT SHOULD
IC92934 INDEX MAY NOT BE USED ON SECONDARY SERVERS FOLLOWING TABLE ALTER
IC92960 ASSERT FAILED EXCEPTION CAUGHT IN OPJINIT ON 11.70.FC7W1
IC93116 PERFORMANCE PROBLEM WHEN AN INDEX SELF JOIN IS BEING CHOSEN OVER NON INDEX SELF JOIN QUERY PLAN
IC93133 IN THE DATABASES WITHOUT LOGGING LOCKS GET LOST WHEN THE INSERT TRIGGER INVOKES SPL CONTAINING A SUBSTR() FUNCTION.
IC93136 ONTAPE RENAMED EXTERNAL RESTORE FAILING, IF EXTENDED RESERVED PAGE RESIDES IN A NON ROOT CHUNK.
IC93227 DROP OF A CHUNK OF A TEMPORARY DBSPACE DOES NOT CLOSE FILEDESCRIPTOR ON THE RSS SECONDARY
IC93307 QUERY WITH MULTIPLE JOINS DOES NOT COMPLETE AND THE ESTIMATED COST OF THE QUERY IS VERY HIGH
IC93309 TRIGGER PROCEDURE WILL CRASH THE SERVER WHEN SET EXPLAIN ON IS SET
IC93505 CDR CHECK REPLSET USING --PROCESS OPTION FOR PARALLEL CHECKING CAN RESULT IN MISSING OUTPUT INFORMATION AND LEFTOVER $INFORMIXDIR/tmp/tfil_* files
IC93542 QUERY PERFORMING SEQUENTIAL SCAN INSTEAD OF A KEY ONLY SCAN
IC93646 INSTANCE FAILS TO START WITH MIRROR CHUNKS IF PRIMARY CHUNK CONTAINING EXTENTED RESERVED PAGES IS LOST
IC93740 USER PRIVILEGES IN HDR SECONDARY CACHE ARE NOT REFRESHED
IC93839 BLOCKED CHECKPOINT WHEN BTSCANNER AND SQLEXEC THREADS YIELD WAITING ON A BUFFER WITHOUT LEAVING A CRITICAL SECTION CAUSING A DEADLOCK
IC93942 ERROR 202 WHEN EXECUTEINSERT?UPDATE?DELETE?SELECT STATEMENT WITH WHERE CONDITION THAT CONSISTS OF PLANE0, PLANE2, PLANE15
IC93948 ASSERT FAILED: INVALID MUTEX TYPE POSSIBLE DURING RSS RECONNECTION ATTEMPT WHEN DELAY_APPLY IS USED
IC93965 AFCRASH DURING ONCHECK -PE OR -CE IN MT_FREE CALLED FROM RS_RELEASEEXTMAPMEMORY
IC93967 SINGLE SIGN-ON (SSO) CONNECTION CAN LEAK MEMORY IN THE GLOBAL POOL
IC94007 UNABLE TO REDIRECT THE OUTPUT OF ONPLOAD BY USING (>> SCRIPTNAME.OUT) COULD DO THIS IN EARLIER VERSION OF THE ENGINE
IC94008 PARALLEL PUT AND GET ACTIVITY ON BUFFER FAST CACHE CAN CAUSE ABORT IN BT_FAST_BUFFGET/BUFFGET FUNCTION
IC94064 ROLLBACK OF DEFRAGMENT OPERATION CAN LEAD TO UNEXPECTED INSTANCE TERMINATION IN BUFFCLEAR() CALLED VIA DEFRAG_PGMOVE_FUN()
IC94098 SETTING SECURITY_LOCALCONNECTION=2 ON SOLARIS AND CONNECTING VIA TLITCP FAILS WITH -951/-952 ERRORS RUNNING ONTAPE
IC94226 (-9791)ERROR:ROUTINE EXECUTION TRAP-PROCNAME= REASON:MEM WHILE TRYING TO GET VISUAL QUERY PLAN FROM DATA STUDIO
IC94380 ONMODE -F CRASHES ENGINE IN TXFREEBLK
IC94740 LOGICAL LOGS ON HDR SECONDARY CAN LOSE BACKED UP FLAG LEADING TO PING TIMEOUTS AND INABILITY FOR SERVERS TO RECONNECT AND RESYNC
IC94982 HPL FAILPOINTS 11620/16134, SQL -349 WHEN UNLOADING UDT BIG ENOUGH TO RESIDE IN SBLOB
IC95034 OPTIMIZER PROCESSES QUERY IN DIFFERENT ORDER THAN ON V10 WHICH SIGNIFICANTLY IMPACTS EXECUTION TIME
IC95145 SELECT MAX() CHOOSES QUERY PLAN WITH LOWER ESTIMATED COSTS BUT LONGER RUN TIME
IC95604 EXTENSIVE MEMORY USAGE WHEN USING FRAGMENT LEVEL STATISTICS AND UPDATE STATISTICS HIGH
IC95692 DUPLICATE ROWS IN TABLE WITH UNIQUE INDEX WHEN ROWS RESULT FROM INSERT TRIGGERS ON ER-REPLICATED TABLES.
IC95693 REPACK COMMAND FAILS ON SYSTEM CATALOGS
IC95780 FEA: ALERTCLEANUP FUNCTION SHOULD EXECUTE DELETE STATEMENTS IN MULTIPLE SMALL TRANSACTIONS TO AVOID LONG TX TO OCCUR
IC95984 CRASH IN HASHFULLNAME DUE TO CONTINUED USE OF MEMORY WHICH MAY HAVE BEEN FREED OR REUSED.
IC95989 CRASH IN HASHFULLNAME DUE TO CONTINUED USE OF MEMORY WHICH MAY HAVE BEEN FREED OR REUSED.
IC96230 DEADLOCK ON NSF.0LOCK MUTEX POSSIBLE WHEN USING STREAM PIPES
IP23572 CONNECTION MANAGER DOES NOT SUPPORT MULTIPLE LISTENER THREADS ON A SINGLE DBSERVERNAME OR DBSERVERALIASES PORT

xC7W2 APARs
Description
IC69419 FRACTION OF SECOND IN GL_DATETIME %F DID NOT DISPLAY AS EXPECTED
IC87342 WARNING! AVOID_EXECUTE HAS BEEN SET SHOULD BE PRINTED WHEN AVOID_EXECUTE IS ON AND QUERY IS RUN
IC89273 CHAR VALUES WITH MORE THAN ONE ZERO BYTE NOT FOUND BY IS NULL/IS NOT NULL CLAUSES WHEN INDEX PATH IS USED
IC89276 ASSERTION FAILURE POSSIBLE IN RESET_ARCINFO() WHEN BOTH ARCHIVE RESERVED PAGES ARE DAMAGED
IC89549 AUTOMATIC INSTANCE CREATION DURING CUSTOM INSTALLATION CAN FAIL WITH ERROR REFERRING TO SQLHOSTS ISSUE
IC89728 APPLICATIONS MIGHT HIT ERROR -710 ALTHOUGH AUTO_REPREPARE IS ENABLED
IC90449 UPDATE STATEMENT AFTER AN ALTER TABLE CAUSING ASSERTION FAILURE WITH BUFFER MODIFIED IN INCONSISTENT CHUNK
IC90599 SERVER ALLOCATES LOTS OF MEMORY WHEN DROPPING DATABASE WITH TABLES HAVING COLLECTION DATA TYPES DEFINED
IC90792 DIFFERENCE IN BEHAVIOUR BETWEEN PLATFORMS REGARDING EXPIRED/LOCKED PASSWORD VALIDATION
IC90887 HOSTNAME FIELD FROM SYSSESSIONS WHEN QUERIED IN SYSDBOPEN() THROUGH DRDA IS INCORRECTLY RETURNED
IC90901 PID FIELD FROM ONAUDIT OUTPUT WAS RETURNING 0 OR -1 ON CERTAIN PLATFORMS THROUGH JDBC CONNECTION AND IS NOW RANDOM
IC90943 MEMORY LEAK IN GLOBAL POOL OF TYPE RDAHEAD (OR MID_RA) WHEN USING AUTO_READAHEAD
IC90981 GENONCFG CAN FAIL WITH INAPPLICABLE ERRORS OR GENERATE UNUSABLE ONCONFIG
IC90982 ONSTAT -G HIS SHOWS WRONG LOG SPACE VALUE
IC91121 768: INTERNAL ERROR IN ROUTINE OPJOIN() WITH MULTIPLE JOINS
IC91338 SELECT COUNT(*) CAN LEAD TO AF IN LDDBLNULL WHEN USING NESTED SUBQUERIES AND AN INDEXED DATE COLUMN
IC91342 SQL ERROR -272 WHEN CREATING A DATA MART
IC91389 RENAMED RESTORE FORCES NEW CHUNK PAGE SIZE TO BE MULTIPLE OF DBSPACE PAGE SIZE WHEREAS CHUNK ADDITION DOES NOT
IC91412 SERVER CAN CRASH WHEN EXECUTING SELECT FROM SYSSQEXPLAIN
IC91601 CDR CHECK CAN HANG IN FUNCTION GETPKCOLS()
IC91605 QUERY WILL HANG WHEN USING SYSMASTER TABLE SYSLCKTAB WITH FILTER ON INDX COLUMN GREATER THAN OR EQUAL TO SIZE OF LOCK TABLE
IC91606 IF SETORIGIN MODIFIES ORIGIN AND NEW ITEMS ARE INSERTED PRIOR TO ORIGINAL ORIGIN, SELECT FROM VTI TABLE RETURNS NO ROWS FOUND
IC91961 DBSCHEMA AND DBEXPORT RETURNS A WARNING MESSAGE WHEN TABLE NAME, PROCEDURE NAME OR COLUMN NAME HAS MULTI BYTE CHARACTER A TO Z
IC92005 CONTINUAL MEMORY LEAK IN CONNECTION MANAGER WHEN A SERVER PORT IS INACESSIBLE
IC92019 VIEW WITH JOIN ON SMI TABLES AND AGGREGATE COLUMNS RESULTS IN MEMORY CORRUPTION THAT LEADS TO DIFFERENT ASSERT FAILURES
IC92087 PREPARED STATEMENT CAN CAUSE A CRASH IN SQRETTYPE() IF RUN AGAINST A RE-CREATED TABLE WITH LVARCHAR COLUMN
IC92116 READAHEAD THREAD CAUSES HDR SECONDARY TO ABORT USING TEMP TABLES WITH BLOBS
IC92117 QUERY CAN ASSERT IN SQOPTIM() IF SYSINDICES ENTRY HAS NULL VALUE IN CLUST COLUMN
IC92213 VALUES IN THE SYSMASTER:SYSRSTCB.IOWAITTIME COLUMN CAN BE INCORRECT
IC92503 POPULATING FOT INDEX MAY END UP WITH ASSERT FAILURE IN PTMAP IF THE TABLE WAS TRUNCATED BEFORE THE DATA LOADING

xC7W1 APARs
Description
IC78379 [WINDOWS] USER INFORMIX AND GROUP INFORMIX-ADMIN EXIST AFTER CUSTOM INSTALL SPECIFYING LOCAL SYSTEM ACCOUNT
IC81331 MESSAGE ASSERT WARNING: LOGPUTX(EXTEND_CHUNK) - RSBEGIN() NEVER CALLED SEEN WHEN EXTENDING PHYSICAL LOG CHUNK SIZE
IC81894 ONMONITOR PRODUCES 25582 ERROR ON EXIT
IC83706 CONFUSING NUMBERS IN COLUMN QUEUE IN CDR LIST SERV OUTPUT
IC83955 THREADS STARTED WITH FORK_BE_SESSION END UP WITH RSTCB->TID THAT DOES NOT MATCH TCB->THREAD_ID SO THREAD ID OUTPUT IN ONSTATS DO
IC83985 FUNCTIONALITY AND DESCRIPTION OF SYSTEM VALUES IN IFXDEPLOY.CONF FILE IS UNCLEAR
IC85085 RUNNING UPDATE STATISTICS ON A TABLE WITH FRAGMENT LEVEL STATS RETURNS AN INCORRECT MESSAGE RELATED TO SBSPACENAME
IC85171 SYSADMIN:ALERTCLEANUP FUNCTION MUST BE RECREATED DURING MIGRATION/CONVERSION
IC85487 CDR_SERIAL DOES NOT WORK PROPERLY IF YOU ADD A BIG NUMBER BEFORE
IC85636 ONCHECK CANNOT BFGET BUFFER FOR PARTNUM BECAUSE OF NEGATIVE PAGENUM
IC85882 ONSTAT -G DBG CAN STOP WITH CHANGING DATA STRUCTURE FORCED COMMAND TERMINATION.
IC85883 ASSERTION FAILURE IN UNCOMPRESS_ROW() MISSES TO GIVE PRECISE REASON FOR WHY IT HAPPENED
IC85935 MESSAGE FAILPOINT: 14100 IN LOAD JOB LOG FILE WHEN LOADING FROM EMPTY FILE AND TABLE CONTAINS LVARCHAR
IC86023 IDS FAILS IN MT_AIO_WAIT() WITH CIO AND MULTIPLE CHUNKS IN A SINGLE COOKED FILE
IC86077 LINUX: WHEN USING HUGE MEMORY AND RESIDENT SET TO -1, SERVER IS UNABLE TO ADD V SEGMENTS AFTER THE INITIAL V ALLOCATIONS
IC86189 REMOTE SUB-QUERY HAS INCORRECT QUERY PATH WITH VERY LOW PERFORMANCE
IC86329 A STORED PROCEDURE IN SOME CASES INSTEAD OF RETURNING ONLY -9791, CAN ASSERT FAIL OR EVEN CRASH
IC86365 RESTORING AN INSTANCE WHEN USERMAPPING IS ON WILL MAKE ENGINE CRASH
IC86369 ONSTAT -G IDXSCAN DOES NOT WORK ANYMORE AND THEREFORE ONSTAT USAGE SHOULD NOT MENTION IT
IC86442 ERROR 768 IN OPEXPRRG WHEN THERE IS AN INDEX ON NCHAR COLUMN AND THERE ARE DIFFERENT LOCALES.
IC86443 SELECT WITH WHERE CLAUSE CONTAINING MATCHES CONDITION WITH MULTIPLE WILDCARDS RETURNS WRONG RESULTS WITH CUSTOMIZED LOCALE
IC86445 A QUERY CALLED FROM JAVA UDR MAY RETURN CORRUPTED VALUES DEPENDING ON PREDICATE ORDER
IC86490 SUPPLIED KRAKATOA HAS OUTDATED TZ INFO
IC86493 MISLEADING ERROR MESSAGE, UNEXPECTED RSS AUTHENTICATION FAILURE WHEN HA_ALIAS IS NOT SET
IC86500 HDR SECONDARY DOES NOT PING TIMEOUT AFTER PRIMARY LOSES CONNECTION AND TRIES TO RECONNECT TO SECONDARY
IC86784 AN ASSERT FAILURE IN INIT_TERM_PER_VALUE IS POSSIBLE WHEN MULTI INDEX SCAN IS USED
IC86822 OPTIMIZER PREFERS INDEX PATH OVER SKIP SCAN WHICH RESULTS IN LONGER EXECUTION TIME
IC86848 IDS CRASHES ON ROLLBACK OF LONG TRANSACTIONS
IC86933 IPCSTRPOLL THREAD CAN ASSERT FAIL ON RARE OCCASIONS WHEN THERE ARE MULTIPLE IPCSTR OR SOCTCP/TLITCP POLL THREADS
IC86951 USAGE OF MENU DRIVEN TABLE MODIFICATION CHANGED BETWEEN 11.50 AND 11.70 AND HAS PROBLEMS
IC86952 POSSIBILITY OF ERKEY (IFX_ERKEY_2 COLUMN) CORRUPTION
IC86993 CDR CHECK REPLICATESET IFX_INTERNAL_SET RETURNS SQL FAILURE 195 WHEN THERE IS NETWORK DELAY BETWEEN SOURCE AND TARGET
IC87024 ASSERT FAILURE OR CRASH WITH LEFT JOIN SQL WHEN TABLES HAVE MANY INDEXES
IC87060 DBSCHEMA REPORTS WRONG SIZE OF EXTENT AND NEXT SIZE WHEN INDEX IS CREATED WITH EXTENT SIZE OPTION
IC87066 CDR THREADS NAMES ARE NOT CLEANED UP FROM SYSMASTER:SYSTHREADS TABLES EVEN THOUGH THREADS ARE NO LONGER PRESENT ON THE SERVER.
IC87067 SETTING UP A REPLICATE BETWEEN IDS 10.00 AND 11.70 CAN FAIL WITH DIFFERENT SYMPTOMS
IC87069 MORE MEMORY CONSUMED THAN CONFIGURED WHEN HIGH AMOUNT OF BUFFERS AND VIRTSIZE
IC87248 EXECUTING ONMODE -L WHILE RUNNING ONTAPE -A CAUSES CORRUPTED LOGICAL LOG FILE
IC87250 WRONG RESULTS FOR SQL WITH MULTIPLE COUNT(DISTINCT) POSSIBLE WHEN QUERY RUNS WITH PDQ AND MANY CPU VPS CONFIGURED
IC87251 RUNNING A SIMPLE QUERY THAT PERFORMS A HASH JOIN WITH PDQ ENABLED TAKES LONGER IN 11.70 THAN 11.50
IC87252 SQL -604 AND ISAM -164 ON DELETE FROM TABLE WITH LIST FIELD
IC87257 CDR DEFINE SERVER RETURNS ERROR 123 DURING INTERNAL REPLICATE DEFINE FOR GLOBAL CATALOG SYNC IN A MULTI NODE CLUSTER
IC87310 INDEX ON CDR_DELTAB_* IS CREATED WITH EXTENT AND NEXT SIZE WHEN BASE TABLE HAS AN INDEX (PRIMARY KEY) DEFINED WITH EXTENT AND NE
IC87311 SERVER CAN CRASH IN LDDBLNULL() INSTEAD OF REPORTING ERROR 321 OR 595 IF AN AGGREGATED COLUMN IS USED IN A JOIN WITH GROUP BY
IC87341 IFXCLONE FAILS WITH ERROR SMX FAILED TO CREATE PIPES FOR CLONE RESTORE ON SOLARIS WHEN PROTOCOL/INTERFACE IS SET TO TLITCP
IC87375 BTSCANNER THREAD CAN ASSERT FAIL WHEN BUFFER MODIFIED IN INCONSISTENT CHUNK WHEN CLEANING EN_US.UTF8 NVARCHAR INDEX
IC87399 CDR CHECK REPL --TIMESTAMP WITH REPLCHECK DEFINED SELECTS ALL THE COLUMNS MOST OF TIME THAN INDEX DEFINED ON IFX_REPLCHECK
IC87444 INFORMIX USER/GROUP CREATION ERROR DURING INSTALLATION WITH ROLE SEPARATION
IC87489 SYSCDR:REPLCHECK_STAT.REPLCHECK_STATUS IS NOT SHOWING THE CORRECT STATUS FOR REPLICATES THAT FAILED REPAIR
IC87490 ASSERT FAILURE DUE TO MEMORY CORRUPTION DOES NOT PROPERLY SET RESULTS: STRING IN ASSERT FAILURE MESSAGE
IC87587 WITH BATCHEDREAD_INDEX ENABLED, A QUERY THAT FILTERS ON A DECIMAL INDEX WILL RETURN NO ROWS
IC87589 SERVER CAN ABEND WHEN DOING SELECTS FROM SYSCDRSEND_BUF WHILE PUTTING LOTS OF LOAD ON THIS TABLE
IC87644 COMPLEX QUERY WITH A NESTED VIRTUAL TABLE CAUSES A CRASH
IC87681 SERVER TERMINATES UNEXPECTEDLY WHEN EXECUTING A QUERY WITH SUBQUERY AND STATEMENT CACHE IS ON
IC87682 IFXCLONE ON LINUX FAILS WITH ERROR WARNING: MT_AIO_WAIT: ERRNO == EINVAL USING RAW DEVICES. IT WORKS FINE WITH COOKED FILES.
IC87771 DROP SPECIFIC FUNCTION IF EXISTS SPECIFIC_NAME; FAILS WITH 201: SYNTAX ERROR
IC87814 BTS OUT OF MEMORY ERROR POSSIBLE AND CAUSING A MEMORY CORRUPTION WHEN OCCURRING
IC88153 THE EXAMPLE GIVEN TO CREATE A COMPOSITE BTS INDEX SHOWS THE INCORRECT KEYWORD DEFAULT_QUERY_FIELD
IC88170 AUTO_CRSD() SHRINK THRESHOLD DOES NOT CONSIDER EMPTY TABLES
IC88171 EMPTY LIST TYPE COLLECTION IN EXPLICIT CASTING CAUSES ASSERT FAILED
IC88172 ALTER TABLE MODIFY DOES NOT MODIFY THE COLUMN WHEN THERE ARE FRAGMENT LEVEL STATISTICS FOR THIS COLUMN
IC88201 AFTER ALL THE MEMBERS IN CLUSTER HAVE BEEN RESTARTED EXCEPT CM, ONSTAT -G CMSM DOES NOT DISPLAY A STATUS OF FAILOVER ARBITRATOR
IC88202 CM DOES NOT IDENTIFY THE TYPE OF SECONDARY INSTANCE IF THE INSTANCE WAS BROUGHT UP BEFORE THE PRIMARY
IC88203 CONNECTION MANAGER DOES NOT NOTICE THAT RSS IS BACK ONLINE IF IT WAS RESTARTED TWO TIMES IN A ROW
IC88219 FAST RECOVERY CAN FAIL WITH TRANSACTION STILL OPEN BECAUSE OF COMITTED TRANSACTION IN CHECKPOINT RECORD
IC88260 PROBLEM WITH DBACCESS AND ALTER TABLES HANDLING
IC88265 TIMESTAMP BASED REPAIR (CDR CHECK REPLSET --TIMESTAMP --REPAIR), REPAIRS DATA INCORRECTLY
IC88289 DBIMPORT FAILS WITH -201 SYNTAX ERROR FOR DATABASES WITH UTF8 AND SQL_LOGICAL_CHAR AND DATABLADES REGISTERED
IC88393 FUNCTION NEXT_PAGE_CALLBACK() MAKES A CALL TO MACRO DREQUIRE WITH THE REQUEST TO EV_AFCRASH, BUT END MACRO REGARDLESS CALLS AFWARN_INTERFACE()
IC88543 ASSERTION FAILURE POSSIBLE IN SETCDRALTMODE() WHEN UNIQUE CONSTRAINT IS DROPPED ON A REPLICATED TABLE WHILE ER IS STOPPED
IC88586 ONPLOAD THROWS ASSERT FAILURE ON WINDOWS-7 64-BIT
IC88590 MESSAGES: ERROR IFKNOWNCREATE() LOOKUP FAILED, NAME IS EMPTY IN THE ONLINE LOG FILE.
IC88699 RUNNING A CORRELATED NESTED QUERY GENERATES AF WITH MEMORY BLOCK HEADER CORRUPTION DETECTED IN MT_SHM_MALLOC_SEGID 6
IC88746 INSERT ON UPDATABLE RSS WITH XA TRANSACTION ALLOWS DUPLICATES IN COLUMN WITH A PRIMARY KEY OR A UNIQUE CONSTRAINT
IC88810 DBIMPORT DOES NOT DETECT INVALID SYNTAX IN CREATE PROCEDURE STATEMENT LEADING TO UNEXPECTED INCOMPLETE DATABASE IMPORT
IC88812 DBSCHEMA STORAGE SPACE STATEMENT OUTPUT ORDER CAN BE WRONG
IC88911 IF VIEW BASED ON REMOTE TABLE IS QUERIED WITH REVOKED SELECT PRIVILEGE THEN THE QUERY TO VIEW WILL ALWAYS BE GIVING ERROR -583
IC88916 ON VERY LARGE SYSTEMS (MANY SESSIONS, MANY CPU VPS) WITH LOTS OF TEMP TABLES, THERE MAY BE A BOTTLENECK ON THE RSAM POOL
IC88998 AUTO READAHEAD IS NOT PERFORMING INDEX-DATA READ AHEAD WITH OLD-STYLE ATTACHED INDEXES WHICH CAN LEAD TO A PERFORMANCE PROBLEM
IC88999 ASSERT FAILURE WHEN EXECUTE FUNCTION ADMIN (CREATE GLFILES) IS RUN
IC89002 PRIMARY OR SOURCE SERVER CAN ASSERT FAIL WHILE DECRYPTING DATA USING IBM GLOBAL SECURITY KIT (GSKIT)
IC89003 A INSTANCE CREATED WITH THE IFXCLONE UTILITY CAN FAIL TO START WITH THE ERROR DUPLICATE VPCLASS
IC89007 SELECT STATEMENT USING A VIEW RETURNS -640 WHEN EXECUTED FROM NESTED PROCEDURES
IC89041 SELECT WITH UPPER AND LIKE RETURNS NO RESULTS IN IDS 11.70 WITH DB_LOCALE=DE_DE
IC89125 QUERY USING SEQUENTIAL SCAN ON A TABLE WITH VARCHAR GIVES TRUNCATED STRING BUT USING INDEX GIVES CORRECT STRING
IC89127 POOR QUERY PLAN WITH FILTERS ON NON-INDEXED CHAR(1) FIELDS
IC89282 LOGICAL RECOVERY ROLLFORWARD ERRORS ON SDS NODES WHEN PRIMARY NODE IS PERFORMING LRU (FOREGROUND POSSIBLY) WRITES
IC89299 DROPPARTMART CAN FAIL WITH ASSERTION ACTIVEROWS == EXPECTEDROWS FAILED
IC89302 UPGRADING TO 11.70.XC7 USING ONINIT -VW DOES NOT RETURN TO COMMAND PROMPT
IC89310 ASSERT FAIL, CRASH OR SESSION HANG POSSIBLE FOLLOWING LONG TRANSACTION ROLLBACK INVOLVING REMOTE SERVER
IC89314 SANITY CHECKS IN SQ_HOLD COULD HELP RETURN 408 ERROR RATHER THAN ASSERT FAIL AND ENGINE CRASH
IC89317 ONLOG STOPS TO READ PAGES FROM A LOGICAL LOG ON TAPE AFTER 8192 PAGES
IC89426 HANDLING OF DATA TYPES BASED ON A DECIMAL REPRESENTATION WITH INVALID DATA MAY RESULT IN MEMORY CORRUPTION
IC89427 CDR LIST SERVER -C HANGS WHEN CONNECTING TO A REMOTE INSTANCE RUNNING AN OLDER VERSION
IC89465 TRUSTED CONTEXT CANNOT BE RE-CREATED IF DATABASE HAS NON-DEFAULT LOCALE
IC89479 COUNT (*) VS ACTUAL SELECT * RETURNS DIFFERENT RESULTS
IC89497 ONMODE -X S (TO DUMP A STACK TRACE) CAN CRASH SERVER WHEN RUN AGAINST NAMED VP CLASS WHERE IDLE_THREAD IS RUNNING
IC89547 ERROR : TRUSTED HOST FILE (/ETC/HOSTS.EQUIV) CACHE MARKED INVALID IN ONLINE.LOG
IC89576 A NESTED CURSOR USING HASH JOIN OF 2 FRAGMENTED TABLES CAN RETURN BAD RESULTS IF PDQ IS ON
IC89585 RUNNING CONCDR.SH SCRIPT AFTER MIGRATION CAN LEAD TO MISSING VIEWS IN SYSCDR, THUS PREVENTING CDR DEFINE TEMPLATE
IC89597 USING LITERAL CURRENT IN INSERT VIA SYNONYM INTO A REMOTE TABLE CAN GARBLE COLUMN VALUES
IC89618 DBSCHEDULER AND WORKER THREADS FAIL TO START WHEN SYSADMIN IS MOVED TO ITS OWN DBSPACE USING TASK(RESET SYSADMIN) FUNCTION
IC89645 TURNING ON THE AUDITING LEVEL 1 ADDS AN UNNECESSARY DELAY TO ONSTAT AND ONMODE COMMANDS
IC89646 EXCESSIVE MEMORY USE AND CRASH POSSIBLE WHEN USING TIMESERIES PUTSET FUNCTION
IC89648 ASSERT WARNING: ATTEMPT TO WAKE A NON-EXISTENT THREAD EVERY TIME WHEN A LISTENER THREAD FAILS TO START
IC89650 PERFORMANCE ISSUE WITH A CORRELATED SUBQUERY THAT USES A COMPLEX VIEW USED IN A NOT EXISTS CLAUSE
IC89663 ASSERTION FAILURE IN RDATAVALVCHAR -- QUERY INVOLVES A LARGE NUMBER OF TABLES WITH NESTED LOOP AND HASH JOINS
IC89665 RSS NODE CAN FAIL TO RECONNECT
IC89790 HAVING COUNT(*) = 0 RETURNS ROW WHEN IT SHOULD RETURN NO ROWS
IC89810 EXTENDABLE CHUNKS FEATURE IS NOT WORKING WHEN ER TRIES TO CREATE SHADOW(DELTAB) TABLES
IC89849 ONINIT -W HANGS AND NEVER RETURNS IF AN ONMODE -KY IS ISSUED WHILE ENGINE IS STILL INITALIZING.
IC89875 BTS DATABLADE RETURNS 0 ROWS
IC89892 SELECT FROM VIEW RETURNS ERROR 366
IC89898 BOTTLENECK ON EXTENDED TYPE NAME CACHE WHEN MULTIPLE SESSIONS DISCONNECT AT ONCE
IC89921 EXCESSIVE WAITS ON PLOGPL IMPACTS THE PERFORMANCE OF A CHECKPOINT
IC89941 DBINFO(GET_TZ) RETURNS A WRONG RESULT WHEN STMT_CACHE IS SET
IC89943 CALCULATION OF SIZE OF A CRITICAL FILE FOR ONBAR BACKUP IS WRONG
IC89946 READAHEAD: THREAD EXITED WITH BUFFERS HELD
IC90186 CRASH OF ONCMSM IN SQLI_CURS_CLOSE_TCB(), POSSIBLY DUE TO CM REPEATEDLY SWITCHING PRIMARY TO HDR THEN BACK TO PRIMARY.
IC90212 USING THE LOWER() FUNCTION WITH GL_GLU TAKES EXCESSIVE TIME
IC90284 QUERY RETURNS 874 AND AF IS GENERATED BUT ENGINE DOES NOT CRASH
IC90312 AUTO_CRSD TASK SHOULD NOT RUN AGAINST TABLES IN THE FOLLOWING SYSTEM DATABASES (SYSMASTER, SYSUTILS, SYSUSER, SYSCDR AND SO ON)
IC90345 CDR_MONITOR THREAD CAUSES MEMORY LEAK
IC90447 ONSTAT -G CMSM SHOWS THAT CONNECTION MANAGER INCORRECTLY CONSIDERS THE PRIMARY TO BE DOWN
IC90493 SETTING NON-EXISTENT SQLIDEBUG ON WINDOWS CRASHES ONMODE/ONSTAT AND MAY PROVOKE ENGINE TO ASSERT FAIL
IC90494 RE-USING PREPARED STATEMENTS INCLUDING MULTISETS CAN RESULT IN MEMORY CORRUPTION
IC90497 USING DBACCESS TO ALTER A COLUMN NAME WILL FAIL WITH -201 AND THEN WILL DROP THE TABLE
IC90597 SCHEDULER DOES NOT START AUTOMATICALLY WHEN CONVERSION IS COMPLETED AND IT CANNOT BE STARTED MANUALLY. INSTANCE HAS TO BE RESTARTED
IC90609 ABORTING A PLOAD JOB WITH A PREMATURELY EXITED PL_MASTER ABORTS THE SERVER IN PJT_POST_GLOBALERROR
IC90643 ERROR -999 POSSIBLE WHEN DOING A SELECT FROM VIEW
IC90645 CONTENTION ON SHARED MEMORY MUTEX SH_LOCK POSSIBLE WHEN MANY SESSIONS DISCONNECT SIMULTANEOUSLY AND VP PRIVATE CACHE IS FULL
IC90694 READAHEAD MEMORY POOL CAN GROW AND CAN EVENTUALLY LEAD TO OUT OF BOUNDS MEMORY CONSUMPTION
IC90730 DEADLOCK BETWEEN CDRACCEPT THREAD AND GCREQ THREAD INVOLVING THE PERMNIFG MUTEX AND CDR_GC CONDITION
IC90827 DBEXPORT ON UPDATABLE RSS COULD READ UNCOMMITTED DATA EVEN USELASTCOMMITTED SET TO ALL
IC90862 ONSTAT -Z ON RSS DURING FAST RECOVERY PHASE LEADS TO ENGINE CRASH
IC90943 MEMORY LEAK IN GLOBAL POOL OF TYPE RDAHEAD (OR MID_RA) WHEN USING AUTO_READAHEAD
IC90959 HIGH CPU UTILIZATION AND CONTENTION ON SYSDBPROC CACHE SEEN DURING LARGE-SCALE SESSION CONNECT OR DISCONNECT
IC90980 OAT SHOWS NEGATIVE VALUES FOR NUMBER OF TABLES NEEDING STATISTICS REFRESH AFTER REFRESH IS COMPLETED
IC91340 THE GREATEST AND LEAST BUILT-IN FUNCTIONS CAUSE INSTANCE TO CRASH


Fixpack 11.70.xC7 addresses the following Security Alert: CVE-2012-4857
xC6/xC7 APARs
Description
IC77771 INFORMATION ABOUT MAX. CONCURRENT SESSIONS IN SYSSHMVALS:SH_OVLMAXCONS AND SYSLICENSEINFO:MAX_CONNS IS NOT CONSISTENT
IC78544 ONSTAT -G NTU / NTT DO NOT REPORT CORRECT INFORMATION FOR DBSCHEDULER THREADS
IC79310 CREATING AN INDEX ON A FRAGMENTED TEMP TABLE THROWS -212/-113 AS DOES CREATING A FRAGMENTED INDEX ON A TEMP TABLE
IC79807 VIEW FOR REMOTE TABLE IS NOT WORKING PROPERLY WHEN THE REMOTE TABLE IS RECREATED/ALTERED
IC80634 DB_LOCALE MAY BE SET INCORRECTLY IN INIT_SQSCB FOR THE SESSION WITH MULTIPLE REMOTE QUERIES
IC80652 THE PRINT FILE INFO ARGUMENT WITH THE TASK() FUNCTION DOES NOT WORK.
IC81901 FAILING TO CREATE AN RPM IMAGE DUE TO MISSING UNINSTALL.LOG
IC81902 WARNING USER DOES NOT EXIST - USING ROOT WHEN INSTALLING RPM PACKAGE
IC81903 WHEN BUILDING RPM PACKAGE THE DEFAULT PATH /OPT/IBM/INFORMIX IS USED EVEN IF DIFFERENT PATH IS SPECIFIED
IC82084 SELECT FROM SYSENVSES CAN LEAD TO AN ASSERTION FAILURE IN PRENVSESVAR
IC82171 INSTANCE ABORT POSSIBLE WHEN INDEX KEY DESCRIPTOR ON PARTITION PAGE IS CORRUPTED
IC82240 DBSPACE IS FULL ALARM EVENT 44 IS NOT FIRED WHEN ERROR 264/131 RETURNED TO THE SESSION
IC82597 REVERSION INDICATED AS SUCCESSFUL BUT NOT ALL DATABASES WERE REVERTED
IC82645 SKIP SCAN CAN BADLY SUFFER FROM LIGHT SCANS
IC82658 UNABLE TO GET LOCALIZED ERROR MESSAGES FROM A DRDA CLIENT
IC82659 ENGINE DROPS ASSERT WARNING: NET_SEND_LOCAL_ON FOUND NON-NULLSCB->PLSCB ON TASK() CALL
IC82685 SERVER COULD ASSERT FAIL WHEN QUERIES INVOLVING SYSCONBLOCK LOOK AT CONBLOCKS FOR STATEMENTS USING CONNECT BY SYNTAX
IC82784 QUERY WITH CORRELATED SUBQUERY USING BOTH IS NULL AND IS NOT NULL ORED CONDITIONS FOR THE SAME COLUMN CAN BE VERY SLOW
IC82786 HIERARCHICAL QUERY ACCEPTS DATA WITH MULTIPLE ROOT NODES
IC82990 FUNCTIONAL INDEX SCAN OF REMOTE TABLE MIGHT NOT WORK CORRECTLY IN A CROSS-DATABASE QUERY
IC82992 DRDA: SERVER MIGHT TERMINATE WHEN A STORED PROCEDURE WHICH IS EXECUTED IN A TRANSACTION FAILS WITH ERROR -535
IC83016 STARTUP OF DWA FAILS WITH ASSERTION STR.TELLG > 0 FAILED WHEN SEND_QUEUE_SIZE IS NOT EXPLICITLY SPECIFIED IN THE NODE CONFIG
IC83018 CDRSCN_ THREAD COULD ASSERT FAIL IF A CDR STOP REPL COMMAND IS USED TO STOP THE REPLICATE WHILE THE CDR SYNC REPLICATE IS RUN
IC83074 ONSTAT -G IOA GENERATES OUTPUT WHICH INCLUDES -G IOF OUTPUT BUT DOCUMENTATION DOES NOT DESCRIBE IT CORRECTLY
IC83075 -768 SQL ERROR: INTERNAL ERROR IN ROUTINE READRIDS(): SC_NONSEQ MODE NOT SUPPORTED.
IC83182 DBACCESS: SCREEN MENU IN ALTER TABLE OPTION DOES NOT SHOW ADDITIONAL PAGES FOR TABLE WITH HIGH NUMBERS OF COLUMNS
IC83253 FOR A SELECT INVOLVING A FILTER WITH SUBQUERY A MORE EXPENSIVE QUERY PLAN MIGHT BE CHOSEN WHEN DISTRIBUTIONS EXIST
IC83254 POSSIBLE SQLEXEC THREAD ASSERT FAILS IN SEQ_PUTROW WITH BATCHREAD_TABLE ENABLED
IC83255 CRASH SEGV IN FUNCTION RA_PAGE_ALREADY_READ ON READAHEAD (READ AHEAD) THREAD WHEN MEMORY IS LOW
IC83257 NO ERROR IS DETECTED IF THE ONCONFIG PARAMETER SBSPACENAME IS SET WHICH SHOULD BE UNIQUE TO MULTIPLE SPACES
IC83332 SQL ERROR 240 ISAM ERROR 103 WHEN TRYING TO DELETE FROM A TABLE WITH A FIX OF ATTACHED AND DETACHED INDEXES AND DELETE USES KEY
IC83388 LONG TRANSACTION ROLLBACK HANG POSSIBLE WHEN USING REMOTE DATABASE QUERIES IF REMOTE CONNECTION ATTEMPT HANGS
IC83390 ONMODE -P -1 JVP CRASHES THE DATABASE SERVER
IC83410 CM PRINTS A WARNING MESSAGE WHICH REFERENCES CLUSTER NAME AND INFORMIX ALIAS IN WRONG ORDER
IC83411 CREATE PROCEDURE STATEMENT ABEND IDS SERVER IN OP_JOIN().
IC83412 CONCAT() FUNCTION DOES NOT WORK CORRECTLY FOR AN LVARCHAR TYPE WHICH IS CASTED FROM AN HTML TYPE
IC83539 ONRESTOREPT REPORTS ERROR FAILED TO PROCESS THE RESERVE PAGES IF $ONCONFIG IS NOT SET IN ENV.
IC83541 UPDATE STATISTICS FOR PROCEDURE AFTER MIGRATION SHOULD NOT RETURN -721 BUT -26060
IC83542 CDC ERROR -83800 CAUSED BY LOG PAGE READER READING A POSITION IS CLOSE TO THE WRITE POSITION
IC83702 NCHAR/NVARCHAR COLLATION WRONG WITH ESTONIAN LOCALE (ET_EE.UTF8)
IC83704 DDL_LOGPROCESS_ROUTINECACHE() MESSAGE IF YOU RECREATE A STORED PROCEDURE ON AN UPDATABLE RSS SECONDARY
IC83756 SQL SYNTAX MANUAL DOES NOT CLARIFY TIME DEFINITION IN SQL EXPLAIN.OUT
IC83757 EXECUTING A REMOTE PROCEDURE DOES NOT WORK VIA DRDA
IC83759 DBEXPORT AND DBSCHEMA GENERATE WRONG SYNTAX FOR FUNCTIONAL INDEX WITH DESC OPTION
IC83760 INTERMITTENT PERFORMANCE PROBLEM USING RSAM BATCH SEQUENTIAL SCANS DUE TO EXCESSIVE LOCK CHECKING ACTIVITY
IC83764 SMI TABLE SYSPTNTAB IS CAPABLE TO DISPLAY ONLY VALUES IN INTEGER RANGE INSTEAD OF BIGINT RANGE
IC83765 ASSERT FAILED: SLOT ALLOCATION ERROR IN ONLINE.LOG; AF FILE SHOWS ALLOCSLOT: ATTEMPTING TO ALLOCATE SLOT ON OLD (0) VERSION PAGE
IC83768 IWA: IF A SESSION STARTS SEVERAL QUERIES WITH MULTIPLE OPEN CURSORS THE SECOND QUERY GETS AN ERROR AND WILL NOT BE ACCELERATED
IC83770 CM - FAILOVER MIGHT NOT WORK PROPERLY IF THERE ARE MORE CMS CONNECTED TO MACH11 CLUSTER AND ONE OF THEM HAS FOC SET TO DISABLED
IC83780 EXECUTING STORED PROCEDURES WHILE UPDATING STATISTICS ON THE PROCEDURES FAILS WITH LOCKING ERRORS 211/144 312 211/107
IC83882 START MENU ENTRY FOR 32-BIT AND 64-BIT VERSION OF CSDK AND ICONNECT SHOULD BE DIFFERENT
IC83885 WHEN DBACCESS LOAD FAILS WITH 847: ERROR IN LOAD FILE, IT CAN GIVE AN INCORRECT LINE NUMBER
IC83886 ERRORS 25572 AND 8 WHEN BRINGING THE SERVER ONLINE USING TLITCP AND AN IP ADDRESS IN THE SQLHOSTS FILE
IC83887 HDR REPLICATION SLOWDOWN DUE TO SYNCHRONOUS CONFIGURATION (DRINTERVAL -1)
IC83921 ONSTAT -U ERRONEOUSLY SHOWS THREADS WAITING ON BUFFERS
IC83922 RA_PAGES DESCRIPTION IS MISLEADING
IC83924 AUTO_READAHEAD DOES NOT WORK AS DESCRIBED IN DOC
IC83930 SELECT * FROM SYSSQEXPLAIN RETURNS SQX_ISCURRENT N WHERE THE VALUE WAS Y ON 11.50
IC83941 EXECUTION OF TASK() FOR DBSPACE CREATION RETURNS WRONG ERROR WHEN DBSPACE_NAME PARAMETER CONTAINS EXTRA SPACE
IC83942 MISSING SPACE DBSPACE_NAME ADDED. MESSAGE IN THE ONLINE.LOG AFTER TASK() FUNCTION EXECUTION FOR DBSPACE CREATION
IC83943 CM MUST LOG SERVER TYPE CHANGE
IC83944 OPTIMIZER CHOOSES SEQUENTIAL SCAN WITH HIGH COST FOR A QUERY AGAINST 11.70.XC5. THIS BEHAVIOR IS DIFFERENT FROM 11.50.XC6 AND 9.40
IC83945 DISCREPANCY IN DESCRIPTION WHERE TEMP TABLES ARE STORED
IC83948 DECRYPT_CHAR() FAILS WITH ERROR 26012: THE INTERNAL BASE64 DECODING FUNCTION FAILED
IC83967 CDC RESTART MAY CAUSE LOSS OF REPLICATED DATA
IC83969 AFTER TRYING TO START CM TWICE AND THEN STOP CM WHERE ARBITRATOR IS ACTIVE, ARBITRATOR IS LOST
IC83984 REMOTE TRUSTED CONNECTIONS HIT AUTHENTICATION BOTTLENECK ON HOSTS.EQUIV
IC84007 SKIP SCAN ACCESS METHOD IS NOT DESCRIBED CLEARLY
IC84028 ENGINE CRASHED IN LDDECIMAL RDATAVALDEC VALLOAD
IC84029 HA_ALIAS DOCUMENTATION DOES NOT SPECIFICALLY SPECIFY CONNECTION MANAGER BEHAVIOR
IC84031 DML COMMANDS MAY REPORT ERRORS -206/-111 FOR AN EXISTING TABLE IN DATABASE WITH NON-DEFAULT LOCALES
IC84053 ASSERT FAILS IN _RLT_UDR_EXEC() WHILE RUNNING UPDATES/INSERTS/DELETES ON TABLES USING SPATIAL BLADE (RTREE INDEX)
IC84065 CM REPORTS ATTEMPT OF CHANGING PRIMARY ON STARTUP BUT THE MESSAGE IS ESSENTIALLY ABOUT ONE PRIMARY INSTANCE
IC84066 CONNECTION MANAGER (CM) TRIES TO REFERENCE IPC ALIAS
IC84069 SQL SYNTAX FOR BETWEEN CONDITION REQUIRES TWO ARGUMENTS ON THE RIGHT IN ASCENDING ORDER
IC84092 MIGRATION FROM IDS 7.31 TO 11.70 MAY FAIL IF A TABLE DOES NOT HAVE SUFFICIENT SPACE IN PARTITION HEADER PAGE
IC84093 BFCHECK: BAD PAGE: BUFFER PAGE HAS WRONG PAGE SIZE ASSERTION POSSIBLE WHEN TRYING TO ALLOCATE NEW CHUNK FREE LIST PAGE
IC84094 SKIP SCAN ACCESS TO A COMPRESSED TABLE CAN RETURN BAD RESULTS, GENERATE (TPOS >= START) ASSERT WARNING OR AN AF IN PTMAP
IC84100 ONSTAT -P STATISTIC LOGREC-RA IS NOT DESCRIBED IN MANUALS
IC84102 SET EXPLAIN CAN YIELD THE SERVER TO ABEND IN OPEXPLAIN
IC84227 RENAME COLUMN OF REPLICATED TABLE CAN LEAD TO ASSERTION FAILURE IN CDRDDLUPDATESYSCDRAFTERRENAME_INT()
IC84229 ASSERTIONS MAY OCCUR WHEN COLLECTION VARIABLES ARE USED AS GLOBAL VARIABLES
IC84367 SPATIAL DATABLADE GETTING ASSERT FAILURE FILE WITH GENPG_BFRELEASE STORED BUFFER NOT FOUND
IC84408 DRDA: SQLCA.SQLERRD2 CONTAINS NUMBER OF ROWS FROM PREVIOUS STATEMENT
IC84415 CDR STOP AND INSTANCE SHUTDOWN CAN HANG IN RESYNCCB_DTOR() CALLED BY RESYNCSHUTDOWN()
IC84421 EXECUTING STORED PROCEDURES WHILE UPDATING STATISTICS ON THE PROCEDURES FAILS WITH ERROR 312 ON SYSPROCPLAN
IC84723 FATAL ASSERTION CRASH (SEGV) IN FUNCTION TABINEXPR WHEN LEFT JOIN USED
IC84727 NO MATCHING RECORD FOUND FOR CURRENT SESSION FROM SYSOPENDB
IC84802 ERROR -696 VARIABLE (G_TASK_ID) HAS UNDEFINED VALUE RUNNING THE SCHEDULER TASK AUTO_CRSD
IC84803 MEMORY BLOCK HEADER CORRUPTION WITH 0X20202020 PATTERN OVER WRITE WITH INSERT TRIGGER ACCESSING VIEW IN ANOTHER DATABASE
IC84804 UPDATE STATISTICS BEHAVIOR IS INCONSISTENT RIGHT AFTER UPGRADE TO 11.70 USING DEFAULT SETTINGS OF AUTO_STAT_MODE AND STATCHANGE
IC84819 CREATING AN SPL CAN HANG IN FUNCTION OPEXPRRG AND MATCH_KEY
IC84822 MIGRATION ISSUE: IT IS ALLOWED TO CONVERT AN INSTANCE WITH MISSING CHUNKS BUT NOT ALLOWED TO REVERT IT BACK
IC84847 WITH BATCHREAD_INDEX USING A PREPARED STATEMENT, IF LOCK ERRORS ARE ENCOUNTERED, IT CAN CAUSE READ_RECORD: DELETED ROWID ASSERTI
IC84849 WINDOWS CSDK UNINSTALL FAILS IF INSTALLED IN A NON DEFAULT DIRECTORY
IC84851 SHMGET: [1]: KEY <...>: OPERATING SYSTEM ERROR WITH HUGE PAGES ENABLED ON LINUX
IC84876 AF CRASH SELECTING FROM A TEMP TABLE WHILE A CONCURRENT SESSION IS SELECTING FROM SYSMASTER SYSTABNAMES, SYSPTNTAB
IC84878 ENGINE CRASHED WITH BF_ONWTLIST: ALREADY BUFFER OWNER DURING DATABASE CREATION IN NEWLY ADDED DBSPACE BY TASK()
IC84892 IT IS NOT DOCUMENTED THAT TABLES WITH NEWLY ADDED EXPRESSION FRAGMENTS CANNOT BE REVERTED
IC84923 A MULTI TABLE JOIN DOES NOT USE THE MOST EFFICIENT PLAN AFTER UPDATE STATISTICS HIGH IS RUN
IC84924 DRDA: SERIAL FIELDS COMING FROM OUTER JOINS AND CONTAINING NO DATA ARE NOT SET TO NULL
IC84926 ONTAPE ARCHIVE WITH TAPEDEV SET TO A REMOTE HOST CAN FAIL REMOTE TAPE DEVICE PROCESS TERMINATED DUE TO SIGNAL 100 ERRNO 10
IC84927 SWITCHING OFF RSS_FLOW_CONTROL DOES NOT TAKE EFFECT IMMEDIATELY
IC84973 ERROR 19995 WHEN ATTEMPTING TO RENAME A COLUMN OF A TABLE WHICH IS INCLUDED IN AN EXCLUSIVE TEMPLATE
IC84974 DRIDXAUTO INDEX REPLICATION NO LONGER WORKING
IC84975 UPDATE STATISTICS HIGH OR MEDIUM RETURNS -768 ERROR IF TABLE WAS CREATED WITH STATLEVEL FRAGMENT
IC84977 UNKNOWN ERROR MESSAGE 52222869 APPEARS WHEN LOADING NUMERIC DATA IN A FORMAT NOT MATCHING THE LOCALE SET AND DBMONEY IS NOT SET
IC85042 EXECUTING A REMOTE PROCEDURE ON 11.70.XC3 OR HIGHER FROM 7.31 RETURNS 674
IC85043 UDR CACHE IN NEED OF URGENT PERFORMANCE IMPROVEMENTS - IN PARTICULAR FOR SPLS WITH GLOBALS
IC85086 SPORADIC HPL FAILPOINT 18006 POSSIBLE DURING TABLE LOAD OPERATIONS
IC85089 SELECT MAX() CHOOSES QUERYPLAN WITH HIGHER ESTIMATED COSTS
IC85111 PARALLEL ADD AND DROP OF DBSPACES OR CHUNKS CAN LEAD TO UNEXPECTED INSTANCE ABORT
IC85112 THE IMPLICIT CAST BETWEEN CHAR AND DECIMAL IN UNION ALL SELECT WITH BINARY OPERATION PLUS 0 RETURNS ERROR -308
IC85122 INFORMIX DRDA DOES NOT SET SQLCA.SQLWARN CORRECTLY FOR NON-ANSI DATABASES
IC85123 CDR START REPL WITH SYNCDATASOURCE IN BACKGROUND MODE CAN SHOW 691 ERROR
IC85148 SEGV IN FMFTOPEN_WITH_CHILD AFTER SKIPPING INDEX
IC85174 ONSTAT OUTPUT CONTAINS UNREADABLE INFORMATION IN TTY AND HOSTNAME COLUMNS
IC85175 ROLLFORWARD ERROR ON RSS AFTER FAILOVER
IC85179 ERROR 9602 ILLEGAL ATTEMPT TO CONVERT A COLLECTION TYPE OCCURS UNDER SPECIFIC CONDITIONS WHEN USING SPL FUNCTION
IC85187 AFTER HDR PING TIMEOUT, PRIMARY CANNOT RECONNECT, ERROR RECEIVED CONNECTION REQUEST FROM REMOTE SERVER WHEN DR ISNT OFF
IC85212 SELECT COUNT(*) WITH ORDER BY CAN LEAD TO AF IN LDDBLNULL WHEN INDEX SKIP SCAN PATH IS CHOSEN BY THE OPTIMIZER
IC85223 DISTRIBUTIONS QUICKLY GROW STALE ON AUS_COMMAND TABLE AND SLOWS AUS_REFRESH TASK
IC85262 AF IN COMP_UDR WHEN EXECUTING A PREPARED SQL STATEMENT THAT CONTAINS DATE DATA TYPE, MANY HOST VARIABLES AND STMT_CACHE SET TO 2
IC85326 ASSERT FAILURE WHEN SELECTING PARAMTYPES FROM SYSPROCEDURES
IC85328 GET A -243 ERROR RUNNING A PDQ QUERY ON AN RTREE
IC85334 NO ERROR MESSAGE IS RETURNED WHEN EXECUTING TRUNCATE TABLE FOR A TEMP TABLE ON AN HDR SECONDARY
IC85364 NO DESCRIPTION ABOUT THE MAXIMUM NUMBER OF OPEN TRANSACTIONS ON LIMITATION LIST
IC85365 ERROR 674/111 FOR UPGRADE_PH_TASK.SQL AT LINE 46 APPEARS IN THE ONLINE.LOG AFTER MIGRATION FROM 11.50 TO 11.70
IC85389 ASSERTION FAILURE ON A SECONDARY SERVER PG_FRPTR 3798 < SIZEOF(IFX_PAGE_T) 24 OR > SLOTBEG 3796 WHEN INSERTING ROWS INTO A TABLE WITH NCHAR COLUMNS USED AS INDEX.
IC85390 SQLEXEC THREADS BOUND FOREVER TO CPU VPS
IC85392 EXECUTE FUNCTION ADMIN(RESET SYSADMIN) ALWAYS CREATES SYSADMIN IN DBSPACE
IC85493 CMSM FAILOVER IS NOT HONORING HA_ALIAS
IC85500 COMPLEX QUERY USING A PLAN WITH A HASH JOIN CHOSEN BY THE OPTIMIZER MUCH SLOWER THAN A PLAN WITH A NESTED LOOP JOIN
IC85511 SERVER ASSERT WHILE DOING ENCRYPTION AND DECRYPTION WITH ENCRYPT_CDR SET TO 1
IC85518 PTMAP ASSERTION FAILURE POSSIBLE WHEN ACCESSING TABLE WITH FOREST OF TREES INDEX FOLLOWING TRUNCATE TABLE OPERATION
IC85521 ASSERT FAILURE MEMORY POINTER FREED TWICE POSSIBLE WHEN EXECUTING MULTI INDEX SCAN
IC85522 CONNECTION MANAGER LEAKS MEMORY WHEN ONE OR MORE OF THE MACH11 NODES ARE NOT ACCESSIBLE
IC85523 BTSCANNER THREADS DO NOT START ON HDR SECONDARY AFTER INSTANCE RESTART
IC85529 SIMPLE DRDA CONNECTION CAUSES AF ON WINDOWS 64-BIT
IC85545 CHUNKNUM AND SEQNUM CAN BE SET TO ZERO DURING SBLOB INSERT WITHIN SBA_LOHEADER_CREATE_WLOCK
IC85546 ONSTAG -G CPU DISPLAYS NEGATIVE VALUES IN SCHEDS COLUMN
IC85549 CONNECTION MANAGER CAN ALLOCATE ALL THE AVAILABLE MEMORY AND EVENTUALLY GET KILLED BY THE OS
IC85583 ONMODE -WF/-WM HA_ALIAS DOES NOT WORK ON HDR SECONDARIES
IC85586 ONMODE_MON THREAD CAN HANG IN DR_MODE() WITH DR_PRSEND THREAD WAITING ON NEXT BUFFER AFTER ONMODE -D STANDARD
IC85634 MIGRATION STOPS WITH AN ASSERT FAILURE AND CRASH ON THE READAHEAD_0 THREAD WITHIN FUNCTION PTHDRGETX()
IC85664 ASSERTION FAILURE POSSIBLE IN OLAPTMP_CALLB
IC85665 ASSERTION FAILURE POSSIBLE IN GET_COLLATION_STRENGTH() DURING MIGRATION WHEN SYSTEM DATABASES ARE CREATED WITH NLS
IC85688 DBEXPORT CONVERTS ALTER TABLE DISABLE INDEX TO INVALID SYNTAX CAUSES DBIMPORT TO FAIL WITH -201 ERROR
IC85690 DOCUMENTED BEHAVIOR OF RESET SYSADMIN WITHOUT SPECIFYING TARGET DBSPACE IS INCORRECT.
IC85693 DBIMPORT FAILS WITH PREPARE SQLOBJ -201 ERROR
IC85755 MIGRATION FROM OLD VERSION CAN FAIL TO START WITH NO ERROR OUTPUT IF MIRROR IS SET TO 1
IC85782 ASSERTION FAILURE POSSIBLE IN SEND_ROW_TO_CONSUMER WHEN QUERY RUNS WITH PDQ
IC85846 ERROR -201 FROM QUERIES RUNNING ON 11.70 AND ACCESSING REMOTE OBJECTS FROM 7.31
IC85913 MEMORY CORRUPTION AF DUE TO ONE-BYTE OVERFLOW WHEN USING DRDA PROTOCOL WITH DBPATH SET
IC85939 HUGE MEMORY CONSUMPTION ON INSERT INTO LIST
IC86113 THE OPTIMIZER CHOOSES A TABLE SCAN OVER AN INDEX SCAN WHEN A FUNCTIONAL INDEX WITH PLACE HOLDER VALUE IS USED
IC86188 EXTRACT THE PRODUCT FILES (-DLEGACY OPTION) PERFORMING A REGULAR INSTALLATION AND REMOVING THE RUNASROOT.* FILE
IC86228 DATA SERVER CLIENT THROWS ERROR SQL30061N SQLSTATE=08004 ON CONNECTION, IF AN INVALID DB_LOCALE IS SET ON CLIENT
IC86235 SERVER MIGHT TERMINATE DURING ROLLBACK OF XA TRANSACTION WITH LOGGED TEMP TABLE
IC86268 REMOTE QUERY FAILS WITH ERRORS -245/-103. ONCHECK -CDI DOES NOT REPORT ANY ERROR
IC86349 SECONDARY SHUTDOWN CAN HANG IF CONNECTION MANAGER IS CONNECTED
IC86368 FOR CONNECTION MANAGER OF VERSION 11.70.XC5/3.70.XC5 IT MAY BE NECESSARY TO SET LOCAL_IP
IC86370 CDR REPAIR ATS/RIS CAN RUN INTO ERROR -958 TEMP TABLE TTEMP ALREADY EXISTS IN SESSION
IC86371 DEFINE A REPLICATE CAN CRASH THE SERVER IF A PARTICIPANT TABLE HAS A PRIMARY KEY THAT CONTAINS USER-DEFINED TYPES (UDT)
IC86389 CREATING A USER FAILS WITH ISAM 103 IF CONNECTING A DATABASE WHICH WAS CREATED WITH NON DEFAULT LOCALE
IC86394 A JOIN ON NCHAR COLUMNS IN DATABASE WITH CS_CZ.8859-2@SIS LOCALE RETURNS NO ROWS EVEN IF IT SHOULD
IC86475 ERROR 19828 WHEN PROJECTION LIST DOES NOT INCLUDE EXPRESSION FROM ORDER BY CLAUSE AND GROUP BY CLAUSE IS PRESENT
IC86705 DOC: ONUNLOAD/ONLOAD DOCUMENTATION NEEDS CLARIFICATION REGARDING SMART-BLOB DATA TYPES
IC86706 DELETE STATEMENT DOES NOT REMOVE ALL OF THE CORRECT ROWS WHEN OPTIMIZER SELECTS MULTI INDEX PATH
IC86730 LOGICAL LOG REPLAY ERROR ON HDR SECONDARY WHEN PRIMARY DATA PAGES NUMBER OF SLOTS GETS OUT OF SYNC WITH SAME PAGE ON SECONDARY
IC86761 AFTER UPGRADE FROM 11.50.FC8 TO 11.70.FC5, EXECUTING A PROCEDURE GIVES ERROR 674: ROUTINE CANNOT BE RESOLVED






[{"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":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"11.7","Edition":"Growth;Ultimate","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
17 June 2018

UID

swg27036092