TCP/IP-relevant columns of the SYSIBM.IPNAMES table

The IPNAMES table defines the outbound security and host names that are used to connect to other systems through TCP/IP.

IPNAMES has the following columns:

LINKNAME CHAR(8)

This value matches that specified in the LINKNAME column of the associated row in SYSIBM.LOCATIONS.

SECURITY_OUT CHAR(1)

Defines the security option that is used when local DB2® SQL applications connect to any remote server associated with this TCP⁄IP host. The default, A, means that outgoing connection requests contain an authorization ID without a password.

USERNAMES CHAR(1)

This column is used for outbound requests to control translations of authorization IDs. The values 'O' or 'B' are valid for TCP⁄IP connections.

IPADDR VARCHAR(254)

This column contains an IPv4 or IPv6 address or domain name of a remote TCP⁄IP host.

• An IPv4 address must be left justified and is represented as a dotted-decimal address. An example of an IPv4 address is 9.112.46.111.
• An IPv6 address must be left justified and is represented as a colon-hexadecimal address. An example of an IPv6 address is 2001:0DB8:0000:0000:0008:0800:200C:417A, which can also be expressed in compressed form as 2001:DB8::8:800:200C:417A.
• A domain name is converted to an IP address by the domain name server where a resulting IPv4 or IPv6 address is determined. An example of a domain name is stlmvs1.svl.ibm.com. The gethostbyname socket call is used to resolve the domain name.