PFU0335E VBS REC STORAGE ACQUISITION FAILED FOR DD SYSREC01 unloading XML data

Products

• Fast Unload for DB2 for z/OS

Issue/Introduction

Fast Unload for Db2 for z/OS (PFU) job to unload a table with XML columns failed with the following error message.
  
PFU0335E - VBS REC STORAGE ACQUISITION FAILED FOR DD: SYSREC01
  
FASTUNLOAD                          
DISCARDS 1                          
INPUT-FORMAT TABLE                  
LOAD-CONTROL NONE                   
OUTPUT-FORMAT VARIABLE              
PART-INDEPENDENCE NO                
SHRLEVEL REFERENCE                  
SQL-ACCESS  EXTENSION               
SELECT                              
...
 FROM table-name; 
  
There were XML columns in the Db2 table. 

Resolution

This is the meaning for the PFU0335E error message: 
 
Reason:                                                                     
There is not enough region space specified to accommodate the I/O buffers   
requested. If your DFP level is below 3.2, these buffers are below the 16M line.                                                                       
                                                                            
Action:                                                                     
In this case, the alternative is to specify a smaller number of I/O buffers.
  
There was REGION=512M in the Fast Unload Job. Probably the best solution should be to increase the above storage available with REGION=0M or increase the REGION=512M value.
   
PFU0140I - MAX PRIVATE REGION ABOVE.:      524,288.K, FREE:      521,308.K
                          CONTIGUOUS:      521,008.K
  
If you cannot run with REGION=0M then you may need to specify the LOB-LOC-SIZE parameter to control the amount of internal buffer storage obtained.
It appears that the LOB-LOC-SIZE keyword is used for XML processing as well as xLOB processing.  Start with LOB-LOC-SIZE 250M to see if this will resolve the PFU0335E error message. 
   
The default value for LOB-LOC-SIZE option is 500MB.