IBM Support

SYSIBM.CLIENT_IPADDR generated columns



The SYSIBM.CLIENT_IPADDR generated column in a table has been enhanced for non-TCP/IP based connections.


You are in: IBM i Technology Updates > Db2 for i - Technology UpdatesDb2 for i Functional Enhancements > SYSIBM.CLIENT_IPADDR generated columns

The SYSIBM.CLIENT_IPADDR global variable can be referenced at any point in SQL, or encapsulated into a table as a generated column to audit which IP address changed any row in the database file.
For example:
alter table toystore.sales
  add column audit_client_IP varchar(128)
  generated always as (SYSIBM.CLIENT_IPADDR) implicitly hidden;
With this enhancement, the value in audit_client_IP will no longer be NULL when traditional, non-TCP/IP interfaces are used to affect change in the database file.
Audit the IP addreess changing rows within a database file

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

Document Information

Modified date:
13 April 2021