NETSTAT_INTERFACE_INFO view

The NETSTAT_INTERFACE_INFO view returns information about IPv4 and IPv6 interfaces.

The values returned for the columns in the view are closely related to the values returned by List Network Interfaces API.

Start of change Authorization: The caller must have *IOSYSCFG special authority or be authorized to the QIBM_IOSYSCFG_VIEW function usage identifier. End of change

The following table describes the columns in the view. The system name is NS_INTER. The schema is QSYS2.

Table 1. NETSTAT_INTERFACE_INFO view
Column Name	System Column Name	Data Type	Description
CONNECTION_TYPE	CONN_TYPE	CHAR(4)	The type of connection. IPV4 The connection is an IPv4 connection. IPV6 The connection is an IPv6 connection.
INTERNET_ADDRESS	INT_ADDR	VARCHAR(45)	The internet address of the interface. For IPv4: The address is in IPv4 address format. Can contain the special value: IP4DHCP The interface has been configured to use DHCP to obtain an IPv4 address. For IPv6: The address is in IPv6 address format. Can contain the special value: IP6SAC This interface will use Stateless Address Auto-configuration to obtain an IPv6 address.
NETWORK_ADDRESS	NET_ADDR	VARCHAR(45)	The internet address of the IP network or subnetwork to which the interface is attached. For IPv4: The address is in IPv4 address format. For IPv6: The address is in IPv6 address format.
SUBNET_MASK	SUBNET_MSK	VARCHAR(15) Nullable	The subnet mask for the network, subnet, and host address fields of the internet address that defines the subnetwork for an interface. Contains null if this is an IPv6 connection.
PREFIX_LENGTH	PRE_LEN	INTEGER Nullable	The prefix length defines how many bits of the IPv6 internet address are in the prefix. It specifies how many of the left-most bits of the address make up the prefix. The prefix length is used to generate network and host addresses. Contains null if this is an IPv4 connection.
LINE_DESCRIPTION	LINE_DES	VARCHAR(10)	The name of the communications line description that identifies the physical network associated with an interface. Can contain the following special values: LOOPBACK This is the loopback interface. Processing associated with a loopback interface does not extend to a physical line. VIRTUALIP The virtual interface is a circuitless interface. For IPv4, the following additional value can be returned. *IPS The interface is used by Internet Protocol (IP) over SNA.
INTERFACE_LINE_TYPE	LINE_TYPE	VARCHAR(6)	The type of line used by the interface. Only supported line types are listed here; obsolete values could be returned for inactive configurations. ASYNC Asynchronous communications protocol. ELAN Ethernet local area network protocol. VETH Virtual Ethernet protocol. Can also contain one of the following special values: ERROR A system error other than those for NOTFND was received while trying to determine the link type for an interface. NONE Line is not defined. This value is used for the following interfaces: LOOPBACK, VIRTUALIP. There is no line type value for this interface. NOTFND Not found. The line description object for this interface cannot be found.
INTERFACE_STATUS	STATUS	VARCHAR(12)	The current status of the logical interface. ACTIVE The interface has been started and is running. ENDING The operating system is processing the request to end this interface. FAILED The line description associated with this interface has entered the failed state. FAILED (TCP) An error was detected in the IBM® TCP/IP Licensed Internal Code. INACTIVE The interface has not been started. RCYCNL A hardware failure has occurred and the line description associated with this interface is in the recovery canceled (RCYCNL) state. RCYPND An error with the physical line associated with this interface was detected by the system. The line description associated with this interface is in the recovery pending (RCYPND) state. STARTING The operating system is processing the request to start this interface. For IPv4, the following additional value can be returned. ACQUIRING The operating system is attempting to obtain an IP address from a Dynamic Host Configuration Protocol (DHCP) server. For IPv6, the following additional value can be returned. DEPRECATED The interface address preferred lifetime has expired but the valid lifetime has not yet expired.
INTERFACE_SOURCE	SOURCE	VARCHAR(9) Nullable	Specifies how this interface was added to the protocol stack. LOOPBACK The interface was added by the protocol stack as the loopback address. STATELESS The interface was added by IPv6 address autoconfiguration. STATEFUL The interface was added by Dynamic Host Configuration Protocol version 6 (DHCPv6) configuration. MANUAL The interface was added by manual configuration. Contains null if this is an IPv4 connection.
SERVICE_TYPE	SRVC_TYPE	VARCHAR(9) Nullable	The type of service that defines how the internet hosts and routers should make trade-offs between throughput, delay, reliability, and cost. MAXRLB A higher level of effort to ensure delivery is important for datagrams with the maximize reliability indication. MAXTHRPUT High data rate is important for datagrams with the maximize throughput indication. MINCOST Lower cost is important for datagrams with the minimize monetary cost indication. MINDELAY Prompt delivery is important for datagrams with the minimize delay indication. NORMAL Normal service is used for delivery of datagrams. OTHER An Internet Protocol (IP) over SNA interface. Contains null if this is an IPv6 connection.
VIRTUAL_LAN_ID	LAN_ID	VARCHAR(4)	The virtual LAN to which this interface belongs according to IEEE standard 802.1Q. Can also contain the following special value: NONE The interface does not belong to a virtual LAN.
MAXIMUM_TRANSMISSION_ UNIT	MTU	VARCHAR(10)	The maximum transmission unit (MTU) value specified for this interface. Either an integer value or this special value: LIND The interface is not currently active and the MTU was specified as *LIND. For IPv4, the following additional value can be returned. OTHER An Internet Protocol (IP) over SNA interface.
CONFIGURED_MAXIMUM_ TRANSMISSION_UNIT	CFG_MTU	VARCHAR(10)	The configured maximum transmission unit value specified for this interface. Either an integer value or this special value: LIND The interface is not currently active and the MTU was specified as *LIND.
AUTOSTART	AUTOSTART	VARCHAR(3)	Specifies whether the interface is automatically started when the protocol stack is activated. NO This interface is not automatically started. YES This interface is automatically started.
DAD_MAX_TRANSMITS	DAD_MAX	BIGINT Nullable	The maximum number of duplicate address detection (DAD) transmissions the protocol stack will send out on this interface. Contains null if this is an IPv4 connection.
HOST_ADDRESS	HOST_ADDR	VARCHAR(45)	Host portion of the internet address. For IPv4: Host portion of the Internet address, in dotted decimal notation, as determined by the subnet mask specified for this interface. For IPv6: Host portion of the Internet address, in IPv6 address format, as determined by the prefix length configured for this interface.
DIRECTED_BROADCAST_ ADDRESS	DIRBRDADR	VARCHAR(15) Nullable	The Internet address, in dotted decimal notation, used to broadcast to all systems attached to the same network or subnetwork as this interface. Contains null if this is an IPv6 connection or if interface is attached to a network that does not support a broadcast operation.
ASSOCIATED_LOCAL_ INTERFACE	ASCLCLINT	VARCHAR(15) Nullable	The Internet address, in dotted decimal notation, of the local interface that has been associated with this interface. Contains null if this is an IPv6 connection or if no association has been made between this interface and another local interface.
CHANGE_STATUS	CHGSTS	VARCHAR(6) Nullable	The status of the most recent change to this interface in the dynamic tables used by the TCP/IP protocol stack. ADD Add interface request processed. CHANGE Change interface request processed. END End interface request processed. START Start interface request processed. Contains null if this is an IPv6 connection.
PACKET_RULES	PKT_RULES	VARCHAR(17) Nullable	The kind of packet rules data available for this line. NONE No filters and no NAT are loaded for this line. NAT NAT is enabled for this line. FILTERS Filters are defined for this line. NAT_FILTERS NAT enabled and filters defined for this line. FILTERS_IPSEC Filters and IPSec filters are defined for this line. NAT_FILTERS_IPSEC NAT enabled and Filters and IPsec filters defined for this line. Contains null if packet rules data is unknown.
INTERFACE_TYPE	TYPE	VARCHAR(12) Nullable	The interface type: BROADCAST Broadcast capable. NONBROADCAST Non-broadcast capable. UNNUMBERED Unnumbered network. Contains null if this is an IPv6 connection.
NETWORK_FULL_NAME	NET_FNAME	VARCHAR(24) Nullable	The complete name of the network that this interface is a part of. Contains null if this is an IPv6 connection or if there is no network name.
INTERFACE_FULL_NAME	FNAME	VARCHAR(24) Nullable	The complete interface name. Contains null if this is an IPv6 connection or if there is no interface name.
ALIAS_NAME	ALIAS_NAME	VARGRAPHIC(50) CCSID 1200 Nullable	Name given to the interface to use as an alternate to the IP address. Contains null if there is no alias name.
INTERFACE_TEXT	LABEL	VARGRAPHIC(50) CCSID 1200 Nullable	Description of the interface. Contains null if there is no interface description.
DHCP_CREATED	DHCPCRT	VARCHAR(3) Nullable	Specifies whether this interface was created using Dynamic Host Configuration Protocol (DHCP). NO This interface was not created using DHCP. YES This interface was created using DHCP. Contains null if this is an IPv6 connection.
DHCP_DYNAMIC_DNS_ UPDATES	DHCPDYNDNS	VARCHAR(3) Nullable	Specifies whether dynamic updates to Domain Name System (DNS) tables are enabled or not. NO DNS updates are disabled. YES DNS updates are enabled. Contains null if this is an IPv6 connection or if interface was not created by DHCP.
DHCP_LEASE_EXPIRATION	DHCPLEXP	TIMESTAMP(0) Nullable	The timestamp when the DHCP lease will expire. Contains null if this is an IPv6 connection or if interface was not created by DHCP.
DHCP_LEASE_OBTAINED	DHCPLOBT	TIMESTAMP(0) Nullable	The timestamp when the DHCP lease was obtained or renewed. Contains null if interface was not created by DHCP.
DHCP_USE_UNIQUE_ID	DHCPUSEUID	VARCHAR(3) Nullable	Whether the DHCP unique identifier (DUID) is used as the client identification for the Dynamic Host Configuration Protocol (DHCP). NO The hardware (MAC) address is used for the client ID. YES The DHCP unique identifier is used for the client ID or this is an IPv6 connection. Contains null if interface was not created by DHCP.
DHCP_SERVER_UNIQUE_ID	DHCPSRVUID	VARCHAR(30) Nullable	Specifies the DHCP unique identifier (DUID) of the DHCP server from which the IP address was obtained. Contains null if this is an IPv4 connection or if interface was not created by DHCP.
DHCP_SERVER_ADDRESS	DHCPSRVADD	VARCHAR(15) Nullable	The Internet address, in dotted decimal notation, of the DHCP server from which the DHCP lease was obtained or renewed. Contains null if this is an IPv6 connection or if interface was not created by DHCP.
PREFERRED_INTERFACE_ DEFAULT_ROUTE	PREFDFTRTE	VARCHAR(3) Nullable	This field describes whether the preferred proxy interfaces are based on the system's default route. NO The default route is not used to determine the preferred interface. YES The default route is used to determine the preferred interface. Contains null if this is an IPv6 connection.
PREFERRED_INTERFACE_LIST	PREFIFCLST	VARCHAR(159) Nullable	A list of up to 10 preferred interface internet addresses. Each internet address within the preferred interface list is given in dotted decimal notation. When there is more than one internet address, a single blank separates the addresses. Contains null if this is an IPv6 connection or if a preferred interface list is not being used.
PREFERRED_PHYSICAL_LINE_ LIST	PREFLINLST	VARCHAR(159) Nullable	A list of up to 10 preferred physical line list entries. Each entry in the list is formatted as `LINE_DESCRIPTION:VIRTUAL_LAN_ID`. The line description can be up to 10 characters long. The virtual LAN ID can be up to 4 characters long. When there is more than one preferred physical line, a single blank separates entries. Contains null if this is an IPv4 connection.
ADDRESS_TYPE	ADDR_TYPE	VARCHAR(9) Nullable	The type of IPv6 address that is assigned to this network interface. ANYCAST An identifier for a set of interfaces (typically belonging to different nodes). A packet sent to an anycast address is delivered to one of the interfaces identified by that address (the "nearest" one, according to the routing protocols' measure of distance). MULTICAST An identifier for a set of interfaces (typically belonging to different nodes). A packet sent to a multicast address is delivered to all interfaces identified by that address. UNICAST An identifier for a single interface. A packet sent to a unicast address is delivered to the interface identified by that address. Contains null if this is an IPv4 connection.
ADDRESS_CLASS	ADDR_CLASS	VARCHAR(9) Nullable	The class of IPv6 address that is assigned to this network interface. PUBLIC The interface is a public one. TEMPORARY The interface is a temporary one used for privacy extensions. Contains null if this is an IPv4 connection.
ADDRESS_PREFERRED_LIFETIME	ADDPLIFE	BIGINT Nullable	The length of time that a "valid" address is preferred, in seconds. A negative value indicates that the address preferred lifetime expired that number of seconds ago. Contains null if this is an IPv4 connection or if this address has an infinite preferred lifetime.
ADDRESS_VALID_LIFETIME	ADDVLIFE	BIGINT Nullable	The length of time, in seconds, that an address remains in a "valid" state. A negative value indicates that the address valid lifetime expired that number of seconds ago. Contains null if this is an IPv4 connection or if this address has an infinite valid lifetime.
ADDRESS_PREFERRED_ LIFETIME_EXPIRATION	ADDPFRLE	TIMESTAMP(0) Nullable	The timestamp when this address will no longer be in the preferred state. If the timestamp is in the future, the address is still preferred. If the timestamp is in the past, then this address is no longer preferred. Contains null if this is an IPv4 connection or if this address has an infinite preferred lifetime which never expires.
ADDRESS_VALID_LIFETIME_ EXPIRATION	ADDVLDLE	TIMESTAMP(0) Nullable	The timestamp when this address will expire or did expire. If the timestamp is in the future, the address has not expired yet. If the timestamp is in the past, then this address has expired and is still being returned for a short period of time to indicate that the interface ceased to function because its valid lifetime expired. Contains null if this is an IPv4 connection or if this address has an infinite valid lifetime which never expires.
ON_LINK	ON_LINK	VARCHAR(3) Nullable	Whether or not this interface and all IPv6 addresses with the same prefix are on the same link. NO Addresses with the same prefix are not assumed to be on the same link. YES Addresses with the same prefix are assumed to be on the same link and directly reachable. Contains null if this is an IPv4 connection or if INTERNET_ADDRESS is *IP6SAC
PROXY_ARP_ENABLED	PRXARPENB	VARCHAR(3) Nullable	Indicates whether Proxy ARP is currently active for this interface. NO Proxy ARP not enabled. YES Proxy ARP enabled. Contains null if this is an IPv6 connection.
PROXY_ARP_ALLOWED	PRXARPALW	VARCHAR(3) Nullable	Indicates whether Proxy ARP has been configured to be allowed or not allowed. NO Proxy ARP not allowed. YES Proxy ARP allowed. Contains null if this is an IPv6 connection or if interface is not Virtual Ethernet.
CURRENT_PROXY_AGENT_LINE	PRXAGT	VARCHAR(10) Nullable	Name of the communication line description that is used with the IPv6 interface for virtual IP address (VIPA) proxy Neighbor Discovery. Contains null if this is an IPv4 connection or if no association has been made between this interface and another physical interface.
CURRENT_PROXY_AGENT_ LINE_VIRTUAL_LAN_ID	PRXAGTLAN	VARCHAR(4) Nullable	The virtual LAN to which the proxy agent line belongs according to IEEE standard 802.1Q. Can also contain the following special value: NONE There is no virtual LAN identifier associated with the current proxy agent line. Contains null if this is an IPv4 connection or if no association has been made between this interface and another physical interface.
LAST_CHANGE_TIMESTAMP	LASTCHG	TIMESTAMP(0) Nullable	The timestamp of the most recent change to this interface in the dynamic tables used by the protocol stack. Contains null if the interface has never been changed.

Example

Return information about all interfaces which are using Virtual Ethernet protocol..

SELECT * FROM QSYS2.NETSTAT_INTERFACE_INFO 
  WHERE INTERFACE_LINE_TYPE = 'VETH'