News
Abstract
The SYSIBM.CLIENT_IPADDR generated column in a table has been enhanced for non-TCP/IP based connections.
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 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;
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.
[{"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"}]
Was this topic helpful?
Document Information
Modified date:
13 April 2021
UID
ibm16442061