16.16.12 Problems related to SQL statements that create work tables (when the multi-node function is being used)
If an SQL statement being executed when the HADB server terminates abnormally creates a work table, make sure that the disk to be used by work table DB area files is not shared and used by multiple nodes. If the disk to be used for the work table DB area files is shared and used by multiple nodes, operations are not guaranteed. In this case, incorrect retrieval results might be displayed, or the HADB server might terminate abnormally.
If the disk to be used for work table DB area files is shared and used by multiple nodes, perform the following.
Procedure:
-
Terminate the HADB servers in the multi-node configuration.
-
Prepare a disk for work table DB area files for each node.
-
For each node, specify the path to the disk prepared in step 2 above for the server definition adb_blk_path_wrk operand.
-
Start the HADB servers in the multi-node configuration again.
- Note
-
You can determine whether the executed SQL statement creates a work table by referring to Considerations when executing an SQL statement that creates work tables in the HADB Application Development Guide.