17.10.5 Whether the re-execute facility that starts from the processing to create B-tree indexes and text indexes can be applied
Depending on the adbimport command's cancellation timing, the re-execute facility that starts from the processing to create B-tree indexes and text indexes might or might not be applied when the adbimport command is re-executed.
The table below describes 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.
Note that the database recovery method is the same regardless of the cancellation timing.
-d option |
Timing of the cancellation#1 |
||
---|---|---|---|
While creating table data |
During sort processing |
During creation of B-tree and text indexes#2 |
|
Specified (creation mode) |
|
|
|
Omitted (addition mode) |
|
|
- Legend:
-
Re-execute facility: Re-execute facility that starts from the processing to create B-tree indexes and text indexes
- Note:
-
B-tree indexes include the B-tree index for the primary key.
- #1
-
You can determine when the command was canceled by the messages that are issued, as shown in the following:
- #2
-
If the KFAA80204-I message (whose return code is 0 or 4) has been issued, the table and indexes have been imported. In this case, there is no need to re-execute the adbimport command.
If the KFAA80204-I message is not output, execute the following command, and then check the second line in the output results (the column titles occupy the first line in the output results):
adbdbstatus -c table -n name-of-table-for-which-adbimport-command-was-canceled
Specify name-of-table-for-which-adbimport-command-was-canceled in the format schema-name.table-identifier.
- ■ When the value of the Command_status column (column 17) is abort and the value of the Rerun_command column (column 18) is adbimport
-
Import processing was not completed. Re-execute the adbimport command.
- ■ When no values are displayed in the Command_status column (column 17) and the Rerun_command column (column 18)
-
Import processing has been completed. There is no need to re-execute the adbimport command.
- #3
-
When the adbimport command is re-executed, the data import processing is performed from the beginning.
- #4
-
When the adbimport command is re-executed, the data import processing restarts from the point of B-tree and text index creation processing. However, if all the B-tree indexes and text indexes defined for the table to be processed are deleted before the adbimport command is re-executed, only command termination processing is performed.