IT36512: DB2 CLI APPLICATION MAY FAIL TO RETRIEVE LOB VIA STREAMING WITH ERROR -902 (RC 9) WHEN DATA_ENCRYPT IS SET

Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows

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 is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  IT36527

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RB10 PSN

     UP