CLIENT_IPADDR

Contains the value of the client IP address for the connection.

For remote client connections, the value is the host IP address of the application that is used to establish the connection. For local host applications, the value is NULL. For remote host applications, the value is the IP address that is associated with the Db2 subsystem used to establish the connection as shown by issuing the -DISPLAY DDF command.

This global variable has the following characteristics:

It is read only, with values maintained by the system.
The type is CHAR(39).
The schema is SYSIBM.
The scope of this global variable is session.

The value is set by Db2 as obtained from the network. If the client did not connect by using the TCP/IP or SSL protocol, the value of the global variable is NULL.

1111:2222:3333:4444:5555:6666:7777:8888

Or IPv4-mapped IPv6 format:

::FFFF:9.30.115.135