Limitation of XML virtual storage usage
You can use the XMLVALA and XMLVALS subsystem parameters to limit the amount of Db2 virtual storage that is used for XML processing.
Because XML values are defined without a maximum size, Db2 cannot estimate the amount of memory that it needs for processing SQL/XML and XQuery queries before run time. Db2 allocates virtual storage at run time based on the size of the XML data. For large XML data, the amount of virtual storage that Db2 requires can grow very large.
If your Db2 subsystem encounters storage constraints
because XML values are using too much memory, set the XMLVALA and XMLVALS subsystem parameters:
- To specify the maximum amount of memory, in KB, that Db2 uses for storing XML values for each user, set XMLVALA. The default is 204800 KB.
- To specify the maximum amount of memory, in MB, that Db2 uses for storing XML values for the entire subsystem, set XMLVALS. The default is 10240 MB.