A fix is available
APAR status
Closed as program error.
Error description
There is a rare edge case attempting to stream lob objects via Dynamic Data Format which can be enabled by the db2cli.ini LOBCacheSize option setting (or alternatively by the SQL_ATTR_LOB_CACHE_SIZE statement attribute). Additional the dbm cfg authentication parameter need to be set to DATA_ENCRYPT. When this edge condition occurs we fail to return the LOB value and might return the error SQLJC_ERROR_BEOF which cause the -902 failure in the application. In addition the following messages might be logged in db2diag.log (DIAGLEVEL 4): 2021-04-09-02.11.58.823692-420 I10324E1625 LEVEL: Info PID : 1699080 TID : 140562273026176 PROC : db2batch INSTANCE: db2v111 NODE : 000 DB : XXX APPID : 10.2.1.234.60148.210409091158 HOSTNAME: db2sup FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReadDssContLen, probe:50 MESSAGE : ZRC=0x87360009=-2026504183=SQLJC_ERROR_BEOF "DATA DOES NOT EXIST" DIA8506C Unexpected end of file was reached. ... 2021-04-09-02.11.58.827989-420 I15126E408 LEVEL: Severe PID : 1699080 TID : 140562273026176 PROC : db2batch INSTANCE: db2v111 NODE : 000 DB : XXX APPID : 10.2.1.234.60148.210409091158 HOSTNAME: db2sup FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReadDssHdr, probe:20 MESSAGE : ZRC=0x8036008D=-2143944563=SQLJC_ERROR_SYNTAX "SYNTAX ERROR"
Local fix
Disable DATA_ENCRYPT or LobCacheSize setting
Problem summary
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.1.4.7 * ****************************************************************
Problem conclusion
Upgrade to 11.1.4.7
Temporary fix
Comments
APAR Information
APAR number
IT36512
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-04-09
Closed date
2022-04-17
Last modified date
2022-04-17
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 FOR LUW
Fixed component ID
DB2FORLUW
Applicable component levels
RB10 PSN
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
03 May 2022