PH48726: SQLCODE=-330 PERFORMING UPDATE OR INSERT OF LOB OR XML DATA IN UNICODE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Customer is performing INSERT, or INSERT/UPDATE of a table with
  CLOB columns with Unicode UTF-8 data.
  The size of the data exceeds the size of internal buffers
  (approximately 256K). In certain scenarios, depending on data,
  DB2 may report SQLCODE=-330 when performing the INSERT/UPDATE.
  
  When the data contain Unicode UTF-8 characters which may not be
  converted to the Optim's plan, such characters may get lost,
  or replaced with a substitution character. This may cause space
  characters to be inserted in to the data at the 256K boundaries.
  
  In addition, an ABEND S0C4 may also occur:
  
  CEE3204S The system detected a protection exception
  (System Completion Code=0C4).
  From entry point DSQLIntExecStmt at statement 3569 at compile
  unit offset +00005E96 at entry offset +00005E96 at address
  20EFE5F6.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Optim users performing processing of XML,    *
  *                 CLOB and DBCLOB data encoded in Unicode      *
  *                 with INSERT/RESTORE or CONVERT.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: Optim may corrupt LOB data.             *
  ****************************************************************
  Optim is incorrectly managing its LOB-related buffers and using
  SQL LOB processing statements which may cause data loss in some
  environments.
  

Problem conclusion

• Optim processing will be corrected.
  

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:

  UI82539

Modules/Macros

• FOP00003 FOP00103 FOP00203 FOP00303 FOP00B   FOP01B   FOP05B
  FOP07B   FOP08B   FOP09B   FOP0AB   FOP0BB   FOP0ITKA FOP1ODRV
  FOP1OSFN FOP3DTPR FOP4IPMN FOP4PEMN FOP4PMMN FOP4TRCE FOP9APIM
  FOP9GINF FOPCFPMN FOPCXLIB FOPD2VNN FOPHSTM  FOPIO    FOPK11
  FOPMADDE FOPMAFCN FOPMAIN  FOPMAMAI FOPMARCN FOPMCDRT FOPMCENU
  FOPMCMAI FOPMCOFN FOPMCOLA FOPMCOLP FOPMDBMN FOPMDDDL FOPMDMAI
  FOPMDPRC FOPMDXTR FOPMECMN FOPMEMAI FOPMIXMM FOPMMCMN FOPMMCMR
  FOPMMJBS FOPMMUNU FOPMMUTL FOPMSELM FOPMTMDB FOPMUXIM FOPODPP
  FOPOMN   FOPRS3   FOPRS7   FOPRS9   FOPUMCBT FOPUUNLD FOPVOU
  FOPZFBMN FOPZFMMN FOPZMAIN FOPZSUB
  

Fix information

• Fixed component name

  OPTIM MOVE FOR

• Fixed component ID

  5655V0700

Applicable component levels

• RB70 PSY UI82539

     UP22/09/27 P F209

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.