SQL - SYSIBM.LOCATIONS - www.cadcobol.com.br


Volta ao Menu das SYSIBM

Volta ao Menu Principal


Desenvolvido por DORNELLES, Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com


SYSIBM.LOCATIONS
Db2 for z/OS 12.0.0

Contém uma linha para cada servidor remoto acessível.
A linha associa um nome de LOCATION aos atributos de rede TCP/IP ou SNA para o servidor remoto.
Os solicitantes não são definidos nesta tabela.
As linhas nesta tabela podem ser inseridas, atualizadas e excluídas.

Contains a row for every accessible remote server.
The row associates a LOCATION name with the TCP/IP or SNA network attributes for the remote server.
Requesters are not defined in this table.
Rows in this table can be inserted, updated, and deleted.


Nome da coluna Tipo do dado Descrição Uso
LOCATION CHAR(16) NOT NULL A unique location name for the accessible server.
This is the name by which the remote server is known to local DB2 SQL applications.		 G
LINKNAME CHAR(8) NOT NULL Identifies the VTAM or TCP/IP attributes associated with this location.
For any LINKNAME specified, one or both of the following statements must be true:
  • A row exists in SYSIBM.LUNAMES whose LUNAME matches the value specified in the SYSIBM.LOCATIONS LINKNAME column.
    This row specifies the VTAM communication attributes for the remote location.

  • A row exists in SYSIBM.IPNAMES whose LINKNAME matches the value specified in the SYSIBM.LOCATIONS LINKNAME column.
    This row specifies the TCP/IP communication attributes for the remote location.
  G
IBMREQD CHAR(1) NOT NULL
 WITH DEFAULT 'N'		 A value of Y indicates that the row came from the basic machine-readable material (MRM) tape.
For all other values, see Release dependency indicators in topic D.0.		 G
PORT CHAR(32) NOT NULL
 WITH DEFAULT		 TCP/IP is used for outbound DRDA connections when the following statement is true:

A row exists in SYSIBM.IPNAMES, where the LINKNAME column matches the value specified in the SYSIBM.LOCATIONS LINKNAME column.

If the above mentioned row is found, 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 specified for PORT can take one of two forms:

If the value in PORT is left justified with 1-5 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 can be converted to a TCP/IP port number using the TCP/IP getservbyname socket call.
TCP/IP service names are not case sensitive. 		 G
TPN VARCHAR(64) NOT NULL
 WITH DEFAULT		 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'.
For DB2 private protocol conversations, this column is not used.

For an SQL/DS(TM) server, TPN should contain the resource ID of the SQL/DS machine.		  G

© Copyright IBM Corp.