|
|
abukta
super admin
profile |
|
Join Date: 29 Mar 2005 21:03
Posts: |
|
|
How to increase DBHEAP in DB2 UDB (Unix) |
What is DB2 UDB's DBHEAP? The amount of shared memory available for use by the database (in 4KB pages) used or sorts in intra-partition parallelism or full parallelism (intra-partition and inter-partition).
To get the current value of DBHEAP:
DB2 GET DB CFG
To update the value:
DB2 UPDATE DATABASE CONFIGURATION [FOR database-alias] USING {config-keyword value ...}
eg:
DB2 UPDATE DB CFG FOR E880G40J USING DBHEAP 2000
|
Home 
Forum
