Database Shared Memory

The following parameters affect the database global memory allocated on your system:

• Buffer Pool Size (buffpage).

• Database Heap (dbheap).

• Catalog Cache Size (catalogcache_sz).

• Log Buffer Size (logbufsz).

• Utility Heap Size (util_heap_sz).

• Default Backup Buffer Size (backbufsz).

• Default Restore Buffer Size (restbufsz).

• Maximum Storage for Lock List (locklist).

• Package Cache Size (pckcachesz).

• Sort Heap Size (sortheap). This parameter only affects database global memory if you have shared sorts.