Hitachi

Hitachi Advanced Database Command Reference


16.4 Return codes

The following table lists and describes the return codes of the adbidxrebuild command.

Table 16‒2: Return codes of the adbidxrebuild command

Return code

Description

0

The adbidxrebuild command terminated normally.

4

The adbidxrebuild command terminated normally, but a warning message was issued. Check the displayed message or the message output to a message log file and take appropriate action.

If the KFAA61205-W message (warning message indicating detection of duplicate key values) was issued, the table and a B-tree index subject to index rebuild processing violate the uniqueness constraint (a B-tree index that violates the uniqueness constraint is in the status called uniqueness constraint violation). Locate the duplicate key values and delete the corresponding rows. Then re-execute the adbidxrebuild command to rebuild the B-tree indexes. For details about how to handle such an error, see Steps to take when the uniqueness constraint is violated (when the KFAA61205-W message is output) in Problems related to B-tree indexes in Troubleshooting in the HADB Setup and Operation Guide.

8

One of the following errors occurred:

  • The specified adbidxrebuild command was not executed because it was invalid.

  • An error occurred during execution of the adbidxrebuild command. For the cause of the error and corrective action to take, see the displayed error message or the message that has been output to a message log file. For details, see 16.5 Handling abnormal termination of the adbidxrebuild command.