If required, the database administrator can use DAL commands to modify the local distribution table so that a complete chain remains intact or a new chain is created. The DAL commands are described in section “The Database Administrator Language DAL”.
DAL command | Meaning |
&ADD DISTRIBUTION... | Add new entries to the distribution table |
&CHANGE DISTRIBUTION... | Assign a configuration to another host, i.e. change the NODE/CONF entry |
&DISPLAY DISTRIBUTION... | Display the distribution table on the screen |
&DROP DISTRIBUTION... | Delete entries |
&LOCK DISTRIBUTION... | Lock entries in the distribution table |
&PWD DISTRIBUTION... | Assign or modify a configuration-based password |
&SAVE DISTRIBUTION... | Save the distribution table in a SAM or ISAM file |
&UNLOCK DISTRIBUTION... | Remove lock on entries |
Table 32: Overview of DAL commands for distribution tables
- Changes in distribution tables do not take effect until the next READY statement.
- A database administrator who is not administering multiple DB configuration centrally (see section “Central administration”) is only allowed to modify the distribution table of his/her own DBH.
- It is not possible for different DBHs to synchronize the contents of their distribution tables.
- Changes in distribution tables have no effect on the actual location of a DB configuration.
- The output of the distribution table is restricted to 32 KB. If the distribution table is larger than this then it is not output in full and you are advised of this by a message.