Hitachi

Hitachi Advanced Database Setup and Operation Guide


16.24.5 Synchronizing synonym dictionary files

To synchronize synonym dictionary files, you execute the following command:

adbsyndict -s
About synchronization of synonym dictionary files

When using the multi-node function, the synonym dictionary files must be present on all nodes. The process of ensuring that each node has the same synonym dictionary files is called synchronizing synonym dictionary files. This synchronization process involves copying the synonym dictionary files on the master node to the slave nodes.

The synonym dictionary files on a slave node are stored in the directory specified for the adb_syndict_node_storage_path operand. When SQL statements that perform synonym searches are executed on a slave node, these SQL statements use the synonym dictionary files on the slave node.

If synonym dictionary files are not synchronized

You can still perform synonym searches if the synonym dictionary files have not been synchronized. However, if execution processing for SQL statements that perform synonym searches is assigned to a slave node whose synonym dictionary files have not been synchronized, that slave node will not execute the SQL statements. In this case, execution of the SQL statements will take place on the master node. If this state continues, it can lead to an increased load on the master node. For this reason, ensure that the synonym dictionary files are synchronized and the synonym dictionary files on the slave nodes are the latest files.

Cases where synonym dictionary files need to be synchronized

Circumstances in which you need to synchronize synonym dictionary files include returning a node to a multi-node configuration or adding a node. If the latest synonym dictionary files are not stored on the slave node, the warning message KFAA51537-W is output when you start the HADB server and then you execute a synonym search. If you encounter this message, execute the adbsyndict command to synchronize the synonym dictionary files.

Note

If you register, update, or delete a synonym dictionary, the HADB server will synchronize the synonym dictionary files automatically.