Hitachi

Hitachi Advanced Database Messages


KFAA80237-I

The cost information collection time has exceeded the specified time. (table = "aa....aa"."bb....bb") (M+S)

The time required for collecting cost information exceeds the specified time.

aa....aa:

Schema name

bb....bb:

Table identifier

S:

Registers the cost information that was collected until this message was output, and then continues processing.

Action:

This message is output if the time required for collecting cost information exceeds the time specified for the cost-information collection option adb_getcst_collect_time.

As a basic rule, even if this message is output, there is no need to collect cost information again. However, if the access path selected during execution of an SQL statement is different from the one you expected, increase the value specified for the cost-information collection option adb_getcst_collect_time, and then re-execute the adbgetcst command.

For details about the cost-information collection option adb_getcst_collect_time, see Explanation of specification format in Format of the cost-information collection option in the manual HADB Command Reference.