SYSIBM.IPNAMES columns
The SYSIBM.IPNAMES table is used only for outbound requests that use TCP/IP protocols.
- LINKNAME CHAR(8)
- The name used in the LINKNAME column of SYSIBM.LOCATIONS to identify the remote system.
- IPADDR
- Specifies an IP address or domain name of a remote TCP/IP host.
- SECURITY_OUT
- Indicates the DRDA security
option that is used when local Db2 SQL
applications connect to any remote server that is associated with
this TCP/IP host.
- A
- The letter A signifies the security option of already verified,
and it is the default. Outbound connection requests contain an
authorization ID and no password. The value that is used for an outbound
request is either the Db2 user's
authorization ID or a translated ID, depending on the value in the
USERNAMES column.
The authorization ID is not encrypted when it is sent to the partner. For encryption, see option D.
- R
- The letter R signifies the RACF® PassTicket security option. Outbound connection requests contain a user ID and a RACF PassTicket. When a RACF PassTicket is generated, the LINKNAME column value is used as the RACF PassTicket application name and must match the following at the target server
- LUNAME - if the remote site is a Db2 subsystem that is defined with only an LUNAME value and no GENERIC LU name value or IPNAME value
- GENERIC - if the remote site is a Db2 subsystem that is defined with a GENERIC LU name value in addition to an LUNAME value but no IPNAME value
- IPNAME - if the remote site is a Db2 subsystem that is defined with an IPNAME value that triggers the remote Db2 subsystem's DDF to activate only its TCP/IP communications support.
The value that is used for an outbound request is either the Db2 user's authorization ID or a translated ID, depending on the value in the USERNAMES column. The translated ID is used to build the RACF PassTicket.
Important:
Do not specify R for CONNECT statements with a USER parameter. If a user ID and password are explicitly specified in a CONNECT statement, Db2 does not translate them.
The authorization ID is not encrypted when it is sent to the partner.
- D
- The letter D signifies the security option of user ID and security-sensitive data encryption.
Outbound connection requests contain an authorization ID and no password. The authorization ID that
is used for an outbound request is either the Db2 user's authorization ID or a translated ID,
depending on the USERNAMES column.
This option indicates that the user ID and the security-sensitive data are to be encrypted.
Security-sensitive data is any
input or output data. Examples are rows that are retrieved from a remote server, rows that are sent
to the remote server, and SQL statement text.
If you do not require encryption, see option A.
- E
- The letter E signifies the security option of user ID, password, and security-sensitive data
encryption. 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".
This option indicates that the user ID, password, and security-sensitive data are to be encrypted.
Security-sensitive data is any
input or output data. Examples are rows that are retrieved from a remote server, rows that are sent
to the remote server, and SQL statement text.
If you do not require
security-sensitive data encryption, see option P. - P
- The letter P signifies the password security option. Outbound
connection requests contain an authorization ID and a password. The
password is obtained from the SYSIBM.USERNAMES table. If you specify
P, the USERNAMES column must specify "O".
If you specify P and the server supports encryption, the user ID and the password are encrypted. If the server does not support encryption, the user ID and the password are sent to the partner in clear text. If you also need to encrypt security-sensitive data, see option E.
- USERNAMES CHAR(1)
- This column indicates whether an outbound request translates the authorization ID. When you specify O, use the SYSIBM.USERNAMES table to perform the translation.