SYSIBM.LOCATIONS
                        www.cadcobol.com - linguagem de programação COBOL

Volta a página anterior

Volta ao Menu das SYSIBM

Volta ao Menu Principal


Desenvolvido por DORNELLES, Carlos Alberto - Analista de Sistemas - Brasília DF.

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