DB2 Version 10.1 for Linux, UNIX, and Windows

CLIENT_IPADDR global variable

This built-in global variable contains the IP address of the current client, as returned by the operating system.

This global variable has the following characteristics:
  • It is read-only, with values maintained by system.
  • The type is VARCHAR(128).
  • The schema is SYSIBM.
  • The scope of this global variable is session.

The value of the CLIENT_IPADDR global variable is NULL if the client did not connect by using the TCP/IP or SSL protocol.

Related reference:
CLIENT_HOST global variable
CLIENT_ORIGUSERID global variable
CLIENT_USRSECTOKEN global variable