invispix 10x10

Fix list for Informix Server 11.70.xC5, PID 11.70.xC5W1

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.xC5 and 11.70.xC5W1. This report combines both Windows- and UNIX-specific defect fixes, and is more current than the defect information included in the product release.


W1 APARs
Description
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
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.
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
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-NULL SCB->PLSCB ON TASK() CALL
IC82784 QUERY WITH CORRELATED SUBQUERY USING BOTH IS NULL AND IS NOT NULL ORED CONDITIONS FOR THE SAME COLUMN CAN BE VERY SLOW
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
IC83075 -768 SQL ERROR: INTERNAL ERROR IN ROUTINE READRIDS(): SC_NONSEQ MODE NOT SUPPORTED.
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 (READAHEAD) THREAD WHEN MEMORY IS LOW
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
IC83757 EXECUTING A REMOTE PROCEDURE DOES NOT WORK VIA DRDA
IC83760 INTERMITTENT PERFORMANCE PROBLEM USING RSAM BATCH SEQUENTIAL SCANS DUE TO EXCESSIVE LOCK CHECKING ACTIVITY
IC83765 ASSERT FAILED: SLOT ALLOCATION ERROR IN ONLINE.LOG; AF FILE SHOWS ALLOCSLOT: ATTEMPTING TO ALLOCATE SLOT ON OLD (0) VERSION PAGE
IC83780 EXECUTING STORED PROCEDURES WHILE UPDATING STATISTICS ON THE PROCEDURES FAILS WITH LOCKING ERRORS 211/144 312 211/107
IC83886 ERRORS 25572 AND 8 WHEN BRINGING THE SERVER ONLINE USING TLITCP AND AN IP ADDRESS IN THE SQLHOSTS FILE
IC83921 ONSTAT -U ERRONEOUSLY SHOWS THREADS WAITING ON BUFFERS
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
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
IC84065 CM REPORTS ATTEMPT OF CHANGING PRIMARY ON STARTUP BUT THE MESSAGE IS ESSENTIALLY ABOUT ONE PRIMARY INSTANCE
IC84094 SKIP SCAN ACCESS TO A COMPRESSED TABLE CAN RETURN BAD RESULTS, GENERATE (TPOS >= START) ASSERT WARNING OR AN AF IN PTMAP
IC84229 ASSERTIONS MAY OCCUR WHEN COLLECTION VARIABLES ARE USED AS GLOBAL VARIABLES
IC84408 DRDA: SQLCA.SQLERRD2 CONTAINS NUMBER OF ROWS FROM PREVIOUS STATEMENT
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
IC84804 UPDATE STATISTICS BEHAVIOR IS INCONSISTENT RIGHT AFTER UPGRADE TO 11.70 USING DEFAULT SETTINGS OF AUTO_STAT_MODE AND STATCHANGE
IC84847 WITH BATCHREAD_INDEX USING A PREPARED STATEMENT, IF LOCK ERRORS ARE ENCOUNTERED, IT CAN CAUSE READ_RECORD: DELETED ROWID ASSERTION FAILURES
IC85043 UDR CACHE IN NEED OF URGENT PERFORMANCE IMPROVEMENTS - IN PARTICULAR FOR SPLS WITH GLOBALS
xC5 APARS
Description
IC77892 RSS SECONDARY IS NOT ALWAYS MARKED AS DISCONNECTED ON MACH11 PRIMARY IN CASE OF NETWORK FAILURE
IC78377 IF STATEMENT JOINS MANY DERIVED TABLES, IT CAUSES SQLEXEC THREAD TO LOOP INFINITELY
IC78546 ONCONFIG PARAMETER BATCHEDREAD_KEYONLY IS NOT DOCUMENTED
IC78556 CONVERSION GUARD CORRUPTS OUTPUT FOR ONCHECK -CR & -PR AFTER ONRESTOREPT HAS BEEN RUN
IC78670 HOSTNAME EASILY CHANGED IN AUDIT LOGS
IC78762 FINDERR 460 INDICATES INCORRECT MAXIMUM STATEMENT LENGTH 32K
IC78810 SELECT FIRST/LIMIT INTO EXTERNAL TABLES RETRIEVES INCORRECT NUMBER OF ROWS
IC78847 SERVER CRASH IN MKATTNODE WHEN READING SYNONYM TABLES DATA DICTIONARY INFORMATION USING DIRTY READ WITH CONCURRENT ALTER TABLE
IC78848 CONCURRENT DELETE WITH BATCHEDREAD_INDEX SET ISSUES SPORADIC DEADLOCK ERRORS
IC78881 QUERY RUN AS A USER WHO HAS BEEN GRANTED A ROLE AGAINST UPDATABLE (SDS) GIVES ERROR -272. WORKS FINE ON PRIMARY.
IC78924 ERROR -285 INVALID CURSOR RECEIVED BY SQLEXEC IF SCROLL CURSOR AND REGULAR CURSOR WITH SAME SQL STATEMENT AND STMT_CACHE IS SET
IC78939 UPGRADE TO IDS 11.70.XC3 FAILS WITH SQLCODE = -591 IF DEFINED PROCEDURE HAS REFERENCE TO A TABLE COLUMN WITH A DEFAULT VALUE
IC78963 DESCRIBE OF PREPARED STATEMENT CALLING SPL RETURNS WRONG SIZE FOR SECOND INPUT PARAMETER
IC78965 LARGE QUERY JOINING MANY PERMANENT AND TEMPORARY TABLES TAKES LONGER TO OPTIMIZE ON 11.70.XC3 THAN IT DID ON 11.70.XC2
IC79133 ONSTAT -G AFR DOES NOT SHOW FILE NAME FOR RDAHEAD MEMORY BLOCK
IC79194 DBACCESS DIES WITH A MEMORY FAULT (COREDUMP) MESSAGE WHEN YOU HAVE A STORED PROC WITH 200+ PARMS
IC79256 CLOSING FRAGMENTED TABLES WITH ONLY ONE FRAGMENT LEAKS MEMORY
IC79258 UNABLE TO INSTALL PATCH PRODUCT OVER THE EXISTING 11.70.XC3 INSTALL
IC79263 VARCHAR PARAMETER VALUES IN STORED PROCEDURES CORRUPTING MEMORY IF USED IN EXCEPTION
IC79304 TIMESERIES: DELRANGE()/DELTRIM() HAS EXCESSIVE BUFREAD
IC79306 WRONG SETTING OF SQLIDEBUG WILL LEAD TO ERROR TRYING TO START DBACCESS AND ONSTAT
IC79307 ONMODE -D STANDARD AS WELL AS ONMODE -D MAKE PRIMARY HANG TURNING RSS INTO STANDARD SERVER
IC79308 USERS GET -27002 IF LOG_STAGING_DIR IS SET AND LOG LAG AFTER ENGINE RESTART REGARDLESS OF CDR_LOG_LAG_ACTION SETTING
IC79316 TSBINLOADPUT GIVES ASSERT FAILURE WHEN LOADING FROM CORRUPTED DATA FILE
IC79317 SNAPSHOT-CLONE: IFXCLONE FAILS TO WORK ON INFORMIX EDITIONS WHICH HAVE PARALLEL OPTION DISABLED, GROWTH EDITION FOR EXAMPLE
IC79320 A QUERY WITH OUTER JOINS ENTERS AN INFINITE LOOP ALLOCATING MEMORY
IC79323 CDCAPI.EC INCLUDED IN DOC WILL NOT WORK ON AIX
IC79376 IN OUT OF MEMORY CONDITION SQLEXEC THREAD CAN CRASH IN SQ_EXFPROUTINE DUE TO NULL SQTCB->CURRSDB
IC79377 CDR SYNC SELECTS ALL ROWS IN SOURCE TABLE WHEN TARGET TABLE IS EMPTY RESULTING IN UNNECESSARY STARTUP TIME
IC79378 SYSTEM ABEND WHEN ATTEMPTING TO CREATE FOREST OF TREES (FOT) FUNCTIONAL INDEX
IC79433 TIMESERIES FAST LOADER WILL SET CAL_OFFSET TO -1 WHEN DATE PRECEDES ORIGIN DATE OR FALLS BETWEEN CALENDAR BOUNDARIES
IC79434 EXCESSIVE MEMORY USE OF EXE. POOLS WHEN CALLING TIME SERIES UDRS INSIDE SPL PROCEDURE
IC79455 NOT ABLE TO INSTALL A SPECIAL BUILD RELEASE ON TOP OF ANOTHER SPECIAL BUILD RELEASE
IC79477 ERROR -647 RAISED IN CALC_SEEK_COST() WITHIN LOG FUNCTION ON SOLARIS
IC79488 HINSERT LOG RECORD INCORRECTLY BEING SWITCHED INTO AN HUPDAFT RECORD
IC79557 RANGE OF VALUES DESCRIPTION FOR UPDATABLE_SECONDARY IS INCORRECT
IC79561 DELRANGE REPORTING (UTSCJ) - PAGE 5 IN CONTAINER CO_VEE_INT_001 IS CORRUPT WHEN END DATE BETWEEN ORIGIN AND FIRST ELEMENT DATES
IC79569 FOREST OF TREES (FOT) INDEX ACCESS DOES NOT WORK FOR OR INDEX PATH
IC79657 ERROR -285 INVALID CURSOR RECEIVED BY SQLEXEC IF SCROLL CURSOR AND REGULAR CURSOR WITH SAME SQL STATEMENT AND STMT_CACHE IS SET
IC79660 FATAL ERROR: STATUS FILE CREATION FAILED. WHEN $INFORMIXDIR/TMP NOT WRITABLE
IC79716 ALTER TABLE ADD PRIMARY KEY ON AN EXISTING UNIQUE INDEX RUNS SLOW
IC79796 REVERTING FROM 11.70.XC3 OR XC4 FAILS WHEN THERE ARE OUTSTANDING IN PLACE ALTERS
IC79798 UPDATABLE SECONDARY REMAINS IN UPDATES BLOCKED STATE AFTER TEMPORARY NETWORK DISCONNECT
IC79806 SELECT FROM SYSPTNBIT PSEUDO TABLE CAN LEAD TO ASSERTION FAILURE
IC79808 PERFORMANCE DEGRADATION OF DATA TRANSMISSION VIA SSL ENCRYPTED CONNECTION COMPARED TO STANDARD SOCKET CONNECTION.
IC79841 CSM (ENCRYPTION) VPS CAN HANG IN TIGHT LOOP
IC79864 QUERY ON A VIEW WITH MANY TABLES AND MANY OUTER TABLES IS MUCH SLOWER AFTER MIGRATION FROM 11.50.FC3 TO 11.70.FC3.
IC79892 SELECT ON SYSSQLSTAT CRASHES IDS ON WINDOWS 2008
IC79894 SH_OVLMAXCONS NOT UPDATED DURING CHECKPOINT AT SHUTDOWN
IC79897 FRAGMENT ELIMINATION NOT USED WHEN A CURSOR USES HOST VARIABLES
IC79943 WRONG RESULTS WHEN A SUBQUERY IN A NOT EXISTS CLAUSE IS FLATTENED
IC79945 ERROR -768 IN OPJOIN() EXECUTING STATEMENT USING VIEW WHEN IFX_FOLDVIEW IS SET
IC79959 ONSTAT -G SES OUTPUT ON HDR SECONDARY SHOWS JUNK IN HOSTNAME FOR ONE OF THE SESSIONS
IC79978 ERROR -246/-111 WITH BATCHEDREAD_INDEX ON NON-LOGGED DATABASE
IC79980 ERROR -1225 IN EVALCOLS() WHEN SELECTING A TEXT COLUMN
IC79981 QUERY INCLUDING SUBSTR(COL,X,Y) FUNCTION CAN BE OFFLOADED TO IWA, BUT EQUIVALENT NOTATION COL[X,Y] IS REJECTED AND PROCESSED LOC
IC79983 ONSTAT CAN SHOW ADDITIONAL UNINTENDED CHARACTERS AFTER THE ROLE NAME IN THE CURRENT ROLE OUTPUT
IC79984 DISPLAY OF SQL COMMAND IN ONSTAT -G SES OR ONSTAT -G SQL CAN MISS SPACE CHARACTERS
IC80084 AFTER THE ALTER SEQUENCE RESTART COMMAND THE SEQUENCE GETS RESTARTED AGAIN WITH ANY OTHER ALTER SEQUENCE COMMAND
IC80085 INCORRECT USAGE OF TABLE EXPRESSIONS CAN LEAD TO AN ASSERT FAIL IN STCMPR WHEN AGGREGATES ARE INVOLVED
IC80087 SOLARIS: BTS BLADE IS COMPILED IN DEBUG MODE
IC80089 CPUVP COULD NOT BE REMOVED IF EACH LISTEN THREAD WORKS ON EVERY CPUVP BUT THIS RESTRICTION IS NOT DOCUMENTED.
IC80100 SELECTING FROM TIMESERIES VTI CAN CONSUME LARGE CMD MEMORY IF MANY OF THE ELEMENTS DO NOT MEET THE CRITERIA OF THE QUERY
IC80130 SETCONTAINERNAME() API APPENDS EXTRA BYTE TO EACH TIMESERIES ELEMENT AFTER IT IS MOVED TO THE NEW CONTAINER
IC80134 EMPTY TABLES ARE NOT DEFRAGMENTED
IC80136 OPTIMIZER GIVES HIGH ESTIMATED COST AND ROWS RETURNED WITH VIEWS AND OUTER JOINS
IC80164 UPDATE STATISTICS LOW WITH USTLOW_SAMPLE ENABLED CRASHES ENGINE
IC80166 NULL DATE DATA SHOWS UP AS 00/00/0000 IN AN EXTERNAL TABLE
IC80167 ERROR BTS CLUCENE ERROR: IO ERROR: FSE IO CANNOT OPEN FILE RANDOMLY OCCURS DURING LOCK CONTENTION
IC80182 ASSERT FAILURE CRASH IN BUFFGET()
IC80187 ADMIN GUIDE AND ADMIN REFERENCE HAVE DIFFERENT DESCRIPTIONS REGARDING SERVER MODE WHEN CHANGING PHYSICAL-LOG LOCATION OR SIZE
IC80234 THE INSTANCE CAN CRASH IN MINDEX_BIDXFRAGS() IF THE SKIP SCAN METHOD IS USED TO ACCESS A TABLE
IC80277 ONSTAT -G CKP SHOWING IPL CHECKPOINTS AS UNKNOWN
IC80280 SOMETIMES, SCHEDULER SHUTDOWN FAILS TO SHUTDOWN ALL DBWORKER THREADS, WITH VARIOUS SYMPTOMS
IC80282 ERROR -9791 ON RLT_OPEN WHEN R-TREE INDEX ON TEMPORARY TABLE WAS CREATED OUTSIDE OF XA TRANSACTION
IC80311 DOCUMENT STATES YOU CAN INSERT DATA INTO BYTE AND TEXT COLUMNS USING ONLOAD
IC80313 SELECT COUNT(*) IN A UDR CAN LEAD TO ASSERT FAILURE IN LDDBLNULL WHEN INDEX SKIP SCAN PATH IS CHOSEN BY THE OPTIMIZER
IC80320 SETCONTAINERNAME() API APPENDS EXTRA BYTE TO EACH TIMESERIES ELEMENT AFTER IT IS MOVED TO THE NEW CONTAINER
IC80385 DROPPING A BLOBSPACE FAILS IF NO CHECKPOINT OCCURRED BETWEEN TABLE CREATION AND DROPPING THAT TABLES TEXT OR BYTE COLUMN
IC80388 LOW MEMORY MANAGER (LMM) IS NOT ABLE TO TERMINATE SESSIONS PROPERLY
IC80431 WHEN PERFORMING LARGE RESULT SET QUERY ON TIME SERIES VTI TABLE, SEEMS TO STILL BE A CMD POOL MEMORY LEAK EVEN AFTER FIX FOR IC8
IC80490 ENHANCE ERROR 19803 TO MAKE MENTION OF INABILITY TO GRANT DEFAULT ROLE - WITH GRANT OPTION
IC80547 ASSERT FAILED: NEGATIVE PARTNUM PASSED TO RA_PAGE_ALREADY_READ
IC80548 PREPARE INSERT-SELECT ASSUMES EXCLUSIVE LOCK ON THE SELECT TABLE WHEN THERE IS NOT ONE AT ALL
IC80567 OUTPUT OF MESSAGE DR GROUPER: LOCAL PARTICIPANT(...) STOPPED CAN LEAD TO ASSERTION FAILURE AF
IC80636 ISOLATION LEVEL MIGHT BE TRACKED INCORRECTLY IN SMI TABLES WHEN SQL SET ISOLATION IS USED
IC80640 UPDATE STATISTICS ON PROCEDURE OR CALL PROCEDURE CAN LEAD TO ASSERT FAIL IN WRTHOSTVAR WITH SET EXPLAIN ON
IC80653 ASSERT FAILURE, CRASH IN PROPENDB WHILE QUERYING SYSMASTER:SYSOPENDB TABLE
IC80654 ASSERTION FAILURE IN ROWALTER OR INCORRECT RESULTS WHEN USING COMMITTED READ LAST COMMITTED ISOLATION WHEN A ROW WITH VARCHARS IS DELETED
IC80741 SLOW DRAINING OF SEND QUEUE DUE TO MUTEX CONTENTION WITH LARGE TRANSACTION VOLUME
IC80756 602/102 ERROR WHEN SELECTING A TEXT/BYTE COLUMN
IC80788 MEMORY CORRUPTION AF CRASH WHILE INSERTING TIMESERIES DATA USING PUTELEMNODUPS
IC80837 WHEN SELECT USING MATCHES OR LIKE USING CONDITION IN BETWEEN TWO MULTI-BYTE CHARACTERS DOES NOT RETURN ANY ROW EVEN IF THERE ARE
IC80858 NEITHER SQL_RUNTIME NOR SQL_TOTALTIME ARE GIVING CORRECT TIME SPENT EXECUTING A STATEMENT
IC80866 AUS EVALUATOR COULD FAIL WITH -242/-113 IN HDR ENVIRONMENT
IC80876 SELECT FIRST 1 WITH AN ORDER BY USES A SEQUENTIAL SCAN AND A SORT INSTEAD OF A MATCHING COMPOSITE INDEX
IC80877 TX STAMP AND PDQ FROM ONSTAT -G HIS OUTPUT ARE NOT DOCUMENTED
IC80879 INCORRECT VALUE FOR PDQ IN ONSTAT -G HIS
IC80880 ASSERTION FAILURE IN STMTMON_INSERT WHEN IFX_GRID_CONNECT() IS USED AND SQL TRACING IS ACTIVATED
IC80881 CORRUPTED SQL AND ISAM ERROR SHOWN IN ONSTAT -G HIS EXECUTING 4GL PROGRAM WHEN PDQ IS ENABLED
IC80906 SLOW PERFORMANCE EXECUTING DELETE STATEMENT WITH SUBQUERY USING PDQ IN 4GL PROGRAM
IC80913 PASSWORD KEYWORD AS A RESERVED WORD IS LISTED IN BOTH VERSION 10.0 AND VERSION 11.70.XC2 FIELD IN MIGRATION GUIDE
IC80918 UPDATE STATISTICS MAY RAISE ERROR 647 ON SOLARIS
IC80921 AN UPDATABLE SECONDARY CAN CRASH WHEN RECONNECTING AFTER A DISCONNECT
IC80922 IF USING UTF8 AND THERE ARE MORE THAN 18 CHARACTER COLUMNS, CDR CHECK CAN FAIL WITH ERROR -528
IC80933 THE DESCRIPTION OF RESERVED WORDS/SQL KEYWORDS IN THE MANUAL SHOULD BE MORE HELPFUL, USEFUL AND IN DETAIL.
IC80960 NO DESCRIPTION ABOUT AUTOREG MIGRATE DB-NAME STARTUP TASK AND DESCRIPTION ABOUT SYSBLDPREPARE() FUNCTION IS INSUFFICIENT
IC80988 ONDWA -V OUTPUT IS CONFUSING, AS IT DOES NOT REFERENCE IWA (INFORMIX WAREHOUSE ACCELERATOR)
IC81026 INCORRECT RESULTS WHEN LEFT JOIN USED ON TABLE WITH LOCKED ROW
IC81028 CDR REPAIR ATS COMMAND FAILS WHEN REPLICATED ROW CONTAINS A NULL IN THE PRIMARY KEY
IC81050 RUNNING A QUERY WITH AGGREGATE FUNCTION AND GROUP BY WITH PDQ CAUSES A SERVER ABEND
IC81085 CDR SYNC FAILS WITH 691 AND 111 ERRORS IF TABLE HAS RECURSIVE REFERENTIAL INTEGRITY RULES
IC81100 BTS KEYWORD SEARCH DOES NOT WORK FOR ALL SUPPORTED DATA TYPES
IC81101 SQL 242 ERROR RETURNED WHEN DROPPING TEMP TABLES WITH AUTO_READAHEAD ON
IC81102 FINAL AND PREPARE AS RESERVED WORDS ARE MISSED IN MIGRATION GUIDE AND SQL GUIDE: SYNTAX.
IC81103 SIGSEGV IN EXIT_THREAD CALLED FROM SQFAILREQUEST
IC81124 BTS SCORE VARIABLE NOT RECOGNIZED FROM PREPARED STATEMENT IN SPL - ERROR 217
IC81144 ERROR -254 RETURNED OPENING A CURSOR WITH HOST VARIABLES
IC81145 SQL ADMIN API DOC SAYS THAT ONMODE -Y 2 PREVENTS QUERY FROM EXECUTION WHICH IS NOT TRUE
IC81213 SELECT WITH WHERE CLAUSE CONTAINING LIKE/MATCHES CONDITION WITH BLANKS AND WILDCARDS MIGHT RETURN WRONG RESULTS
IC81229 BTS SNOWBALL INDEX CREATION FAILS WITH UNHELPFUL ERROR MESSAGE: BTS02 - BTS INTERNAL ERROR.
IC81249 INCORRECT QUERY RESULTS WITH PUSH-DOWN HASH-JOIN PLAN AND PDQ ENABLED
IC81262 LOGICAL LOG REPLAY ERROR ON RSS AFTER ALTERING EXTENT SIZE AND USING THE SHRINK METHOD
IC81282 CDC API REPORTS WRONG DATA FOR COLUMN OF INTERVAL TYPE WITH PRECISION AND NOT NULL MODIFIERS
IC81339 BTSCANNER CAN YIELD WAITING ON A BUFFER WITHOUT LEAVING A CRITICAL SECTION WHICH CAN LEAD TO A BLOCKED CHECKPOINT
IC81341 CONNECTION WITH ENCRYPTED PASSWORD AND PAM THROUGH CM GETS ERROR -908
IC81394 MEMORY LEAK ON SCDR* POOLS ON A PRIMARY/RSS WHEN A LOGICAL LOG IS COMPLETE OR A CREATE DATABASE IS EXECUTED
IC81416 DBACCESS REPORTS ERROR CANNOT OPEN FILE CALS.IEM
IC81451 CDR ERROR COMMAND WITH LEAF NODES CAUSES SYSCDR:CDR_ERRORS TO FLOOD WITH GC OPERATION REVIEW ERROR FAILED: UNDEFINED SERVER MESSAGES
IC81557 ADDING INTERVALS OF YEARS OR MONTHS SHOULD NOT GENERATE INVALID DATETIME ERRORS AT END OF MONTH
IC81590 CRASH IN THE ASF TCP LISTENER THREAD
IC81591 ENABLING IFX_FOLDVIEW MAY CAUSE ERROR 206/111 OR 242/102
IC81741 SERVER ABENDS IN MT_LOCK WHEN TRYING TO FREE SAPI MEMORY
IC81761 WITH AUTO_REPREPARE SET TO 1 IT IS POSSIBLE TO SEE 1 BYTE MEMORY CORRUPTION WHICH CAN LEAD TO ALL SORTS OF ASSERTION FAILURES
IC81764 SERVER BLOCKED AT CHECKPOINT WHEN A RACE CONDITION BETWEEN THE MAIN_LOOP() THREAD AND THE USER THREAD(SQLEXEC) OCCUR
IC81766 CALL OF ST_ISVALID() RETURNS ERROR -392
IC81768 ERROR 768: INTERNAL ERROR IN ROUTINE OP_REARRANGE_DTS: WRONG NUMBER OF TABLES WITH STAR JOIN AND PDQ
IC81890 DATABASE SERVER CAN USE THE WRONG FILE DESCRIPTOR STRUCTURES TO ACCESS A TABLE DUE TO DATABASE SERVER FILE DESCRIPTOR MIX-UP
IC81891 VARIOUS ASSERTION FAILURES SEEN WHEN RUNNING MULTIPLE, CONCURRENT SPLS AND UPDATE STATISTICS AT THE SAME TIME
IC81892 /TMP DIRECTORY IS NO LONGER USED FOR TEMPORARY DATA WHEN YOU RUN SELECT STATEMENTS WITH THE GROUP BY CLAUSE OR ORDER BY CLAUSE
IC81900 ERROR 9791 WHEN USING MULTISET AND RALLOC_MODE POOL ENABLED
IC81962 SYNCING AN ERKEY REPLICATE FAILS IF SOME, BUT NOT ALL PARTICIPANTS HAVE A PRIMARY KEY DEFINED
IC81965 ASSERT WARNING : INTERNAL ERROR - FREEING TRANSACTION ENTRY THAT STILL HOLDS LOCKS! IS ALARMED AT SEVERITY 5
IC81967 CASE EXPRESSION WITH NEGATIVE INT8 VALUES RETURNS WRONG RESULT
IC82007 SELECT FIRST 1 RETURNS ALL RECORDS SATISFYING THE CONDITION, INSTEAD OF RETURNING 1 RECORD
IC82085 MEANINGLESS WARNING MESSAGE IN ONLINE.LOG: FAILED TO INITIALIZE VIRTUAL PROCESSOR OF CLASS AIO.
IC82166 AUTOREGISTRATION OF SPATIAL DATABLADE WHEN A STORED PROCEDURE NAMED ST_* OR SE_* IS EXECUTED
IC82170 EXECUTE PROCEDURE OF PROCEDURES OR FUNCTIONS NAMED ST_* OR SE_* NEEDS MORE THAN 2 MINUTES
IC82178 GROUP BY ON INNER COLLECTION SUBQUERY AND FILTER ON OUTER COLLECTION SUBQUERY APPLIES FILTER IN ERROR AND CAUSES WRONG RESULTS
IC82179 PREPARED INSERT/UPDATE WHEN EXECUTED ON SDS DOES NOT SHOW ON SDS ON FOLLOWING DML STATEMENT UNTIL SOME DELAY
IC82227 IN A NON-LOGGING DATABASE A MEMORY LEAK MIGHT BE OBSERVED IN A SESSION POOL, MEMID SQL
IC82283 PROXY THREAD ASSERT FAILS AND ABORTS PRIMARY WHEN DML STATEMENTS ISSUED FROM UPDATABLE SECONDARY INVOLVE TRIGGERS AND FUNCTIONAL INDEXES
IC82288 RUNNING SELECT FROM SYSDRI MULITPLE TIMES WITH PDQPRIORITY SET LEADS TO NO ROWS FOUND SQL ERROR 100 HPL FAILPOINT 11431 AND 11008
IC82310 LINUX: VALUES OF SIGINFO_T STRUCTURE NOT PRINTED IN THE ASSERTION FAILURE FILE
IC82329 MEMORY CORRUPTION CRASH WHEN CREATE INDEX ON FRAGMENTED TABLE IS INTERRUPTED, ABORTED / KILLED
IC82354 CAN DEFINE A REPLICATE ON TABLES WITH DIFFERING PRIMARY KEY DEFINITION
IC82449 INCORRECT RESULTS WHEN NESTED LOOP JOIN USED ON TABLE WITH LOCKED ROW
IC82450 THE REGISTER DUMP FROM THE SIGNAL CONTEXT IN AF FILES ON LINUX POWER PC ARE INCORRECT
IC82483 FAILURE TO AUTHENTICATE DOMAIN USERS CRASHES ENGINE
IC82506 SELECT ON ROWID WITH SUBSELECT MIGHT RETURN WRONG RESULTS WHEN OPTIMIZER USES SKIP SCAN INDEX PATH
IC82624 THE OPTIMIZER DOES NOT CHOOSE A COMPOSITE INDEX EVEN THOUGH THE DATA NEEDS TO BE ORDERED LIKE THAT INDEX IN 11.70.FC4
IC82743 ASSERTION FAILURE POSSIBLE IN ADD_TO_FREELIST() WHEN QSTATS IS ACTIVATED AND ONSTAT -Z IS RUN
IC82757 IFXDEPLOYASSIST HANGS ON THE INSTANCE FEATURES WINDOW - STATUS SHOWS LOADING AND FEATURES DIALOG IS NOT POPULATED
IC82955 CRASH OF PRIMARY SERVER IN RSS_SEND_ THREAD JUST AFTER BOUNCING RSS SERVER


invispix 10x10