16.24.2 Performing synonym searches
The procedures for performing synonym searches are the same as the procedures when the multi-node function is not used. For details about how to perform synonym searches, see 11.16.2 Performing synonym search operations.
Synonym searches performed in an environment that uses the multi-node function use the synonym dictionary files on the node to which execution processing of the SQL statement was assigned. The synonym dictionary files used in the multi-node function are stored in the directory specified for the adb_syndict_node_storage_path operand in the server definition. When execution processing of an SQL statement is assigned to a slave node that does not have the latest synonym dictionary files in this directory, that slave node does not process the SQL statement. In this case, execution of the SQL statement takes place on the master node instead. At this time, the KFAA51537-W message is output.
If this state continues, performance might drop for the following reasons:
-
Execution processing of SQL statements that execute synonym searches becomes concentrated on the master node, increasing the load on the master node
-
Processing takes place to change the node on which SQL statements that perform synonym searches are executed from the slave node to the master node
For this reason, take care to synchronize the synonym dictionary files so that the latest synonym dictionary files are always stored on the slave node. For details about how to synchronize the synonym dictionary files, see 16.24.5 Synchronizing synonym dictionary files.