KFAA50291-W

Cost information collection processing was skipped for table aa....aa.bb....bb. Possible causes are as follows:

• The adbimport command terminated abnormally.

• The adbidxrebuild command terminated abnormally.

• The adbunarchivechunk command terminated abnormally.

• An index is in unfinished status because it was defined after data had been stored in the table.

aa....aa:

Schema name

bb....bb:

Table identifier

cc....cc: Reason for skipping the processing:

• The adbimport command has not been re-executed.

• The adbidxrebuild command has not been re-executed.

• The adbunarchivechunk command has not been re-executed.

• No indexes have been created.

S:

Continues processing.

Action:

• If cc....cc is other than No indexes have been created.

  Re-execute the command that terminated abnormally, and then use the adbgetcst command to collect cost information.

• When cc....cc is No indexes have been created.

  Release the indexes from unfinished status, and then use the adbgetcst command to collect the cost information.

  For details about how to release the B-tree index 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 the text index 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 the range index from unfinished status, see Steps to take when unfinished status is applied to a range index in the HADB Setup and Operation Guide.

When you execute the adbgetcst command, use the -t option to specify the name of the table for which cost information collection processing was skipped.