PH62674: SYSTEM ERROR "COULD NOT ALLOCATE LOB BUFFER "

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Customer is performing EXTRACT processing under ISPF of DB2
  data. The table includes a CLOB column. They create a very large
  Row List (PNS). After a successful EXTRACT, they attempt another
  one reusing the existing PNS. The process terminates with the
  following System Error:
  
  Insufficient Memory on 2024/08/02 16:05
  
  Optim encountered shortage of virtual memory and processing will
  be terminated. ...
  
  An Internal System Error has Occurred on 2024/08/02 16:06
  
  Could Not Allocate LOB Buffer
  DB2Rel=1215(NFM), Rel=11.7.0
  Code=-2, AuxInfo=
  01  FOPDETCH 20240328 PH59828  (000992) AT_FetchSet
  02  FOPEDRIV 20240328 PH59828  (002999) Initialize
  03  FOPEDRIV 20240328 PH59828  (000642) EditAD
  
  In addition, an EDIT attempt of the table with a (nullable) CLOB
  column terminates with the following DB2 error:
  
  DSNT408I SQLCODE = -301, ERROR:  THE VALUE OF INPUT VARIABLE OR
           ARGUMENT NUMBER 6 CANNOT BE USED AS SPECIFIED BECAUSE
           OF ITS DATA TYPE
  DSNT418I SQLSTATE   = 42895 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNXRIHB SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = -480  0  0  -1  0  0 SQL DIAGNOSTIC INFO
  DSNT416I SQLERRD    = X'FFFFFE20'  X'00000000'  X'00000000'
           X'FFFFFFFF'  X'00000000'  X'00000000' SQL DIAGNOSTIC
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Optim users processing DB2 tables with       *
  *                 nullable LOB and XML columns.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: See Error Description.                  *
  ****************************************************************
  A coding error causes incorrect processing of LOB and XML
  columns.
  

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:

Modules/Macros

• FOP1ODRV FOP1OSFN FOP4PEMN FOP4PMMN FOP9APIM FOPCFPMN FOPCXLIB
  FOPDYER3 FOPDYER5 FOPHSTM  FOPMAIN  FOPMCENU FOPMCMAI FOPMCOLA
  FOPMCOLP FOPMDMAI FOPMDPRC FOPMDXTR FOPMECMN FOPMEMAI FOPMMCMR
  FOPMMJBS FOPMMUNU FOPMMUTL FOPMUXIM FOPODPP  FOPOMN   FOPRS9
  FOPT0P10 FOPT110J FOPT29J  FOPT29K  FOPTC710 FOPTC718 FOPTUO50
  FOPTUO51 FOPUMCBT FOPZFMMN FOPZMAIN
  

Fix information

• Fixed component name

  OPTIM MOVE FOR

• Fixed component ID

  5655V0700

Applicable component levels

• RB70 PSY UI98046

     UP24/08/17 P F408

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.