17.10.3 When a B-tree index or a text index has been defined for a table subject to import processing
If a B-tree index has been defined for a table subject to import processing (including for tables in which a primary key is defined), or if a text index has been defined for a table subject to import processing, check whether the KFAA80203-I message has been issued before you execute the adbimport command. The KFAA80203-I message is issued when table data import processing is completed. If this message has been issued, it means that the time required for re-executing data import processing can be reduced because the re-execute facility that starts from the processing to create B-tree indexes and text indexes is being applied.
If this message has not been issued, you must perform data import processing from the beginning (starting with importing the table data).
The re-execute facility that starts from the processing to create B-tree indexes and text indexes is applied automatically when the adbimport command is re-executed by the same HADB user who executed the adbimport command that terminated abnormally. No special operation is required.
If you want to change command options and import options when re-executing the adbimport command, see 17.10.6 Changing command options and import options when re-executing commands.
- Important
-
-
If an access error occurred on a command status file (file under the $DBDIR/ADBSYS/ADBUTL directory) and the KFAA50244-E message has been issued, execute the adbidxrebuild command with the --force option specified.
Also, when an index is defined for the table to be processed while the adbimport command is stopped, and the KFAA50209-E message has been issued, execute the adbidxrebuild command with the --force option specified. If the adbimport command has not been canceled, execute the adbidxrebuild command without the --force option specified.
For details about how to execute the adbidxrebuild command with the --force option specified, see (2) Executing the adbidxrebuild command with the --force option specified in 17.10.7 If an error occurs during re-execution of the adbimport command.
-
If an access error occurs on a temporary work file (the KFAA50247-E message has been issued), execute the adbidxrebuild command with the --create-temp-file option specified.
For details about how to execute the adbidxrebuild command with the --create-temp-file option specified, see (1) Executing the adbidxrebuild command with the --create-temp-file option specified in 17.10.7 If an error occurs during re-execution of the adbimport command.
-