IBM Support

Add client and server IP address and port number to QSYS2.TCPIP_INFO

News


Abstract

Add client and server IP address and port number to QSYS2.TCPIP_INFO

Content

You are in: IBM i Technology Updates > Db2 for i - Technology UpdatesDb2 for i Database Engineer (DBE) Enhancements > Add client and server IP address and port number to QSYS2.TCPIP_INFO

Client/server identification, logging, and other instrumentation is possible with SQL.

The QSYS2/TCPIP_INFO view returns detailed information for the current connection.
 
Example:
SELECT * from QSYS2.TCPIP_INFO;
QSYS2/TCPIP_INFO columns as of IBM i 7.1:
image-20200117132404-2

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Document Information

Modified date:
11 April 2021

UID

ibm11169674