SYSIBM.LOCATIONS columns

The SYSIBM.LOCATIONS table contains a row for every accessible remote server. Each row associates a LOCATION name with the TCP/IP or SNA network attributes for the remote server. Requesters are not defined in the SYSIBM.LOCATIONS table.

Begin general-use programming interface information.
LOCATION CHAR(16)
Indicates the unique location name by which the remote server is known to local Db2 SQL applications.
LINKNAME CHAR(8)
Identifies the VTAM® or TCP/IP network locations that are associated with this row. A blank value in this column indicates that this name translation rule applies to any TCP/IP or SNA partner.

If you specify a non-blank value for this column, one or both of the following situations must be true:

  • A row exists in table SYSIBM.LUNAMES that has an LUNAME value that matches the LINKNAME value that appears in this column.
  • A row exists in table SYSIBM.IPNAMES that has a LINKNAME value that matches the LINKNAME value that appears in this column.

For information on the effects of changing values for TCP/IP connections to values for VTAM connections in CDB (communications database) tables, see When updates to CDB values take effect for VTAM (SNA) connections.

PORT CHAR(32)
Indicates that TCP/IP is used for outbound connections when the following statement is true:
  • A row exists in SYSIBM.IPNAMES, where the LINKNAME column matches the value that is specified in the SYSIBM.LOCATIONS LINKNAME column.
If the previously mentioned row is found, and the SECURE column has a value of 'N', the value of the PORT column is interpreted as follows:
  • If PORT is blank, the default DRDA port (446) is used.
  • If PORT is nonblank, the value that is specified for PORT can take one of two forms:
    • If the value in PORT is left-justified with one to five numeric characters, the value is assumed to be the TCP/IP port number of the remote database server.
    • Any other value is assumed to be a TCP/IP service name, which you can convert to a TCP/IP port number by using the TCP/IP getservbyname socket call. TCP/IP service names are not case-sensitive.
If the previously mentioned row is found, and the SECURE column has a value of 'Y', the value of the PORT column is interpreted as follows:
  • If PORT is blank, the default secure DRDA port (448) is used.
  • If PORT is nonblank, the value that is specified for PORT takes the value of the configured secure DRDA port at the remote server.
TPN VARCHAR(64)
Used only when the local Db2 begins an SNA conversation with another server. When used, TPN indicates the SNA LU 6.2 transaction program name (TPN) that will allocate the conversation. A length of zero for the column indicates the default TPN. For DRDA conversations, this is the DRDA default, which is X'07F6C4C2'.
DBALIAS(128)
Used to access a remote database server. If DBALIAS is blank, the location name is used to access the remote database server. This column does not change the name of any database objects sent to the remote site that contains the location qualifier.
TRUSTED
Indicates whether the connection to the remote server can be trusted. This is restricted to TCP/IP only. This column is ignored for connections that use SNA.
Y
The location is trusted. Access to the remote location requires a trusted context that is defined at the remote location.
N
The location is not trusted.
SECURE
Indicates the use of the Secure Socket Layer (SSL) protocol for outbound connections when local Db2 applications connect to the remote database server by using TCP/IP.
Y
A secure SSL connection is required for the outbound connection.
N
A secure connection is not required for the outbound connection.
End general-use programming interface information.