Fix list for Informix Server 11.70.xC9W2

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

APAR

Abstract

IT18144

PDQ insert when select from an external table with wrong delimiter can assertr an xlcnv thread

IT20166

shared lock held on "bld ref ###" when ddl insert on table with referential constraint waits on lock held by parent table

IT21541

Need backport of APAR IT21541 to 11.70

IT26236

ISM fails to backup space larger than approximately 4.3 Terabytes.

IT26382

Deadlock (-143 / -622) on sysfragments & sysindices when concurrent TRUNCATE & SET INDEXES FOR with lock mode WAIT & no log DB

IT27018

With variable row length and MAX_FILL_DATA_PAGES pages might forever offer room that never satisfies any new row, potentially causing long checkpoint blocks

IT27262

onmode -- output shows the wrong usage syntax for onmode -I

IT27265

Function Replace prints different results for the same record which has char variable.

IT27311

expensive plan with high estimated cost is chosen over a much better plan for query with multiple ansi joins

IT27477

onstat -z can hang the server if it finds a bad mutex

IT28303

jdbc client that retrieves auto generated keys for insert into ... select from ... statement leaks opentable memory and open table entries in IDS

IT28342

PROMOTING AN SDS TO A PRIMARY SERVER REPORTS A PANIC ON THE PRIMARY INSTEAD OF A PROPER SHUTDOWN

IT28376

Server assert fails in fm_openany after unexpected call to execute_blob_assign due to uninitialized value_t

IT28476

Modified backport of defect APAR IT02085 in 11.70 addresses the original problem but doesnt prevent from -874 in op_join/opchop as in 12.10

IT29002

readahead_### threads can be continually allocated

IT29006

SQL API modify chunk expand, currently allows the server to increase the size of an non big page chunk to more then 1048576 pages

IT29031

querying maximum value out of a given range in a date column will scan index from end without yielding vp

IT29239

spurious and permanent error -106 (non-exclusive access) possible

IT29322

When rtree node splits and server has hdr/rss configured, then pages on hdr/rss get out of sync with primary due to slot length difference

IT30087

DR_IXRDROP does not protect DRBRP->bt_rstcb from being cleared during attempt to call ixrdrop.

IT30188

Rollforward of log record failed iserrno = 111 trying to apply log records for just created RTREE index in non default page size dbspace

IT30240

Logical recovery error trying to restart server if rtree index has been sent to secondary but no checkpoint happens before failure

IT30384

Exception in arc_bpages detecting/correcting corrupted BLOBspace page

IT30403

MEMORY CORRUPTION FROM OPTIMIZER JOIN STRUCT CREATION

IT30417

Potential large amounts of memory corruption/server abort if the row length portion of sort of variable length data is corrupted

IT30471

socssllst thread can block forever during accept of client connection, waiting for response from client

IT30715

Locking temporary table causes HDR Primary to crash

IT31807

excessive memory usage during archive when chunk contains 0x7fffffff pages

IT31851

A chunk can be extended past MAX_CHK_SIZE_KB (e.g. currently 4 TB on linux), at which time ch_size goes negative and all heck breaks loose.

IT32066

Multi table query using inner and left uses a wrong path resulting in poor perfromance

IT32397

dbschema do not output not null phrase on external tables.

IT32490

distributions are not created for first column of temp table when running update statistics high or medium

IT32532

query plan with best estimated cost that also runs the quickest  is not chosen

IT32533

distributions created on a temp table used in a query can skew costs and optimizer may chose bad plan

IT32607

Concurrent starting and exiting of dbWorker threads could lead to incorrect ce_usecount/ref_cnt

IT33046

ISTAR query using DECRYPT_CHAR(column,value) as a filter which is promoted by the optimizer to the remote database cause an assertion in  decrypt_const_password

IT33157

ifxclone hardcodes the setting of INFORMIXCONTIME to the value of 10

IT33231

Unable to create XA transactions with IBM Data Server Clients version 11.1 and above

IT34052

No error message information for 19849 using finderr

IT34040

-9700 error can occur on open cursor after aus_evaluator task runs and update statistics