4.3.5 Estimating memory requirements during execution of the adbexport command

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

Table 4‒7: Memory requirement determinations (during execution of the adbexport 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 + (db_idx` `× 1,024)`	`adbbuff` operand
3		Process common memory	`1,024 +` `max_users` `+` `GBUF` `+ (scan_buff_size` `x` `rthd_num` `x 4)`	`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.

scan_buff_size

Value specified for the adb_export_scan_buff_size export option

rthd_num

Value specified for the adb_export_rthd_num export option

db_idx: Size of the data DB area for storing indexes (gigabytes)