12.4.2 Swapping the current audit trail file

This subsection explains how to swap the current audit trail file.

You cannot reference the audit trail data in the current audit trail file. If you want to reference the audit trail data in the current audit trail file, you must first swap the file. To swap audit trail files, you use the adbaudittrail command.

As an HADB user with the audit admin privilege, execute the adbaudittrail command with the --swap option specified.

Note

For information about the adbaudittrail command, see adbaudittrail (Manage the Audit Trail Facility) in the manual HADB Command Reference.

When you execute the adbaudittrail command with the --swap option specified, swapping of the audit trail files takes place and the current audit trail file is renamed. You can then use the following methods to reference the audit trails output to the renamed audit trail file:

• 12.3.3 Referencing audit trails (when using SELECT statements to reference audit trails)

• 12.3.4 Referencing audit trails (when referencing audit trail data converted to CSV format)

To Page Top