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.
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 |
|
|
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