KFAA51130-W

A work table was created because a hash table area was insufficient.

aa....aa: Tree row number of the corresponding access path

If access path statistical information has not been output, 0 is displayed for the tree row number.

bb....bb:

Maintenance information 1

cc....cc:

Maintenance information 2

S:

Continues processing.

Action:

Execution of the SQL statement might require a long time. To reduce the execution time of the SQL statement, increase the value specified for the adb_sql_exe_hashtbl_area_size operand in the server definition or client definition.

If this message is output during execution of the adbexport command, increase the value specified for the adb_export_hashtbl_area_size export option or the adb_sql_exe_hashtbl_area_size operand in the server definition.

If you want to know about the work table that is created if the hash table area is insufficient, check the access path information shown in the location indicated by aa....aa. Also see the following parts in the HADB Application Development Guide:

• If hash join is used as the table joining method

  Action to take when the hash table area has insufficient space in About hash join

• If hash execution is used as the subquery processing method

  Hash execution in Methods for processing subqueries that do not contain an external reference column, or Hash execution in Methods for processing subqueries that contain an external reference column

• If global hash grouping is used as the grouping method

  Global hash grouping in Hash grouping

• If hash execution is used as the method for processing SELECT DISTINCT

  Hash execution in Method for processing SELECT DISTINCT

• If hash execution is used as the method for processing the set operation

  Hash execution in Methods for processing set operations