DB2 Version 9.7 for Linux, UNIX, and Windows

util_heap_sz - Utility heap size configuration parameter

This parameter indicates the maximum amount of memory that can be used simultaneously by the BACKUP, RESTORE, and LOAD (including load recovery) utilities.

Configuration type
Parameter type
Configurable online
Propagation class
Default [range]
5000 [16 - 524 288 ]
Note: The default value is subject to change by the DB2® Configuration Advisor after initial database creation.
Unit of measure
Pages (4 KB)
When allocated
As required by the database manager utilities
When freed
When the utility no longer needs the memory

Recommendation: Use the default value unless your utilities run out of space, in which case you should increase this value. If memory on your system is constrained, you might want to lower the value of this parameter to limit the memory used by the database utilities. If the parameter is set too low, you might not be able to run utilities concurrently. You should update this parameter dynamically as needed. For a small number of utilities, set this parameter to a small value. For a large number of utilities, or for memory intensive utilities, you should set this parameter to a larger value.