Hitachi

Hitachi Advanced Database Command Reference


17.10.6 Changing command options and import options when re-executing commands

This subsection explains the effects of changing command options and import options when the adbimport command is re-executed.

Organization of this subsection

(1) Changing command options

Whether a changed command option takes effect depends on when the adbimport command is canceled. The following table describes how to resume processing when changing command options.

Table 17‒18: Resuming processing when changing command options

No.

Command option to be changed

When canceled#

During creation of a data part of a table

During sort processing

During creation of B-tree and text indexes

1

-u option

N

N

N

2

-p option

N

N

N

3

-d option

Y

--

--

4

-k option

Y

--

--

5

-s option

Y

--

--

6

-g option

Y

--

--

7

-w option

Y

--

--

8

-z option

Y

Y

Y

9

-e option

Y

--

--

10

--force option

If you specify --force, the processing is forcibly re-executed. Therefore, this option does not apply.

11

-b option

Y

--

--

12

--status wait option

Y

--

--

13

-m option

Y

Y

Y

14

-f option

Y

--

--

15

-r option

Y

--

--

16

table-to-be-processed

N

N

N

17

input-data-path-file-name

Y

--

--

Legend:

Y: Changes take effect.

N: Changes will not cause re-execution.

--: Changes are ignored (the processing is executed using the specification before the change).

#

For details about the timing of cancellation, see Table 17‒17: Whether the re-execute facility that starts from the processing to create B-tree indexes and text indexes is applied, depending on the adbimport command's cancellation timing.

(2) Changing import options

Whether a changed import option takes effect depends on when the adbimport command is canceled. The following table describes how to resume processing when changing import options.

Table 17‒19: Resuming processing when changing import options

No.

Import option to be changed

When canceled#

During creation of a data part of a table

During sort processing

During creation of B-tree and text indexes

1

adb_import_errdata_file_name

Y

--

--

2

adb_import_errdata_num

Y

--

--

3

adb_import_errmsg_lv

Y

--

--

4

adb_import_rthd_num

Y

Y

Y

5

adb_import_read_size

Y

--

--

6

adb_import_buff_blk_num

Y

--

--

7

adb_import_sort_buff_size

Y

Y

--

8

adb_import_dividx_rd_buff_size

Y

Y

Y

9

adb_import_dividx_wt_buff_size

Y

Y

Y

10

adb_import_txt_buff_size

Y

Y

Y

11

adb_import_decompress_buff_size

Y

--

--

12

adb_import_null_string

Y

--

--

Legend:

Y: Changes take effect.

--: Changes are ignored (the processing is executed using the specification before the change).

#

For details about the timing of cancellation, see Table 17‒17: Whether the re-execute facility that starts from the processing to create B-tree indexes and text indexes is applied, depending on the adbimport command's cancellation timing.