SYSIBM.IPNAMES
                        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.

Defines the remote DRDA servers DB2 can access using TCP/IP. Rows in this table can be inserted, updated, and deleted.

Nome da coluna Tipo do dado Descrição Uso
 LINKNAME  CHAR(8) NOT NULL  The value specified in this column must match the value specified in the LINKNAME  column of the associated row in SYSIBM.LOCATIONS  G
 SECURITY_OUT  CHAR(1) NOT NULL
 WITH DEFAULT 'A'		  This column defines the DRDA security option that is used when local DB2 SQL  applications connect to any remote server associated with this TCP/IP host:

 A    The option is "already verified." Outbound connection requests contain an         authorization ID and no password. The authorization ID used for an         outbound request is either the DB2 user's authorization ID or a translated ID,         depending upon the value of the USERNAMES column.

 R    The option is "RACF PassTicket." Outbound connection requests contain a         userid and a RACF PassTicket. The value specified in the LINKNAME column is         used as the RACF PassTicket application name for the remote server.
        The authorization ID used for an outbound request is either the DB2 user's         authorization ID or a translated ID, depending upon the value of the         USERNAMES column.

 P    The option is "password." Outbound connection requests contain an         authorization ID and a password. The password is obtained from the         SYSIBM.USERNAMES table. The USERNAMES column must specify "O."		  G
 USERNAMES  CHAR(1) NOT NULL
 WITH DEFAULT		  This column controls outbound authorization ID translation. Outbound translation is  performed when an authorization ID is sent by DB2 to a remote server.

 O        An outbound ID is subject to translation. Rows in the SYSIBM.USERNAMES             table are used to perform ID translation.

 No       translation or "come from" checking is performed on inbound IDs.

 blank   No translation occurs. 		 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
 IPADDR  VARCHAR(254) NOT NULL
 WITH DEFAULT		  This column contains the IP address or domain name of a remote TCP/IP host. The  IPADDR column must be specified as follows:

 ° If the IPADDR contains a left justified character string containing four numeric     values delimited by decimal points, DB2 assumes the value is an IP address in     dotted decimal format. For example, '123.456.78.91' would be interpreted as a     dotted decimal IP address.

 ° All other values are interpreted as a TCP/IP domain name, which can be resolved     by the TCP/IP gethostbyname socket call. TCP/IP domain names are not case     sensitive.		  G