Populating the SYSIBM.IPNAMES table
A row in the SYSIBM.IPNAMES table contains to set up information for the remote server’s IP address and security processing used when connecting. The row in SYSIBM.IPNAMES is selected by matching to the LINKNAME from the SYSIBM.LOCATIONS row for the target server. Perform the following to populate the SYSIBM.IPNAMES table:
Procedure
Set the columns of the SYSIBM.IPNAMES catalog table to:
| Column | Value |
|---|---|
| LINKNAME | An 8-byte link name value. This name is used to matched to the LINKNAME in the SYSIBM.LOCATIONS table. |
| SECURITY_OUT | IDF for DB2 applications supports the use of options ‘A’, ‘P’, and ‘R’. For more information
on these options, For more information on IPNAMES catalog table, refer the IPNAMES topic. Note: IDF does not support DRDA-level
encryption of data payload objects (options D and E are not supported). SSL sessions should
be used when data payload encryption is needed. IDF support the use of encrypted credentials.
When you select option A, P, or R, DB2 will initially request to use clear-text credentials. IDF can
be configured to require that user ID, or user ID and password be AES encrypted, and will negotiate
this added level of protection with DB2 before the values are transmitted. |
| USERNAMES | Set ‘O’ to use SYSIBM.USERNAMES translation or blank to pass user IDs unchanged |
| IPADDR | Set to the IPv4 or IPv6 IP address or the character format domain name of the remote location. |
Following is a sample SQL statement used to create a row in the IP names table:
INSERT INTO SYSIBM.IPNAMES (LINKNAME, SECURITY_OUT, USERNAMES, IPADDR)
VALUES(‘LQ52ABCD’, ‘A’, ‘O’, ‘LQ52’)