15.4 Return codes

0

The adbgetcst command terminated normally.

4

The adbgetcst 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 KFAA50291-W message was output, cost information was not collected for one or more tables for one or more of the following reasons:

• The tables to be processed were non-updatable.

• The B-tree indexes, text indexes, or range indexes defined in the tables to be processed were in unfinished status.

• The adbimport or adbidxrebuild command, executed on the tables to be processed, was canceled.

In such a case, release the tables from non-updatable status or the applicable indexes from unfinished status, or re-execute the canceled command, and then collect cost information.

For details about how to release a table from non-updatable status, see Steps to take when a base table becomes non-updatable in the HADB Setup and Operation Guide.

For details about how to release B-tree indexes from unfinished status, see Steps to take when unfinished status is applied to a B-tree index in the HADB Setup and Operation Guide.

For details about how to release text indexes from unfinished status, see Steps to take when unfinished status is applied to a text index in the HADB Setup and Operation Guide.

For details about how to release range indexes from unfinished status, see Steps to take when unfinished status is applied to a range index in the HADB Setup and Operation Guide.

To identify the canceled command, output the table summary information by specifying, in the adbdbstatus command, table for the -c option and the table to be processed for the -n option. The name of the command that was canceled is output to the Rerun_command column in the output result. For details about the adbdbstatus command, see 13. adbdbstatus (Analyze the Database Status).

8

One of the following errors occurred:

• The specified adbgetcst command did not execute because it was invalid.

• An error occurred while the adbgetcst command was executing. 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.