Auditing in a distributed data environment

The Db2 audit trace records any access to your data, whether the request is from a remote location or from your local Db2 subsystem.

The trace record for a remote request reports the authorization ID as the final result of one of the following conditions:

• An outbound translation
• An inbound translation
• Activity of an authorization exit routine

Essentially, the ID on a trace record for a remote request is the same as the ID to which you grant access privileges for your data. Requests from your location to a remote Db2 are audited only if an audit trace is active at the remote location. The output from the trace appears only in the records at that location.