TCPIP_INFO view
The TCPIP_INFO view contains TCP/IP information for the current host connection.
Authorization: None required.
The following table describes the columns in the view. The schema is QSYS2.
| Column Name | System Column Name | Data Type | Description |
|---|---|---|---|
| COLLECTED_TIME | COLLE00001 | TIMESTAMP Nullable
|
Timestamp indicating when this row of information was collected. |
| LOCAL_HOST_NAME | LOCAL00001 | VARCHAR(255) Nullable
|
TCP/IP host name of the local system. |
| CLIENT_IP_ADDRESS_TYPE | CLIEN00001 | VARCHAR(10) Nullable
|
TCP/IP address version of the client. |
| CLIENT_IP_ADDRESS | CLIEN00002 | VARCHAR(45) Nullable
|
TCP/IP address of the client. |
| CLIENT_PORT_NUMBER | CLIEN00003 | INTEGER Nullable
|
TCP/IP port of the client. |
| SERVER_IP_ADDRESS_TYPE | SERVE00001 | VARCHAR(10) Nullable
|
TCP/IP address version of the server. |
| SERVER_IP_ADDRESS | SERVE00002 | VARCHAR(45) Nullable
|
TCP/IP address of the server. |
| SERVER_PORT_NUMBER | SERVE00003 | INTEGER Nullable
|
TCP/IP port number of the server. |
| HOST_VERSION | HOST_00001 | VARCHAR(10) Nullable
|
Operating system version. |
Example
Return information about the current host connection.
SELECT * FROM QSYS2.TCPIP_INFO