Fix list for Informix 11.50.xC9, PIDs 11.50.xC9W1, W2 and W3

Informix provides periodic fixes for release 11.50. The following list is the most recent report of fixes for customer-reported defects in Version 11.50.xC9. This report combines both Windows- and UNIX-specific defect fixes, and is more current than the defect information included in the product release.


xC9W3 APARs
Description
IC69016 WIN: IDS AUTHENTICATES NON-EXISTING USERS WITH BLANK PASSWORDS WHEN SYSTEMS HOSTS.EQUIV FILE SPECIFIES HOSTNAME ONLY
IC76872 AIX: HARD TO DIAGNOSE KAIO ERRORS 22 (EINVAL) WHEN SYSTEM RUNNING LOW ON PINNABLE MEMORY PAGES
IC78035 A TABLES ALTER COUNTER MAY BE LEFT AS NON-ZERO AFTER A ROLLFORWARD OR ROLLBACK, RESULTING IN A 242/106 ERROR WHILE QUERYING
IC78210 VARIOUS MEMORY ASSERT CRASHES WHEN LOADING SBLOB DATA
IC78368 QUERY WITH REMOTE TABLE SEEMS TO GENERATE BAD QUERY PLAN USING A NESTED LOOP JOIN THAT IS DOING TOO MUCH WORK SCANNING ROWS
IC78407 SYSMASTER TABLE SYSLOWMEMORYMGR IS NOT CREATED WHEN UPGRADE FROM 11.50.X TO 11.50.FC9
IC79135 ERROR -640 IF HAVING CLAUSE COMPARES AN AGGREGATE COLUMN WITH A NON-AGGREGATE COLUMN AND STMT_CACHE IS SET
IC79568 CONDITION FAILED - BAD ALLOCATION SIZE (-1091633152) FOR POOL CDRRQM - DEFENSIVE FIX
IC79961 ONCHECK -CI GIVES RETURN CODE OF 0 EVEN THOUGH AN ERROR IN AN INDEX WAS DETECTED
IC80597 STOPPING HDR SECONDARY AFTER RECEIVING INDEX WHEN DRIDXAUTO ENABLED ASSERTS MEMORY BLOCK CORRUPTION ON PRIMARY
IC80639 ASSERTION IN IDLE THREAD CORRUPTS AFPOOL
IC80821 ASSERT FAIL SIGSEGV WHEN WE CALL SRTCOMPARE WITH BAD ROW ADDRESS FROM PSRTINSERT
IC80934 AN ASSERT FAIL IN MGM_GETMEM CAN HAPPEN AFTER MATERIALIZE_VIEWTMP IS CALLED
IC80961 ASSERTION FAILURE POSSIBLE IN ADD_TO_FREELIST() WHEN QSTATS IS ACTIVATED AND ONSTAT -Z IS RUN
IC81105 SIGSEGV IN GEVAL OR NEW_EVAL CAN OCCUR WHEN CALLED FROM JOIN_NEXT
IC81177 ONBAR -B -L RETURNS $INFORMIXDIR/TMP/BAR_ACT.LOG: CANNOT CREATE WHEN RUN AS USER ROOT
IC81214 PREPARED INSERT/UPDATE WHEN EXECUTED ON SDS DOES NOT SHOW ON SDS ON FOLLOWING DML STATEMENT UNTIL SOME DELAY
IC81215 9986 CORRUPTED COLLECTION ERROR RETURNED WITH LARGE MULTISET
IC81453 ERROR 79784 LOCALE NOT SUPPORTED WHEN LOADING A JAR WITH PL_PL.MAZOVIA LOCALE
IC81527 SELECT WITH FIRST N ROWS AND ORDER BY CLAUSE RUNS SLOW
IC81528 CRASH DURING WHOLE SYSTEM ARCHIVE WHEN SERVER RUNS OUT OF VIRTUAL MEMORY
IC81529 ONSTAT -D SHOWS WRONG VALUES IN PAGE RD AND PAGE WR COLUMNS FOR BLOBSPACE CHUNKS ON A 32BIT INSTANCE RUNNING ON A 64BIT OS
IC81558 ONBAR SIGALRM SIGNAL HANDLER CALLS UNSAFE ROUTINE, LOCALTIME()
IC81579 QUERY RUNS SLOW AFTER UPGRADE FROM 11.50.FC8 TO 11.50.FC9
IC81593 QUERY WITH ANSI JOIN IS SLOW, RE-WRITING IT BY RE-ORDERING JOINS MAKES IT RUN FAST
IC81648 WITH AUTO_REPREPARE SET TO 1 IT IS POSSIBLE TO SEE 1 BYTE MEMORY CORRUPTION WHICH CAN LEAD TO ALL SORTS OF ASSERTION FAILURES
IC81679 IDS CAN ABEND IN CREATE_OPEN_PARTITION_TXN_LIST
IC81745 HAVING MULTIPLE CPU VPS AND PDQPRIORITY 1 (LOW), UNLOADING DATA USING EXTERNAL TABLES WITH PIPES CAN HANG
IC81746 SELECT FIRST 1 WITH AN ORDER BY USES A SEQUENTIAL SCAN AND A SORT INSTEAD OF A MATCHING COMPOSITE INDEX
IC81779 CASE EXPRESSION WITH NEGATIVE INT8 VALUES RETURNS WRONG RESULT
IC81780 ONMODE_MON THREAD SEGV DUE TO CONCURRENT ONMODE COMMAND AND ONSTAT COMMAND WHEN AUDITING IS ENABLED
IC81863 USING A FULLY-QUALIFIED TABLE NAME DOES NOT RESOLVE THE DATABASE SERVER NAME OPPOSITELY IF DATABASE SERVER NAMES ARE NOT UNIQUE
IC81897 ONSTAT -G CKP FAILS TO SHOW CHECKPOINT INFORMATION OR CAN PRINT RANDOM VALUES AFTER INSTANCE IS STARTED
IC81899 THE ENDING VALUE FOR RSS_FLOW_CONTROL CANNOT BE SET TO 128M OR HIGHER (32768 PAGES)
IC81966 THE WARNING: NOT ENOUGH TEMP SPACE FOR PARALLEL INDEX BUILD DOES NOT SHOW REQUIRED SPACE.
IC81969 AUTO UPDATE STATISTIC REFRESH EVALUATION FAILS WITH ERROR -206 ON TABLE AUS_WORK_INFO
IC82033 CDR DEFINE SERVER RETURNS GENERAL ERROR (-1) (-1)
IC82087 GROUP BY ON INNER COLLECTION SUBQUERY AND FILTER ON OUTER COLLECTION SUBQUERY APPLIES FILTER IN ERROR AND CAUSES WRONG RESULTS
IC82138 INCORRECT REFERENCE TO CDR REMOVE COMMAND WHEN CDR DELETE SERVER FAILS TO DROP SYSCDR
IC82140 TEMPORARY TABLES WITH LOGGING ARE NOT DROPPED FROM THE DBSPACE WHEN APPLICATIONS DISCONNECT WITHOUT A COMMIT OR ROLLBACK
IC82141 THE SCHEDULER DOES NOT USE DBSPACETEMP
IC82165 SELECT QUERY EXECUTED BY THE USER WITH CONNECT PRIVILEGES ONLY CAUSES ENGINE CRASH (SQL ERR 272)
IC82208 CDR CHECK --REPAIR FAILS TO INSERT A MISSING ROW ON TARGET IF ROW CONTAINS A UNIQUE KEY THAT ALREADY EXISTS IN THE TARGET TABLE
IC82212 ARCHECKER REPORTS: PAGE 48_240 IS NOT A PARTITION PAGE (32) BUT IT IS A PARTITION PAGE
IC82238 A UDR CONTAINING A CROSS-DATABASE QUERY WITH ANSI JOIN CAN GENERATE AN AF IN PRNEXT_JOINTAB CALL
IC82291 9791 ERROR POSSIBLE ALONG WITH AF WHEN SPL CALLING OTHER SPL IS INTERUPTED WHILE TRYING TO RETREIVE SPL EXECUTE CATALOGS
IC82308 WARNING: SBSPACE IS FULL MISLEADING IN ONLINE.LOG, FREE META DATA IS 0 BUT INSERTS SUCCEED
IC82355 THERE IS AN ADDITIONAL BACKSLASH ADDED IN A SPECIFIC ROW AFTER LOADING DATA WITH AN EXTERNAL TABLE
IC82446 ESQL STATEMENT WITH DATATIME HOST VARIABLE GETS ERROR -1260
IC82448 ARCHECKER SEGV CORE DUMPS WHEN USING RESTORE TO CURRENT WITH NO LOG
IC82505 SEGV CRASH IN MT_FREE CALLED FROM UPDST_LRUBUF_DEALLOC WHEN NO MORE MEMORY AVAILABLE
IC82566 IF A TARGET NODE IS DISCONNECTED DURING CDR CHECK -R, INCORRECT NODE NAME IS PRINTED IN THE DISCONNECT ERROR MESSAGE
IC82567 ONSTAT -G SES HANGS WHEN RUN ON A SHARED DISK SERVER ( SDS )
IC82595 SELECT ON VIEW WITH WITH CHECK OPTION IS TAKING LONG TIME TO COMPLETE. IFX_FOLDVIEW IS ENABLED IN ONCONFIG.
IC82596 CDR CHECK -R DOES NOT SEEM TO REPLICATE THE CRCOLS(CDRTIME, CDRSERVER) VALUES TO TARGET WHEN CONFLICT RESOLUTION DELETEWIN
IC82623 ON AIX, WE SHOULD CHECK FOR THE SETTING OF RESIDENT BEFORE BRINGING THE INSTANCE ONLINE
IC82642 OUT OF MEMORY CONDITION CAN LEAD TO PARTITION NO MORE EXTENTS ERROR AND SUBSEQUENT AF PTHDRPAGE:PTDROP:BAD EXTENT SLOT DROPPING
IC82643 INCORRECT ALARM IS RETURNED WHEN TRYING TO EXTEND A PARTITION UNDER OUT OF MEMORY CONDITIONS
IC82756 ONBAR BACKUP USING TIVOLI STORAGE MANAGER FAILS WITH -43231 CREATETIME NOT SET BY STORAGE MANAGER
IC82785 ONSTAT -P CAN CRASH WHEN IT FOUND BUFFERS OF SPACES THAT NO LONGER EXIST
IC82787 IF A SUBSCRIPT STRING[FIRST,LAST] IS USED IN AN UPDATE WITH CORRELATED SUBQUERY, WRONG VALUES MAY BE USED FOR UPDATE
IC82924 FAILOVER CONNECTION TAKES UP TO 5 SECONDS PER SERVER
IC82950 SEGV CRASH IN _STRCPY IFX_GETSPNAM ON MSC VP ON HP WHEN TRUSTED ENABLED AND NO SHADOW FILE
IC82978 ADDING INTERVALS OF YEARS OR MONTHS SHOULD NOT GENERATE INVALID DATETIME ERRORS AT END OF MONTH
IC82979 REMOTE CURSOR UPDATE RESULTS IN ENGINE CRASH DUE TO BCOPY REFERENCING MEMORY BEYOND INFORMIX SEGMENT
IC82981 HDR SECONDARY LOGICAL LOG REMAINS NOT BACKED UP AFTER HDR RECONNECTED IF THE PRIMARY CHANGED LTAPEDEV WHEN HDR PAIRS BROKEN
IC83037 BTS SCORE VARIABLE NOT RECOGNIZED FROM PREPARED STATEMENT IN SPL- ERROR 217
IC83077 CDR SYNC INCORRECTLY TREATING TARGET ROWS NOT QUALIFYING THEIR PARTICIPANTS WHERE CONDITION AS EXTRA TARGET ROWS
IC83258 ASSERT FAILED: CONDITION FAILED (SIZE != 0) ON HP-UX/IA64 EVEN WITH IC75470 FIXED
IC83411 CREATE PROCEDURE STATEMENT ABEND IDS SERVER IN OP_JOIN().
IC83466 RUNNING ONCHECK CAN GENERATE ONE OR MANY ASF ECHO-THREAD SERVER MESSAGES IN ONLINELOG
IC83540 ONSTAT -G ATH OUTPUT: LACK OF SPACE SEPARATOR BETWEEN AND COLUMNS
IC83707 DRDA: .NET METHOD EXECUTENONQUERY MIGHT RETURN -1 INSTEAD OF 0 AS NUMBER OF AFFECTED ROWS
IC83720 QUERY CHOOSES WRONG PATH WITH MULTI TABLE JOIN AND UPDATE STATISTICS HIGH
IC83721 INSERTING INTO A TEXT COLUMN IN A REGULAR TABLE FROM AN EXTERNAL TABLE RETURNS ERROR -391 IF A NOT NULL CONSTRAINT EXISTS
IC83740 ONCHECK DISPLAY OVERFLOW WHEN PN_SERIAL8 WILL NOT FIT IN SPACE
IC83741 BUILDSMI PRODUCES ERROR WHEN RUN IN SINGLE USER MODE
IC83758 INCORRECT RESULT IS RETURNED WHEN INDEX SELF JOIN IS USED.
IC83763 WHEN ONPLOAD UNLOADS TO A PIPE, IF THE PIPE BREAKS THE JOB WILL REPORT ERRORS TO LOGFIE BUT CONTINUE TO PROCESS AND CAN THEN COR
IC83773 PERFORMANCE REGRESSION IN IDS 11.50.XC9W2
IC83782 SORTTEMP TABLE IS NOT DELETED AFTER THE SESSION RUNNING THE QUERY(WITH ORDER BY) IS GONE
IC83848 SELECT USING SPATIAL RTREE INDEX REPORTS ERROR (RTRC9) FILE RLTSCAN.C, LINE 2000.
IC83923 NEW IXBAR FILE CREATED BY ONSMSYNC CAN BE MISSING A LOGICAL LOG SUCH THAT THE IXBAR FILE CANNOT BE USED FOR A COLD RESTORE
IC83925 ASSERTION CRASH IN INSDMLVLTN DURING VIOLATION CHECKS
IC83931 SELECT ON A LARGE TABLE TAKES VERY LONG, WHEN ENVIORNMENT VARIABLE IFX_FLAT_UCSQ IS SET
IC83946 UPDATE AGAINST FRAGMENTED TABLE RUNS FINE ON PRIMARY SERVER BUT GIVES ERROR 601/770 WHEN RUN AGAINST UPDATABLE SDS SERVER
IC83956 UDR CACHE IN NEED OF URGENT PERFORMANCE IMPROVEMENTS - IN PARTICULAR FOR SPLS WITH GLOBALS
IC83968 NO MATCHING RECORD FOUND FOR CURRENT SESSION FROM SYSOPENDB
IC84005 ASSERT FAIL IN SQOPTIM WHILE RUNNING A SELECT WITH A JOIN OF AN EXTERNAL TABLE
IC84096 WRONG RESULT FOR QUERY WITH VIEWS AND SUBQUERIES WHEN IFX_FOLDVIEW IS SET TO 1
IC84225 WHEN USING MULTI-BYTE LOCALE AND GL_USEGLU CDR DEFINE REPL WITH SPL CONFLICT RESOLUTION GIVE ERROR 38 SPL ROUTINE DOES NOT EXIST
IC84368 IDS CRASHES IN EVALCOLS() IF IFX_FOLDVIEW SET WITH MULTIPLE DERIVED TABLES AND OUTER LEFT JOIN
IC84371 SERVER HANG OR CRASH WHEN QUERY INCLUDES SUBQUERY, REMOTE VIEW AND SYNONYM
IC84410 BLADEMGR COMMAND LIST DATABASE CAN TEMPORARILY RESULT IN PREPARE ERROR WHEN USED ON A SECONDARY SERVER
IC84469 STORED PROCEDURE GENERATES A QUERY PLAN THAT RETURNS INCORRECT NUMBER OF ROWS FOR CERTAIN ARGUMENTS
IC84724 OPTIMIZER OVERESTIMATION FOR VIEW TEMP TABLES CAUSES VERY LARGE FIRST/NEXT EXTENT SIZES
IC84725 OPTIMIZER OVERESTIMATION FOR VIEW TEMP TABLES CAUSES ROOTDBS TO BE USED ALWAYS FOR TEMP SPACE
IC84807 SELECT * FROM TABLE(LIST{ROW(1,1)}) CAUSES HDR SECONDARY CRASH ON SOLARIS
IC84809 SEGV CAN OCCUR WHEN CALLING ACCPSOCKET FROM TLACCEPT
IC84820 BTSCANNER THREADS DO NOT START ON HDR SECONDARY AFTER INSTANCE RESTART
IC84821 UNLOADING DATA WITH EXTERNAL TABLE WHEN PDQ ENABLED LEADS TO HIGH CPU USAGE AND LOWER PERFORMANCE
IC84877 BTSCANNER THREAD CAN ASSERT FAIL IN BTC_DO_ENABLE
IC84924 DRDA: SERIAL FIELDS COMING FROM OUTER JOINS AND CONTAINING NO DATA ARE NOT SET TO NULL
IC85086 SPORADIC HPL FAILPOINT 18006 POSSIBLE DURING TABLE LOAD OPERATIONS
IC85122 INFORMIX DRDA DOES NOT SET SQLCA.SQLWARN CORRECTLY FOR NON-ANSI DATABASES
IC85148 SEGV IN FMFTOPEN_WITH_CHILD AFTER SKIPPING INDEX
IC85176 MEMORY LEAK ON REMOTE INSTANCE PREPARING A CURSOR AND CALLING A STORED PROCEDURE INSIDE A LOOP
IC85178 RSS_ONMOD THREAD AFS TRYING TO PROMOTE SDS SECONDARY TO PRIMARY
IC85263 DBWORKER THREAD CRASHES IN PH_SQL_SETUP DURING DBSCHEDULER STOP
IC85331 AN UNLOAD MIGHT INCORRECTLY TRIM TRAILING BLANKS FROM VARCHAR DATATYPE WHEN A NON-DEFAULT DB_LOCALE IS USED
IC85337 SQLEXEC THREAD CAN BE LEFT HANGING FOREVER IN FUNCTION DBCRON_SUBMIT_TASK
IC85551 HUGE MEMORY CONSUMPTION ON INSERT INTO LIST
IC85630 CDR STOP HANGS IF CDR REALIZE TEMPLATE --SYNCDATASOURCE IS RUNNING.
IC85631 ONPLOADS FD RLIM_CUR EXCEED 256. FD VIOLATION CAUGHT BY OPERATING SYSTEM.
IC85723 AF CRASH OR PDQ QUERY HANG WHEN XCHG JOIN THREADS ENTER RACE CONDITIONS DUE TO A MUTEX BECOMING FREED
IC85753 DBEXPORT/DBSCHEMA HANG FOR DATABASES CREATED WITH SQL_LOGICAL_CHAR AND DATABLADES REGISTERED
IC85781 ONMODE -D STANDARD ON RS SERVER CAUSES ENGINE CRASH IF DELAY_APPLY ENABLED
IC85782 ASSERTION FAILURE POSSIBLE IN SEND_ROW_TO_CONSUMER WHEN QUERY RUNS WITH PDQ
IC85914 9628: TYPE () NOT FOUND, WHEN USING COLLECTION LIST IN SPL ARGUMENTS
IC86080 AFTER SDS FAILOVER THE NEW UPDATABLE SDS DOES NOT REGISTER ALL THE CONNECTION MANAGER INSTANCES
IC86109 LENGTH OF CHARACTER COLUMNS IS NOT EXPANDED AS REQUIRED BY SQL_LOGICAL_CHAR WHEN BTS IS REGISTERED
IC86110 DBSCHEMA PRINTS WRONG TABLE DEFINITION WHEN SQL_LOGICAL_CHAR IS USED AND BTS IS REGISTERED
IC86114 AUS_REFRESH_STATS TASK REFRESHES A LIMITED NUMBER OF STATISTICS AFTER UPGRADE
IC86326 SELECT RETURNS INCORRECT VALUES IF DECODE IS IN A SUBQUERY
IC86366 CRASH POSSIBLE SELECTING FROM TABLE SYSMASTER:SYSPROXYAGENTS
IC86367 DECIMAL TYPE LOSES PRECISION IN ESQL/C PROGRAM IF STMT_CACHE ENABLED AND SQL EXECUTION EXCEEDS THE NUMBER OF STMT_CACHE_HITS
IC86394 A JOIN ON NCHAR COLUMNS IN DATABASE WITH CS_CZ.8859-2@SIS LOCALE RETURNS NO ROWS EVEN IF IT SHOULD
IC86414 ERROR -768 IN ROUTINE OPJOIN IN MULTI TABLE JOIN STATEMENT USING ANSI JOIN SYNTAX
IC86488 SYSMASTER:SYSSQLSTAT SHOWS WRONG STATEMENT IN SQS_STATEMENT COLUMN
IC86571 -408 ERROR IS NOT EXPLICIT ENOUGH TO TRACK DOWN THE SOURCE OF THE ERROR
IC86643 DBIMPORT RETURNS SYNTAX ERROR ON COMMENT ENDING WITH SEMICOLON
IC86670 AF IN COMP_UDR WHEN EXECUTING A PREPARED SQL STATEMENT THAT CONTAINS DATE DATA TYPE, MANY HOST VARIABLES AND SET STMT_CACHE TO 2
IC86729 ONBAR BACKUP FAILS WITH MT_PROMOTE FAILED FOR TICKET XXXXXX WITH ERROR -3 IN INIT_ARCBU-2
IC86823 SERVER MIGHT REUSE THE LOGICAL LOG WHERE A ROLLING BACK TRANSACTION WAS STARTED
IC86953 ASSERT WARNING: ARCHIVE DETECTS THAT PAGE X:XXXXXX IS CORRUPT DURING A BACKUP
IC86994 DBACCESS: IN MENU TABLE - ALTER - ADD USING ARROW KEYS DOES NOT ALLOW ONE TO MOVE CURSOR TO THE BOTTOM OF THE COLUMN LIST
IC87023 CREATE INDEX CAN CAUSE SEGV AFTER CALLING USTMPDIST TO SAVE DATA DISTRIBUTIONS THAT SHOULD HAVE BEEN CREATED
IC87068 ERRONEOUS GETTAB() ERROR MESSAGE FROM ONCHECK AGAINST A SEQUENCE
IC87308 FAST RECOVERY CAN FAIL WITH TRANSACTION STILL OPEN BECAUSE OF COMMITTED TRANSACTION IN CHECKPOINT RECORD
IC87313 QUERIES USING HOST VARIABLES CAN CAUSE A HOT RR_I MUTEX ON LARGE SYSTEMS
IC87376 SMI QUERY CRASHES INFORMIX INSTANCE.
IC87447 CHECKPOINT HUNG DUE TO DEADLOCK BETWEEN ONTAPE AND DBWORKER THREAD
IC87529 INCORRECT RESULT FOR A QUERY WITH VIEWS AND LEFT JOIN WHEN IFX_FOLDVIEW=1
IC87534 OPTIMIZER NOT CHOOSING FASTER OR-INDEX PATH WITH FUNCTIONAL INDEXES
IC87536 HANDLING OF USER DEFINED TYPES WITH INVALID DATA MAY RESULT IN MEMORY CORRUPTION
IC87588 LIKE() FUNCTION CAUSES A CRASH
IC87683 CRASH IN BUFFGET() WHEN ACCESSING PAGE SIZE FIELD ON THE PAGE WHEN RUNNING ER COMMANDS
IC87805 PREPARED STATEMENT CAN CAUSE HUGE ALLOCATION OF RALLOC MEMORY WHEN CALLED REPEATEDLY WITH DIFFERENT TYPES OF HOST VARIABLES
IC88152 ONINIT PRINTS MISLEADING ERROR DBSERVERNAME HOSTNAME NOT IN SQLHOSTS FILE WHEN THE $ONCONFIG FILE IS EMPTY
IC88159 ACCESSING A DATABASE OBJECT IN A REMOTE INSTANCE HAS UNNECESSARY STAT() CALLS FOR SQLHOSTS
IC88207 AF CRASH WHEN A TRUNCATE COMMAND ON A REPLICATED TABLE IS INTERRUPTED
IC88391 ENGINE CRASH OCCURS IF YOU SPECIFY AGGREGATE FUNCTION TO COLUMN IN ORDER BY CLAUSE
IC88560 WHEN CALLING A DATABLADE FROM WITHIN A TRIGGER, THE DATABLADE STORES THE VALUES FOR THE ROWS IN THE CMD POOL, WHICH LEADS TO A
IC88585 THE REPACK OPERATION CAN END PREMATURELY IF A LONG ROW (>PAGESIZE/2) IS HIT
IC88811 DELETE STATEMENT USING AN INDEX CAN REPORT -243/-111 WHEN RUN IN PARALLEL WITH OTHER SIMILAR DELETE USING ADJACENT KEY VALUE
IC88912 EXCESSIVE CALLS TO GETENV CAN BADLY IMPACT LOAD PERFORMANCE
IC88922 DATA SERVER CLIENT THROWS ERROR SQL30061N SQLSTATE=08004 ON CONNECTION, IF AN INVALID DB_LOCALE IS SET ON CLIENT
IC89005 HDR RSS SERVER HANGS WHEN SWITCHING STATE FROM RSS TO STANDARD AND DRAUTO=2 SETTING
IC89274 IF VIEW BASED ON REMOTE TABLE IS QUERIED WITH REVOKED SELECT PRIVILEGE THEN THE QUERY TO VIEW WILL ALWAYS BE GIVING ERROR -583
IC89275 CREATING AN INDEX ONLINE ON A COMPRESSED TABLE WITH CONCURRENT UPDATES MAY CORRUPT TABLE DATA
IC89280 ORPHANED PARTITION BLOB PAGES WHEN INSERT INTO RAW TABLE FAILS WITH -391 ERROR
IC89281 LOGICAL RECOVERY ROLLFORWARD ERRORS ON SDS NODES WHEN PRIMARY NODE IS PERFORMING LRU (FOREGROUND POSSIBLY) WRITES
IC89309 SEVERE CONCURRENCY ISSUE, 154 ERRORS WITH TRANSACTION ON UPDATABLE SDS NODE THAT UPDATES THE SAME ROWS IN A TABLE TWICE
IC89356 WRONG NUMBER OF ROWS RETURNED WITH GROUP BY ON A DECIMAL COLUMN.
IC89386 DRDA XA CONNECTION FAILED TO OPEN CONNECTION WITH ERROR SQL30061N
IC89388 UNEXPECTED NULL VALUES RETURNED EXECUTING A REMOTE STORED PROCEDURE WITHIN A LOCAL STORED PROCEDURE AND LVARCHAR RETURNED
IC89424 SMART BLOB LOAD PROGRAM USES MORE MEMORY ON SDS SECONDARY
IC89462 UNDETECTED BLOCK HEADER CORRUPTION CAN BE MASKED IN SOME CONDITIONS WHEN MERGING ADJACENT FREE BLOCKS LEADING TO SEGV IN MT_FREE
IC89511 ONSTAT CAN LOOP ON CHANGING DATA STRUCTURE FORCED COMMAND TERMINATION
IC89673 COLUMN VALUES FOR ONSTAT -G SMB ON 64 BIT INSTANCE IS NOT ALIGNED
IC89811 ONSTAT -G CMSM CRASHES WITH ERROR OF CHANGING DATA STRUCTURE FORCED COMMAND TERMINATION.
IC89891 LOGICAL RECOVERY ROLLFORWARD ERRORS ON SDS NODES WHEN PRIMARY NODE IS PERFORMING CHECKPOINT BUFFER FLUSHING
IC89895 AFTER PHYSICAL RESTORE, ONMODE -S AND ONMODE -M RETURN BEFORE THE DATABASE SERVER IS FULLY IN QUIESCENT OR ON-LINE MODE
IC89940 ONLOG PRINTS 25582 OR 25587 TO THE ONLINE LOG FILE
IC90002 PROBLEMS WITH QUERIES ON SYSSQLCURALL, SYSSQSCB, AND SYSOPENDB - SOME DATA NOT RETURNED
IC90050 ONBAR HANG WITH FIX TO IC81558
IC90095 WITH ROLE SEPARATION ENABLED, AND DBSA GROUP NOT INFORMIX, LOG_STAGING_DIR AND ITS SUBDIRS OWNERSHIP ARE NOT SET CORRECTLY
IC90245 ONSPACES IS ABLE TO DROP AN SBSPACE CHUNK THAT CONTAINS SMARTBLOB DATA
IC90251 HDR PAIR MAY OCCASIONALLY LOSE CONNECTION CAUSED BY THE PING TIMEOUTS WITH VARIOUS ASF ERRORS
IC90264 MEMORY LEAK IN ONCMSM IF ASF_CALL FAILS
IC90283 DB_LOCALE MAY BE SET INCORRECTLY CAUSING ERROR 23101 IN INIT_SQSCB FOR THE SESSION WITH MULTIPLE REMOTE QUERIES
IC90346 PAM IS NOT USED BY THE CONNECTION MANAGER
IC90375 THE ONSTAT -G MEM CAN HANG IN MT_SHOWPOOLS()
IC90608 OPTIMIZER DOES NOT CHOOSE INDEX PATH WHEN USING ORDER BY CLAUSE ON FRAGMENTED TABLES/INDEXES
IC90726 HDR SECONDARY STUCK IN FAST RECOVERY AFTER DR RESET
IC90729 ASSERTION CRASH SEGV FOUND DURING MT_SHM_FREE 1 WITH VARIABLE ROW SIZES BEING SELECTED AND PROGRAM CURSOR IS OPENED AND CLOSED
xC9W2 APARs
Description
IC67083 USING IBM DATA SERVER DRIVER FOR JDBC WRONG META DATA WILL BE DISPLAYED WHEN CONNECTING INFORMIX DATABASE TABLE
IC70912 WITH CDR CONFIGURED BUT DOWN CHECKPOINTS CAN OCCUR IN ONE-SECOND INTERVALS WHEN REPLAY POSITION HAS BEEN OVERWRITTEN
IC76197 BLADEMANAGER FAILS TO REGISTER DATABLADES IN UTF8 DATABASES WHEN SQL_LOGICAL_CHAR IS USED
IC77086 ONSTAT -G HIS: FIELD RUN TIME SHOWS ZERO
IC77371 UNEXPECTED OUTPUT FORMAT WITH DBACCESS WHEN THE CLIENT_LOCALE CHANGES FROM EN_US.819 TO EN_US.UTF8
IC77813 MEASURING REALTIME INSIDE IDS YIELDS VERY HIGH VALUES ON SOME HARDWARE
IC77923 BUILDSMI FAILS WITH ERROR 921 WHEN USING THE LOCAL SYSTEM ACCOUNT ON A WINDOWS 2008 SERVER
IC78601 ASSERTION WARNING: CANNOT LOAD LOCALE FOR EN_US.1252, PARTNUM 0X200002
IC78637 ONSTAT -G HIS SHOWS RUN TIME AND OTHER TIME FIELDS AS 0 FOR STATEMENTS WITH AGGREGATE EXPRESSIONS
IC78922 MEMORY CORRUPTION CRASH WHEN CREATE INDEX ON FRAGMENTED TABLE IS INTERRUPTED, ABORTED / KILLED
IC79312 ERROR -874 FROM INSERT THROUGH A PROCEDURE WITH SINGLETON SELECT ON INSERT TABLE AS FUNCTION ARGUMENT
IC79313 CSM (ENCRYPTION) VPS CAN HANG IN TIGHT LOOP
IC79318 ONSMSYNC DOES NOT SYNC (DOES NOT ADD TO SYSUTILS) DBSPACE BACKUPS LISTED IN IXBAR FILE WITH ACTION_ID 0
IC79319 INVALID MUTEX TYPE IN CDRSTOP THREAD DETECTED IN WAKE_FULL_QBUF
IC79322 BAD PERFORMANCE OF THE QUERY TO SYSMASTER:SYSSCBLST
IC79415 PROBLEM WITH EXISTENCE OF WHITESPACE IN PATHNAME OF DLL IN EXTERNAL FUNCTION (UDF).
IC79475 USING ROW SCOPE AND FIRETRIGGER OPTIONS IN REPLICATE DEFINITION CAN CAUSE DUPLICATE VALUES IN UNIQUE CONSTRAINT ON ER TARGET
IC79476 SELECT FROM OWNER.TABLENAME WITHOUT QUOTATION MARKS FAILS WITH -201 WHEN TABLE OWNER BEGINS WITH NUMERIC
IC79486 CRASH IN HASH_READ_TUPLE WHEN TEMPORARY SPACE IS EXHAUSTED
IC79487 SLIGHTLY MISLEADING MESSAGE POSSIBLE DURING MIGRATION/CONVERSION: PARTITION HEADER PAGE ... HAS FREE SPACE 8 AND THE SPACE NEEDED IS 8
IC79488 HINSERT LOG RECORD INCORRECTLY BEING SWITCHED INTO AN HUPDAFT RECORD
IC79658 LOCAL CONNECTION TO PAM PORT FAILING WITH -951 FOR THE CLIENT AND -956 IN SERVER LOG
IC79702 AFTER AN UNEXPECTED END OF A CDC APPLICATION THE RELATED SESSIONS/THREADS ARE HANGING AROUND AND CANNOT BE CORRECTLY REMOVED
IC79715 ASSERTION FAILURE IN ROWALTER OR INCORRECT RESULTS WHEN USING COMMITTED READ LAST COMMITTED ISOLATION WHEN A ROW WITH VARCHARS IS DELETED
IC79794 PERFORMANCE DEGRADATION OF DATA TRANSMISSION VIA SSL ENCRYPTED CONNECTION COMPARED TO STANDARD SOCKET CONNECTION
IC79804 THE SYSTEM CALL EXIT() IS USED IN A SIGNAL HANDLER BUT AIX DOCUMENTATION SAYS IT SHOULD NOT.
IC79805 QUERY USING TO_CHAR() MIGHT CAUSE ASSERT FAILURE ON LEADING FUNCTION
IC79843 DUPLICATE TRANSACTION IDS MIGHT BE POSSIBLE AFTER GOING THROUGH RECOVERY INVOLVING XA OR DISTRIBUTED TRANSACTIONS
IC79869 MEMORY ALLOCATION PROBLEM WITH SQL MEMID WHEN SPL RUNS SELECT FROM TEMP TABLE AND JOIN OF ANOTHER.
IC79893 SETTING CHUNK DOWN FOR MIRRORED DBSPACE ON PRIMARY SERVER WITH ONSPACES WILL NOT BE NOTICED ON THE SDS SECONDARY NODE
IC79944 ERROR: 874 AND ASSERT FAILURE WHEN A SELECT QUERY IS RUN AGAINST A VIEW
IC79946 SQL STATEMENTS RUN MULTIPLE TIMES IN SAME SESSION WHEN MEMORY CANNOT BE ALLOCATED BY SERVER CAN RESULT IN MEMORY CORRUPTION
IC79947 RS SERVER (RSS) CRASHED WHILE APPLYING LOGICAL LOG RECORD
IC79959 ONSTAT -G SES OUTPUT ON HDR SECONDARY SHOWS JUNK IN HOSTNAME FOR ONE OF THE SESSIONS
IC79962 DYNAMICALLY REDUCING THE NUMBER OF CPU VPS MAY ABEND THE SERVER
IC79982 -239/-100 OR -268/-100 FOR SERIAL AFTER HDR FAILOVER ON NEW PRIMARY
IC80083 CHANGE OF TRUSTED HOSTS HANDLING CAN MAKE ADDITIONAL ENTRIES NECESSARY IN TRUSTED HOSTS CONFIGURATION FILE
IC80090 A SELECT WITH SUBSELECT AND GROUP BY MIGHT RETURN INCORRECT RESULTS DEPENDING ON THE GROUPING ORDER
IC80135 INSERT TRIGGER NOT FIRED IF THE TRIGGERING ACTION COMES FROM AN UDR AND REPEATABLE READ IS USED AND OPTCOMPIND IS SET TO 1
IC80136 OPTIMIZER GIVES HIGH ESTIMATED COST AND ROWS RETURNED WITH VIEWS AND OUTER JOINS
IC80138 WINDOWS: INFORMIX CRASHES IF THE CRT/OS FUNCTION CALLS RAISEEXCEPTION()
IC80139 POOR PERFORMANCE USING AUTOINDEX WITH A TABLE HAVING 300 MILLION ROWS
IC80163 QUERY EXECUTED WITH IFX_FOLDVIEW SET RETURNS INCORRECT RESULTS
IC80183 SEGV CRASH WHEN INSERTING INTO A TABLE FROM AN EXTERNAL TABLE
IC80184 SEGV CRASH DURING PASS THROUGH OF SRTQUICK FUNCTION WHEN CREATING INDEXES OR UPDATE STATISTICS BEING RUN AND PDQ SET
IC80233 THE ERROR UNABLE TO ALLOCATE A TRANSACTION FOR USER ID CAN BE REPORTED WHEN THE MAXIMUM NUMBER OF TRANSACTIONS IS REACHED
IC80275 RUNNING HPL TO UNLOAD A TABLE WITH AN ESCAPED SPACE IN LVARCHAR COLUMN MEET HPL FAILPOINT: 18313
IC80276 RUNNING THE DROP LOG TASK IN A QUERY CAN LEAD TO A CONTINUOUSLY LOOPING THREAD
IC80280 SOMETIMES, SCHEDULER SHUTDOWN FAILS TO SHUTDOWN ALL DBWORKER THREADS, WITH VARIOUS SYMPTOMS
IC80286 REMOTE QUERY EXECUTION WITHIN FUNCTION OR PROCEDURE MAY LEAD TO ERROR 556
IC80288 UPDATE LOCKS REMAIN IN PLACE FOLLOWING REBUILD OF SYSHA DATABASE BY SDS_SEND THREAD
IC80321 QUERY RETURNS WRONG NUMBER OF ROWS IF RUNNING FROM REMOTE INSTANCE WITH CREATE SYNONYM
IC80386 SELECT MULTISET USING STORED PROCEDURE WRITES ASSERT FAILURE AND RETURNS -9791 ERROR
IC80422 SWITCHING PARTIALLY USED LOGICAL LOG FILE WHILE RUNNING ONTAPE-C CAUSES A CORRUPTED LOGICAL LOG FILE THAT CANNOT BE RESTORED
IC80491 DBEXPORT FAILS WITH ILLEGAL SPL ROUTINE ENTRY IF DATABASE IS CREATED WITH EN_US.UTF8 LOCALE
IC80494 UNCLEAR OUTPUT OF ONSTAT -G SQL WHEN TEMPORARY TABLES ARE DROPPED AND CREATED WITHIN A STORED PROCEDURE
IC80544 COMPRESSION FEATURE IS NOT CHECKING APPROPRIATELY FOR RESERVED DATABASE NAMES AND IS INCORRECTLY BLOCKING COMPRESS OPERATIONS
IC80550 UPDATE STATISTICS MAY RAISE ERROR 647 ON SOLARIS
IC80568 FOR EXTENDED DATA TYPES, IDS 10 MAKES BETTER USE OF SQLI FETCH BUF THAN IDS 11
IC80637 ISOLATION LEVEL MIGHT BE TRACKED INCORRECTLY IN SMI TABLES WHEN SQL SET ISOLATION IS USED
IC80642 BAD PERFORMANCE OF ANY QUERY TO SYSMASTER:SYSTCBLST TABLE
IC80653 ASSERT FAILURE, CRASH IN PROPENDB WHILE QUERYING SYSMASTER:SYSOPENDB TABLE
IC80688 AF IN _STRLEN/RCASESHIFT WHEN INVALID SELECT SKIP .. FIRST SYNTAX IS EXECUTED IN THE SAME SESSION AS A PREVIOUS QUERY THAT MODIFIED TABLE DATA
IC80693 CDR SYNC -E MERGE FOR A REPLICATE DEFINED WITH WHERE CLAUSE DELETES ROW OUTSIDE OF THE WHERE CLAUSE ON THE TARGET SERVER
IC80707 ONCONFIG PARAMETERS ADDED/MODIFIED/DROPPED AFTER INVOKING ONMONITOR
IC80786 BAD PLAN MIGHT BE CHOSEN WHEN A UDR IS PRESENT IN FILTER LIST
IC80787 SIGSEGV IN EXIT_THREAD CALLED FROM SQFAILREQUEST
IC80799 INVALID MUTEX TYPE CAN HAPPEN WHEN INTERUPTING ONTAPE BACKUP WHILE PROCESSING SMARTBLOB SPACES
IC80860 A TIMESTAMP SHIFT CAN CAUSE ASSERT FAILURE ON SECONDARY DUE TO ROLLFORWARD ERROR WITH ISERRNO=101.
IC80878 USING DB2TYPE.TIME WITH INFORMIX DATETIME HOUR TO SECOND AND GETTING DEFAULT YEAR AND DATE AS WELL
IC81027 KILLING A SESSION WHICH RAN REMOTE STATEMENT LEADS TO THE REMOTE INSTANCE TO COMMIT INSTEAD OF ROLLBACK
IC81030 DBACCESS ON LINUX PRINTS OUT BLANK SCREEN OR GARBAGE CHOOSING A FILE COMING FROM WINDOWS
IC81153 ERROR -9700 RETURNED OPENING A CURSOR WITH HOST VARIABLES
IC81178 ENABLING IFX_FOLDVIEW MAY CAUSE ERROR 206/111 OR 242/102
IC81417 ONSTAT -G RSS VERBOSE MIGHT SHOW AN INCORRECT NUMBER OF PENDING LOG PAGES
IC81451 CDR ERROR COMMAND WITH LEAF NODES CAUSES SYSCDR:CDR_ERRORS TO FLOOD WITH GC OPERATION REVIEW ERROR FAILED: UNDEFINED SERVER MESSAGES
xC9W1 APARs
Description
IC68622 WHEN THERE IS NO MORE ROOM FOR GROWING THE SDS_PAGING FILES, MISLEADING ASSERTION WARNINGS COME UP
IC72025 BATCH UPDATES IN ANSI DATABASE FAILED BECAUSE OF SQLCODE=100
IC75947 CALLING A STORED PROCEDURE THAT CALLS ANOTHER STORED PROCEDURE IN A DIFFERENT DATABASE MAY RETURN ERROR 111 AND 387.
IC76417 QUERY AGAINST DATETIME COLUMN USING VALUE BEYOND LAST BUCKET PRODUCES BAD QUERY PLAN
IC76585 ATTEMPT OF OPENING NON-EXISTING BLOB FILES CAUSING HPL PERFORMANCE SLOWDOWN
IC76732 RALLOC MEMORY GROWS IF YOU TRUNCATE A TABLE AND THEN RUN SELECT ON THIS TABLE WITHIN A FOREACH LOOP IN A STORED PROCEDURE
IC76868 FRAGMENT ELIMINATION DOES NOT OCCUR ON FRAGMENTED PARENT INDEX DURING CHILD TABLE INSERTS
IC77195 OPTIMIZER UNDERESTIMATES THE COST OF SORT OPERATIONS FOR WIDE RESULT SETS
IC77239 -900 AND -8328 ERROR MESSAGE DESCRIPTIONS ARE MISSING FROM THE FINDERR TOOL (ERRMSGTXT FILE)
IC77372 ABNORMAL ALLOCATION OF VIRTUAL MEMORY SEGMENTS WHEN CREATE INDEX ON FRAGMENTED TABLES
IC77400 ASSERT FAILED: READ_RECORD: UNEXPECTED LOG RECORD TYPE
IC77629 THE MAXIMUM NUMBER OF CONNECTIONS ON PAGE_ZERO SHOULD BE RESET DURING HDR/RSS SECONDARY SETUP
IC77716 CDR DS THREADS AND POSSIBLY TRANSACTIONS ABORTING IF NORMAL TRANSACTIONS REPLICATED IN PARALLEL WITH OR SHORTLY AFTER CDR SYNC
IC77718 SEGV CRASH ON PRIMARY IN PROXYWRITEEXECDML WHEN PARTITION BLOBS ARE BEING MODIFIED.
IC77721 PREPARED CREATE TABLE STATEMENT LEADS TO MISSED INDEX ENTRY IN SYSINDICES AFTER RUNNING IT MULTIPLE TIMES
IC77722 AFTER FAILOVER OF SECONDARY TO PRIMARY, TEMPORARY SBSPACE IS UNUSABLE
IC77723 CORRELATED SUBQUERY OPTIMIZER COST MAY BE CALCULATED TOO LOW, RESULTING IN SLOW PERFORMANCE
IC77725 CDR SYNC/CHECK COMMAND MAY HANG WHEN SYNC TARGET PARTICIPANT LIST HAS BOTH HUB AND LEAF SERVER
IC77729 A SELECT STATEMENT USING SUBSTR ON MULTI-BYTE STRING MAY CRASH THE SERVER IN GL_ISBMSTERM() FUNCTION.
IC77732 SELECT WITH MATCHES ON A MULTI-BYTE CHARACTER DOES NOT RETURN ANY ROW EVEN IF ROWS EXIST THAT MATCH THE CONDITION.
IC77736 CONNECT BY (HIERARCHICAL) QUERY EXECUTED WITHIN STORED PROCEDURE CAN LEAD TO ERROR 1214
IC77745 ASSERTION FAILURE IN ROWALTER WHEN USING COMMITTED READ LAST COMMITTED AND VARCHAR ROW ALTERED PREVIOUSLY
IC77762 STORED PROCEDURES CAN SEGV IN DECCVASCINT AND CHARCMP
IC77763 INTERMITTENT -691 ERRORS WHEN USING TIME-BASED EXCLUSIVE REPLICATE SETS
IC77780 MEMORY CORRUPTION WHEN A XA TRANSACTION IS HEURISTICALLY ROLLED BACK
IC77804 TODAY VALUE IS DIFFERENT WITH SELECT AND INSERT STATEMENTS IN SPL
IC77812 BACKUP/RESTORE WITH BAR_PERFORMANCE SET ON 32-BIT PLATFORMS, XFER STATS ARE INCORRECT
IC77852 ERROR -768 IN ROUTINE OPJOIN FROM STATEMENT WITH NESTED EXISTS CLAUSES AND ANSI JOINS
IC77864 ONTAPE ARCHIVE WITH BACKUP_FILTER AND TAPEDEV SET TO A REMOTE HOST HANGS
IC77876 MEMORY LEAK OBSERVED WITH DYNAMIC ROUTINE-NAME SPECIFICATION
IC77891 A STORED PROCEDURE CREATED BEFORE AN UPGRADE RETURNS 26060 OR 26061 WHEN RUNNING IN MULTIPLE SESSIONS AT THE SAME TIME
IC77892 RSS SECONDARY IS NOT ALWAYS MARKED AS DISCONNECTED ON MACH11 PRIMARY IN CASE OF NETWORK FAILURE
IC77902 FRONT END ERROR -25587 CAN BE SEEN WHEN RUNNING MANY SQL UNLOADS IN PARALLEL ON HIGH SPEC MACHINE (AIX P7)
IC77918 ASSERT FAILURE WHEN MULTIPLE UPDATE STATISTICS COMMANDS ARE RUN AGAINST THE SAME DATABASE
IC78237 ON SLA REDIRECTION CM DOES NOT ATTEMPT TO CONNECT TO A GOOD ALIAS IF FIRST ONE IS BROKEN
IC78238 CM REDIRECTS FROM PRI SLA TO RSS INSTANCE IF IT CANNOT CONNECT TO PRIMARY AT STARTUP
IC78270 TABLE REPACK SHOULD NOT FAIL AT AN EMPTY TABLE
IC78273 AFTER ADDING NEW AND DROPPING EXISTING LOGICAL LOGS AN ONBAR LOGICAL LOG BACKUP CAN FAIL WITH ERROR -284
IC78369 THE ENGINE WILL CRASH IN FNSUBSTR() IF AN ILLEGAL CHARACTER IS FOUND IN GP_MBSNBYTE()
IC78371 EXECUTING A REMOTE PROCEDURE INVOLVING SELECT INTO TEMP FAILS WITH ERROR 556
IC78373 MAIN_LOOP THREAD SPINNING IN SAFE_DSKFLUSH CAN CAUSE OTHER THREADS TRYING TO FLUSH BUFFER TO HANG
IC78378 ERRORS -9791/-9969 FROM STORED PROCEDURES USING COLLECTION TYPES AS PARAMETERS AND RETURN VALUES
IC78407 SYSMASTER TABLE SYSLOWMEMORYMGR IS NOT CREATED WHEN UPGRADE FROM 11.50.X TO 11.50.FC9
IC78555 HIGH ACTIVITY ON SYSPROCPLAN AFTER UPDATE STATISTICS ON TABLES
IC78557 BTREE SCANNER FAILS CLEANING DIRTY PAGES IN ALICE MODE
IC78576 DEADLOCK CAN OCCUR BETWEEN BTSCANNER AND SQLEXEC THREAD THAT IS ROLLING BACK
IC78577 SERVER WILL NOT INITIALIZE IF DS_HASHSIZE IS MISCONFIGURED IN THE ONCONFIG FILE
IC78600 CDR DEFINE SERVER RETURNS INCORRECT ERROR 47 WHEN GLOBAL CATALOG SYNC IS ABORTED DUE TO NETWORK FAILURE WITH MASTER NODE
IC78633 ONBAR BACKUP TO NETWORKER STORAGE MANAGER CAN LEAD TO MULTIPLE COPIES OF IDS (0:1, 0:2, ...) STORED IN SYSUTILS AND IXBAR
IC78634 ERROR -768 IN OPJOIN() EXECUTING STATEMENT USING VIEW WHEN IFX_FOLDVIEW IS USED
IC78693 SESSION MEMORY MAY LEAK IF UDR IS CALLED WITH OMITTED ARGUMENT AND IF THAT ARGUMENT IS SET TO BE NULL BY DEFAULT
IC78750 SOMETIMES HDR SECONDARYS NON-TEMP SPACE CHUNKS SHOW PO FLAGS INSTEAD OF PI AFTER PRIMARY AND SECONDARY SWITCH
IC78752 ONSTAT -G RSS SHOWS LOCAL SERVER TYPE AS STANDARD AFTER A RSS SERVER HAS BECOME PRIMARY OF THE CLUSTER
IC78809 ONSTAT -G RSS SHOULD DISPLAY STANDARD INSTEAD OF PRIMARY WHEN SERVER IS INITIALIZED
IC78923 SQLEXEC THREAD CAN HANG ON CPU VP WHEN CLIENT CONNECTION TERMINATES ABNORMALLY WITH OPEN DISTRIBUTED TRANSACTION AND SYSDBCLOSE
IC78924 ERROR -285 INVALID CURSOR RECEIVED BY SQLEXEC IF SCROLL CURSOR AND REGULAR CURSOR WITH SAME SQL STATEMENT AND STMT_CACHE IS SET
IC78942 RSS STOPS TO APPLY LOGICAL LOGS WITHOUT ANY ERRORS OR WARNINGS IN THE IBM INFORMIX SERVER MESSAGE LOG
IC78943 CURSOR WITH HOLD ON TABLE REMOVED BY TRANSACTION ROLLBACK ABENDS SERVER
IC79050 INCORRECT BEHAVIOR WITH EXTERNAL TABLE WHEN STRING CANNOT BE FULLY CONVERTED INTO AN INTEGER, ERROR 1213 SHOULD BE THROWN
IC79092 ONBAR PROCESS HANGS IF CLEANUP FUNCTION FOR PERFORMING ARCHIVE RECEIVES INTERNAL DEADLOCK ERROR
IC79115 DBEXPORT DOES NOT GENERATE OWNER FOR UPDATE STATISTICS
IC79116 ONBAR POINT IN TIME RESTORE BUILDS A WRONG LIST OF THE OBJECTS TO RESTORE
IC79117 ASSERT FAILURE CRASH IN BUFFGET()
IC79137 WRONG BITMAP PAGE OVER THE RANGE OF NPUSED RESULTS IN MISLEADING ASSERT FAILURE
IC79138 ONCHECK DOES NOT DETECT CERTAIN BITMAP CORRUPTION
IC79314 A SELECT COUNT(*) FROM A VIEW WITH UNION ALL LEADS TO AN ASSERT FAIL IN HJOIN_OPEN WHEN IFX_FOLDVIEW IS SET TO 1
IC79315 SYSADMIN TASKS CAN ABEND SERVER IN FUNCTION REMGREPLY
IC79493 11.50.XC9 CRASH WITH MEMORY FREED TWICE IN UDR_SAPI_CLEANUP()
xC9 APARs
Description
IC64903 SERVER CRASHES ON LINUX IF YOU TRY TO LOAD THE JAVA VM AND THE ONCONFIG PARAMETER JVPJAVAVM IS SET TO THE WRONG VALUE
IC65267 DOC: PROVIDE AN EXAMPLE CONCSM.CFG FILE AS CONCSM.CFG.TXT IN $INFORMIXDIR/ETC
IC65558 INCORRECT ERROR MESSAGE RETURNED FROM DBACCESS WHEN SB_CHECK_FOR_TEMP IS SET TO 1
IC66182 ENCRYPT_MACFILE OVERFLOW IN ONCONFIG ASSERT FAILS THE ENGINE AT STARTUP
IC67610 [WIN] NTCHNAME DOES NOT UPDATE ALL HOSTNAME OCCURENCES IN WINDOWS REGISTRY
IC68020 LONG TRANSACTION NOT RECOGNIZED AFTER LOGICAL LOG WAS DROPPED
IC68056 EVIDENCE.SH DOES NOT EXPAND VARIABLE PARAMETERS FROM ONCONFIG FILE AND CAN CAUSE SHARED MEMORY DUMPING TO FAIL
IC68160 ONTAPE -L CORRUPTS SECONDARY
IC68758 SBLOB LOCK PROMOTION DOES NOT WORK
IC68957 SEVERE PERFORMANCE PROBLEM CAUSED BY PROMOTING SBLOB LOCKS TO PARTITION LOCKS
IC69128 CONNECTION MANAGER NEEDS THE ABILITY TO DISTRIBUTE TO A SPECIFIC SERVER (OR SET OF SERVERS) OF THE SAME PROTOCOL
IC69158 ALARMPROGRAM CALLED WITH EMPTY EVENT_MSG FOR LOGICAL LOG FULL EVENT
IC69177 GRANT DEFAULT ROLE TO USER GIVES RESOURCE PRIVILEGES
IC69182 MISSING ALARMPROGRAM ALARMS SOMETIMES WHEN THREAD HAS MIGRATED VPS WHILE ISSUING THE ALARM
IC69783 ON WINDOWS, ALARMPROGRAM DOES NOT WORK CORRECTLY WITH COUNTRY SPECIFIC DATE AND TIME DELIMITERS
IC70027 SESSION CAN HANG ON PROXYSESS CONDITION WHEN EXECUTING AN UPDATE ON AN UPDATEABLE SDS NODE
IC70155 ONSPACES GIVES INCORRECT WARNING: $INFORMIXDIR/ETC/$ONCONFIG CANNOT BE ACCESSED IF CPU AFFINITY SET TO INVALID RANGE OF CPUS
IC70212 GET 330 AND 100 ERROR WHEN TRY TO CREATE A NEW DATABASE BY CONNECTION MANAGER IN CLUSTER ENVIRONMENT
IC70500 ALARMPROGRAM PUTS VALUE FOR EVENT_MSG WITHIN QUOTATION MARKS WHICH LEADS TO INVALID CALL OF MAILUTILITY NTMAIL
IC70533 CHECKPOINT HISTORY (ONSTAT -G CKP) TRIGGER EVENTS SHOULD BE CLEARLY DESCRIBED IN DOCUMENTATION
IC70537 ONSTAT -G STK NOT WORKING ON ZLINUX
IC70777 USING A SCHEMA FILE GENERATED BY DBEXPORT OR DBSCHEMA CAN LEAD TO ERROR -206/-111
IC70782 ALARMPROGRAM.BAT MAKES EACH LINE IT SAVES IN .ALARM FILE BIGGER BY ONE SPACE SYMBOL ON WINDOWS PLATFORM
IC70971 GETTING -9996 ERROR WHEN TRYING TO CREATE A NEW DATABASE BY CONNECTION MANAGER IN CLUSTER ENVIRONMENT
IC70980 GETTING A -27009 ERROR WHEN TRYING TO DROP A NON-EXISTENT DATABASE IN DATABASE CLUSTER WITH GROUP MODE
IC71059 WRONG SELECT PERMISSIONS FOR VIEWS REFFERING TO TABLES IN ANOTHER DATABASE
IC71131 THE OPTIMIZER CHOOSES AN INCORRECT QUERY PLAN AFTER CHANGING AN INDEXED COLUMN TO A USER-DEFINED TYPE (UDT)
IC71395 ONSTAT -Z DOES NOT RESET COUNTERS FOR Q-EXCEED IN ONSTAT -G NT(U,T,A) OUTPUT
IC71436 EVIDENCE.SH SCRIPT DOES NOT CREATE SHARED MEMORY DUMP FILE IN DUMPDIR
IC71696 AUS EVALUATOR FAILS SPORADICALLY WITH ERRORS 254 AND 154 AFTER HDR INITIALIZATION
IC71697 A SINGLE CDRNS THREAD RUNS INEFFICIENTLY WHEN ENCRYPTION IS TURNED ON WITH MULTIPLE CRYPTO VPS DEFINED
IC71702 POOR PERFORMANCE OF ONBAR QUERY TO GET THE USED SIZE OF A DBSPACE EVEN WITH INDEX SCAN
IC71713 FUNCTIONALITY OF BUILT-IN TASK ALERT CLEANUP DOES NOT CORRESPOND TO DOCUMENTATION
IC71832 ONINIT -W ON WINDOWS SIMPLY RETURNS WHETHER IT FAILS OR NOT
IC71843 WILD CARD % AT THE BEGINNING OF QUERY AGAINST UFT8 IS EXTREMELY SLOW IF SEVERAL MATCHES FOUND
IC71852 INSERT CAN FAIL WITH -211 DUE TO CHANGED BEHAVIOR WITH DIRTY READ ISOLATION LEVEL
IC71945 FUNCTION USER DOES NOT MAKE USE OF CODE PAGE CONVERSION
IC71972 AUTO UPDATE STATISTICS IS ENABLED DURING A MINOR IDS VERSION UPGRADE (FROM 11.50.FC6W2 TO 11.50.FC7X3)
IC71973 AN ASSERT FAIL CAN BE OBSERVED WITH A SELECT FROM A DERIVED TABLE.
IC72023 ALTER FRAGMENT ATTACH RECREATES INDEXES ON ATTACHED FRAGMENTS
IC72110 SECONDARY CAN SOMETIMES FAIL IN RECOVERY WHEN TRYING TO COME INTO STANDARD MODE WITH ASSERT FAILED ROLLBACK ERROR 0 WHEN RECOVER
IC72113 OPTIMIZER CHOOSES INAPPROPRIATE KEY-FIRST SCAN WHEN JOIN INCLUDES SMALL TEMP TABLE ON A VERY SIMPLE SELECT STATEMENT
IC72114 IT IS POSSIBLE TO UPDATE FLOAT COLUMNS TO OUT OF RANGE VALUES WHICH CAUSES DBIMPORT AND LOAD TO FAIL WITH ERROR -1223
IC72116 ONLOAD OF DATABASE WITH DISABLED INDEX OR CONSTRAINT FAILS OR LOADS BAD DATA
IC72257 REMOTE SPL EXECUTION SHOULD ONLY BE ALLOWED IN RESTRICTED MODE FOR USER WITH APPROPRIATE REMOTE PRIVILEGES
IC72258 ONCHECK -PR MIGHT ABORT WITH SEGMENTATION FAULT
IC72259 SYNTAX ERROR (-201) FOR CDR DEFINE SERVER IF DISK INITIALIZATION OR SYSMASTER CREATION HAD OCCURRED WITH DELIMIDENT
IC72274 CANNOT REPLICATE A TABLE WITH UPPER CASE LETTERS IN TABLE OR COLUMN NAMES
IC72298 DURING A BACKUP ISM REPORTS A MEDIA NOTICE FILE DISK IS FULL
IC72300 ON LINUX SECURITY_LOCALCONNECT SET TO 1 OR 2, CAUSES ONTAPE RUN AS USER INFORMIX TO GENERATE -952 ERRORS CONNECTING TO DB
IC72372 DBEXPORT USING IDS 11.50.XC8 OR ABOVE IS SLOWER THAN DBEXPORT USING IDS 7.31.
IC72375 ERROR 747 RETURNED ON A REMOTE DDL STATEMENT AFTER RUNNING SPL THAT EXECUTES TRIGGERS ON THE SAME TABLE.
IC72392 CHECKPOINT HANG POSSIBLE ON HDR PRIMARY DURING INITIAL EXCHANGE WITH SECONDARY
IC72394 [WIN] UPGRADE TO 11.50 PID RESETS ONCONFIG PARAMETER MIRROR TO DEFAULT VALUE 0
IC72455 SDS FAILOVER REPORTS -244/-107 IN ONLINE.LOG ON DELETE FROM SDS_TAB
IC72532 LEFT OUTER JOIN IS SLOWER THAN OUTER JOIN
IC72533 RUNNING CERTAIN STATEMENT MIX WITH PDQ CAUSES AF CRASH WITH DIFFERENT STACKS.
IC72534 SDS NODES IN SDS CLUSTER WILL BE IN INCORRECT STATUS AFTER NETWORK WAS BROKEN FOR A WHILE
IC72536 CREATING A BTS INDEX IS MUCH SLOWER IN 11.50.XC6/XC7 THAN IN 11.50.XC5 AND EARLIER VERSIONS
IC72538 WIN32: RETURN CODE TYPE MIS-MATCH BETWEEN LIBTXBSA AND ONBAR CAUSES ONBAR BACKUPS WITH TSM TO FAIL
IC72582 SPURIOUS MESSAGE IN ONLINE.LOG IF RSS CONNECTIVITY ISSUE
IC72585 RESULTS FROM A REMOTE QUERY WITHIN A STORED PROCEDURE ARE TRUNCATED IF UPDATE STATISTICS IS RUN ON REMOTE TABLES
IC72618 EXECUTE FUNCTION TASK() MAY CAUSE MEMORY OVERRUN ON WINDOWS
IC72619 11.50 UPGRADE RTREE CONVERSION FAILS WITH AF IN CONVERTSM IF CLIENT_LOCALE AND DB_LOCALE WOULD RESULT IN A -23101 ERROR
IC72621 SQL STATEMENT SET ENCRYPTION PASSWORD CAN CORRUPT MEMORY
IC72634 CDR DEFINE REPLICATE FAILS WITH SQL CODE -1215 IF TABLE HAS MORE THAN 2147483647 ROWS
IC72636 SESSION WITH PDQ AND SELECT STATEMENT WITH SUBQUERY HANGS WHEN QUERY IS FROM A VIEW
IC72638 ONCHECK -PP DOES NOT SHOW SLOT INFORMATION IF NUMBER OF SLOTS IS GREATER THAN 255
IC72651 -272 FOR REMOTE SELECT FROM SPL THOUGH SELECT PRIVILEGE GRANTED THROUGH ROLE
IC72665 WINDOWS 64-BIT: SHARED MEMORY ALLOCATION FAILURE LEADING TO REALLOCATION OF VIRTUAL SEGMENT
IC72672 SELECT FROM A VIEW WHICH CONTAINS CASE WHEN ....ELSE...END RETURNS INCORRECT RESULT: TRUNCATED VARCHAR
IC72675 RETURN INCORRECT RESULT WHEN RUN A FUZZY SEARCH WITH WILDCARD CHARACTER IN CHINESE LOCALE
IC72676 DELAYED EXECUTION OF ONSTAT - POSSIBLE WHEN MANY GROUPS EXISTS ON THE SYSTEM
IC72680 QUERY USING INDEX PATH TAKES MUCH LONGER THAN SEQUENTIAL SCAN
IC72683 DBIMPORT OF DATABASE WITH BTS DOES NOT CREATE BTS INDICES ON AIX
IC72684 DBEXPORT/DBIMPORT BETWEEN DIFFERENT PLATFORMS OR VERSIONS DO NOT WORK FOR DATABASES WHERE BTS IS REGISTERED
IC72685 DBIMPORT OF DATABASE WITH BTS REQUIRES LOGGING FOR CREATING BTS INDICES
IC72772 MIGRATION FROM IDS 10.00 TO 11.50 ASSERT FAILS WITH ERROR 211 WHEN UDR REFERENCES A DATA TYPE THAT DOES NOT EXISTS.
IC72790 ASSERTION FAILURE WHEN SELECTING FROM A VIEW WHOSE DEFINITION INCLUDES A SELECT FROM ANOTHER VIEW IN ITS PROJECTION LIST
IC72792 SCHEDULER THREADS CANNOT START WITH START.SQL, EVEN IF STOP FILE IS REMOVED AFTER ENGINE COMES ONLINE
IC72794 ENGINE HANGS IN HDR ENVIRONMENT WHILE ASSERT FAILING
IC72796 ANY ATTEMPT TO ACCESS A TABLE AFTER RENAMING ITS COLUMN THAT HAS A CHECK CONSTRAINT WITH CAST (::) OPERATOR GIVES THE ERROR -676
IC72804 ERROR 213 FROM CDR CHECK REPLSET -R (REPAIR) PRINTS HUNDREDS OF LINES OF DASHES
IC72805 NOT NULL CONSTRAINT IGNORED WHEN UPDATE TRIGGER CALLS PROCEDURE TO PERFORM INSERT
IC72806 DROPPING A PRIMARY KEY COLUMN AND RECREATING PRIMARY KEY IN SAME ALTER STATEMENT CAUSES SERVER ABEND
IC72913 INCORRECT RESULTS WHEN ACCESSING REMOTE DATA IN SPL
IC72915 SQL EXPRESSIONS OF INFORMIX OUTER JOINED SUBQUERY OR VIEW APPLIES TO JOIN RESULT RATHER THEN SUBQUERY
IC72917 ISQL CRASHES DB WHEN GATEWAY SYNONYM IS SELECTED IN INFO
IC72918 CDR CHECK FAILS WITH SQL ERROR 195
IC73095 EXECUTING A STORED PROCEDURE RESULTS IN OPTIMIZER EXCEPTION ERROR 874 AND ASSERTION FAILURE ON LINUX.
IC73107 SELECT WITH WILD CARD MATCHING USING KOREAN LOCALE CAN CRASH THE SERVER IN RPERFWILDMATCH FUNCTION.
IC73108 THE ENVIRONMENT VARIABLE IFX_SMX_TIMEOUT IS UNDOCUMENTED.
IC73131 IN ASEERTION FAILURE FILE, WHEN REGISTERS ARE DUMPED OUT, THE VALUES ARE INCORRECT ON HP-UX
IC73133 DISTRIBUTION CACHE ON SECONDARY HAS NOT BEEN CLEANED AFTER UPDATE STATISTICS ON PRIMARY
IC73140 MISLEADING NO MEMORY ERROR IN ONLINE.LOG TRYING TO RUN CDR LIST SERVER DURING CDR QUEUER INITIALIZATION
IC73142 MULTIPLE DBEXPORTS RUNNING CONCURRENTLY WILL RESULT IN LOCKING ERRORS ON SYSHA_TYPE & SYSPTNKEY.
IC73191 ASSERTION FAILURE POSSIBLE IN VII_INSERT_LEFTOVER DUE TO ACCESS OF ALREADY FREED MEMORY
IC73192 SELECT VIEW WITH OUTER REMOTE VIEW IS SLOW
IC73265 THE IMPLICIT CAST IN THE STORED PROCEDURE DOES NOT WORK CORRECT AT THE FIRST TRIGGER CALL.
IC73268 CDR SYNC REPLICATE AND CDR REALIZE TEMPLATE FAILS WITH RC=1280 IF ENGINE STARTED WITH SHARED MEMORY CONNECTION
IC73295 STATEMENTS ARE NOT CACHED WHEN STATEMENT HIT COUNT EXCEEDS STMT_CACHE_HITS
IC73298 FILETOBLOB INSERT INTO RETURNS ERROR 217 IF THE OPTIONAL TABLE OR COLUMN PARAMETERS ARE NOT SPECIFIED
IC73338 ERROR 9791 AND SEGV IN NEXTRANGE() WITH INSERT ... SELECT STATEMENT ON SYNONYM
IC73344 QUERY RUN FROM SYSUTILS FAILS WITH ERROR 9753 AFTER REVERTING FROM 11.50.FC8 TO 11.50.FC5.
IC73346 MEMORY CORRUPTION AF CRASH WHEN CREATING/DROPPING INDEXES ON TEMP TABLE USING PREPARED STATEMENTS
IC73439 GSKIT INSTALLATION SCRIPT RESETS THE $PATH VARIABLE AND HENCE CAN FALL INTO AN ENDLESS LOOP
IC73440 BTS QUERY FAILS WITH ERROR BTSB0 WHEN THE SEARCH TERM CONSISTS OF MORE THAN 1024 KEYS
IC73442 PERFORMANCE PROBLEM WHEN A TEMPORARY TABLE IS CREATED AND DROPPED WITHIN A LOOP AND WITHIN A TRANSACTION.
IC73443 IN CLAUSE CONTAINING SUBQUERY THAT RETURNS MANY ROWS SLOWER COMPARED TO 10.00
IC73455 RSS SECONDARY DOES NOT SYNC AFTER THE FLIP OF PRIMARY AND RSS SECONDARY
IC73468 QUERY USING OUTER JOIN OF REMOTE TABLES RETURNS ERROR -769
IC73563 ONLINE.LOG REPORTS ERROR -214 AND -107 WHEN IDS WAS BROUGHT ONLINE
IC73640 WRONG RESULTS POSSIBLE FOR SQL QUERY WITH JOIN, LIKE WITH WILDCARD AND A SPECIFIC INDEX USED
IC73671 TK_NEXT_EXECUTION WAS SET ON A DATE THAT WAS NOT SCHEDULED TO DO WORK
IC73675 SQL ERROR -346/-240 FROM UPDATE/DELETE STATEMENT WHEN THE TABLE HAS A FUNCTIONAL INDEX
IC73684 IFXPAMAUTHENTICATE() RUNS ON MSC VP LEADING TO CONERR -930 FOR REMOTE CONNECTIONS
IC73690 WHILE CHECKING A BLOBSPACE THE ONCHECK -PE COMMAND MAY REPORT A REFERENCE TO AN INVALID TBLSPACE
IC73766 INSERTING INTO A TEMP TABLE IN AN ANSI DATABASE ON AN HDR SECONDARY GETS SQLCODE 100
IC73798 LINUX: INFORMIX SERVER MAY CRASH WITH STACK OVERFLOW ASSERTION FAILURE IN CREATE VIEW COMMAND WITH LOTS OF UNION CLAUSES
IC73808 RUNNING ONMODE -D MAKE PRIMARY DBSERVERNAME FAILS TO START DBSCHEDULER
IC73809 TRUNC() AND ROUND() BUILT-IN FUNCTIONS MIGHT RETURN ERROR -1260 IF THEIR FIRST ARGUMENT IS NVARCHAR
IC73845 WINDOWS: WSTATS DOES NOT COLLECT STATISTICS FOR THREADS IN READY STATE
IC73910 ERRONEOUS TAPESIZE/LTAPESIZE MODIFIED MESSAGE IN ONLINE.LOG
IC73918 ASSERTION IN FREE_POOLS() WHEN MORE THAN ONE SORT FILE EXISTS AND THE PROCESS WAS STOPPED OR FILE SYSTEM BECAME FULL
IC73921 RUNNING JAVA PROC RETURNS ERROR -9431 ON WINDOWS: CANNOT FIND SYSTEM CLASS OR METHOD OR LIBRARY
IC73985 SOMETIMES, AFTER ONMODE -F, REMOVED SEGMENTS ARE LEFT ATTACHED TO AN ONINIT VP -- CAUSES SHMAT 22 ERRORS WHEN ADDING NEW SEGS
IC73986 DBIMPORT STATEMENTS CANNOT RUN IN PARALLEL BECAUSE OF LOCKS ON SYSDBSPACES
IC73987 EXTENT SIZE DOUBLING DOES NOT WORK CORRECTLY.
IC73989 RUNNING HPL TO UNLOAD A TABLE MAY TRADE AN ESCAPED SPACE TEXT COLUMN VALUE FOR NULL
IC73991 RUNNING UPDATE STATISTICS MEDIUM AND HIGH RESULTS IN A SLOWER QUERY PLAN THAN RUNNING UPDATE STATISTICS LOW OR DROP DISTRIBUTION
IC74045 READ AHEAD IN SINGLE_CPU_VP MODE CAN CORRUPT LRU QUEUES
IC74057 SELECT ROW VARIABLE WITH ASTERISK(*) NOTATION IN STORED PROCEDURE FAILS WITH ERROR -9791 AT REPEATED EXECUTION
IC74064 COMPLEX QUERY RETURNS -874 AND AF IN HASSUBQ()
IC74065 ALLOW ONPLOAD TO BE ABLE TO UNLOAD DATA ON SECONDARY SERVER OF A CLUSTER
IC74068 INCORRECT DESCRIPTION GIVEN FOR COLUMNS NIF_STATE AND NIF_CONNSTATE FOR THE SYSCDR_NIF TABLE
IC74069 ONTAPE AND ONBAR RESTORE MAY CREATE SPARSE FILES WHEN RESTORING TO COOKED CHUNKS
IC74124 SELECT QUERY WITH MULTIPLE OUTER JOINS CAUSES AN INFINITE LOOP
IC74125 DBSA USERS ARE NOT ABLE TO EXECUTE SQL ADMIN API FUNCTIONS
IC74133 -25573: OSERR = 0: ERRSTR = : NETWORK DRIVER CANNOT ACCEPT A CONNECTION ON THE PORT USING ONIPCNP NAMED PIPE CONNECTION TYPE
IC74139 SUPP_GIDS ARRAY STORED IN SCB_T AND AIO_USER_T STRUCTURES IS VERY LARGE ON LINUX PLATFORM
IC74163 IF YOU INTERRUPT CREATE DATABASE STATEMENT, SUBSEQUENT CREATE DATABASE STATEMENT GET 9996 ERROR
IC74166 USER WITH CONNECT PRIVILEGE CAN CREATE/DELETE A SEQUENCE OBJECT, BUT RECEIVES ERROR -388 WHEN HE TRIES TO ALTER IT
IC74179 VALUES FOR THE ONCONFIG PARAMETER RSS_FLOW_CONTROL AT 2G AND ABOVE DO NOT WORK PROPERLY
IC74219 EXECUTING STORED PROCEDURE THAT INSERTS INTO A COLLECTION CAN ASSERT
IC74228 JVP ABORTS DURING JAVA UDR EXECUTION WHEN USING LATVIAN (LV_LV.1257) LOCALE
IC74259 REWRITE ANSI INNER JOIN QUERY INSIDE DERIVED TABLE/VIEW
IC74262 UNABLE TO SYNC TABLE WHEN REPLICATE DEFINITION HAS SUBSCRIPT FOR PRIMARY KEY COLUMNS
IC74289 OPTIMIZER CHOOSES SLOW PATH FOR SELECT ON VIEW WITH SINGLE TABLE, THAN SELECT ON THE TABLE DIRECTLY CAUSING SLOW QUERY RUNTIME
IC74305 JAVA UDR SHOULD SUPPORT KO_KR.CP_949 LOCALE.
IC74308 ERROR -9750 WHEN EXECUTING A SPL FUNCTION USING A PREPARED EXECUTE PROCEDURE STATEMENT
IC74324 ASSERTION FAILURE IN LOGUNDO WHEN ROLLING BACK A TRANSACTION THAT HAS IN PLACE ALTERS INVOLVED ON THE TABLE AND PAGE BEING MODIFIED
IC74326 SYSALARMPROGRAM CAN HANG (POSSIBLY WHOLE INSTANCE) IF IT CONTAINS COMMANDS INTERACTING WITH THE ENGINE
IC74328 ONSTAT -G CDR CONFIG DOES NOT CONTAIN CDR_ALARMS INFORMATION
IC74329 RESULTS OF TRYING TO CREATE A TEMP TABLE INSIDE A STORED PROCEDURE OR FUNCTION ARE INCONSISTENT
IC74368 IT IS NOT DOCUMENTED THAT WBLADEMGR.EXE REQUIRES .NET FRAMEWORK > 1.1 TO BE INSTALLED IN ORDER TO WORK PROPERLY
IC74373 THE LOCATION OF MICROSOFT WINDOWS SNMP AGENT ONSRVAPD.EXE ON WIN 64 BIT PLATFORM IS NOT DOCUMENTED.
IC74455 INCORRECT ERROR MESSAGE FROM CDR DEFINE SERVER WHEN CLOCKS ARE OUT OF SYNC.
IC74482 UPDATE ON SECONDARY HANGS WITH KOREAN TABLE AND COLUMN NAME UNDER DB_LOCALE=KO_KR.CP_949
IC74486 IDS CHOOSES INDEX SELF JOIN AND THAT IS VERY SLOW
IC74487 AUS REFRESH RETURNS ERROR -1215
IC74488 I/O BAD REQUEST CHUNK , PAGENUM , PAGECNT 1 POSSIBLE ON INVALID ARCHIVE RESERVED PAGE
IC74492 RENAMED CHUNK RESTORE FLAGS CHUNK OVERLAP IN ERROR WHEN USING SYMBOLIC LINKS TO SAME DEVICE
IC74494 CDR REJECTS ROWS WITH ERRORS -391/-239 WHEN TARGET TABLES HAVE DEFINED TRIGGERS. CDR CHECK INSERTS REJECTED ROWS WITHOUT ERRORS.
IC74497 THE MAXIMUM NUMBER OF DATABASES THAT CAN BE OPENED IN A SESSION SHOULD BE DOCUMENTED
IC74518 INSTALLING IN DOMAIN IS STUCK IN REPEATING PASSWORD COMPLEXITY WINDOW
IC74519 A PROCEDURE WHICH STORES A REMOTE SELECT RESULT INTO A TEMP TABLE STORES GARBAGE ON MULTIPLE EXECUTIONS IF PDQ IS ENABLED
IC74520 WHEN THE GROUP INFORMIX-ADMIN ALREADY EXISTS, TWO UNNECESSARY ERROR MESSAGE BOXES ARE DISPLAYED DURING INSTALLATION
IC74521 READ_RECORD: DECOMPRESS_ROW ASSERTION FAILURE SELECTING FROM A TABLE USING COMMITTED READ LAST COMMITTED ISOLATION LEVEL OPEN IN-PLACE ALTER
IC74526 UNABLE TO DROP DATABASE WITH TABLES HAVING COLUMNS OF COLLECTION(LIST) DATA TYPE. THE DROP COMMAND SEEMS TO HANG.
IC74542 INTERRUPTED LOAD LEAVES ORPHANED SESSION WHICH USES 100% OF ONE CPU VP
IC74543 THE START TIME IN THE IXBAR OF NON-ROOT DBSPACES IN A PARALLEL WHOLE SYSTEM BACKUP IS NOT THE SAME AS THE START TIME OF THE ROOT
IC74611 DELETE WINS CONFLICT RESOLUTION INCORRECT MESSAGE IN ATS/RIS WHEN DELETE / UPDATE CONFLICTS
IC74626 CORRELATED SUBQUERY THAT RAN FINE IN 9.40 IS HANGING OR NEVER RETURNING IN 11.50; ESTIMATED COST IS VERY HIGH
IC74628 INDEX CORRUPTION AND WRONG RESULTS WITH NULL OR EMPTY STRING VALUES IN NVARCHAR FIELDS
IC74664 FEA: THE MAXIMUM NUMBER OF DATABASES THAT CAN BE OPENED IN A SESSION SHOULD BE INCREASED, CURRENT LIMIT IS 8
IC74667 THE SYSDBCLOSE() PROCEDURE DOES NOT WORK CORRECTLY IF IT CONTAINS THE CURRENT OPERATOR
IC74668 DYNAMIC DBSERVERALIASES CHANGES WITH ONMODE -P TO START/STOP NEW LISTENER THREAD CAUSING CDR DEFINE SERVER TO FAIL.
IC74700 CONNECT BY QUERY SPORADICALLY ALLOCATES A LOT OF MEMORY AND IS SLOW
IC74702 SELECT COUNT(*) FROM VIEW UNION ALL OF TWO TABLES IS MUCH SLOWER THAN THE SAME QUERY WITHOUT THE VIEW
IC74705 INFORMIX INSTANCE MIGHT CRASH IF THE ALTER TABLE DROP CRCOLS IS RUN ON A TABLE WHICH ALSO HAS IFX_REPLCHECK COLUMN DEFINED
IC74709 SETTING ROLE WITHIN STORED PROCEDURE ON SECONDARY SERVER DOES NOT LEAD TO THE DESIRED RESULT, BUT TO PERMISSION ERROR -213, -214
IC74711 SCHEDULER CANNOT BE STARTED IF SERVER WAS INITIALIZED WITH $INFORMIXDIR/ETC/SYSADMIN/STOP FILE PRESENT
IC74712 IN A PARENT-CHILD CONSTRAINT RELATIONSHIP THE PARENT CAN BE DELETED IF THERE IS A CHILD
IC74716 ADDING A LOG TO THE INSTANCE WILL MAKE ONLOG CRASH
IC74791 GENONCFG FAILS WITH ERROR: DEVICE ... TOO SLOW, UNABLE TO CONFIGURE SYSTEM
IC74792 SELECTING USING A SYNONYM NEEDS A LOT OF READS IN SYSTABLES IF THERE ARE MANY PRIVATE SYNONYMS FOR OTHER USERS
IC74818 CSDK: DEALLOCATE COLLECTION DONE TOO EARLY CAN CAUSE ASSERTION FAILURE OF THE INSTANCE THE CLIENT IS CONNECTED TO
IC74819 INSERT FILTERS MAY NOT WORK PROPERLY IN TABLE LEVEL RESTORE IF SCHEMA HAS SBLOB DATATYPE
IC74820 PARALLEL INDEX BUILD GENERATES ASSERT FAILURE IN RSBLDPIDX() AND THEN ADM VP MAKES ENGINE CRASH
IC74822 SERVER ASSERT FAILS IN DECREFCOUNT ACCESSING A FREED TEMP TABLE DATA DICTIONARY WHEN CLEANING UP A THREAD AFTER XA_CLOSE() CALL
IC74829 TRIM() FUNCTION WITH A PARAMETER GREATER THAN 255 FAILS OR RETURNS WRONG RESULTS
IC74831 DOCUMENTATION ABOUT HDR SYNC UPDATNG SHOULD HAVE A NOTE REGARDING AN ERROR 7350
IC74909 AFTER SDS SECONDARY FAILS OVER TO PRIMARY, IT USES SDS_TEMPDBS INSTEAD OF DBSPACETEMP FOR SORTING
IC74913 SESSION OPENED THROUGH MAXCONNECT CAN APPEAR HUNG IF THE FILETOBLOB(...,CLIENT) FUNCTION WAS USED IN THE SESSION
IC74940 ASSERT FAILURE WHEN A VARIABLE INSIDE OF STORED PROCEDURE HAS UNDEFINED VALUE
IC75015 MEMORY CORRUPTION AFS AND/OR CRASH WHEN A NON-DEFAULT PAGE SIZE SDS_TEMPDBS SPACE IS USED ON SDS NODE
IC75018 OPTIMIZER CHOOSES INDEX SELF JOIN AND PERFORMS POORLY
IC75067 ARCHECKER: TABLE LEVEL RESTORE OF A TABLE WITH SMARTBLOB COLUMNS CAN RESTORE INCOMPLETE OR EMPTY SMARTBLOB DATA
IC75072 RACE CONDITION BETWEEN ONTAPE AND SQLEXEC THREAD CAN CAUSE DEADLOCK ON DBS MUTEX.
IC75074 CASCADING SPL IN TRIGGER FAILS WITH ERROR -674 IN UDR_DETERMINE WHEN MAXOPENDB EQUALS 8 IS REACHED
IC75081 OPTIMIZER DOES NOT ELIMINATE PREDICATE DUPLICATE WITH TODAY FUNCTION
IC75139 QUERY INVOLVING JOIN BETWEEN DERIVED TABLES WITH ONCONFIG PARAMETER IFX_FOLDVIEW SET TO 1 CAN CAUSE ASSERTION FAILURE AND CRASH
IC75142 SQL STATEMENT WITH ONE OR MORE REMOTE SUBQUERY(IES) EITHER ASSERT FAILS OR HANGS WHEN PDQ IS SET
IC75145 THE REVOKE EXECUTE ON ... FROM PUBLIC COMMAND RUN FOR A UDR CREATED WITH NODEFDAC=YES RETURNS ERRORS -580/-111
IC75150 AFTER ONMODE -Z OF DBWORKER THREAD ONLINE.LOG FILLS WITH -213 AND -7442 MESSAGES
IC75158 CDR GC ERROR 113 DURING CDR DEFINE SERVER IF THE MASTER NODE HAS A SHADOW REPLICATE FOR AN EXCLUSIVE REPLSET
IC75159 IDS 11.50.FC8W2 INSTALLATION SHOWS AN ERROR ON SOLARIS 64BIT SPARC
IC75185 CERTAIN SQL ADMIN API FUNCTIONS FAIL TO RUN IF ENGINE BROUGHT ONLINE WITH A WORKING DIRECTORY THAT USER INFORMIX CANNOT ACCESS
IC75238 CDRSCN THREAD CAN ABEND IF SYNC SHADOW REPLICATE DELETED UNDER HIM
IC75290 AF WITH BF_DETACH: BUFFER HELD COUNT -1 < 0 AF MESSAGE IN ENOMEM SITUATION
IC75370 THE LOCK MODE (WAIT VS NOT WAIT) IN A REMOTE QUERY CAN CHANGE WITH THE ROW LOCKED IN THE REMOTE TABLE.
IC75371 CDR SYNC PROCESS HANGS WHEN A CDR DELETE SERVER -F IS ISSUED WHILE SYNC IS RUNNING
IC75375 THE SBSPCLEAN THREAD MAY CRASH THE INSTANCE WITH TRANSACTION STILL OPEN - DYNAMIC SERVER MUST ABORT
IC75379 PRCFGTAB() CAN PRINT NEGATIVE CF_EFFECTIVE VALUES FOR DS_TOTAL_MEMORY IF IT IS A LARGE NUMBER
IC75383 THE PERMISSION OF OUTPUT FILE GENERATED BY SYSTEM COMMAND IN STORED PROCEDURE.
IC75388 HDR UPDATABLE SECONDARY NODE - SQL ROLLBACK WORKS UNRELIABLY ON THE SECONDARY NODE
IC75395 QUERY ON REMOTE VIEW FAILS WITH ERROR 934 AFTER THE VIEW IS REDEFINED WITH AN ALTERED STRUCTURE.
IC75457 RUNNING AN HPL PROJECT WITH AN INVALID DIRECTORY DEFINED RETURNS HPL FAILPOINT 10802 ERROR MESSAGE
IC75465 INTERRUPT KEY (CTRL+C) DOES NOT WORK ON ONMONITOR
IC75468 THREAD PRIORITIES CAN GET STUCK AT HIGHER PRIORITIES OF 2 OR 3 RESULTING IN PROBLEMS SUCH AS ENGINE HANGS
IC75536 ENABLING AUDITING WILL CRASH THE SERVER IN AUD_DDGETTABLE WHEN A SYNONYM IS ACCESSED REMOTELY VIA DISTRIBUTED SQL.
IC75546 UNABLE TO ONMODE -D PRIMARY AFTER PHYSICAL RESTORE OF ORIGINAL PRIMARY SERVER FROM SECONDARY BACKUP
IC75547 BLOCK TIME IS ALWAYS ZERO IN THE OUTPUT OF ONSTAT -G CKP
IC75548 ONSTAT -G STM SQL CAN BE PRINTED INCORRECTLY AND CORRUPT OUTPUT
IC75588 INFORMIX OUTER JOINS TAKE SLOWER PATH THAN ANSI OUTER JOINS
IC75589 REQUEST FOR ADDITIONAL INFORMATION FOR PREPARED STATEMENTS, SEEN IN ONSTAT -G STM
IC75590 JAVA UDR CRASH IN _MEMCPY WITH LARGE RETURNING LVARCHAR AND DB_LOCALE SET TO DE_DE.819
IC75629 SOME ONCONFIG PARAMETERS ARE REMOVED AFTER YOU UPDATE VALUES OF PARAMETER BY ONMONITOR
IC75637 XML EXTRACT FUNCTIONS FAIL WHEN XML DATA CONTAINS COLONS
IC75657 ERROR -1213 FROM CHECK CONSTRAINTS ON MONEY TYPES
IC75658 UPDATE STATISTICS HIGH CAUSES THE WRONG QUERY PLAN USING HASH JOIN INSTEAD OF INDEX PATH NESTED LOOP JOIN
IC75677 UPDATE STATISTICS ON TEMPORARY TABLE IN ANSI DATABASE BEHAVES DIFFERENTLY ON HDR UPDATEABLE SECONDARY SERVER COMPARED TO PRIMARY
IC75702 PROCEDURE RETURNING LIST SUBSET DATA TO NULL INSTEAD OF 0
IC75723 MAXIMUM SIZE OF TAPESIZE PARAMETER IS WRONG IN ADMINISTRATORS REFERENCE.
IC75798 THE RETURN STRING FROM A PROCEDURE IS CORRUPTED AFTER CALLING RPAD() ON A VARCHAR DATA TYPE
IC75802 QUERY GIVES 9635 AFTER UPDATE STATISTICS LOW IS RUN FOR THE TABLE
IC75804 THE ONSTAT -G SES MAY HANG IN SHOW_POOLS()
IC75811 COMPLEX QUERY IN SPL CHOOSES A DIFFERENT JOIN ORDER
IC75812 HOST VARIABLES IN A ANSI JOIN SQL DO NOT FOLLOW THE DEFAULT LEFT TO RIGHT ORDER
IC75819 THREAD STACK OVERFLOW AND MEMORY CORRUPTION WHEN GL_USEGLU IS SET
IC75881 INFORMIX IS NOT PROPERLY CHECKING ERRORS AND RETURN CODE STATUS GENERATED FROM LINUX KAIO OPERATION
IC75937 DATASYNC THREAD UNABLE TO DETECT MEMORY ALLOCATION FAILURE WHEN IT TRIES TO EXTEND NUMBER OF LOCKS IN LOCK MANAGER
IC75939 AN INSTALL OVER THE TOP OF A PARTIAL IDS INSTALL FAILS TO INSTALL $INFORMIXDIR/EXTEND/KRAKATOA/JRE
IC75945 SYNCHRONOUS SECONDARY OUT OF SYNC FOR LONG PERIOD WHEN CREATE INDEX ON HUGE TABLE (100GB)
IC75946 CDRGEVAL FAILING IN UDR_EXECUTE() AND POTENTIALLY CRASHING IN UDTCOMP_ERR() IF PRIMARY KEY CONTAINS LVARCHAR
IC75948 MISSING VALIDATION OF SQLHOSTS GROUP IDS LEADING TO VARIOUS UNCLEAR ERROR CONDITIONS
IC75960 IN 11.50.FC8, DBEXPORT SEGV WHEN CODESET CONVERSION IS DONE BETWEEN CS_CZ.8859-2 AND CS_CZ.CP1250
IC75969 REMOTE ACCESS TO BTS INDEXED TABLE AFTER A RESTORE RETURNS ERROR 556
IC75971 A REMOTE QUERY WITH BTS SEARCH WILL LEAD TO REMOTE ENGINE CRASH
IC75991 AFTER UPDATE STATS ON PROCEDURE, IDEAL QUERY NO LONGER USING OPTIMAL PLAN DETERMINED WHEN UPDATE STATS ON TABLE IN PLAN
IC76019 LOCAL CONNECTION MANAGER CREATES PERFORMANCE PROBLEMS WITH REMOTE SYNONYMS
IC76046 FREQUENT RSS ACK TIMEOUT WHEN INDEX LOGGED PAGES WERE TRANSFERRED FROM PRIMARY
IC76047 ERROR -8319 IS BEING DROPPED SPORADICALLY IF SEQUENCE OBJECTS ARE USED IN PROCEDURES
IC76048 WRONG NUMBER OF ROWS RETURNED WHEN FROM CLAUSE CONTAINS SUBQUERY
IC76052 SQLEXEC THREAD TRYING TO COMMIT A 2 PHASE COMMIT TRANSACTION CAN HANG FOREVER WHEN THERE ARE CONNECTION PROBLEMS WITH THE SUBORD
IC76146 INSERTING INTO A FRAGMENTED TABLE WITH PDQPRIORITY ENABLED CAN LEAD TO INDEX CORRUPTION.
IC76167 ASSERT FAILURE IF THE VALUE IN A SUBSCRIPT IS GREATER THAN THE NUMBER OF CHARACTERS WITHIN SINGLE QUOTES
IC76199 PRIMARY SERVER HUNG IN BLOCKED CHECKPOINT AND WAITING FOR MUTEX DRCB_LOCK
IC76207 SQL REPLACE() FUNCTION WITH EMPTY SOURCE STRING CAN ABEND SERVER
IC76319 FEATURE: INFORMIX SHOULD ALLOW UPDATES TO ROWS WITH PARTITION BLOBS IN FRAGMENTED TABLES THAT HAVE REACHED MAX PAGES ALLOCATED
IC76331 WHEN A SEQUENCE IS USED IN A STORED PROCEDURE THAT IS CALLED BY ANOTHER STORED PROCEDURE, IT RETURNS A -8319 ERROR
IC76334 UDR IN FILTER LIST POTENTIALLY EXECUTED REGARDLESS OF OTHER FILTER CRITERIA
IC76453 POOR PERFORMANCE FOR SELF JOIN WITH DISTRIBUTIONS FOR INDEX COLUMN
IC76454 OPTIMIZER CHOOSES SLOW PATH AFTER UPGRADE AND QUERY PERFORMANCE IS MUCH WORSE THAN BEFORE
IC76457 SOCSSL PROTOCOL REPORTING SECURE SOCKETS LAYER GSK ERRORS AND EVEN HANGS UNDER STRESS
IC76460 ASSERT FAIL IN NEXT_SORT() DURING LOW MEMORY CONDITION
IC76500 WIN: SETTING PROCESSOR AFFINITY DOES NOT WORK PROPERLY
IC76530 SERIAL COLUMN INSIDE A SUB-SELECT IS INCORRECTLY DESCRIBED AS NOT NULLABLE
IC76584 Query with IN sub-query returns 284 error
IC76630 WRONG RESULT POSSIBLE IN OUTER JOIN OF REMOTE TABLES WITH ON CLAUSE CONTAINING IS (NOT) NULL CLAUSE
IC76694 SECOND OPEN OF CURSOR GENERATES A -874 ERROR AND AN ASSERTION FAILURE MESSAGE IN MSGPATH FILE WITH SQLEXEC THREAD FAILING IN SETRDKEYFLAG FUNCTION
IC76696 INDEX SORT ORDER PROBLEM WITH NON-PRINTABLES IN NCHAR FIELD
IC76873 PAM AUTHENTICATION CAN ABEND SERVER
IC76874 SERVER HANG WHEN QUERYING VIEW USING UNION AND USING IFX_FOLDVIEW
IC76875 NULLS RETURNED AS -2147483648 INSTEAD OF NULL
IC76877 SELECT QUERY CAUSES AN ERROR -208 OR IDS PANIC
IC76878 ONSTAT -G CKP REPORTS LARGE CKPT TIME
IC76879 HDR SECONDARY SERVER HANGS WHEN SWITCHING STATE FROM SECONDARY TO STANDARD
IC76916 AFTER RUNNING TRUNCATE THE STATEMENT STOPPED USING INDEX THAT WAS USED PREVIOUSLY.
IC77025 CM DOES NOT PERFORM FAILOVER WHEN BOTH PRIMARY AND CONNECTION MANAGER GO DOWN AND ONLY CONNECTION MANAGER COMES BACK UP ONLINE
IC77026 ONTAPE BACKUP TO DIRECTORY WITH FILTER FAILING WILL RETURN WITH BAD EXIT CODE
IC77045 ONCHECK MAY RETURN NEGATIVE VALUE FOR AVERAGE FREE BYTES DUE TO INT OVERFLOW
IC77046 DESCRIPTION MISSING IN DOCUMENTATION FOR AUDIT EVENT CODES AND FIELDS
IC77047 BASIC TEXT SEARCH INDEX DOCUMENTATION DOES NOT DESCRIBE WILDCARD SEARCHES WITHIN THE PHRASE
IC77048 CDR SYNC TASK CAN HANG WHILE PERFORMING SYNC ON A LARGE TABLE IF NETWORK CONNECTION WAS DISCONNECTED AND RECONNECTED
IC77050 QUERY CONTAINING SEVERAL LEFT JOIN OPERATIONS TAKES 20X MORE TIME ON 11.50 THEN ON 9.40 BECAUSE OF A HIGH NUMBER OF BUFREADS
IC77051 DOC - DOCUMENT THE SORT REQUIREMENTS FOR ONCHECK
IC77083 OPTIMIZATION HIGH MODE CAN FAIL TO FIND PLAN WITH LOWER COSTS FOR QUERY WITH MANY TABLES AND MANY FOREIGN KEYS/INDEXES
IC77105 ASSERT FAILURE IN PREPSELECT OPENING CURSOR WITH REOPTIMIZATION
IC77107 UPDATE STATISTICS CAUSES QUERIES USING ROWID TO USE SEQUENTIAL SCAN INSTEAD OF INDEX PATH
IC77129 STRANGE VALUES IN THE OUTPUT OF ONSTAT -P IN %CACHED WRITES FIELD
IC77155 WHEN ONTAPE WAITS ON USER PROMPT IT MUST BE ABLE TO RECOGNISE EOF SYMBOL FROM STDIN
IC77194 INSERT INTO A VIEW WITH CHECK OPTION RESULTS IN -392 IF IFX_FOLDVIEW IS SET
IC77274 UPDATE CAN FAIL IN ROW, BUT SUCCEED IN INDEX IF ON AN AN OLD VERSION ROW WHOSE PAGES PGALTER IS JUST BEING ROLLED BACK
IC77330 CDR CHECK --REPAIR CAN HANG WHEN ROWS ARE MISSING ON TARGET
IC77393 ONBAR ABORTS LOGICAL RESTORE WHEN IT CANNOT ACCESS ROOTDBS BACKUP FROM THE STORAGE MANAGER DURING AN ONBAR LOGICAL RESTORE
IC77511 ASSERT FAILED: EXCEPTION CAUGHT IN COL2EXPR() WHILE INVOKING A TRIGGER THAT EXECUTES SPL USING WITH TRIGGER REFERENCES