Hitachi

Hitachi Advanced Database Command Reference


16.5.6 If an error occurs during re-execution of the adbidxrebuild command

If an error occurs during re-execution of the adbidxrebuild command, identify the cause of the error and take the necessary actions according to the following procedure.

Procedure

  1. Check whether the KFAA50244-E message has been issued.

    If the KFAA50244-E message has been issued, an access error has occurred on a command status file (file under the $DBDIR/ADBSYS/ADBUTL directory). Execute the adbidxrebuild command with the --force option specified.

    For details, see (2) Executing the adbidxrebuild command with the --force option specified.

    If the KFAA50244-E message has not been issued, proceed to step 2.

  2. Check whether the KFAA50247-E message has been issued.

    If the KFAA50247-E message has been issued, an access error occurred on a temporary work file. Execute the adbidxrebuild command with the --create-temp-file option specified.

    For details, see (1) Executing the adbidxrebuild command with the --create-temp-file option specified.

    If the KFAA50247-E message has not been issued, proceed to step 3.

  3. Check whether a message other than KFAA50244-E and KFAA50247-E has been issued.

    Check the message that was issued and identify the cause of the error. After removing the cause of the error, execute the adbidxrebuild command.

Organization of this subsection

(1) Executing the adbidxrebuild command with the --create-temp-file option specified

If the KFAA50247-E message is issued during re-execution of the adbidxrebuild command, an access error has occurred on a temporary work file. Execute the adbidxrebuild command with the --create-temp-file option specified.

Important

It is assumed that the --create-temp-file option will be specified if the temporary work file necessary for re-execution (index record file or sort result file) does not exist. If the adbidxrebuild command is executed when a temporary work file exists, the existing file is re-built. However, if you do not have write or read privileges for the applicable file, an access error might occur during execution of the adbidxrebuild command. (The KFAA30959-E, KFAA40204-E, KFAA40205-E, KFAA40214-E, KFAA41205-E, or KFAA41206-I message is issued. 13 (EACCES) is output for the error number.) In such a case, first delete the applicable file using the OS's rm command or a similar method, and then re-execute the adbidxrebuild command.

(2) Executing the adbidxrebuild command with the --force option specified

If the KFAA50244-E message is issued during re-execution of the adbidxrebuild command, an access error has occurred on a command status file (file under the $DBDIR/ADBSYS/ADBUTL directory).

In this case, take the necessary actions according to the following procedure.

Procedure

  1. Delete the temporary work files.

    Delete the files under the directories listed below (temporary work files) using the OS's rm command or a similar method. If there are any files for which you do not have write or read privileges, you might not be able to execute the adbidxrebuild command.

    • If the -w option was specified during execution of the previous command that was canceled:

      The temporary work file storage directory specified in the -w option

    • If the -w option was omitted during execution of the previous command that was canceled:

      The $DBDIR/ADBWORK directory

  2. Execute the adbidxrebuild command with the --force option specified.

    Execute the adbidxrebuild command with the --force option specified.