Define os servidores DRDA remotos que o DB2 pode acessar usando TCP/IP.
As linhas nesta tabela podem ser inseridas, atualizadas e excluídas.
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 |
| NAME |
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 |
