REFRESH LOCATIONS is an XDB Server utility command (not supported in DB2 mode) that re-reads the SYSIBM.SYSLOCATIONS catalog
table and updates the system with any new location changes. The REFRESH LOCATIONS command is necessary only if a location
has been manually inserted into SYSIBM.SYSLOCATIONS. If a new location is created using the CREATE LOCATION command, the system
is automatically reset (and the catalog tables updated) to include the new location information.
Invocation
REFRESH LOCATIONS is an executable command that can be issued interactively, embedded in a host language, or dynamically prepared.
Authorization
REFRESH LOCATIONS requires no special privilege or authority. However, only a super user can edit the SYSIBM.SYSLOCATIONS
catalog table.
Description
In order for the XDB Server to take advantage of Remote Unit of Work (RUW) or Distributed Unit of Work (DUW) processing, location information must be recorded in the SYSIBM.SYSLOCATIONS catalog table. This location information is read into memory the first time any application or user logs into the XDB Server.
If new location information is manually inserted into SYSIBM.SYSLOCATIONS (after the initial logging on), a REFRESH LOCATIONS command must be issued to reset the system to recognize this newly recorded location. The CREATE LOCATION command, however, automatically resets the system with the new location information.