Hitachi

Hitachi Advanced Database Setup and Operation Guide


4.3.4 Estimating memory requirements during execution of the adbgetcst command

The following table shows the formula for calculating the amount of memory required when the adbgetcst command is executed.

Table 4‒6: Memory requirement determinations (during execution of the adbgetcst command)

No.

Memory type

Formula (megabytes)

Related server definitions

1

Shared memory

Shared memory management area

100

None

2

Global buffer page

dbarea_num × 1,024

adbbuff operand

3

Process common memory

1,024 + max_users + GBUF

  • adb_sys_proc_area_max operand

  • adbbuff operand

4

Real thread private memory

rthd_num × 512

adb_sys_rthd_area_max operand

5

Process memory

Heap memory

1,024

None

Explanation of the variables

dbarea_num: Number of data DB areas

If this value cannot be estimated, use the combined total number of tables and indexes that will be defined.

max_users

Value specified for the adb_sys_max_users operand in the server definition

GBUF: Global buffer

Assume 20 megabytes for each 400 megabytes of the global buffer page size calculated in No. 2.

rthd_num

Value specified for the adb_getcst_rthd_num cost-information collection option