Fast Unload Job to unload a table with XML columns failed with the following error message.
PFU0335E - VBS REC STORAGE ACQUISITION FAILED FOR DD: SYSREC01
There were XML columns in the DB2 table.
Release : 20.0
Component : CA Fast Unload for DB2 for z/OS
This is the meaning for the PFU0335E error message:
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.
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
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.