NETWORK_ATTRIBUTE_INFO view

The NETWORK_ATTRIBUTE_INFO view returns a single row containing information about the network attributes of the system.

The information returned is similar to the detail available through the Display Network Attributes (DSPNETA) CL command, the Retrieve Network Attributes (RTVNETA) CL command, and the Retrieve Network Attributes (QWCRNETA) API.

Authorization: Start of change The caller must have *IOSYSCFG special authority or be authorized to the QIBM_IOSYSCFG_VIEW function usage identifier to see non-null values for JOB_ACTION, DDM_REQUEST_ACCESS, CLIENT_REQUEST_ACCESS, and ALLOW_ADD_TO_CLUSTER. End of change

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

Table 1. NETWORK_ATTRIBUTE_INFO view
Column Name	System Column Name	Data Type	Description
HOST_NAME	HOST_NAME	VARCHAR(8)	Name of the system where this information was generated. This is the name set by CHGNETA.
PENDING_HOST_NAME	PEND_HOST	VARCHAR(8) Nullable	The pending system name, if a change is pending. Contains the null value if no change is pending.
NETWORK_ID	NETWORK_ID	VARCHAR(8)	The local network ID assigned to the system.
CONTROL_POINT	CTL_POINT	VARCHAR(8)	The local control point name for the system.
LOCATION	LOCATION	VARCHAR(8)	The default local location name for the system.
MODE	MODE	VARCHAR(8) Nullable	The default mode name for the system. Contains the null value if there is no default mode.
APPN_NODE_TYPE	NODETYPE	VARCHAR(8)	The advanced peer-to-peer networking (APPN) node type. BEXNODE The node performs as a branch extender node. The node performs as an end node in the backbone APPN network, and performs as a network node server to end nodes within its local domain. ENDNODE The node does not provide network services to other nodes, but may participate in the APPN network by using the services of an attached network server, or may operate in a peer environment similar to migration end nodes. *NETNODE The node provides intermediate routing, route selection services, and distributed directory services for local users and to end nodes and migration end nodes that it is serving.
DATA_COMPRESSION	DTACPR	VARCHAR(10)	Whether data compression is used when the system is an SNA end node. This value is used by mode descriptions that specify NETATR for data compression. If data compression is requested by the remote system, the data compression levels used by the session are the lower of the requested levels and the configured levels. ALLOW Data compression is allowed on the session by the local system if requested by a remote system. The local system does not request that compression be used. NONE Data compression is not allowed on the session. REQUEST Data compression is requested on the session by the local system. However, the request can be refused or changed to a lower compression level by the remote system. Data compression is allowed on the session if requested by the remote system. REQUIRE Data compression is required on the session. If the remote system does not change the levels of compression to the local system's exact requested levels, the session is not established. The data compression levels that the local system requires are the specified levels. integer* If either the receiving or sending link has a line speed equal to or less than this specified line speed, this value indicates the need for compression by requesting that the remote systems compress the session data. Otherwise, this value does not indicate to the remote systems that there is a need to compress the data. Values range from 1 through 2147483647 bits per second.
INTERMEDIATE_DATA_ COMPRESSION	DTACPRINM	VARCHAR(10)	The level of data compression to request when the system is an SNA intermediate node. NONE Does not indicate to the remote systems that there is a need to compress the data. REQUEST Indicates the need for compression by requesting that the remote systems compress the session data. integer If either the receiving or sending link has a line speed equal to or less than this specified line speed, this value indicates the need for compression by requesting that the remote systems compress the session data. Otherwise, this value does not indicate to the remote systems that there is a need to compress the data. Values range from 1 through 2147483647 bits per second.
MAXIMUM_SESSIONS	MAX_SSN	INTEGER Nullable	The maximum number of advanced program-to-program communications (APPC) intermediate sessions for an advanced peer-to-peer networking (APPN) node type of NETNODE or BEXNODE. Contains the null value when APPN_NODE_TYPE is *ENDNODE.
ROUTE_ADDITION_RESISTANCE	RESISTANCE	INTEGER Nullable	The advanced peer-to-peer networking (APPN) route addition resistance for an APPN node type of NETNODE or BEXNODE. Contains the null value when APPN_NODE_TYPE is *ENDNODE.
SERVER_NETWORK_ID_COUNT	SRV_NETCNT	INTEGER Nullable	The number of network ID values in the SERVER_NETWORK_IDS column. Contains the null value when APPN_NODE_TYPE is not *ENDNODE.
SERVER_NETWORK_IDS	SRV_NETIDS	VARCHAR(248) CCSID 1208 Nullable	The advanced peer-to-peer networking (APPN) network node servers for an APPN node type of ENDNODE or BEXNODE. This list is returned as an array within a JSON object. The array can contain up to five elements and is identified by NET_IDS. Each entry in the JSON array contains two JSON objects: An object with a name of "NET_ID" and a value of a network ID. An object with a name of "CTL_POINT" and a value of the corresponding control point. The special value of LCLNETID for a network ID. This indicates that the value of NETWORK_ID at the time the node server is referred to is be used. A special value of ANY applies to the control point. This indicates that the first network node that offers services will become the network node server. Any network node with the same network ID as that specified for NETWORK_ID can be a potential network node server. Contains the null value when SERVER_NETWORK_ID_COUNT is 0 or APPN_NODE_TYPE is not *ENDNODE.
SERVER_NETWORK_ID	SRV_NETID	VARCHAR(9) Nullable	The server network ID for the first entry in the SERVER_NETWORK_IDS list. The special value of LCLNETID indicates that the value of NETWORK_ID at the time the node server is referred to is be used. Contains the null value when SERVER_NETWORK_ID_COUNT is 0 or APPN_NODE_TYPE is not ENDNODE.
SERVER_CONTROL_POINT	SRV_CTLPT	VARCHAR(8) Nullable	The server control point for the first entry in the SERVER_NETWORK_IDS list. A special value of ANY indicates that the first network node that offers services will become the network node server. Any network node with the same network ID as that specified for NETWORK_ID can be a potential network node server. Contains the null value when SERVER_NETWORK_ID_COUNT is 0 or APPN_NODE_TYPE is not ENDNODE.
ALERT_STATUS	ALERT_STS	VARCHAR(9)	Alert status controls the creation of local alerts. OFF Alerts are not created by the system. ON Alerts are created by a system for all changeable conditions except unattended conditions. UNATTEND Alerts are created by the system for all alert conditions including those which have the alert indicator in the message description set to UNATTEND.
ALERT_LOGGING	ALERT_LOG	VARCHAR(6)	Specifies which alerts are to be logged: ALL Both locally created alerts and incoming alerts are logged. LOCAL Only locally created alerts are logged. NONE No alerts are logged. RCV Only alerts received from other nodes are logged.
ALERT_PRIMARY_FOCAL_POINT	ALERT_PRIM	VARCHAR(4)	Whether the system is an alert primary focal point. NO The system is not an alert primary focal point. YES The system is defined to be an alert primary focal point and provides focal point services to all nodes in the network that are explicitly defined in the sphere of control.
ALERT_DEFAULT_FOCAL_POINT	ALERT_DFT	VARCHAR(4)	Whether the system is an alert default focal point. NO The system is not an alert default focal point. YES The system is defined to be an alert default focal point and provides focal point services to all nodes in the network that are not being serviced by another focal point.
ALERT_BACKUP_NETWORK_ID	ALERT_BNET	VARCHAR(8) Nullable	The network ID of the system that provides backup focal point services for alerts. These backup values define the system that provides alert focal point services if the local system is unavailable and ALERT_PRIMARY_FOCAL_POINT is *YES. The backup focal point is only used by systems in the primary sphere of control. Contains the null value if no backup focal point is defined.
ALERT_BACKUP_CONTROL_ POINT	ALERT_BCTL	VARCHAR(8) Nullable	The control point name of the system that provides backup focal point services for alerts. Contains the null value if no backup focal point is defined.
ALERT_REQUEST_NETWORK_ID	ALERT_RQS	VARCHAR(8) Nullable	The network ID of the system that is requested to provide focal point services for alerts. The focal point to request values define the name of the system that is requested to provide alert focal point services. Contains the null value if no backup focal point is defined.
ALERT_REQUEST_CONTROL_ POINT	ALERT_RQSC	VARCHAR(8) Nullable	Specify the control point name of the system that is requested to provide focal point services for alerts. Contains the null value if no backup focal point is defined.
ALERT_CONTROLLER	ALERT_CTL	VARCHAR(10) Nullable	The name of the controller to be used for alerts in a system service control point - physical unit (SSCP-PU) session. This controller is ignored if the system has a focal point (in which case the node is in another system's sphere of control). Contains the null value if no alert controller is defined.
ALERT_HOLD_COUNT	ALERT_HOLD	INTEGER Nullable	The maximum number of alerts to be created before the alerts are sent over the system service control point - physical unit session. Alerts are held by the system until this number of alerts have been created. If the alert controller (ALERT_CONTROLLER) network attribute is being used to send alerts (SSCP-PU session), alerts will be sent automatically regardless of the ALERT_HOLD_COUNT network attribute when a switched connection is made for other reasons. Can contain the following special value: -2 Indicates *NOMAX. The alerts are held indefinitely. The alerts can be sent at a later time by changing the ALRHLDCNT value on the CHGNETA CL command to a lower value. Contains the null value if no alert hold count is set.
ALERT_FILTER_LIBRARY	ALERT_FTRL	VARCHAR(10) Nullable	The name of the library that contains the filter object. Contains the null value if no alert filter is being used.
ALERT_FILTER	ALERT_FTR	VARCHAR(10) Nullable	The name of the filter object that is used by the alert manager when processing alerts. Contains the null value if no alert filter is being used.
MESSAGE_QUEUE_LIBRARY	MSGQ_LIB	VARCHAR(10)	The library where MESSAGE_QUEUE resides.
MESSAGE_QUEUE	MSGQ	VARCHAR(10)	The name of the message queue to which messages received through the SNA distribution services (SNADS) network are sent for: Users who have no message queue specified in their user profile Users whose message queue is not available
OUTPUT_QUEUE_LIBRARY	OUTQ_LIB	VARCHAR(10)	The library where OUTPUT_QUEUE resides.
OUTPUT_QUEUE	OUTQ	VARCHAR(10)	The name of the output queue to which spooled files received through the SNA distribution services (SNADS) network are sent for users whose output queue is not available.
JOB_ACTION	JOB_ACTION	VARCHAR(7) Nullable	The action that is taken for any input stream received through the SNA distribution services (SNADS) network by the system. FILE The input stream is filed in the queue of network files received for the user to whom it was sent. That user may then look at the input stream, end it, receive it, or submit it to a job queue. REJECT The input stream is rejected by the system. This action allows users to secure their system from input streams received through the network. *SEARCH The table of network job entries is searched to determine the action to be taken for the input stream. Contains the null value if not authorized to view this information.
MAXIMUM_HOPS	MAX_HOPS	INTEGER	The maximum number of times in an SNA distribution services (SNADS) network that a distribution queue entry originating at this node may be received and routed on the path to its final destination. If this number is exceeded, the distribution queue entry is ended. When the distribution queue entry is ended, a feedback status is sent back to the sender if it was requested.
DDM_REQUEST_ACCESS	DDM_RQS	VARCHAR(8) Nullable	How the system processes distributed data management (DDM) and Distributed Relational Database Architecture (DRDA) requests from other systems. OBJAUT All requests are allowed and controlled by the object authorization on the system. REJECT The system does not allow DDM or DRDA requests from remote systems. This system can still use DDM or DRDA, however, to access files or SQL tables on remote systems. *PROGRAM The program identified in the DDM_REQUEST_LIBRARY and DDM_REQUEST_PROGRAM columns is used. Contains the null value if not authorized to view this information.
DDM_REQUEST_LIBRARY	DDM_LIB	VARCHAR(10) Nullable	The name of the library that contains DDM_REQUEST_PROGRAM. Contains the null value if DDM_REQUEST_ACCESS is not *PROGRAM.
DDM_REQUEST_PROGRAM	DDM_PGM	VARCHAR(10) Nullable	The name of a user-written validation program that is called each time a DDM request is made from a remote system. This program indicates to DDM whether the request should proceed or be ended. System security still applies. Contains the null value if DDM_REQUEST_ACCESS is not *PROGRAM.
CLIENT_REQUEST_ACCESS	CLIENT_RQS	VARCHAR(8) Nullable	The way in which the system processes client requests from other systems. OBJAUT Normal object authorizations are checked for the client requests. For example, authorization to retrieve data from a database file for a transfer function request is checked. REGFAC The registration facility is used to determine whether to call an exit program. If no exit program is defined for an exit point and this value is specified, OBJAUT is used. REJECT The system rejects every request from clients. *PROGRAM The program identified in the CLIENT_REQUEST_LIBRARY and CLIENT_REQUEST_PROGRAM columns is used. Contains the null value if not authorized to view this information.
CLIENT_REQUEST_LIBRARY	CLIENT_LIB	VARCHAR(10) Nullable	The name of the library that contains CLIENT_REQUEST_PROGRAM. Contains the null value if CLIENT_REQUEST_ACCESS is not *PROGRAM.
CLIENT_REQUEST_PROGRAM	CLIENT_PGM	VARCHAR(10) Nullable	The name of a user-written validation program that is called each time a server request comes from a client. The program is passed two parameters: the first is used by the program to indicate to the server application whether this client request should be handled; the second describes the client request (the name of the application and type request). Contains the null value if CLIENT_REQUEST_ACCESS is not *PROGRAM.
NETWORK_SERVER_DOMAIN	NWS_DOMAIN	VARCHAR(8)	The LAN server domain associated with the file server.
ALLOW_VIRTUAL_APPN	VIRT_APPN	VARCHAR(4)	Specifies whether APPC sessions and devices are allowed to use virtual APPN controllers. NO The system does not allow APPC sessions or devices to use virtual APPN controllers. If sessions are using HPR transport tower support, they will use virtual APPN controllers regardless of this setting. YES The system does allow APPC sessions or devices to use virtual APPN controllers.
ALLOW_HPR_TRANSPORT_ TOWER	HPR_TOWER	VARCHAR(4)	The HPR transport tower support value is used for APPN session traffic. NO The system does not allow HPR transport tower support to be used with APPN session traffic. YES The system allows HPR transport tower support to be used with APPN session traffic.
AUTOCREATE_APPC_DEVICE_ LIMIT	APPC_LIMIT	INTEGER	The APPC device limit used for auto-creation of devices on virtual APPN controllers.
NETWORK_PRIORITY_TIMER	NET_TIMER	INTEGER Nullable	The amount of time, in minutes, to allow for a path switch attempt of a Rapid Transport Protocol (RTP) connection that has network transmission priority. Contains the null value if no path switch is allowed.
HIGH_PRIORITY_TIMER	HIGH_TIMER	INTEGER Nullable	The amount of time, in minutes, to allow for a path switch attempt of an RTP connection that has high transmission priority. Contains the null value if no path switch is allowed.
MEDIUM_PRIORITY_TIMER	MED_TIMER	INTEGER Nullable	The amount of time, in minutes, to allow for a path switch attempt of an RTP connection that has medium transmission priority. Contains the null value if no path switch is allowed.
LOW_PRIORITY_TIMER	LOW_TIMER	INTEGER Nullable	The amount of time, in minutes, to allow for a path switch attempt of an RTP connection that has low transmission priority. Contains the null value if no path switch is allowed.
ALLOW_ADD_TO_CLUSTER	ADD_CLUST	VARCHAR(7) Nullable	Whether this system will allow another system to add it as a node in a cluster. ANY Any other system can add this system as a node in a cluster. NONE No other system can add this system as a node in a cluster. *RQSAUT Any other system can add this system as a node in a cluster only after the cluster add request has been authenticated. Contains the null value if not authorized to view this information.
MODEM_COUNTRY_OR_ REGION_ID	MODEM_ID	CHAR(2) Nullable	The country or region identifier associated with a modem. This defines the country or region-specific default characteristics for modems that are internal to IBM i I/O adapters. This value must be configured correctly to ensure proper operation and, in some countries or regions, meet legal requirements. The adapter will fail the vary on of the line if the modem country or region ID is not set. Contains the null value if no country or region identifier has been defined.

Example

Review the system network attributes.

SELECT * FROM QSYS2.NETWORK_ATTRIBUTE_INFO;