4.3.7 Estimating memory requirements during execution of the adbarchivechunk command
The following table shows the formula for calculating the amount of memory required when the adbarchivechunk 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 x 1,024 + (db_idx x 1,024) |
adbbuff operand |
|
|
3 |
Process common memory |
1,024 + max_users + GBUF + (scan_buff_size x rthd_num x 4) |
|
|
|
4 |
Real thread private memory |
rthd_num x 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.
- db_idx: Size of the data DB area for storing indexes (gigabytes)
-
Substitute the values determined for the following items in Table 4‒1: Formula (DB directory size) in 4.2.1 Estimating the size of the DB directory.
-
Data DB area file for storing B-tree indexes
-
Data DB area file for storing text indexes
-
Data DB area file for storing range indexes
-
- 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.
- scan_buff_size
-
Value specified for the archive chunk option adb_arcv_scan_buff_size
- rthd_num
-
Value specified for the archive chunk option adb_arcv_rthd_num