2.2.2 Format of archive chunk options

(1) Specification format

[set adb_arcv_rthd_num = number-of-processing-real-threads-to-be-used-by-adbarchivechunk-command]
[set adb_arcv_scan_buff_size = table-data-scan-buffer-size]

The rules for specifying these archive chunk options are the same as for the server definition. For the rules for specifying server definitions, see the topic Syntax rules for the server definition in the HADB Setup and Operation Guide.

To Page Top

(2) Explanation of specification format

● adb_arcv_rthd_num = number-of-processing-real-threads-to-be-used-by-adbarchivechunk-command

~<integer>((3 to 4,096))

Specifies the number of processing real threads to be used for executing the adbarchivechunk command.

Specify 9 for this option. If you do not specify this option, or you specify a value other than 9, chunk archive processing might take longer.

The adbarchivechunk command uses the number of processing real threads specified in this option. For details about the processing of the adbarchivechunk command using processing real threads and the number of processing real threads to be used for each step of processing, see 2.1.2 Relationships among threads used by the adbarchivechunk command.

If this option is omitted, the number of processing real threads to be used for executing the adbarchivechunk command is determined by the adb_sql_exe_max_rthd_num operand in the server definition. The following table shows the relationship between the value of this option or the adb_sql_exe_max_rthd_num operand in the server definition and the number of processing real threads used for executing the command.

Table 2‒14: Number of processing real threads used for executing the command

No.	Value in this option or in the server definition		Number of processing real threads used for executing the command
1	When this option is omitted	If the adb_sql_exe_max_rthd_num operand in the server definition is not specified	The default value of the adb_sql_exe_max_rthd_num operand in the server definition is used.
2		If a value in the range from 0 to 2 is specified in the adb_sql_exe_max_rthd_num operand in the server definition	--
3		If 3 or a greater value is specified for the adb_sql_exe_max_rthd_num operand in the server definition	The value specified for the adb_sql_exe_max_rthd_num operand in the server definition is used.
4	If 3 or a greater value is specified in this option		The value specified in this option is used.

Legend:

--: The adbarchivechunk command results in an error.

Note:

For details about the adb_sql_exe_max_rthd_num operand in the server definition, see Operands related to performance (set format) in the HADB Setup and Operation Guide.

● adb_arcv_scan_buff_size = table-data-scan-buffer-size

~<integer>((1 to 2,048))<<16>> (units: megabytes)

Specify the size (in megabytes) of the buffer to be used for retaining table data search results. A larger value can reduce overhead in searching table data.

As a guideline, specify a value equivalent to the data length in the search results times about 10,000.

For details about how to obtain data lengths in search results, see Data length of each data type in Determining the memory requirement during normal operation in Estimating the HADB server's memory requirement in Preparing Resources in the HADB Setup and Operation Guide.

Note that all the scan results stored in one scan buffer are output to the same archive file.

If the specified buffer size is too small to store any data item obtained in the scan results, the adbarchivechunk command will result in an error.

To Page Top