6.3.10 Determining the memory requirement for executing the adbexport command
When the adbexport command is executed, the HADB server uses the type of memory described in this subsection. Determine the requirement for each type of memory.
- ■ Shared memory
-
-
Process common memory (PROC_EXPORTSZ)
-
Real thread private memory (RTHD_EXPORTSZ)
-
- ■ Process memory
-
-
Heap memory (HEAP_EXPORTSZ)
-
- Organization of this subsection
(1) Determining the process common memory requirement (for executing the adbexport command)
Use the following formula to determine the amount of process common memory (PROC_EXPORTSZ) required to execute the adbexport command.
Formula (kilobytes)
|
|
![[Figure]](GRAPHICS/F0000441.GIF)
- #1
-
Add this value when the number of output data files specified for the output data path file name exceeds 1,024.
- #2
-
If you execute multiple adbexport commands concurrently, determine the memory requirement for each adbexport command. Then, add up the total memory requirements.
Explanation of variables
- PROC_MNG
-
Use the following formula to determine the value.
Formula (kilobytes)
![[Figure]](GRAPHICS/F0000442.GIF)
- #1
-
Add this value if you specify the -n option for the adbexport command.
- #2
-
Add this value when the audit trail facility is enabled.
- DIC
-
Determine the value by referring to the explanation of the variable DIC in (a) Determining the variable PROC_IMPT in (1) Determining the process common memory requirement (for executing the adbimport command) in 6.3.6 Determining the memory requirement for executing the adbimport command.
- IOA
-
Use the following formula to determine this value.
Formula (kilobytes)
![[Figure]](GRAPHICS/F0000443.GIF)
- sql_size
-
Use the following formula to determine this value.
Formula
sql_size = (SQL-statement-file-size) x 2 + 1 + 1,024
- scan_buff_size
-
Use the following formula to determine this value.
Formula
value-specified-for-export-option-adb_export_scan_buff_size x 1,024
- offset_area
-
Use the following formula to determine this value.
Formula
(8 x number-of-columns-in-search-result x (scan_buff_size x 1,024 ÷ data-length-in-search-result)) ÷ 1,024
- scan_rthd
-
Use the following formula to determine the value:
Formula
↓(value-specified-for-export-option-adb_export_rthd_num - 1) ÷ 2↓
- EXPF
-
Use the following formula to determine this value.
Formula (kilobytes)
![[Figure]](GRAPHICS/F0000444.GIF)
- #
-
Add this value when you specify the --compress GZIP option for the adbexport command.
- exp_rthd
-
Use the following formula to determine this value.
Formula
↓(value-specified-for-export-option-adb_export_rthd_num - 1) ÷ 2↓
- PROC_EXPSQLS
-
When the adbexport command is executed, the following SQL statement is executed once to export data from the processing-target table.
If the -n option is specified
SELECT * FROM target-table-name;
If the -q option is specified
SELECT-statement-specified-in-the-SQL-statement-file
Determine for each processing-target table the amount of memory required to execute a retrieval SQL statement by referring to (c) Determining the variable PROC_EXECSQLSZ in (1) Determining the process common memory requirement (during normal operation) under 6.3.4 Determining the memory requirement during normal operation. Then, substitute the largest of the determined values.
- PROC_AUDINFSZ
-
Determine the value of the variable PROC_AUDINFSZ according to (r) Determining the variable AUDINF in (3) Determining the process common memory requirement (for starting the HADB server) under 6.3.3 Determining the memory requirement for starting the HADB server.
- PROC_OUTFILE
-
This value must be added when the number of output data files specified for the output data path file name exceeds 1,024. Use the following formula to determine this value.
Formula (kilobytes)
![[Figure]](GRAPHICS/F0000445.GIF)
- OUTFMAX
-
Number of output data files specified for the output data path file
(2) Determining the real thread private memory requirement (during execution of the adbexport command)
Use the following formula to determine the amount of real thread private memory (RTHD_EXPORTSZ) required to execute the adbexport command.
Formula (kilobytes)
|
|
![[Figure]](GRAPHICS/F0000446.GIF)
Explanation of variables
- EXPORTSQL
-
When the adbexport command is executed, the following SQL statement is executed once to export data from the processing-target table.
If the -n option is specified
SELECT * FROM target-table-name;
If the -q option is specified
SELECT-statement-specified-in-the-SQL-statement-file
Determine for each processing-target table the amount of memory required to execute a retrieval SQL statement by referring to (c) Determining the variable RTHD_EXESQLSZ and (g) Determining the variable RTHD_EXESQLDICSZ in (2) Determining the real thread private memory requirement (during normal operation) under 6.3.4 Determining the memory requirement during normal operation. Then, substitute the largest of the determined values.
(3) Determining the heap memory requirement (for executing the adbexport command)
Use the following formula to determine the amount of heap memory (HEAP_EXPORTSZ) used to execute the adbexport command.
Formula (kilobytes)
|
|
![[Figure]](GRAPHICS/F0000447.GIF)
- #
-
If you execute multiple adbexport commands concurrently, determine the memory requirement for each adbexport command. Then, add up the total memory requirements.
Explanation of variables
- HEAP_ZLIB
-
If you specify the --compress GZIP option, use the following formula to determine this value.
Formula (kilobytes)
![[Figure]](GRAPHICS/F0000448.GIF)
- file_num
-
Number of output data files