SYSIBM.LOCATIONS
SYSIBM.LOCATIONS maps the Db2 location names in connection requests to the port numbers (or service names) of remote systems.
SYSIBM.LOCATIONS must contain at least one row for each remote
group, depending on the access method that is used.
- For group access, the LOCATION column of the row contains the group's Db2 location name and PORT name. The LOCATION, PORT and the corresponding IPNAMES row identifies the members used to access Db2.
- For member-routing access, the LOCATION column of each row contains the group PORT number and location alias that identifies one, several, or all members of the group. The LOCATION, PORT and corresponding IPNAMES row controls which member is used to access Db2.
- For single-member access, the LOCATION column of the row contains the PORT number and location alias that identifies one member of the group. The LOCATION, PORT, and corresponding IPNAMES row identifies controls which member is used to access Db2.
Tip: You can specify a case-sensitive service name, instead
of a port number, in the PORT column of the SYSIBM.LOCATIONS table.