SYSIBM.IPNAMES columns

The SYSIBM.IPNAMES table is used only for outbound requests that use TCP/IP protocols.

Begin general-use programming interface information.
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: Start of changeDo 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.End of change

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. Start of changeSecurity-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.End of change 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. Start of changeSecurity-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.End of change 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.
O
The letter O signifies an outbound ID that is subject to translation. Rows in the SYSIBM.USERNAMES table are used to perform ID translation. If a connection to any remote server is to be established as trusted, a row in the SYSIBM.USERNAMES table is used to obtain the system authorization ID.
S
The letter S signifies the system authorization ID, within a trusted context, obtained from the SYSIBM.USERNAMES table. If the system authorization ID that is specified in the AUTHID column is different from the primary authorization ID, Db2 sends the user switch request on behalf of the primary authorization ID after successfully establishing the trusted connection.
blank
No translation is done.
End general-use programming interface information.