Product Documentation
Abstract
Informix Dynamic Server provides periodic fixes for release 10.00. The following is a complete listing of fixes for Version 10.00.xC7.
Content
Important: As part of IBM's ongoing effort to increase and enhance self-help information available to Informix customers, IBM® Informix® Dynamic Server (IDS) product defects are now being reported as Authorized Program Analysis Reports (APARs).
If you are interested in learning more about Authorized Program Analysis Reports, review the following Technote, Informix APAR Information.
| Fix release date: 18 10 2007 Last modified: 9 April 2014 Status: Recommended  Download information | |
NOTE: some detail links below have been disabled as they are not available.
APAR | Description |
| IC49831 | UNABLE TO CHANGE ONAUDIT PARAMETERS WITH ONAUDIT IF ROLE SEPARATION IS INSTALLED |
| IC50058 | UNEXPECTED BEHAVIOUR OF SEQUENCES WHEN USING TRANSACTIONS WHERE |
| IC50132 | SERVER CRASH WITH 6000 CONCURRENT CONNECTIONS. CRASH HAPPENSAT |
| IC50554 | F.E. VERSION FIELD IN ONSTAT -G SQL ONLY LISTS 9.03 FOR ANY LATER VERSION APPLICATION |
| IC50716 | RESTORE FAILS WITH THERE ARE NO STORAGE SPACES/LOGICAL LOGS TO BACKUP/RESTORE |
| IC50849 | SELECT VIA ROWID ON FRAGMENTED TABLES USES SEQUENTIAL SCAN |
| IC50905 | CROSS DATABASE TABLE WITH EXTENDED DATA TYPES AND ORDER BY |
| IC50956 | LOGGING TEMP TABLES CAUSE A LARGE PERFORMANCE PROBLEM |
| IC50961 | GCREQ MEMORY POINTER FREED TWICE AFTER QUEUING CONTROL MESSAGE FAILED |
| IC51018 | ONMODE -Y SHOULD INCLUDE AN OPTION TO SET THE OUTPUT FILE PATH |
| IC51019 | WHEN DYNAMICALLY TURNING ON SET EXPLAIN, THE DBA HAS NO WAY OF DETERMINING WHERE THE RESULTS GO |
| IC51039 | ONCHECK USED WITH DIFFERENT SET DB_LOCALE RETURNS AN ERROR MESSAGE (SQOPENDB()) |
| IC51085 | ONBAR FAILS DURING BACKUP OF SBSPACE WHEN SMART BLOB EXTENT |
| IC51144 | RECURSIVE CALLS TO SINGLE INSTANCE USING GROUP NAME HANGS QUERY |
| IC51161 | ARCHECKER: ERROR -535 WHEN RUNNING A MULTIPLE TABLE LEVEL |
| IC51171 | SELECT ORDER BY GET 306 ERROR VIA OTHER INSTANCE USING SYNONYM |
| IC51184 | SELECT QUERY WITH EXPRESSION ON A TABLE WITH INTERVAL AND MONEY DATA TYPE RETURNS THE CONVERT ERROR 1260. |
| IC51188 | EXCESSIVE BLANK LINES IN DBSCHEMA OUTPUT |
| IC51224 | OVERLOADED STORED PROCEDURES/FUNCTIONS ARE NOT DISPLAYED |
| IC51242 | CDR ERR OUTPUT SHOWS ERROR 31 (UNDEFINED REPLICATE) AFTER CDR SYNC COMMAND |
| IC51330 | ERROR: VP_MEMORY_CACHE_KB MODIFIED INCORRECTLY WRITTEN IN ONLINE LOG |
| IC51342 | ERROR -201 RETURNED WHILE ATTEMPTING TO EXECUTE A PROCEDURE |
| IC51357 | 9905 ERROR WHEN USING MULTISET, SEEN WHEN USING ROLLBACK WORK |
| IC51370 | TABLE CORRUPTION OCCURS AFTER RUNNING INSERT INTO A SELECT |
| IC51378 | A SERVER ABEND IN RVALDATAUDT OCCURS WHEN RUNNING MULTIPLE |
| IC51380 | DYNAMIC PAGE GENERATION ERROR: INAPPROPRIATE NUMERIC OPERATION, OR CORRUPT DATA DISPLAYED, WHEN USING VECTORS/ARRAYS/SUBSCR |
| IC51413 | IN DBACCESS, THE EXIT OPTION DOES NOT WORK ON THE REFERENCE |
| IC51427 | FOREIGN KEY CONSTRAINTS MAY BE BROKEN USING AN INSERT TRIGGER CALLING AN UPDATING STORED PROCEDURE |
| IC51513 | ERROR 9720 WHEN LOADING A MODULE LEAVES THE MODULE MUTEX LOCKED |
| IC51517 | FAILURE TO INSERT BLOB/CLOB USING FILETOBLOB FROM A CLIENT |
| IC51538 | WHEN RETURNED FROM STORED PROCEDURES, ERRORS SUCH AS -271 DO NOT IDENTIFY THE TABLE OR INDEX |
| IC51555 | THE CONCATENATION OPERATOR, |
| IC51559 | USING A DESCENDING INDEX IN A SIMPLE QUERY WITH A MATCHES |
| IC51560 | THE OPTIMIZER CHOOSES A SEQUENTIAL SCAN INSTEAD OF AN INDEX IF A TABLE HAS TOO MANY ROWS |
| IC51562 | ERROR 393 RETURNED INCORRECTLY WITH AN OUTER JOIN AND A |
| IC51570 | TRYING TO DROP/RENAME OR ALTER A SEQUENCE CAN CAUSE SEGV WITH |
| IC51572 | MEMORY OVERFLOW CAUSED BY RECURSION WHEN ACCESSING A VIEW |
| IC51577 | A SELECT STATEMENT WITH AN INTERVAL AGGREGATE HAVING CLAUSE |
| IC51610 | CALLING A STORED PROCEDURE THAT USES UPDATE WHERE CURRENT OF CLOSE WITHIN A JDBC XA APPLICATION FAILS WITH ERROR -507 |
| IC51615 | IPV6 ENABLED CLIENTS NEED 80 SECONDS TO CONNECT ON SOLARIS |
| IC51616 | A NESTED LOOP JOIN USING REMOTE LEFT OUTER JOIN AS AN INNER |
| IC51630 | INCORRECT BYTES QUEUED AND A SENDQ ISSUE WITH A REPLICATE INCLUDING ONLY A LOCAL AND A FAR REMOTE PARTICIPANT |
| IC51645 | A SERVER CRASH OCCURS IN THE IN _NET_SIGNAL_REMENDPT() FUNCTION |
| IC51650 | ASSERTION FAILURE DUE TO A MEMORY BLOCK FREED BEFORE THE TMCHAIN STRUCTURE IS RELEASED |
| IC51651 | RUNNING A QUERY WITH A CORRELATED SUBQUERY IN A STORED PROCEDURE WITH PDQ CAUSES A SERVER ABEND |
| IC51652 | INCORRECT RESULT FROM A QUERY WHICH USES A COMPOSITE INDEX WITH |
| IC51653 | ERROR 393 RETURNED INCORRECTLY WITH AN OUTER JOIN AND A |
| IC51668 | MEMORY LEAK IN SQSCB DURING THE CREATION AND DELETION OF TABLES |
| IC51669 | TABLE LEVEL RESTORE FAILS TO DO LOGICAL RECOVERY OVER MORE THAN |
| IC51675 | THE OPTIMIZER CHOOSES THE INDEX WHICH APPEARS FIRST IN |
| IC51687 | DEADLOCKS OCCUR (ERROR -243 AND -143) WHEN UPDATING |
| IC51722 | ONSTAT -G SMB C (CHUNKS) ALWAYS PRINTS CHUNK SIZE 0 |
| IC51726 | UPDATE STATISTICS CHANGES THE RESULT SET OF A REMOTE QUERY |
| IC51729 | NIF SEND THREAD FOR A 7.31 COUNTERPART CAN EITHER HANG OR CRASH |
| IC51731 | ONINIT ON HP-UX PRODUCES A WARNING: PAM LIBRARY |
| IC51734 | ERROR: CONNECTION TARGET SERVER SITE2 DO NOT KNOW ABOUT ME |
| IC51736 | UNLOAD OF A CHARACTER COLUMN CONTAINING 0X0 BYTE IS NOT |
| IC51739 | ASSERT FAILED: PAGE CHECK ERROR IN GENPG_READ(): BAD PAGE |
| IC51781 | CHANGING ONCONFIG PARAMETERS WITH ONMODE DOES NOT UPDATE THE |
| IC51792 | ERROR 528: MAXIMUM OUTPUT ROWSIZE (32767) EXCEEDED WHEN TRYING |
| IC51814 | SELECT STATEMENT RETURNS A -201 ERROR IF IT HAS THE NVL() |
| IC51816 | SERVER CRASH OCCURS IN THE MATERIALIZE_VIEWTMP FUNCTION AFTER |
| IC51817 | SELECT STATEMENT RETURNS AN INCORRECT RESULT WHEN USING AN |
| IC51820 | USING TRANSPORT LAYER SECURITY (TLS) FOR LDAP AUTHENTICATION |
| IC51827 | THE CHUNK RENAME WITH ONTAPE -R -RENAME -F ON WINDOWS |
| IC51840 | WRONG RESULT RETURNED FROM A SIMPLE QUERY WITH REDUNDANT RANGE |
| IC51844 | 1214 VALUE EXCEEDS LIMIT OF SMALLINT PRECISION ERROR WHEN |
| IC51857 | POINT IN TIME RESTORE FAILS FOR A DATABASE FRAGMENTED USING AN0x0dSBSPACE (ROUND ROBIN) |
| IC51870 | A BAD QUERY PLAN IS CREATED FOR A STORED PROCEDURE SELECT STATEMENT |
| IC51914 | A REMOTE QUERY CONTAINING AN OUTER CLAUSE AND A CONDITION EVALUATING TO FALSE RETURNS ERROR -217 |
| IC51916 | ER RETAINING ALL TRANSACTIONS IF AN HDR SECONDARY IS UNAVAILABLE |
| IC51919 | BUILDSMI TRACING SHOULD ALSO INCLUDE AN INITIAL DROP DATABASE |
| IC51935 | THE PHYSICAL LOG CHECK AFTER THE CONVERSION FROM A PRE-9.40 VERSION MAY LEAVE THE PHYSICAL LOG IN AN NON-EMPTY STATE |
| IC51936 | A MEMORY ALLOCATION PROBLEM IN IDS DUE TO A VP-PRIVATE CACHE FEATURE BEING ON BY DEFAULT |
| IC51944 | ER TARGET APPLIES TRANSACTION IN THE WRONG ORDER |
| IC51960 | A SEQUENTIAL SCAN OCCURS ON ALL THE FRAGMENTS EVEN WHEN THE |
| IC51983 | ALICE MODE CAN SEND INVALID PAGES TO PTMAPX |
| IC51984 | CRASH IN THE _NET_SIGNAL_REMENDPT() FUNCTION WHEN MEM_SCRIBBLE IS SET WITH IPCSHM |
| IC51985 | CDR QUEUER: SEND QUEUE IS FULL - WAITING FOR SPACE IN CDR_QDATA_SBSPACE |
| IC51986 | SELECT WITH A SUBSELECT CAUSES AN ASSERTION FAILURE AND ERROR 874 |
| IC51991 | FIRST N ROWS WITH REMOTE SELECT RETURNING 0 ROWS |
| IC51992 | ONBAR CAN CRASH WITH UNFAVOURABLE GL_DATETIME SETTING |
| IC51994 | SELECT USING SENDRECV CAN ASSERT FAIL WHEN SENDING DATA TO CLIENT |
| IC52005 | QUERY WITH MULTISET AND STATEMENTCACHE ON WILL CAUSE A SERVER ABEND IN CEXPR2HASHKEY |
| IC52006 | SET INDEXES ENABLED FOR AN INHERITANCE TABLE CORRUPTS THE INDEX |
| IC52053 | AN ONPLOAD DELUXE LOAD GENERATES ERROR 271 AND ISAM 0 |
| IC52069 | BUNDLE INSTALLER IDS_INSTALL FAILS TO DETECT CORRECT FREE SPACE INFORMATION WHEN FILE SYSTEMS ARE MOUNTED ON TOP OF EACH OTHER |
| IC52071 | HDR PRIMARY QUIESCENT (UNREACHABLE) AFTER RESTART UNTIL ALL LOGS ARE SHIPPED TO THE SECONDARY |
| IC52091 | XA_ROLLBACK CALLED VIA A TRIGGER FAILS WITH ERROR 242 AND 123 CAUSING ORPHAN LOCKS AND AN INCOMPLETE GLOBAL TRANSACTION |
| IC52093 | THE METHOD FOR SETTING THREAD PRIORITY IS FLAWED AND AFFECTS BTREE SCANNER PRIORITY |
| IC52095 | RUNNING ONCHECK USES TOO MANY TIMESTAMPS |
| IC52096 | PAGE FLAG (PG_FLAGS) CORRUPTION OCCURS WHEN RUNNING DML ON MORE THAN ONE ROW AT A TIME |
| IC52150 | LOADING A DATETIME VALUE WITH A DBACCESS LOAD CAN LEAD TO A 1262 ERROR ON UNIX PLATFORMS WHEN CR-LF LINE ENDING IS USED |
| IC52151 | HPUX IA64: SERVER MAY GENERATE AF FILES IN OPEQJOIN WITH A SIGILL SIGNAL |
| IC52161 | ONSTAT -C OUTPUT SHOWS RAPIDLY INCREASING NUMBERS WHICH CAN BECOME NEGATIVE |
| IC52230 | VIEW REFERENCING SYSMASTER TABLES CAN LEAD TO FAILING CONVERSION - ERROR SQL -311 ISAM -103 AND MEMORY BLOCK HEADER CORRUPTION |
| IC52240 | CDR DEFINE REPLICATE AS A MASTER REPLICATE GENERATES ERROR NOT ALL COLUMNS IN PK ARE SELECTED FOR REPL |
| IC52242 | ENGINE AFS BY ADM WITH ONMODE -KUY OR KY |
| IC52252 | PHYSICAL LOG OVERFLOW DURING INSERT IN AN IN-PLACE ALTERED TABLE |
| IC52253 | OPTIMIZER DOES NOT USE THE ASSOCIATIVE LAW FOR FILTERS ON SUBSTRINGS |
| IC52256 | WRONG RESULTS DOING SELECT WITH WHERE CLAUSE ON SYSDBSPARTN TABLE |
| IC52261 | ACHECKER -TDVS OUTPUT CANNOT BE READ. |
| IC52263 | ONTAPE BACKUP TAKEN WITH TAPESIZE -1 TO FILE/TAPE (NOT DIRECTORY) CANNOT BE RESTORED |
| IC52264 | SERVER CRASHED WHILE PERFORMING DATALOAD IN MT_YIELD |
| IC52278 | ONUNLOAD CORRUPTS MEMORY LEADING TO IDS CRASH WHEN ONINIT WAS ISSUED AS ROOT |
| IC52309 | ERROR -881, RESULTING STRING LENGTH FROM TRIM EXCEEDS THE LIMIT, WHEN CONCATENATING USING THE II OPERATOR |
| IC52314 | EIX000: -9930 BYTE, TEXT, SERIAL OR SERIAL8 DATATYPES IN COLLECTION TYPES NOT ALLOWED |
| IC52316 | LONG CHECKPOINT DURATION WHEN NUMBER OF PT_DIRTY IS HIGH |
| IC52325 | SELF-JOIN QUERY WITH FILTER CONDITION RETURNS INCONSISTENT RESULTS BASED ON SELECT COLUMN CHOICES |
| IC52338 | THE BTREE SCANNER LEAVES EMPTY OR UNCLEANED PAGES BEHIND |
| IC52339 | A JDBC PROGRAM RETRIEVING A UDT FROM A RESULTSET MAY CAUSE A SERVER ABEND |
| IC52343 | ALTER FRAGMENT ON INDEX DOES NOT UPDATE THE SYSMASTER:SYSEXTENTS CORRECTLY WITH THE INDEX NAME |
| IC52348 | OPTIMIZER DOES NOT RECOGNIZE 1=0 IN WHERE CLAUSE AND SCANS ENTIRE TABLE. |
| IC52354 | FROM AN ESQL OR SIMILAR APPLICATION, OPENING A PREPARED CURSOR FOR THE SECOND TIME CAN FETCH NO ROWS OR APPEAR TO HANG |
| IC52361 | ALTER TABLE ADD COLUMN RESETS TABLE STATISTICS IN SYSFRAGMENTS |
| IC52362 | CREATING A DATABASE SCHEMA AS ANOTHER USER WITH DBA PRIVILEGES GETS THE WARNING:PRIVILEGE NOT REVOKED |
| IC52365 | A CRASH OCCURS IN THE TMCHAIN_DELETE FUNCTION WHEN FREEING THE CONTEXT OF A STORED PROCEDURE CALLED BY ANOTHER STORED PROCEDURE |
| IC52366 | THE OPTIMIZER CHOOSES A BAD PATH AFTER UPGRADING TO 10.00.FC5 OR GREATER |
| IC52381 | A SELECT STATEMENT FROM A VIEW WITH A SUBSELECT RETURNS ERROR -392 |
| IC52382 | AN SQL LOAD INTO A TABLE ALLOCATES AND CONSUMES MASSIVE AMOUNTS OF MEMORY |
| IC52408 | A CRASH OCCURS IN THE FMFTOPEN_WITH_CHILD FUNCTION WHEN A SELECT WITH A SYNONYM IS RUN ON A TABLE WITH BLOB AFTER A MIGRATION |
| IC52410 | THE ENGINE CAN CRASH WHEN RUNNING THE COMMAND ONSTAT -G STK ALL LIGHT |
| IC52432 | WITH SYNCHRONOUS HDR, TRANSACTIONS ARE LOST ON A SECONDARY WHEN THE PRIMARY CRASHES AND THE SECONDARY IS SWITCHED TO PRIMARY OR |
| IC52434 | ERROR 212, 101, CANNOT CREATE AN INDEX WITHOUT USING IN CLAUSE WHEN CREATING A FRAGMENTED TABLE WITH PARTITIONS |
| IC52438 | CDR CHECK -R RUNS ON -535 (ALREADY IN TRANSACTION) IN ANSI DATABASE AS SOON AS SOMETHING TO REPAIR |
| IC52478 | A STORED PROCEDURE WITH A MULTISET CAUSES AN ABEND IN PROCESS_ELEMENT WHEN REACHING THE CACHE LIMITS. |
| IC52489 | AN INCONSISTENT NUMBER OF SEQUENTIAL SCANS WHEN DOING AN UPDATE STATISTICS HIGH ON A TABLE |
| IC52490 | AN INSERT INTO A COLLECTION DERIVED TABLE WILL CAUSE ERROR -9875 OR -9791 |
| IC52491 | INCORRECT ERROR MESSAGE WHEN USING INVALID CHARACTERS IN UTF8 ENVIRONMENT |
| IC52539 | A DATABASE SERVER CRASH OCCURS AFTER MEMORY IS EXHAUSTED |
| IC52541 | A BLOB SELECTED WITH CR_LOCKBLOB MAY STILL RECEIVE SQL ERROR -604, ISAM -164 WITH A CONCURRENT UPDATE ON BLOB |
| IC52542 | AN ENGINE ABORTS WHEN USING PAM ON SOLARIS AND HAVING > 256 (APPROX) CONCURRENT PAM CLIENT CONNECTIONS |
| IC52544 | THE IDS SERVER CAN CRASH IN THE BUFGET FUNCTION WHEN CLIENTS DISCONNECT |
| IC52550 | SETTING GL_USEGLU=1 CAUSES DBACCESS CONNECTIONS TO FAIL WITH 25588 ERROR |
| IC52562 | ERROR WITH SELECT COMPARING SUBSTRINGS <= & >= TO SAME VALUE |
| IC52577 | ASSERT FAILURE AFTER ONMODE -D 0 WITH PDQ SET ON STORED PROCEDURES |
| IC52583 | CONSTRAINT NAME LONGER THAN 64 CHARACTERS RESULTS IN ERROR 268: UNIQUE CONSTRAINT |
| IC52586 | EXECUTING A SIMPLE QUERY ON A VIEW WHICH USES A SEQUENCE OPERATOR GENERATES OPTIMIZER ERROR -874. |
| IC52592 | MEMORY LEAK IN DICTIONARY POOL WHEN DOING TRUNCATE TABLE ON TABLES WITH REFERENTIAL CONSTRAINTS |
| IC52599 | USING || TO CONCAT A STRING > 255 FAILS WITH -881 IF FIRST TWO STRINGS ARE < 255 |
| IC52600 | ROLLBACK OF A CREATE SEQUENCE CAN CAUSE PTHDRPAGE:PTALLOC:BAD PARTN PAGE MESSAGES IN THE LOG |
| IC52605 | A QUERY USING OUTER JOINS AND TABLE ALIASES WILL RETURN A -393 CODE IF THE SAME ALIAS NAMES ARE USED IN A SUBQUERY |
| IC52630 | RECURSIVE UDR CALLS TO A COLLECTION LIST CAUSE EXCESSIVE MEMORY GROWTH IN PROCPOOL |
| IC52652 | GLS CONVERSION NOT RAISING AN ERROR LIKE I-CONNECT FOR WINDOWS WHEN INSERT MISMATCHED CHARACTERS. |
| IC52656 | SELECT WITH ORDER BY GIVES ERROR -202 AFTER UPGRADING TO 10.00.FC6 |
| IC52661 | ONSMSYNC -T DOES NOT PASS THE CORRECT COPY ID TO BSADELETEOBJECT() |
| IC52666 | YOU RUN A QUERY USING A SYNONYM WITH OUTER JOINS AND AN ORDER BY CLAUSE THEN IDS ALLOCATES MEMORY UNTIL IT CRASHES |
| IC52667 | ONCHECK -CR AND ONCHECK -PR RETURN AN ERROR ON ELEMENT IFX_EXTEND_ROLE |
| IC52677 | AN INCOMPLETE UPDATE TO A SLOB COLUMN CAUSES ZERO-BYTE LARGE OBJECTS TO BE CREATED IN THE SBSPACE. |
| IC52680 | A MEMORY LEAK IN THE AIO POOL IS CAUSED BY SETTING THE ONCONFIG PARAMETER SECURITY_LOCALCONNECTION |
| IC52695 | MEMORY LEAK IN EXE POOL OCCURS WHEN USING FUNCTION ST_INTERSECTS() |
| IC52736 | IDS WILL ASSERT FAIL WHEN A CLIENT CONNECTS WITH AN ENVIRONMENT LARGER THAN 32 KB. |
| IC52739 | ENGINE ASSERT WARNS REPEATEDLY ON LOCK TABLE OVERFLOW WHEN MEMORY ALLOCATION FAILS |
| IC52745 | OPTIMIZER CHOOSES WRONG INDEX PATH CAUSING THE QUERY TO RUN SLOW |
| IC52747 | STORED PROCEDURE USING A HOST VARIABLE TO SET A VALUE DOES NOT RETURN EXPECTED ROWS. |
| IC52749 | BTSCANNER CAN SEND UNITITALIZED OR INVALID PAGES TO PTMAPX IF ALICE MODE ENABLED |
| IC52767 | IDS TOOLS LIKE ONSTAT, ONMODE, ONCHECK, ONTAPE ARE UNABLE TO ATTACH TO SHARED MEMORY ON WINDOWS SERVER 2003 SP2 WITH LARGE SHARE |
| IC52803 | TRUNCATE TABLE RESETS STATISTICS IN SYSINDICES FOR UNRELATED TABLES |
| IC52804 | SETTING OPTIMIZER DIRECTIVES DOES NOT WORK AS EXPECTED FOR SPATIAL QUERIES |
| IC52807 | UNNECESSARY BUFFER READS CAUSED BY SEQUENTIAL SCAN ON AN EMPTY TABLE |
| IC52808 | ERROR -242/-106 CAUSED BY ALTER FRAGMENT PERSISTS AS LONG AS THE SESSION IS ACTIVE |
| IC52842 | EXTERNAL DIRECTIVES DO NOT ALLOW BLANK SPACE IN FRONT OF STRING |
| IC52887 | BTREE SCANNER RUNS IN ENDLESS LOOP |
| IC52894 | RUNNING MULTIPLE ONCHECK IN MULTIUSER ENVIRONMENT, CAN CAUSE SYSTEM TO HANG |
| IC52903 | THE OPTIMIZER CHOOSES A SLOWER PATH FOR A SELECT QUERY WITH OUTER JOIN AND WHERE CLAUSE AFTER IDS UPGRADE. |
| IC52908 | ERROR -768 RESULTS WHEN RUNNING AN UPDATE WITH A SUBQUERY WHERE THERE IS A SELF-JOIN ON THE MASTER TABLE AND THE SUBQUERY TABLE |
| IC52930 | CDR REPAIR ATS ON ER READ ONLY TARGET CHANGES REPLICATE BEHAVIOUR ON TARGET TO APPLY |
| IC52948 | ER CAN FAIL TO START WITHOUT A SINGLE MESSAGE ON AN EXPLICIT STANDARD SERVER IF DBSERVERNAME IS CHANGED |
| IC52972 | ONTAPE USAGE IS MISSING THE LOWER CASE -T STDIO AND -V OPTIONS |
| IC52973 | PERFORMANCE PROBLEMS AFTER UPGRADE TO IDS 10.00.XC6 |
| IC52982 | INCORRECTLY PLACED THOUSANDTH SEPARATOR FAILS TO GIVE ERROR. |
| IC52985 | UPDATE STATISTICS ON A TABLE WITH MANY FRAGMENTS AND MANY ROWS GIVES ERROR 597 |
| IC52995 | BTSCANNER DOESNT CONSIDER EXCLUSIVE OPENED DATABASES AND CAUSES LOCKING ERRORS. |
| IC53080 | SERVER CRASH WITH MUTEX HOLDER VALUE IS NOT NULL IN SB_LT_DEALLOC_NOCHECK, MT_FREE_MUTEX |
| IC53133 | XA_RECOVER DOES NOT WORK FOR MSDTC TRANSACTION |
| IC53134 | ADM VP ASSERTION FAILURE CAN HAPPEN BECAUSE OF RACE CONDITION BETWEEN LOGBACKUP THREAD AND AIO VP THREAD |
| IC53150 | USER FUNCTION TAKES A LONG TIME TO CREATE WHEN USING AN OPTIMIZER DIRECTIVE |
| IC53159 | ONSTAT -G SEG SHOWS WRONG TOTAL BLKUSED VALUE WHEN SEGMENT ID EXCEEDS 9 DIGITS |
| IC53160 | INDEX SCAN ON A REMOTE (OUTER) VIEW RETURNS WRONG RESULT |
| IC53164 | CURRENT SERIAL8 VALUE IS NOT SHOWN THROUGH ONCHECK -PT |
| IC53174 | ERROR -874 FROM OPTIMIZER WHEN AN UMLAUT IS USED IN LIKE/MATCHES CONDITION WITHIN A PROCEDURE |
| IC53188 | WRONG RESULTS USING OUTER AND IS NULL(DOMINANT ID) CONDITION |
| IC53199 | NO CLEAN UP OF SHADOW REPLICATE WHEN A SYNC IS PERFORMED ON A LEAF SERVER |
| IC53200 | DOING AN INSERT WITH QUESTION MARKS AS PART OF THE DATA VIA JDBC ALLOCATES AN HUGE AMOUNT OF MEMORY AND CRASHES THE SERVER |
| IC53201 | TLR ON SUSE LINUX 10.2 CANNOT BE USED WITH STDIO |
| IC53214 | WITH SIMPLE PASSWORD ENCRYPTION (SPWDCSM) AND PAM (IN PASSWORD MODE), USER CANT CONNECT TO SERVER, EVEN WITH VALID PASSWORD. |
| IC53215 | USING CDR DEFINE REPLICATE WITH -D -----IGNOREDEL PRODUCES USAGE ERROR |
| IC53216 | LONG FORM OF CDR CHECK REPLICATE FAILS |
| IC53225 | EXECUTING FUNCTIONS IFX_PARAM_TYPES/IFX_RET_TYPES IN SELECT CAUSES MEMORY CORRUPTION |
| IC53227 | USING STDEV ON A SMALLFLOAT COLUMN SOMETIMES RETURNS ERROR 647 ON FUNCTION SQRT |
| IC53259 | CAST IS NOT CREATED AS ORIGINALLY DEFINED AFTER RUNNING OUTPUT OF DBSCHEMA |
| IC53261 | REPEATED ASSERTION FAILURES WHEN SHMTOTAL IS REACHED AND LOCK TABLE OVERFLOW OCCURS |
| IC53287 | ARCHECKER INCORRECTLY REPORTS ERROR WHEN VERIFYING DBSPACE FROM WHICH AN INTERMEDIATE CHUNK HAS BEEN REMOVED |
| IC53312 | WRONG RESULTS USING JOIN WITH SUBSTRING CONDITION AND IN CLAUSE |
| IC53313 | CDR LIST REPL REPORTS ACTIVE STATUS OF A REPLICATE THAT HAS BEEN SUSPENDED |
| IC53329 | MOD() OPERATOR RETURNS ZERO INCORRECTLY FOR SOME LARGE VALUES |
| IC53339 | REMOTE QUERY ON A VIEW DEFINED WITH A CALL TO TO_CHAR, RPAD, OR REPLACE FUNCTIONS FAILS WITH ERROR 9628. |
| IC53401 | CDR SYNC USING --EXTRATARGETSROWS=DELETE GIVES A USAGE ERROR |
| IC53442 | WRONG RESULTS RETURNED WHEN OPTCOMPIND SET TO 0 AND COMPOSITE INDEX IS BEING USED |
| IC53474 | ONINIT HANGS FOR SOME TIME DURING RESTORE FROM BACKUP |
| IC53475 | THE DATABASE SERVER TAKES A LONG TIME TO DROP A TIMESERIES VIRTUAL TABLE |
| IC53476 | 893: CANNOT ACTIVATE/CREATE OBJECT ENABLING AN INDEX ON 10.00.UC6W4 |
| IC53477 | SELECT WITH LEFT JOIN CREATES ERROR 768 |
| IC53478 | MEMORY LEAK IN RALLOC WHEN INSERTING INTO A COLLECTION DERIVED TABLE |
| IC53600 | WILDCARD SELECT USING LIKE RETURNS WRONG NUMBER OF ROWS WHEN THERE IS AN INDEX |
| IC53603 | ERROR -874 FROM OPTIMIZER WHEN OPERATOR FUNCTION LESSTHANOREQUAL IS USED |
| IC53617 | A PDQ QUERY USING THE FIRST CLAUSE RETURNS WRONG RESULTS |
| IC53672 | LONG CHECKPOINTS CAN OCCUR WHEN USING A TABLE WITH ROWSIZE > PAGESIZE |
| IC53730 | SELECT WITH TEMP TABLE AND TO_DATE GIVES ERROR 1260 |
| IC53756 | QUERY NOT RETURNING CORRECT RESULTS |
| IC53767 | QUERY FAILS WITH ERROR -874 AFTER RUNNING UPDATE STATISTICS HIGH. IN A FEW OCCASIONS WILL ALSO CRASH THE ENGINE. |
| IC54023 | XA_PREPARE RETURNS -6 (XAER_PROTO) AND LEAVES TRANSACTION BRANCH ORPHANED WITH MTS (TIGHTLY-COUPLED TRANSACTION) |
[{"Product":{"code":"SSGU8G","label":"Informix Servers"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF025","label":"Platform Independent"},{"code":"PF010","label":"HP-UX"},{"code":"PF015","label":"IRIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.0","Edition":"Enterprise;Express","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
More support for:
Informix Servers
Software version:
10.0
Operating system(s):
AIX, HP-UX, IRIX, Linux, Solaris, Windows
Document number:
319631
Modified date:
17 June 2018
UID
swg27010815
Manage My Notification Subscriptions