Fix list for Informix Dynamic Server 10.00.xC9
Informix Dynamic Server provides periodic fixes for release 10.00. The following list is the most recent report of fixes for customer-reported defects in Version 10.00.xC9. This report combines both Windows- and Unix-specific defects fixes, and its contents is more current than the defects files included in the product release.
NOTE: some detail links below have been disabled as they are no longer available.
APAR
|
Description
|
IC50083 | A MEMORY LEAK OCCURS IN THE MEMORY POOL PRP WHEN REPEATEDLY EXECUTING A STORED PROCEDURE WHICH RETURNS A ROW TYPE |
IC50084 | A MEMORY LEAK OCCURS IN RALLOC WHEN REPEATEDLY EXECUTING A STORED PROCEDURE WHICH RETURNS A SET TYPE |
IC51119 | FINDERR -350 STATEMENT MISLEADING |
IC52301 | CDR DELETE SERVER GIVES 25582 IN THE ONLINE.LOG |
IC52329 | INDEX QUERY WITH ETX DATA ON AN HDR SECONDARY FAILS WITH SQL -626 AND ISAM -140 |
IC52488 | INDEX EXTENT SIZE CALCULATION IS INCORRECT |
IC52863 | NEED TO GET AN APPROXIMATE SIZE OF ALL THE SPACE OR MEMORY NEEDED FOR DOING A HASH JOIN |
IC53186 | ABORTED TRANSACTION (ATS) OR DATA CORRUPTION POSSIBLE WITH UPDATE TRIGGER ON REPLICATED TABLE AND PARTIAL ROW REPLICATION |
IC53463 | AIX STACK UNWIND IN AF FILES APPEAR TO BE UNRELIABLE WHEN A SIGNAL HANDLER IS INVOLVED |
IC53507 | ER WILL NOT START IF AN ORPHAN G= ENTRY IS FOUND IN SQLHOSTS |
IC53579 | CDR LIST SHOULD RETURN APPROPRIATE EXIT CODES |
IC53868 | HIGH CPU UTILISATION USING ISM_WATCH ON LINUX PLATFORM |
IC53983 | MEMORY CORRUPTION IN ILS DATABASE WHEN TWO SESSIONS EXECUTE A RECURSIVE STORED PROCEDURE IN SUCCESSION |
IC53998 | MEMORY LEAK IN RALLOC WHEN RETURNING A ROW TYPE WITH RESUME |
IC54069 | DOC: NEED MORE INFORMATION ABOUT PROGRAMMING PITFALLS AROUND FOREACH LOOPS |
IC54155 | THE BLOB COLUMN DIFFERENCES ARE NOT (FULLY) DETECTED/REPAIRED BY CDR CHECK |
IC54156 | TABLE RESTORE FAILS WITH SCHEMAS USING SUBSTRINGS |
IC54201 | EXECUTING A STORED PROCEDURE PROCESSING A LVARCHAR AND A SET DATATYPE, CAUSES THE INFORMIX SERVER TO ASSERT FAILURE IN ADDCOL |
IC54281 | ERROR 9791 AND ENGINE CRASH WHEN EXECUTING A FUNCTION THAT USES A LIST COLLECTION. |
IC54398 | DBSCHEMA ON A DATABASE CREATED WITH DB_LOCALE=EN_US.UTF8 CAUSES AN ERROR -23103 |
IC54476 | CDR ADMIN COMMANDS CAN HANG WHILE THE SERVER IS IN THE DDR BLOCK. |
IC54478 | IDS MAY HANG IN A CHECKPOINT WITH PARALLEL INSERT AND UPDATE STATISTICS |
IC54482 | DOCUMENTATION FOR BTREE SCANNER AND ALICE MODE IS POOR |
IC54483 | DESCRIPTION OF RETURN VALUE FOR IFX_UNLOAD_MODULE() MISSING IN IBM INFORMIX GUIDE TO SQL |
IC54557 | QUERY FAILS WITH ERROR 9847 TWICE MAKES IDS SERVER CRASH, WHEN STATEMENT CACHE IS TURNED ON. |
IC54615 | USAGE INFO PRINTED BY ONCHECK SHOULD BE MORE CONSISTENT WITH DOCUMENTATION |
IC54661 | ASSERT FAIL WITH SELECT WITH +FIRST_ROWS INDEX HINT AND DISTRIBUTIONS |
IC54674 | CDR CHECK REPL --REPAIR ON A TABLE WITH MULITPLE REPLICATES UPDATES ALL REPLICATES |
IC54675 | CANNOT DISABLE MIRROR_LOCATION IN SILENT.INI USING A DASH |
IC54688 | CDR CHECK REPLICATESET SEGMENTATION FAULT/CORE DUMP |
IC54690 | INFORMIX HIGH PERFORMANCE LOADER DOES NOT WORK ON MICROSOFT WINDOWS IT RETURNS AN ERROR -668 |
IC54692 | ONSMSYNC SEGVS IF HP DATA PROTECTOR RETURNS BSA_RC_SUCCESS |
IC54707 | CDR CHECK DOES NOT FOLLOW DESCENDING SORT ORDER OF THE PRIMARY KEY FIELD |
IC54714 | CDR SYNC COMMAND HANGS WHEN COLUMN DATA VALUES ARE OUT OF THE FILTER RANGE IN THE REPLICATE |
IC54726 | AN INFORMIX ONBAR WHOLE SYSTEM RESTORE WILL ONLY RESTORE THE ROOTDBS DBSPACE |
IC54729 | SDS, RSS AND HDR SEC SERVERS ASSERT FAILED: READ_RECORD: DECOMPRESS_ROW SOURCE = 0XC0000000099BA818 TARGET = 0XC00000000CFC60B0 |
IC54802 | HPKAIOADDSEG: ASYNC_ADDSEG FAILED, ERRNO = 7 ON ATTEMPT TO ADD 51ST SEGMENT FOLLOWED BY ABEND IN MT_NOTIFYVP() |
IC54836 | ERROR 25572 OSERR 13 WHEN STARTING IDS WITH 2 NETWORK CONNECTIONS, 2+ CPU VPS, PORT NUMBER < 1024 |
IC54847 | SERVER REPORTS A NON-FATAL ERROR: ASSERT FAILED: BUFFER IN WRONG STATE FOR CLEANING DELETED ITEMS |
IC54851 | DATA PAGE WITH PG_NSLOTS=255 IS NEVER RE-USED FOR STORING DATA EVEN THOUGH THERE IS ENOUGH SPACE |
IC54866 | TRUNCATING AN ALTERED TABLE LEADS TO AN ONCHECK ERROR WHEN COMPARING NUMBER OF PAGES IN VERSION WITH PNV_PAGES |
IC54882 | A ROLLBACK OPERATION HANGS, AFTER LONG TRANSACTION OCCURS |
IC54885 | DOCUMENTATION DOES NOT GIVE INSTMGR.EXE OPTIONS |
IC54887 | CDR LIST REPAIR ABENDING IF BOTH NO REPLICATE OR NO REPLSET EXIST FOR THE REPAIR JOB |
IC54900 | THE VALUES IN ONSTAT -G NTD OUTPUT ARE SHIFTED UP HORIZONTALLY BY ONE ROW |
IC54935 | A QUERY WHICH SELECTS FROM A VIEW GIVES VERY SLOW PERFORMANCE AFTER MIGRATION FROM 10.00.FC5 TO 10.00.FC7 |
IC54943 | DBACCESS ABENDS WHEN TERMINAL HEIGHT IS TOO SMALL |
IC54956 | CDR DATASYNC THREAD SEGV IN DSIRESOLVERTHREAD ON TARGET, SRC SERVER 7.31 AND REPLICATE FAILS TO BE DEFINED AND STARTED PROPERLY |
IC54968 | ATS/RIS FILES CAN FILL UP THE SYSTEM TEMP DIRECTORY IF CONFIGURED DIRECTORY IS FULL OR NOT CONFIGURED AT ALL |
IC54969 | RECURSION OF ADDSQCOST() CAN FAIL IF MT_CALL() WAS CALLED |
IC54982 | UPDATE NEEDED FOR ERROR -800 MESSAGE TEXT, WITH REGARD TO NVL FUNCTION |
IC55019 | PERFORMANCE IS NOT SPELLED CORRECTLY IN A WARNING MESSAGE |
IC55031 | PREPARED SQL CONTAINING LPAD DOES NOT USE AN INDEX SCAN |
IC55036 | MIGRATION TO IDS 10.00.xC8 or 11 ASSERT FAILS WITH ERROR 211 WHEN UDR REFERENCES TABLE WITH LIKE AND LET STATEMENTS |
IC55043 | INDEX SHORTER THAN 4 BYTES WITH LARGE DUPLICATE LISTS CAUSE THE BTREE SCANNER TO CONSUME EXTRA I/O |
IC55052 | FAST RECOVERY CAN FAIL WHEN CCFLAGS IS SET TO CC_SLOW_STAMP |
IC55061 | CDR MESSAGE: DID NOT FIND CDR SHADOW COLUMNS IN THE STREAM |
IC55063 | INCORRECT INDEX PATH USED WHEN TABLE IS FRAGMENTED COMPARED TO A NON-FRAGMENTED TABLE |
IC55079 | REMOTE SYNTAX USING A GROUP NAME FROM THE SQLHOSTS FILE CAUSES SESSION HANG |
IC55110 | ASSERT FAILED AFTER REOPENING A CURSOR WITH HOLD ON A RECREATED TEMP TABLE |
IC55132 | ASSERT FAILURE WHEN USING SEQUENCE_NAME.NEXTVAL IN A SUBSELECT AND THE MAX FUNCTION |
IC55169 | WINDOWS DOMAIN USERS ARE ONLY ACCEPTED AS DOMAINUSERNAME NOT USERNAME. |
IC55214 | A REMOTE SQL SELECT WITH A STREAM-PIPE CONNECTION RETURNS A 936 ERROR |
IC55256 | RUNNING OUT OF MEMORY DURING BTSPLIT CAUSES INDEX CORRUPTION; SUBSEQUENT INSERT CAUSES AF IN BF_ONWTLIST |
IC55274 | SELECT FAILS TO DO FRAGMENT ELIMINATION AFTER ADDING COLUMNS TO A TABLE |
IC55287 | BITMAP MODE IS INCORRECTLY CALCULATED FOR IN-PLACE ALTERED DATA PAGES |
IC55307 | THE HEADER OF PLOG_MARKER PAGE IS CORRUPTED WHEN FUZZY CHECKPOINTS ARE USED AND FAST_RESTART_CKPT_FUZZYLOG=1 |
IC55308 | QUERY USING OUTER JOIN RETURNS WRONG RESULT |
IC55372 | PAM AUTHORIZATION FAILURE FOR REMOTE OR ISTAR QUERIES CAUSES AN AF WITH 64-BIT IDS ON AUTH_COMPARE |
IC55421 | HPL VARCHAR/LVARCHAR DATA CORRUPTION IN DELUXE MODE |
IC55437 | ERROR -874 FROM OPTIMIZER FOR SUBQUERY WITH SET COLUMN IN WHERE CLAUSE |
IC55462 | ERROR -750 IN GET_DIST WHEN REMOTE C LANGUAGE PROCEDURE IS REFERRING TO A TABLE IN A DIFFERENT DATABASE |
IC55506 | ASSERTION FAILURE WHEN CREATING TABLE WITH 9000 COLUMNS ON 16K PAGESIZE DBSPACE |
IC55556 | NO NEW CONNECTIONS ARE POSSIBLE ONCE THE LIMIT FOR UNSUCCESSFUL CONNECTIONS SPECIFIED BY MAX_INCOMPLETE_CONNECTIONS IS REACHED |
IC55573 | HPL UNLOADS LVARCHAR EMPTY STRING INCORRECTLY AS NULL |
IC55574 | SELECT RETURNS INCORRECT OUTPUT USING DYNAMIC HASH JOIN |
IC55599 | DBSCHEMA FOR TABLE RETURNS CREATE AGGREGATES |
IC55600 | INSERT INTO A LIST DATATYPE IN A SP IN PARALLEL WITH AN UPDATE STAT ON THE SAME PROC ABENDS IN GETCOLLVARDDXTP |
IC55601 | IDS CANNOT BE INSTALLED INTO A MICROSOFT WINDOWS DOMAIN |
IC55602 | ERROR -22555 IS NOT RETURNED TO CLIENT |
IC55603 | CANNOT DISPLAY JAPANESE CHARACTER IN QUERY WINDOW IN DBACCESS |
IC55604 | WINDOWS: IDS DOMAIN INSTALL IS NOT WORKING |
IC55605 | INDEX READ_AHEAD IS NOT BEING USED FOR INDEX PAGES IN INFORMIX DYNAMIC SERVER |
IC55633 | CDR_SUPPRESS_ATSRISWARN IS EVALUATED WHEN INSTANCE IS BROUGHT ONLINE |
IC55672 | XA: KILLING XA APPLICATIONS WITH OPEN TRANSACTIONS MAY REPORT FREEING TRANSACTION ENTRY THAT STILL HOLDING LOCK MESSAGE |
IC55685 | SM_DISCON THREAD FAILS WITH SEGV IN NET_SM_DISCON_THREAD_FREE_STATINFO WHILE TRYING TO CLEAN UP A FAILED CONNECTION ATTEMPT |
IC55811 | SLOW PERFORMANCE ON LEFT OUTER JOIN WHEN USING MIXED ANSI AND INFORMIX SYNTAX |
IC55813 | IN 10.00.FC8 THE OPTIMIZER CHOOSES A BAD INDEX SIGNIFICANTLY SLOWING PERFORMANCE |
IC55839 | ROW SIZE MAY BE CALCULATED INCORRECTLY WHEN CASTING HTML DATA TYPE TO LVARCHAR AND LEAD TO ERROR 528. |
IC55981 | STATEMENT CACHE AND FULL OUTER JOIN LEAD TO UNEXPECTED ABORT IN ITBLDQNODE CALLED BY ITBLDJOIN |
IC56000 | ONMODE -YU HANGS IF CALLED FROM AN ALARM PROGRAM DUE TO ALARM 31 WHEN GROUPER PAGING FILE IS FULL |
IC56033 | CDR SYNC/CHECK CAN FAIL WITH BAD ROWID ON DELETE WHERE CURRENT OF CURSOR |
IC56034 | CDR CHECK AND REPAIR OPTIONS MAY FAIL IF A UNIQUE INDEX EXISTS ON THE TABLE |
IC56090 | IDS SESSIONS COULD HANG WAITING FOR NETWORK AND ARE UNABLE TO BE KILLED WITH ONMODE |
IC56216 | IF A SUBSELECT CONTAINS A REMOTE QUERY, A -1213 ERROR CAN BE GENERATED. |
IC56225 | AN ERROR -874 IS RETURNED FROM THE OPTIMIZER FOR A QUERY WITH REMOTE SYNONYMS AND OUTER JOINS |
IC56243 | DBSCHEMA INCORRECTLY HANDLES DROPPING AND CREATING IMPLICIT CASTS CAUSING 9919 ERRORS |
IC56285 | AN INSTANCE MAY CRASH IF ITS NOT ABLE TO RUN A JAVA UDR |
IC56286 | FINDERR SHOULD MENTION DELIMIDENT FOR ERROR -201 SYNTAX ERROR |
IC56287 | ASSERT FAILED: INTERNAL TBLSPACE ERROR, WHEN INTERNAL TABLESPACE USAGE COUNT IS OVER THE LIMIT. |
IC56288 | IF YOU CREATE A TABLE WITH DISABLED UNIQUE INDEX ONCHECK -PT RETURNS ERROR. |
IC56310 | DBEXPORT -X OF VARCHAR COLUMN CONTAINS 00 WHEN CLIENT_LOCALE IS NOT SET OR INCORRECT |
IC56331 | ERROR MESSAGES FROM DBEXPORT ARE NOT WRITTEN TO THE DBEXPORT.OUT FILE |
IC56369 | INCORRECT USE OF ONMODE -D COMMAND CAN TAKE A SECONDARY TO STANDARD MODE BUT CHUNKS LEFT AS BEING INCONSISTENT |
IC56370 | AFTER A CONVERSION FROM IDS VERSION 7 TO 10, STORED PROCEDURE EXECUTION RETURNS AN ERROR -597 |
IC56424 | LONG CHECKPOINT DURATION AS AN INSERT INTO AN INDEX LOOPS THROUGH EMPTY PAGES IN BTNEXITEM |
IC56442 | SIMPLE STORED PROCEDURE WITH 8 RETURN VALUES CAN CRASH SERVER IN PCODE_GET_OPCODE() |
IC56445 | CDR ERROR 57 TO PROVIDE MORE DESCRIPTIVE ERROR MESSAGES ON DEFINE REPLICATE, REPLSET AND CDR REALIZE TEMPLATE |
IC56453 | IDS MAY HANG WHEN RUNNING REMOTE QUERY USING STREAM PIPE FOR LOCAL CONNECTION PROTOCOL |
IC56462 | DOCUMENTATION STATES THAT ORDER BY WOULD NOT BE ALLOWED WITHIN STORED PROCEDURES |
IC56488 | NON-RELATED SCHEMA INFORMATION (UDA) PROVIDED USING DBSCHEMA |
IC56507 | WHEN PERFORMING AN UPDATE ON A CDR TABLE, THE DELETE SHOULD BE APPLIED ON THE TARGET BEFORE THE INSERT |
IC56512 | CDR CHECK RETURNS MULTIPLE ERRORS WHEN INCORRECT COMMAND LINE SYNTAX, PARAMETERS, OR OPTIONS PROVIDED |
IC56513 | ONBAR COLD RESTORE HANGS AT LOGICAL RECOVERY TRANSACTION CLEANUP PHASE |
IC56521 | Degradation in HDR secondary performance due to foreground writes during DR Log buffer flushing. |
IC56522 | CPU VPS may not have access to runtime data for ICU resulting in random -202 errors. |
IC56550 | EMPTY BTREE PAGES (NSLOTS = 0) ARE LEFT BEHIND BY BTREE SCANNER FOR NON-LOGGED TABLES |
IC56556 | ERROR -272 RECEIVED WHEN SELECTING FROM A REMOTE VIEW CREATED WITH UNION. |
IC56562 | CLIENT_LOCALE FROM A REMOTE CLIENT IS USED TO FORK A CHILD PROCESS FOR EXECUTING A SHELL SCRIPT FROM A STORED PROCEDURE. |
IC56565 | INDEX MISSING ON BAR_INSTANCE:INS_AID CAUSES PERFORMANCE ISSUES WITH ONSMSYNC.. |
IC56589 | A QUERY WITH TWO IN CLAUSES WHICH ARE ORDERED SELECTS ALL ROWS. |
IC56592 | AFTER RESULTS RETURNED SUCCESSFULLY AND THEN CASTING ERROR, SUBSEQUENT RESULTS INCORRECTLY RETURNING 0 ROWS . |
IC56593 | ASSERT FAIL AND CRASH DURING CLEANUP OF STORED PROCEDURE CACHE |
IC56594 | IDS ALLOWS USER TO CREATE TABLE WITH INVALID DEFAULT VALUE FOR DATE COLUMN WITH NOT NULL |
IC56595 | CONCATENATION OF CHAR COLUMNS NOT WORKING |
IC56596 | ERROR -201 EXECUTING A ROUTINE WHICH SELECTS AGAINST A SYNONYM WITH AN NVL FUNCTION |
IC56597 | DROPPING CPU VPS INCORRECTLY SETS MGM PROCESSORS TO TOTAL NUMBER OF VPS |
IC56598 | SEGV IN MKREMBUFF WITH SELECT ON SYSDATABASES WITH REMOTE SUBQUERY |
IC56671 | WRONG RESULTS WHEN USING A NESTED SELECT |
IC56673 | DATA DICTIONARY CORRUPTION WHEN SELECTING DATA FROM A UNION VIEW WITH NUMCPUVPS >1 |
IC56677 | OPERATOR [] NOT EVALUATED WITHIN AN LOGICAL OR OPERATION DEPENDING ON THE ACCESS PATH |
IC56692 | UPGRADE FUNCTION INITIALIZES EXISTING INSTANCE WITHOUT CONFIRMATION |
IC56698 | CROSS-INSTANCE CONNECTION IS NOT RE-ESTABLISHED WHEN THE CLIENT USES A DIFFERENT DBSERVERALIAS IN THE SAME SESSION |
IC56699 | WHITESPACE IS NOT INSERTED BY DEFAULT ON A VARCHAR WHEN DEFINED AS NOT NULL. |
IC56704 | EXCESSIVE MEMORY ALLOCATION ON A HDR SECONDARY SERVER |
IC56726 | CDR CHECK REPORTS MISMATCH WHEN SOURCE AND TARGET HAVE DIFFERENT UNIQUE INDEXES DEFINED |
IC56741 | LIO IS NOT USED ON SECNDARY TO WRITE LOG PAGES |
IC56742 | REDO OF PARTITION BLOB DOING UNNECESSARY FOREGROUND READ OF PAGES WHEN PAGES IN PARTITION IS USED FIRST TIME |
IC56750 | MEMORY LEAK WHEN INSERT TRIGGER FAILS DUE TO UNIQUE KEY CONSTRAINT VIOLATION |
IC56751 | CDR REPAIR OUTPUT OF THE REPLICATE STATUS REPORTS ERROR -1 FROM CLEANUPSYNC |
IC56764 | STORED PROCEDURE RETURNS INCORRECT RESULTS WHEN RUN CONSECUTIVELY AFTER UPGRADING TO IDS 10 |
IC56798 | DOUBLE-BYTE CHARACTER AT THE END OF A STRING GETS TRUNCATED IF THE LENGTH OF THE STRING EXCEEDS THE LVARCHAR COLUMN BY 1 BYTE |
IC56825 | CDR CHECK WITH REPAIR OPTION CAN ORDER SYNC REPLICATES SUCH THAT RELATIONAL CONSTRAINTS WILL CAUSE A FAILURE |
IC57051 | SPOOLING LARGE TRANSACTIONS TO PAGING THREAD CAN CAUSE GROUPER THREADS TO RUN OUT OF IOBLOCKS |
IC57148 | CDR CHECK -R DOES NOT SET THE REPLICATION FLAG FOR DELETES |
IC57149 | CDR SYNC REPORTS MISMATCH WHEN SOURCE AND TARGET HAVE DIFFERENT UNIQUE INDEXES DEFINED |
IC57151 | CDR COMMANDS EXECUTED BY NON-INFORMIX USERS SHOULD REPORT INFORMATIVE ERROR SUGGESTING IT IS A USERID ISSUE |
IC57304 | FREQUENT -211 ON SYSPROCPLAN IN 10.00.XC8, 11.10.XC2 AND IN ABOVE VERSIONS |
IC57396 | NEW CONNECTIONS HANG IF A SESSION HAS LOTS OF PREPARED STATEMENTS THAT HAVE NOT BEEN CLOSED |
IC57511 | RANDOM MEMORY CORRUPTION WHEN COMPARING A CASE (OR DECODE) TO A COLUMN |
IC57600 | CDR LIST REPL REPORTS ACTIVE STATE OF A REPLICATE THAT HAS BEEN SUSPENDED |
IC57630 | DOCUMENTATION NEEDED ON CDR SYNC, CDR CHECK AND CDR CHECK REPAIR FUNCTIONALITY |
IC57632 | NO DIAGNOSTICS PRODUCED ON "CDR PAGER: READ MISMATCH, CHECKSUM ERROR FOUND. ERROR |
IC57633 | DOC - CLARIFY TOPOLOGY DESCRIPTION IN ENTERPRISE REPLICATION GUIDE |
IC57649 | SERVER TOOLS LIKE CDR AND DBACCESS CAN SEGV TRYING TO FREE CURSOR IF SERVER CONNECTION IS BROKEN |
IC57651 | CDR REMOVE DID NOT REMOVE ALL CDR_DELTAB TABLES |
IC57652 | ONSTAT -A DOES NOT DISPLAY ALL INFO |
IC57653 | ERROR 57 DISPLAYS TABLE %S IN CCM.LOG |
IC57654 | CDR REMOVE DOES NOT CLEAN SBSPACETEMP |
IC57655 | CDR DELETE SERVER DOES NOT REMOVE ALL ER COMPONENTS IF USER CONNECTED TO SYSCDR DATABASE |
IC57656 | CDR REMOVE RECEIVES COMMAND FAILED -- GENERAL ERROR (-1) (-1) WHEN USER CONNECTED TO SYSCDR |
IC57657 | CDR VIEW COMMAND WITHOUT ANY OPTION - DOES NOT PRINT USAGE |