|
Problem IT37215
|
Status: Closed |
MISSING BYTES OF DATA WHEN FETCHING LOB COLUMNS CONTAINING MULTIBYTE CHARACTERS FROM JCC
|
| product: |
DB2 CONNECT / DB2CONNCT / B50 - DB2 |
| Problem description: |
When a LOB column which contains multibyte characters is
fetched, few bytes of data is missing in some scenarios.
circumstances under which the issue can re-occur:
The issue may re-occur if the all below scenarios are met
? application is trying to fetch LOB data which contains
multibyte characters
? if application is using LOB locators to fetch the data, i.e
progressiveStreaming=2 and fullyMaterializeLobData=false
? If the data size is greater than streamBufferSize.
Even when all the criteria are met, the issue occurs randomly
depending upon on the character buffer size used in application
and actual data size. It is a rare corner case.
All the driver versions below 4.31 are vulnerable to this
problem. The issue can occur in all OS platforms.
This APAR fix also fixes the length returned for lob objects
e.g: clob.length(). |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All Db2connect users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to v11.5.7.0 and later *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* All Db2connect users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to v11.5.7.0 and later *
**************************************************************** |
| Comment |
Fixed in v11.5.7.0 and later versions |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 10.06.2021
13.10.2021
13.10.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
