16.25.1 Setting up the audit trail facility environment

This subsection provides notes that apply when using the audit trail facility together with the multi-node function. For details about how to set up the environment for the audit trail facility, see 12.2 Setting up the audit trail facility environment.

■ Creating the audit trail directory

You must create an audit trail directory on each node.
We recommend that you create the audit trail directory on a node-local file system on each node.
You must specify the adb_audit_log_path operand in the server definition for each node. This operand specifies the location of the audit trail directory.

Note: Audit trails are output on the node where the corresponding operation was performed. For this reason, you need to create an audit trail directory for each node, and specify the name of that directory in the applicable adb_audit_log_path operand.

■ Preparing the file systems where the audit trail storage directories will be created

Configure the environment such that the paths of the audit trail files specified in the ADB_AUDITREAD function that retrieves audit trail data are accessible from all nodes using the same absolute paths.

Important

If audit trail files cannot be read by the same absolute path from all nodes, the results of transactions that execute SQL statements that retrieve audit trail data will differ depending on the node to which the transaction was assigned.
In the ADB_AUDITREAD function, you must specify the absolute path of the audit trail file from which to retrieve data.

Create the audit trail storage directory on a file system that is shared among all nodes. The following is an example of environment setup when using an NFS (a type of distributed file system):

Procedure:

After preparing the NFS server, create the audit trail storage directory on the NFS server.
Export the audit trail storage directory you created in step 1.

Perform this operation on the NFS server.
Mount the directory exported in step 2 so that the paths are the same on all nodes.

Perform this operation on all nodes.
Move the audit trail files that were output to the audit trail directory on each node to the audit trail storage directory on the NFS server.

Perform this operation on all nodes.
When retrieving audit trail data, specify in the ADB_AUDITREAD function the path of the audit trail files in the audit trail storage directory.

The following figure shows an example of a system configuration that uses NFS:

Figure 16‒10: Example of a system configuration that uses NFS

To Page Top