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.
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.
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.