NETSTAT_JOB_INFO view
The NETSTAT_JOB_INFO view returns information about jobs using IPv4 and IPv6 network connections.
The values returned for the columns in the view are closely related to the values returned by the Retrieve Network Connection Data (QtocRtvNetCnnDta) API.
Authorization: None required.
The following table describes the columns in the view. The system name is NS_JOB. The schema is QSYS2.
Column Name | System Column Name | Data Type | Description |
---|---|---|---|
CONNECTION_TYPE | CONN_TYPE | CHAR(4) | The type of connection.
|
REMOTE_ADDRESS | RMT_ADDR | VARCHAR(45) | The internet address of the remote host. For
IPv4:
For IPv6:
|
REMOTE_PORT | RMT_PORT | INTEGER | The remote host port number. A value of 0 means that the connection is a listening or UDP socket, so this field does not apply. |
REMOTE_PORT_NAME | RMT_NAME | VARGRAPHIC(14) CCSID 1200 Nullable
|
The remote host well-known port name or the
name from the service table entry. Contains null if there is no well-known port name. |
LOCAL_ADDRESS | LOCAL_ADDR | VARCHAR(45) | The local address of this connection
on this system. For IPv4:
For IPv6:
|
LOCAL_PORT | LOCAL_PORT | INTEGER | The local system port number. |
LOCAL_PORT_NAME | LOCAL_NAME | VARGRAPHIC(14) CCSID 1200 Nullable
|
The local system well-known port name or the
name from the service table entry. Contains null if there is no well-known port name. |
AUTHORIZATION_NAME | USER_NAME | VARCHAR(10) Nullable
|
The effective user profile of the
thread for which information is being retrieved. This name may differ
from the user portion of the job name. Contains null when SLIC_TASK_NAME is not null or if JOB_NAME is the special value *SIGNON. |
JOB_NAME | JOB_NAME | VARCHAR(28) Nullable
|
The qualified job name. Can also
contain the following special value:
Contains null when SLIC_TASK_NAME is not null. |
JOB_NAME_SHORT | JOB_NAME_S | VARCHAR(10) Nullable
|
The name of the job. Contains the null value when JOB_NAME is *SIGNON or SLIC_TASK_NAME is not null. |
JOB_USER | JOB_USER | VARCHAR(10) Nullable
|
The user profile that started the job. Contains the null value when JOB_NAME is *SIGNON or SLIC_TASK_NAME is not null. |
JOB_NUMBER | JOB_NUMBER | VARCHAR(6) Nullable
|
The job number of the job. Contains the null value when JOB_NAME is *SIGNON or SLIC_TASK_NAME is not null. |
SLIC_TASK_NAME | SLIC_TASK | VARCHAR(16) Nullable
|
The task name as identified to
the system. Contains null when JOB_NAME is not null. |
INTERNAL_JOB_ID | JOB_ID | BINARY(16) Nullable
|
A value that can be used by system
APIs to speed the process of locating the job on the system. Contains null if JOB_NAME is the special value *SIGNON or if SLIC_TASK_NAME is not null. |
JOB_TYPE | JOB_TYPE | VARCHAR(11) Nullable
|
The type of job:
Contains null if JOB_NAME is the special value *SIGNON or if SLIC_TASK_NAME is not null. |
Example
Return information about all jobs using IPv4 network connections.
SELECT * FROM QSYS2.NETSTAT_JOB_INFO
WHERE CONNECTION_TYPE = 'IPV4'