Changing the database heap size on DB2 broker databases

Increase the value of the database heap size parameter for each broker database to ensure that the heap size is sufficient.

Each database in a DB2® instance is associated with a heap (temporary storage) but the default size of the heap (measured in 4 KB pages) is too low for the broker to use. Therefore, if you create broker databases in DB2, you must increase the heap size to at least 900, which gives the broker database 3600 KB of storage space (that is, 900 multiplied by 4 KB pages).

Using the DB2 Control Center

To change the database heap size using the DB2 Control Center:
  1. Start the DB2 Control Center.
    • On Windows®, click Start > Programs > IBM DB2 > General Administration Tools > Control Center
    • On Linux® and UNIX® , enter the following command (ensure that you have already run the DB2 profile so that the shell is running the DB2 environment):
      db2cc
  2. For each broker database that you have created:
    1. In the tree, right-click the database name, then click Configure Parameters.
    2. In the Database Configuration window, click Performance > DBHEAP.
    3. Click the cell in the Value column, then click the button labelled ...
    4. In the Change Database Configuration Parameters window, set the value of the DBHEAP parameter to at least 900 (the maximum value that you can enter is 60000), then click OK. The new value is displayed in the cell in the Pending Value column in the Database Configuration window.
    5. Click OK. The new value is applied and a message is displayed to show that the heap size was changed successfully.
    6. Click Close to close the message and return to the main DB2 Control Center window.
The heap size of the broker database is changed.

Using the DB2 command line

  1. Open a DB2 command window.
  2. Enter the following command. In this example, WBRKBKDB is the name of the broker database, and 900 is the number of 4 KB pages:
    db2 update database configuration for WBRKBKDB using dbheap 900
The heap size of the broker database is changed.
Next: If you have been following the instructions in Configuring broker databases, the next task is Authorizing access to broker databases.
Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2009Copyright IBM Corporation 1999, 2009. All Rights Reserved.
Last updated : 2009-01-07 15:40:29

ah14450_